Skip to content
Navigation Menu
{{ message }}
forked from rjjakes/wordpress-orm
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathManager.php
More file actions
319 lines (259 loc) · 8.22 KB
/
Copy pathManager.php
File metadata and controls
319 lines (259 loc) · 8.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
<?php
namespace Symlink\ORM;
use Symlink\ORM\Models\BaseModel;
use Symlink\ORM\Repositories\BaseRepository;
use Symlink\ORM\Collections\TrackedCollection;
class Manager {
/**
* @var \Symlink\ORM\Manager
*/
private static $manager_service = null;
/**
* Holds an array of objects the manager knows exist in the database (either
* from a query or a previous persist() call).
*
* @var TrackedCollection
*/
private $tracked;
/**
* Initializes a non static copy of itself when called. Subsequent calls
* return the same object (fake dependency injection/service).
*
* @return \Symlink\ORM\Manager
*/
public static function getManager() {
// Initialize the service if it's not already set.
if ( self::$manager_service === null ) {
self::$manager_service = new Manager();
}
// Return the instance.
return self::$manager_service;
}
/**
* Manager constructor.
*/
public function __construct() {
$this->tracked = new TrackedCollection;
}
/**
* Get repository instance from classname.
*
* @param $classname
*
* @return \Symlink\ORM\Repositories\BaseRepository
*/
public function getRepository( $classname ) {
// Get the annotations for this class.
$annotations = Mapping::getMapper()->getProcessed( $classname );
// Get the repository for this class (this has already been validated in the Mapper). .
if ( isset( $annotations['ORM_Repository'] ) ) {
return $annotations['ORM_Repository']::getInstance( $classname, $annotations );
} // No repository set, so assume the base.
else {
return BaseRepository::getInstance( $classname, $annotations );
}
}
/**
* Queue this model up to be added to the database with flush().
*
* @param $object
*/
public function persist( BaseModel $object ) {
// Start tracking this object (because it is new, it will be tracked as
// something to be INSERTed)
$this->tracked[ $object ] = _OBJECT_NEW;
}
/**
* Start tracking a model known to exist in the database.
*
* @param \Symlink\ORM\Models\BaseModel $object
*/
public function track( BaseModel $object ) {
// Save it against the key.
$this->tracked[ $object ] = _OBJECT_TRACKED;
}
/**
* This model should be removed from the db when flush() is called.
*
* @param $model
*/
public function remove( BaseModel $object ) {
unset( $this->tracked[ $object ] );
}
/**
* Start tracking a model known to exist in the database.
*
* @param \Symlink\ORM\Models\BaseModel $object
*/
public function clean( BaseModel $object ) {
// Save it against the key.
$this->tracked[ $object ] = _OBJECT_CLEAN;
}
/**
* Add new objects to the database.
* This will perform one query per table no matter how many records need to
* be added.
*
*/
private function _flush_insert(): void {
global $wpdb;
// Get a list of tables and columns that have data to insert.
$insert = $this->tracked->getInsertUpdateTableData( 'getPersistedObjects' );
// Process the INSERTs
if ( count( $insert ) ) {
// Build the combined query for table: $tablename
foreach ( $insert as $classname => $values ) {
$table_name = $wpdb->prefix . $values['table_name'];
// Build the placeholder SQL query.
$sql = "INSERT INTO " . $table_name . "
(" . implode( ", ", $values['columns'] ) . ")
VALUES
";
while ( $values['placeholders_count'] > 0 ) {
$sql .= "(" . implode( ", ", $values['placeholders'] ) . ")";
if ( $values['placeholders_count'] > 1 ) {
$sql .= ",
";
}
$values['placeholders_count'] -= 1;
}
// Insert using Wordpress prepare() which provides SQL injection protection (apparently).
$prepared = $wpdb->prepare( $sql, $values['values'] );
$count = $wpdb->query( $prepared );
// Start tracking all the added objects.
if ( $count ) {
array_walk( $values['objects'], function ( $object ) {
$this->track( $object );
} );
} // Something went wrong.
else {
$this->handle_error( sprintf( __( 'Failed to insert %s record(s) into the database.' ), count( $insert ) ) );
}
}
}
}
/**
* Compares known database state of tracked objects and compares them with
* the current state. Applies any changes to the database.
*
* This will perform one query per table no matter how many records need to
* be updated.
* https://stackoverflow.com/questions/3432/multiple-updates-in-mysql
*/
private function _flush_update(): void {
global $wpdb;
// Get a list of tables and columns that have data to update.
$update = $this->tracked->getInsertUpdateTableData( 'getChangedObjects' );
// Process the UPDATEs
if ( count( $update ) ) {
// Build the combined query for table: $tablename
foreach ( $update as $classname => $values ) {
// Primary key name
$primary_key_name = ( new $classname )->getPrimaryKeyName();
// Table name
$table_name = $wpdb->prefix . $values['table_name'];
$sql = "INSERT INTO " . $table_name . " (" . $primary_key_name . ", " . implode( ", ", $values['columns'] ) . ")
VALUES
";
while ( $values['placeholders_count'] > 0 ) {
$sql .= "(%d, " . implode( ", ", $values['placeholders'] ) . ")";
if ( $values['placeholders_count'] > 1 ) {
$sql .= ",
";
}
$values['placeholders_count'] -= 1;
}
$sql .= "
ON DUPLICATE KEY UPDATE
";
$update_set = [];
foreach ( $values['columns'] as $column ) {
$update_set[] = $column . "=VALUES(" . $column . ")";
}
$sql .= implode( ", ", $update_set ) . ";";
// Insert using Wordpress prepare() which provides SQL injection protection (apparently).
$prepared = $wpdb->prepare( $sql, $values['values'] );
$count = $wpdb->query( $prepared );
// Start tracking all the added objects.
if ( $count !== false ) {
array_walk( $values['objects'], function ( $object ) {
$this->track( $object );
} );
} // Something went wrong.
else {
$this->handle_error( sprintf( __( 'Failed to update %s record(s) into the database.' ), count( $update ) ) );
}
}
}
}
/**
*
*/
private function _flush_delete(): void {
global $wpdb;
// Get a list of tables and columns that have data to update.
$update = $this->tracked->getRemoveTableData();
// Process the INSERTs
if ( count( $update ) ) {
// Build the combined query for table: $tablename
foreach ( $update as $classname => $values ) {
// Primary key name
$primary_key_name = ( new $classname )->getPrimaryKeyName();
// Table name
$table_name = $wpdb->prefix . $values['table_name'];
// Build the SQL.
$sql = "DELETE FROM " . $table_name . " WHERE " . $primary_key_name . " IN (" . implode( ", ", array_fill( 0, count( $values['values'] ), "%d" ) ) . ");";
// Process all deletes for a particular table together as a single query.
$prepared = $wpdb->prepare( $sql, $values['values'] );
$count = $wpdb->query( $prepared );
// Really remove the object from the tracking list.
foreach ( $values['objects'] as $obj_hash => $object ) {
$this->clean( $object );
}
}
}
}
/**
* Apply changes to all models queued up with persist().
* Attempts to combine queries to reduce MySQL load.
*/
public function flush() {
$this->_flush_update();
$this->_flush_insert();
$this->_flush_delete();
}
/**
* Handle the error and ouput it nicely in WordPress style
*
* @param string $fail_message
*/
private function handle_error( string $fail_message = '' ) {
global $wpdb;
// Default fail message
if ( $fail_message === '' ) {
$fail_message = __( 'WordPress database error' );
}
if ( $wpdb->last_error !== '' ) {
$e = new \Exception();
$trace = $e->getTraceAsString();
$error_html = sprintf(
'<div id="error">
<h2 class="error-message"><span class="dashicons dashicons-dismiss"></span>%s</h2>
<p><strong>Last error:</strong></p>
<p>%s</p>
<p><strong>Last query:</strong></p>
<code>%s</code>
<p><strong>Call stack:</strong></p>
<pre>%s</pre>
</div>',
$fail_message,
htmlspecialchars( $wpdb->last_error, ENT_QUOTES ),
htmlspecialchars( $wpdb->last_query, ENT_QUOTES ),
$trace
);
} else {
$error_html = $fail_message;
}
wp_die( $error_html );
}
}
You can’t perform that action at this time.
