1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
declare(strict_types=1); |
4
|
|
|
|
5
|
|
|
namespace Doctrine\DBAL\Schema; |
6
|
|
|
|
7
|
|
|
use Doctrine\DBAL\Connection; |
8
|
|
|
use Doctrine\DBAL\ConnectionException; |
9
|
|
|
use Doctrine\DBAL\DBALException; |
10
|
|
|
use Doctrine\DBAL\Event\SchemaColumnDefinitionEventArgs; |
11
|
|
|
use Doctrine\DBAL\Event\SchemaIndexDefinitionEventArgs; |
12
|
|
|
use Doctrine\DBAL\Events; |
13
|
|
|
use Doctrine\DBAL\Exception\InvalidArgumentException; |
14
|
|
|
use Doctrine\DBAL\Platforms\AbstractPlatform; |
15
|
|
|
use Doctrine\DBAL\Platforms\Exception\NotSupported; |
16
|
|
|
use Throwable; |
17
|
|
|
use function array_filter; |
18
|
|
|
use function array_intersect; |
19
|
|
|
use function array_map; |
20
|
|
|
use function array_values; |
21
|
|
|
use function assert; |
22
|
|
|
use function call_user_func_array; |
23
|
|
|
use function count; |
24
|
|
|
use function func_get_args; |
25
|
|
|
use function is_array; |
26
|
|
|
use function is_callable; |
27
|
|
|
use function preg_match; |
28
|
|
|
use function strtolower; |
29
|
|
|
|
30
|
|
|
/** |
31
|
|
|
* Base class for schema managers. Schema managers are used to inspect and/or |
32
|
|
|
* modify the database schema/structure. |
33
|
|
|
*/ |
34
|
|
|
abstract class AbstractSchemaManager |
35
|
|
|
{ |
36
|
|
|
/** |
37
|
|
|
* Holds instance of the Doctrine connection for this schema manager. |
38
|
|
|
* |
39
|
|
|
* @var Connection |
40
|
|
|
*/ |
41
|
|
|
protected $_conn; |
42
|
|
|
|
43
|
|
|
/** |
44
|
|
|
* Holds instance of the database platform used for this schema manager. |
45
|
|
|
* |
46
|
|
|
* @var AbstractPlatform |
47
|
|
|
*/ |
48
|
|
|
protected $_platform; |
49
|
|
|
|
50
|
|
|
/** |
51
|
|
|
* Constructor. Accepts the Connection instance to manage the schema for. |
52
|
5934 |
|
*/ |
53
|
|
|
public function __construct(Connection $conn, ?AbstractPlatform $platform = null) |
54
|
5934 |
|
{ |
55
|
5934 |
|
$this->_conn = $conn; |
56
|
5934 |
|
$this->_platform = $platform ?: $this->_conn->getDatabasePlatform(); |
57
|
|
|
} |
58
|
|
|
|
59
|
|
|
/** |
60
|
|
|
* Returns the associated platform. |
61
|
|
|
*/ |
62
|
|
|
public function getDatabasePlatform() : AbstractPlatform |
63
|
3907 |
|
{ |
64
|
|
|
return $this->_platform; |
65
|
3907 |
|
} |
66
|
|
|
|
67
|
|
|
/** |
68
|
|
|
* Tries any method on the schema manager. Normally a method throws an |
69
|
|
|
* exception when your DBMS doesn't support it or if an error occurs. |
70
|
|
|
* This method allows you to try and method on your SchemaManager |
71
|
|
|
* instance and will return false if it does not work or is not supported. |
72
|
|
|
* |
73
|
|
|
* <code> |
74
|
|
|
* $result = $sm->tryMethod('dropView', 'view_name'); |
75
|
|
|
* </code> |
76
|
|
|
* |
77
|
|
|
* @return mixed |
78
|
|
|
*/ |
79
|
|
|
public function tryMethod() |
80
|
5789 |
|
{ |
81
|
|
|
$args = func_get_args(); |
82
|
5789 |
|
$method = $args[0]; |
83
|
5789 |
|
unset($args[0]); |
84
|
5789 |
|
$args = array_values($args); |
85
|
5789 |
|
|
86
|
|
|
$callback = [$this, $method]; |
87
|
5789 |
|
assert(is_callable($callback)); |
88
|
5789 |
|
|
89
|
|
|
try { |
90
|
|
|
return call_user_func_array($callback, $args); |
91
|
5789 |
|
} catch (Throwable $e) { |
92
|
5609 |
|
return false; |
93
|
5609 |
|
} |
94
|
|
|
} |
95
|
|
|
|
96
|
|
|
/** |
97
|
|
|
* Lists the available databases for this connection. |
98
|
|
|
* |
99
|
|
|
* @return string[] |
100
|
|
|
*/ |
101
|
|
|
public function listDatabases() : array |
102
|
3542 |
|
{ |
103
|
|
|
$sql = $this->_platform->getListDatabasesSQL(); |
104
|
3542 |
|
|
105
|
|
|
$databases = $this->_conn->fetchAll($sql); |
106
|
3396 |
|
|
107
|
|
|
return $this->_getPortableDatabasesList($databases); |
108
|
3396 |
|
} |
109
|
|
|
|
110
|
|
|
/** |
111
|
|
|
* Returns a list of all namespaces in the current database. |
112
|
|
|
* |
113
|
|
|
* @return string[] |
114
|
|
|
*/ |
115
|
|
|
public function listNamespaceNames() : array |
116
|
567 |
|
{ |
117
|
|
|
$sql = $this->_platform->getListNamespacesSQL(); |
118
|
567 |
|
|
119
|
|
|
$namespaces = $this->_conn->fetchAll($sql); |
120
|
567 |
|
|
121
|
|
|
return $this->getPortableNamespacesList($namespaces); |
122
|
567 |
|
} |
123
|
|
|
|
124
|
|
|
/** |
125
|
|
|
* Lists the available sequences for this connection. |
126
|
|
|
* |
127
|
|
|
* @return Sequence[] |
128
|
|
|
*/ |
129
|
|
|
public function listSequences(?string $database = null) : array |
130
|
|
|
{ |
131
|
|
|
$database = $this->ensureDatabase( |
132
|
589 |
|
$database ?? $this->_conn->getDatabase() |
133
|
|
|
); |
134
|
589 |
|
|
135
|
589 |
|
$sql = $this->_platform->getListSequencesSQL($database); |
136
|
|
|
|
137
|
589 |
|
$sequences = $this->_conn->fetchAll($sql); |
138
|
|
|
|
139
|
589 |
|
return $this->filterAssetNames($this->_getPortableSequencesList($sequences)); |
140
|
|
|
} |
141
|
589 |
|
|
142
|
|
|
/** |
143
|
|
|
* Lists the columns for a given table. |
144
|
|
|
* |
145
|
|
|
* In contrast to other libraries and to the old version of Doctrine, |
146
|
|
|
* this column definition does try to contain the 'primary' field for |
147
|
|
|
* the reason that it is not portable across different RDBMS. Use |
148
|
|
|
* {@see listTableIndexes($tableName)} to retrieve the primary key |
149
|
|
|
* of a table. We're a RDBMS specifies more details these are held |
150
|
|
|
* in the platformDetails array. |
151
|
|
|
* |
152
|
|
|
* @param string $table The name of the table. |
153
|
|
|
* |
154
|
|
|
* @return Column[] |
155
|
|
|
*/ |
156
|
|
|
public function listTableColumns(string $table, ?string $database = null) : array |
157
|
|
|
{ |
158
|
|
|
if (! $database) { |
159
|
4550 |
|
$database = $this->_conn->getDatabase(); |
160
|
|
|
} |
161
|
4550 |
|
|
162
|
4548 |
|
$sql = $this->_platform->getListTableColumnsSQL($table, $database); |
163
|
|
|
|
164
|
|
|
$tableColumns = $this->_conn->fetchAll($sql); |
165
|
4550 |
|
|
166
|
|
|
return $this->_getPortableTableColumnList($table, $database, $tableColumns); |
167
|
4550 |
|
} |
168
|
|
|
|
169
|
4550 |
|
/** |
170
|
|
|
* Lists the indexes for a given table returning an array of Index instances. |
171
|
|
|
* |
172
|
|
|
* Keys of the portable indexes list are all lower-cased. |
173
|
|
|
* |
174
|
|
|
* @param string $table The name of the table. |
175
|
|
|
* |
176
|
|
|
* @return Index[] |
177
|
|
|
*/ |
178
|
|
|
public function listTableIndexes(string $table) : array |
179
|
|
|
{ |
180
|
|
|
$sql = $this->_platform->getListTableIndexesSQL($table, $this->_conn->getDatabase()); |
181
|
4536 |
|
|
182
|
|
|
$tableIndexes = $this->_conn->fetchAll($sql); |
183
|
4536 |
|
|
184
|
|
|
return $this->_getPortableTableIndexesList($tableIndexes, $table); |
185
|
4536 |
|
} |
186
|
|
|
|
187
|
4536 |
|
/** |
188
|
|
|
* Returns true if all the given tables exist. |
189
|
|
|
* |
190
|
|
|
* @param string|string[] $tableNames |
191
|
|
|
*/ |
192
|
|
|
public function tablesExist($tableNames) : bool |
193
|
|
|
{ |
194
|
|
|
$tableNames = array_map('strtolower', (array) $tableNames); |
195
|
|
|
|
196
|
|
|
return count($tableNames) === count(array_intersect($tableNames, array_map('strtolower', $this->listTableNames()))); |
197
|
4921 |
|
} |
198
|
|
|
|
199
|
4921 |
|
/** |
200
|
|
|
* Returns a list of all tables in the current database. |
201
|
4921 |
|
* |
202
|
|
|
* @return string[] |
203
|
|
|
*/ |
204
|
|
|
public function listTableNames() : array |
205
|
|
|
{ |
206
|
|
|
$sql = $this->_platform->getListTablesSQL(); |
207
|
|
|
|
208
|
|
|
$tables = $this->_conn->fetchAll($sql); |
209
|
4927 |
|
$tableNames = $this->_getPortableTablesList($tables); |
210
|
|
|
|
211
|
4927 |
|
return $this->filterAssetNames($tableNames); |
212
|
|
|
} |
213
|
4927 |
|
|
214
|
4927 |
|
/** |
215
|
|
|
* Filters asset names if they are configured to return only a subset of all |
216
|
4927 |
|
* the found elements. |
217
|
|
|
* |
218
|
|
|
* @param mixed[] $assetNames |
219
|
|
|
* |
220
|
|
|
* @return mixed[] |
221
|
|
|
*/ |
222
|
|
|
protected function filterAssetNames(array $assetNames) : array |
223
|
|
|
{ |
224
|
|
|
$filter = $this->_conn->getConfiguration()->getSchemaAssetsFilter(); |
225
|
|
|
if (! $filter) { |
226
|
|
|
return $assetNames; |
227
|
4929 |
|
} |
228
|
|
|
|
229
|
4929 |
|
return array_values(array_filter($assetNames, $filter)); |
230
|
4929 |
|
} |
231
|
4929 |
|
|
232
|
|
|
/** |
233
|
|
|
* Lists the tables for this connection. |
234
|
1447 |
|
* |
235
|
|
|
* @return Table[] |
236
|
|
|
*/ |
237
|
|
|
public function listTables() : array |
238
|
|
|
{ |
239
|
|
|
$tableNames = $this->listTableNames(); |
240
|
|
|
|
241
|
|
|
$tables = []; |
242
|
|
|
foreach ($tableNames as $tableName) { |
243
|
|
|
$tables[] = $this->listTableDetails($tableName); |
244
|
|
|
} |
245
|
|
|
|
246
|
|
|
return $tables; |
247
|
|
|
} |
248
|
|
|
|
249
|
|
|
public function listTableDetails(string $tableName) : Table |
250
|
|
|
{ |
251
|
|
|
$columns = $this->listTableColumns($tableName); |
252
|
4406 |
|
$foreignKeys = []; |
253
|
|
|
|
254
|
4406 |
|
if ($this->_platform->supportsForeignKeyConstraints()) { |
255
|
|
|
$foreignKeys = $this->listTableForeignKeys($tableName); |
256
|
4406 |
|
} |
257
|
4406 |
|
|
258
|
4404 |
|
$indexes = $this->listTableIndexes($tableName); |
259
|
|
|
|
260
|
|
|
return new Table($tableName, $columns, $indexes, [], $foreignKeys, []); |
261
|
4406 |
|
} |
262
|
|
|
|
263
|
|
|
/** |
264
|
|
|
* Lists the views this connection has. |
265
|
|
|
* |
266
|
|
|
* @return View[] |
267
|
|
|
*/ |
268
|
|
|
public function listViews() : array |
269
|
4526 |
|
{ |
270
|
|
|
$database = $this->ensureDatabase( |
271
|
4526 |
|
$this->_conn->getDatabase() |
272
|
4526 |
|
); |
273
|
|
|
|
274
|
4526 |
|
$sql = $this->_platform->getListViewsSQL($database); |
275
|
4374 |
|
$views = $this->_conn->fetchAll($sql); |
276
|
|
|
|
277
|
|
|
return $this->_getPortableViewsList($views); |
278
|
4526 |
|
} |
279
|
|
|
|
280
|
4526 |
|
/** |
281
|
|
|
* Lists the foreign keys for the given table. |
282
|
|
|
* |
283
|
|
|
* @param string $table The name of the table. |
284
|
|
|
* |
285
|
|
|
* @return ForeignKeyConstraint[] |
286
|
|
|
*/ |
287
|
|
|
public function listTableForeignKeys(string $table, ?string $database = null) : array |
288
|
3166 |
|
{ |
289
|
|
|
if ($database === null) { |
290
|
3166 |
|
$database = $this->_conn->getDatabase(); |
291
|
3166 |
|
} |
292
|
3166 |
|
$sql = $this->_platform->getListTableForeignKeysSQL($table, $database); |
293
|
|
|
$tableForeignKeys = $this->_conn->fetchAll($sql); |
294
|
3166 |
|
|
295
|
|
|
return $this->_getPortableTableForeignKeysList($tableForeignKeys); |
296
|
|
|
} |
297
|
|
|
|
298
|
|
|
/* drop*() Methods */ |
299
|
|
|
|
300
|
|
|
/** |
301
|
|
|
* Drops a database. |
302
|
|
|
* |
303
|
|
|
* NOTE: You can not drop the database this SchemaManager is currently connected to. |
304
|
|
|
* |
305
|
4417 |
|
* @param string $database The name of the database to drop. |
306
|
|
|
*/ |
307
|
4417 |
|
public function dropDatabase(string $database) : void |
308
|
4417 |
|
{ |
309
|
|
|
$this->_execSql($this->_platform->getDropDatabaseSQL($database)); |
310
|
4417 |
|
} |
311
|
4417 |
|
|
312
|
|
|
/** |
313
|
4417 |
|
* Drops the given table. |
314
|
|
|
* |
315
|
|
|
* @param string $tableName The name of the table to drop. |
316
|
|
|
*/ |
317
|
|
|
public function dropTable(string $tableName) : void |
318
|
|
|
{ |
319
|
|
|
$this->_execSql($this->_platform->getDropTableSQL($tableName)); |
320
|
|
|
} |
321
|
|
|
|
322
|
|
|
/** |
323
|
|
|
* Drops the index from the given table. |
324
|
|
|
* |
325
|
|
|
* @param Index|string $index The name of the index. |
326
|
|
|
* @param Table|string $table The name of the table. |
327
|
5378 |
|
*/ |
328
|
|
|
public function dropIndex($index, $table) : void |
329
|
5378 |
|
{ |
330
|
5074 |
|
if ($index instanceof Index) { |
331
|
|
|
$index = $index->getQuotedName($this->_platform); |
332
|
|
|
} |
333
|
|
|
|
334
|
|
|
$this->_execSql($this->_platform->getDropIndexSQL($index, $table)); |
335
|
|
|
} |
336
|
|
|
|
337
|
|
|
/** |
338
|
|
|
* Drops the constraint from the given table. |
339
|
5577 |
|
* |
340
|
|
|
* @param Table|string $table The name of the table. |
341
|
5577 |
|
*/ |
342
|
5456 |
|
public function dropConstraint(Constraint $constraint, $table) : void |
343
|
|
|
{ |
344
|
|
|
$this->_execSql($this->_platform->getDropConstraintSQL($constraint, $table)); |
345
|
|
|
} |
346
|
|
|
|
347
|
|
|
/** |
348
|
|
|
* Drops a foreign key from a table. |
349
|
|
|
* |
350
|
|
|
* @param ForeignKeyConstraint|string $foreignKey The name of the foreign key. |
351
|
|
|
* @param Table|string $table The name of the table with the foreign key. |
352
|
3289 |
|
*/ |
353
|
|
|
public function dropForeignKey($foreignKey, $table) : void |
354
|
3289 |
|
{ |
355
|
|
|
$this->_execSql($this->_platform->getDropForeignKeySQL($foreignKey, $table)); |
356
|
|
|
} |
357
|
|
|
|
358
|
3289 |
|
/** |
359
|
3289 |
|
* Drops a sequence with a given name. |
360
|
|
|
* |
361
|
|
|
* @param string $name The name of the sequence to drop. |
362
|
|
|
*/ |
363
|
|
|
public function dropSequence(string $name) : void |
364
|
|
|
{ |
365
|
|
|
$this->_execSql($this->_platform->getDropSequenceSQL($name)); |
366
|
|
|
} |
367
|
|
|
|
368
|
|
|
/** |
369
|
|
|
* Drops a view. |
370
|
|
|
* |
371
|
|
|
* @param string $name The name of the view. |
372
|
|
|
*/ |
373
|
|
|
public function dropView(string $name) : void |
374
|
|
|
{ |
375
|
|
|
$this->_execSql($this->_platform->getDropViewSQL($name)); |
376
|
|
|
} |
377
|
|
|
|
378
|
|
|
/* create*() Methods */ |
379
|
|
|
|
380
|
|
|
/** |
381
|
|
|
* Creates a new database. |
382
|
|
|
* |
383
|
|
|
* @param string $database The name of the database to create. |
384
|
|
|
*/ |
385
|
|
|
public function createDatabase(string $database) : void |
386
|
|
|
{ |
387
|
|
|
$this->_execSql($this->_platform->getCreateDatabaseSQL($database)); |
388
|
|
|
} |
389
|
|
|
|
390
|
|
|
/** |
391
|
|
|
* Creates a new table. |
392
|
|
|
*/ |
393
|
583 |
|
public function createTable(Table $table) : void |
394
|
|
|
{ |
395
|
583 |
|
$createFlags = AbstractPlatform::CREATE_INDEXES|AbstractPlatform::CREATE_FOREIGNKEYS; |
396
|
|
|
$this->_execSql($this->_platform->getCreateTableSQL($table, $createFlags)); |
397
|
|
|
} |
398
|
|
|
|
399
|
|
|
/** |
400
|
|
|
* Creates a new sequence. |
401
|
|
|
* |
402
|
|
|
* @throws ConnectionException If something fails at database level. |
403
|
|
|
*/ |
404
|
|
|
public function createSequence(Sequence $sequence) : void |
405
|
3276 |
|
{ |
406
|
|
|
$this->_execSql($this->_platform->getCreateSequenceSQL($sequence)); |
407
|
3276 |
|
} |
408
|
|
|
|
409
|
|
|
/** |
410
|
|
|
* Creates a constraint on a table. |
411
|
|
|
* |
412
|
|
|
* @param Table|string $table |
413
|
|
|
*/ |
414
|
|
|
public function createConstraint(Constraint $constraint, $table) : void |
415
|
|
|
{ |
416
|
|
|
$this->_execSql($this->_platform->getCreateConstraintSQL($constraint, $table)); |
417
|
|
|
} |
418
|
|
|
|
419
|
5374 |
|
/** |
420
|
|
|
* Creates a new index on a table. |
421
|
5374 |
|
* |
422
|
5374 |
|
* @param Table|string $table The name of the table on which the index is to be created. |
423
|
|
|
*/ |
424
|
|
|
public function createIndex(Index $index, $table) : void |
425
|
|
|
{ |
426
|
|
|
$this->_execSql($this->_platform->getCreateIndexSQL($index, $table)); |
427
|
|
|
} |
428
|
|
|
|
429
|
5613 |
|
/** |
430
|
|
|
* Creates a new foreign key. |
431
|
5613 |
|
* |
432
|
5613 |
|
* @param ForeignKeyConstraint $foreignKey The ForeignKey instance. |
433
|
5571 |
|
* @param Table|string $table The name of the table on which the foreign key is to be created. |
434
|
|
|
*/ |
435
|
|
|
public function createForeignKey(ForeignKeyConstraint $foreignKey, $table) : void |
436
|
|
|
{ |
437
|
|
|
$this->_execSql($this->_platform->getCreateForeignKeySQL($foreignKey, $table)); |
438
|
|
|
} |
439
|
|
|
|
440
|
|
|
/** |
441
|
|
|
* Creates a new view. |
442
|
|
|
*/ |
443
|
|
|
public function createView(View $view) : void |
444
|
587 |
|
{ |
445
|
|
|
$this->_execSql($this->_platform->getCreateViewSQL($view->getQuotedName($this->_platform), $view->getSql())); |
446
|
587 |
|
} |
447
|
587 |
|
|
448
|
|
|
/* dropAndCreate*() Methods */ |
449
|
|
|
|
450
|
|
|
/** |
451
|
|
|
* Drops and creates a constraint. |
452
|
|
|
* |
453
|
|
|
* @see dropConstraint() |
454
|
|
|
* @see createConstraint() |
455
|
|
|
* |
456
|
2 |
|
* @param Table|string $table |
457
|
|
|
*/ |
458
|
2 |
|
public function dropAndCreateConstraint(Constraint $constraint, $table) : void |
459
|
2 |
|
{ |
460
|
|
|
$this->tryMethod('dropConstraint', $constraint, $table); |
461
|
|
|
$this->createConstraint($constraint, $table); |
462
|
|
|
} |
463
|
|
|
|
464
|
|
|
/** |
465
|
|
|
* Drops and creates a new index on a table. |
466
|
|
|
* |
467
|
|
|
* @param Table|string $table The name of the table on which the index is to be created. |
468
|
3289 |
|
*/ |
469
|
|
|
public function dropAndCreateIndex(Index $index, $table) : void |
470
|
3289 |
|
{ |
471
|
3289 |
|
$this->tryMethod('dropIndex', $index->getQuotedName($this->_platform), $table); |
472
|
|
|
$this->createIndex($index, $table); |
473
|
|
|
} |
474
|
|
|
|
475
|
|
|
/** |
476
|
|
|
* Drops and creates a new foreign key. |
477
|
|
|
* |
478
|
|
|
* @param ForeignKeyConstraint $foreignKey An associative array that defines properties of the foreign key to be created. |
479
|
|
|
* @param Table|string $table The name of the table on which the foreign key is to be created. |
480
|
|
|
*/ |
481
|
3238 |
|
public function dropAndCreateForeignKey(ForeignKeyConstraint $foreignKey, $table) : void |
482
|
|
|
{ |
483
|
3238 |
|
$this->tryMethod('dropForeignKey', $foreignKey, $table); |
484
|
3238 |
|
$this->createForeignKey($foreignKey, $table); |
485
|
|
|
} |
486
|
|
|
|
487
|
|
|
/** |
488
|
|
|
* Drops and create a new sequence. |
489
|
|
|
* |
490
|
|
|
* @throws ConnectionException If something fails at database level. |
491
|
3276 |
|
*/ |
492
|
|
|
public function dropAndCreateSequence(Sequence $sequence) : void |
493
|
3276 |
|
{ |
494
|
3276 |
|
$this->tryMethod('dropSequence', $sequence->getQuotedName($this->_platform)); |
495
|
|
|
$this->createSequence($sequence); |
496
|
|
|
} |
497
|
|
|
|
498
|
|
|
/** |
499
|
|
|
* Drops and creates a new table. |
500
|
|
|
*/ |
501
|
|
|
public function dropAndCreateTable(Table $table) : void |
502
|
|
|
{ |
503
|
|
|
$this->tryMethod('dropTable', $table->getQuotedName($this->_platform)); |
504
|
|
|
$this->createTable($table); |
505
|
|
|
} |
506
|
|
|
|
507
|
|
|
/** |
508
|
|
|
* Drops and creates a new database. |
509
|
|
|
* |
510
|
|
|
* @param string $database The name of the database to create. |
511
|
|
|
*/ |
512
|
|
|
public function dropAndCreateDatabase(string $database) : void |
513
|
|
|
{ |
514
|
|
|
$this->tryMethod('dropDatabase', $database); |
515
|
|
|
$this->createDatabase($database); |
516
|
|
|
} |
517
|
|
|
|
518
|
|
|
/** |
519
|
|
|
* Drops and creates a new view. |
520
|
|
|
*/ |
521
|
3289 |
|
public function dropAndCreateView(View $view) : void |
522
|
|
|
{ |
523
|
3289 |
|
$this->tryMethod('dropView', $view->getQuotedName($this->_platform)); |
524
|
3289 |
|
$this->createView($view); |
525
|
3289 |
|
} |
526
|
|
|
|
527
|
|
|
/* alterTable() Methods */ |
528
|
|
|
|
529
|
|
|
/** |
530
|
|
|
* Alters an existing tables schema. |
531
|
|
|
*/ |
532
|
|
|
public function alterTable(TableDiff $tableDiff) : void |
533
|
|
|
{ |
534
|
|
|
$queries = $this->_platform->getAlterTableSQL($tableDiff); |
535
|
|
|
|
536
|
|
|
if (! is_array($queries) || ! count($queries)) { |
537
|
|
|
return; |
538
|
|
|
} |
539
|
|
|
|
540
|
|
|
foreach ($queries as $ddlQuery) { |
541
|
|
|
$this->_execSql($ddlQuery); |
542
|
|
|
} |
543
|
|
|
} |
544
|
|
|
|
545
|
|
|
/** |
546
|
|
|
* Renames a given table to another name. |
547
|
|
|
* |
548
|
583 |
|
* @param string $name The current name of the table. |
549
|
|
|
* @param string $newName The new name of the table. |
550
|
583 |
|
*/ |
551
|
583 |
|
public function renameTable(string $name, string $newName) : void |
552
|
583 |
|
{ |
553
|
|
|
$tableDiff = new TableDiff($name); |
554
|
|
|
$tableDiff->newName = $newName; |
555
|
|
|
$this->alterTable($tableDiff); |
556
|
|
|
} |
557
|
|
|
|
558
|
|
|
/** |
559
|
5499 |
|
* Methods for filtering return values of list*() methods to convert |
560
|
|
|
* the native DBMS data definition to a portable Doctrine definition |
561
|
5499 |
|
*/ |
562
|
5499 |
|
|
563
|
5499 |
|
/** |
564
|
|
|
* @param mixed[] $databases |
565
|
|
|
* |
566
|
|
|
* @return string[] |
567
|
|
|
*/ |
568
|
|
|
protected function _getPortableDatabasesList(array $databases) : array |
569
|
|
|
{ |
570
|
|
|
$list = []; |
571
|
|
|
foreach ($databases as $value) { |
572
|
5522 |
|
$value = $this->_getPortableDatabaseDefinition($value); |
573
|
|
|
|
574
|
5522 |
|
if (! $value) { |
575
|
5522 |
|
continue; |
576
|
5522 |
|
} |
577
|
|
|
|
578
|
|
|
$list[] = $value; |
579
|
|
|
} |
580
|
|
|
|
581
|
|
|
return $list; |
582
|
|
|
} |
583
|
3276 |
|
|
584
|
|
|
/** |
585
|
3276 |
|
* Converts a list of namespace names from the native DBMS data definition to a portable Doctrine definition. |
586
|
3276 |
|
* |
587
|
3276 |
|
* @param mixed[][] $namespaces The list of namespace names in the native DBMS data definition. |
588
|
|
|
* |
589
|
|
|
* @return string[] |
590
|
|
|
*/ |
591
|
|
|
protected function getPortableNamespacesList(array $namespaces) : array |
592
|
|
|
{ |
593
|
|
|
$namespacesList = []; |
594
|
|
|
|
595
|
|
|
foreach ($namespaces as $namespace) { |
596
|
4111 |
|
$namespacesList[] = $this->getPortableNamespaceDefinition($namespace); |
597
|
|
|
} |
598
|
4111 |
|
|
599
|
|
|
return $namespacesList; |
600
|
4111 |
|
} |
601
|
2507 |
|
|
602
|
|
|
/** |
603
|
|
|
* @param mixed $database |
604
|
4111 |
|
* |
605
|
4111 |
|
* @return mixed |
606
|
|
|
*/ |
607
|
4111 |
|
protected function _getPortableDatabaseDefinition($database) |
608
|
|
|
{ |
609
|
|
|
return $database; |
610
|
|
|
} |
611
|
|
|
|
612
|
|
|
/** |
613
|
|
|
* Converts a namespace definition from the native DBMS data definition to a portable Doctrine definition. |
614
|
|
|
* |
615
|
|
|
* @param mixed[] $namespace The native DBMS namespace definition. |
616
|
|
|
* |
617
|
2 |
|
* @return mixed |
618
|
|
|
*/ |
619
|
2 |
|
protected function getPortableNamespaceDefinition(array $namespace) |
620
|
2 |
|
{ |
621
|
2 |
|
return $namespace; |
622
|
2 |
|
} |
623
|
|
|
|
624
|
|
|
/** |
625
|
|
|
* @param mixed[][] $functions |
626
|
|
|
* |
627
|
|
|
* @return mixed[][] |
628
|
|
|
*/ |
629
|
|
|
protected function _getPortableFunctionsList(array $functions) : array |
630
|
|
|
{ |
631
|
|
|
$list = []; |
632
|
|
|
foreach ($functions as $value) { |
633
|
|
|
$value = $this->_getPortableFunctionDefinition($value); |
634
|
3396 |
|
|
635
|
|
|
if (! $value) { |
|
|
|
|
636
|
3396 |
|
continue; |
637
|
3396 |
|
} |
638
|
3396 |
|
|
639
|
|
|
$list[] = $value; |
640
|
3396 |
|
} |
641
|
|
|
|
642
|
|
|
return $list; |
643
|
|
|
} |
644
|
3396 |
|
|
645
|
|
|
/** |
646
|
|
|
* @param mixed[] $function |
647
|
3396 |
|
* |
648
|
|
|
* @return mixed |
649
|
|
|
*/ |
650
|
|
|
protected function _getPortableFunctionDefinition(array $function) |
651
|
|
|
{ |
652
|
|
|
return $function; |
653
|
|
|
} |
654
|
|
|
|
655
|
|
|
/** |
656
|
|
|
* @param mixed[][] $triggers |
657
|
567 |
|
* |
658
|
|
|
* @return mixed[][] |
659
|
567 |
|
*/ |
660
|
|
|
protected function _getPortableTriggersList(array $triggers) : array |
661
|
567 |
|
{ |
662
|
567 |
|
$list = []; |
663
|
|
|
foreach ($triggers as $value) { |
664
|
|
|
$value = $this->_getPortableTriggerDefinition($value); |
665
|
567 |
|
|
666
|
|
|
if (! $value) { |
|
|
|
|
667
|
|
|
continue; |
668
|
|
|
} |
669
|
|
|
|
670
|
|
|
$list[] = $value; |
671
|
|
|
} |
672
|
|
|
|
673
|
|
|
return $list; |
674
|
|
|
} |
675
|
|
|
|
676
|
|
|
/** |
677
|
|
|
* @param mixed[] $trigger |
678
|
|
|
* |
679
|
|
|
* @return mixed |
680
|
|
|
*/ |
681
|
|
|
protected function _getPortableTriggerDefinition(array $trigger) |
682
|
|
|
{ |
683
|
|
|
return $trigger; |
684
|
|
|
} |
685
|
|
|
|
686
|
|
|
/** |
687
|
|
|
* @param mixed[][] $sequences |
688
|
|
|
* |
689
|
|
|
* @return Sequence[] |
690
|
|
|
*/ |
691
|
|
|
protected function _getPortableSequencesList(array $sequences) : array |
692
|
|
|
{ |
693
|
|
|
$list = []; |
694
|
|
|
|
695
|
|
|
foreach ($sequences as $value) { |
696
|
|
|
$list[] = $this->_getPortableSequenceDefinition($value); |
697
|
|
|
} |
698
|
|
|
|
699
|
|
|
return $list; |
700
|
|
|
} |
701
|
|
|
|
702
|
|
|
/** |
703
|
|
|
* @param mixed[] $sequence |
704
|
|
|
* |
705
|
|
|
* @throws DBALException |
706
|
|
|
*/ |
707
|
|
|
protected function _getPortableSequenceDefinition(array $sequence) : Sequence |
708
|
|
|
{ |
709
|
|
|
throw NotSupported::new('Sequences'); |
710
|
|
|
} |
711
|
|
|
|
712
|
|
|
/** |
713
|
|
|
* Independent of the database the keys of the column list result are lowercased. |
714
|
|
|
* |
715
|
|
|
* The name of the created column instance however is kept in its case. |
716
|
|
|
* |
717
|
|
|
* @param string $table The name of the table. |
718
|
|
|
* @param mixed[][] $tableColumns |
719
|
|
|
* |
720
|
|
|
* @return Column[] |
721
|
|
|
*/ |
722
|
|
|
protected function _getPortableTableColumnList(string $table, ?string $database, array $tableColumns) : array |
723
|
|
|
{ |
724
|
|
|
$eventManager = $this->_platform->getEventManager(); |
725
|
|
|
|
726
|
|
|
$list = []; |
727
|
|
|
foreach ($tableColumns as $tableColumn) { |
728
|
|
|
$column = null; |
729
|
|
|
$defaultPrevented = false; |
730
|
|
|
|
731
|
|
|
if ($eventManager !== null && $eventManager->hasListeners(Events::onSchemaColumnDefinition)) { |
732
|
|
|
$eventArgs = new SchemaColumnDefinitionEventArgs($tableColumn, $table, $database, $this->_conn); |
733
|
|
|
$eventManager->dispatchEvent(Events::onSchemaColumnDefinition, $eventArgs); |
734
|
|
|
|
735
|
|
|
$defaultPrevented = $eventArgs->isDefaultPrevented(); |
736
|
|
|
$column = $eventArgs->getColumn(); |
737
|
|
|
} |
738
|
|
|
|
739
|
|
|
if (! $defaultPrevented) { |
740
|
|
|
$column = $this->_getPortableTableColumnDefinition($tableColumn); |
741
|
|
|
} |
742
|
|
|
|
743
|
|
|
if (! $column) { |
744
|
|
|
continue; |
745
|
|
|
} |
746
|
|
|
|
747
|
|
|
$name = strtolower($column->getQuotedName($this->_platform)); |
748
|
|
|
$list[$name] = $column; |
749
|
|
|
} |
750
|
|
|
|
751
|
|
|
return $list; |
752
|
|
|
} |
753
|
|
|
|
754
|
|
|
/** |
755
|
|
|
* Gets Table Column Definition. |
756
|
|
|
* |
757
|
10 |
|
* @param mixed[] $tableColumn |
758
|
|
|
*/ |
759
|
10 |
|
abstract protected function _getPortableTableColumnDefinition(array $tableColumn) : Column; |
760
|
|
|
|
761
|
10 |
|
/** |
762
|
10 |
|
* Aggregates and groups the index results according to the required data result. |
763
|
|
|
* |
764
|
|
|
* @param mixed[][] $tableIndexRows |
765
|
10 |
|
* |
766
|
|
|
* @return Index[] |
767
|
|
|
*/ |
768
|
|
|
protected function _getPortableTableIndexesList(array $tableIndexRows, string $tableName) : array |
769
|
|
|
{ |
770
|
|
|
$result = []; |
771
|
|
|
foreach ($tableIndexRows as $tableIndex) { |
772
|
|
|
$indexName = $keyName = $tableIndex['key_name']; |
773
|
|
|
if ($tableIndex['primary']) { |
774
|
|
|
$keyName = 'primary'; |
775
|
|
|
} |
776
|
|
|
$keyName = strtolower($keyName); |
777
|
|
|
|
778
|
|
|
if (! isset($result[$keyName])) { |
779
|
|
|
$options = [ |
780
|
|
|
'lengths' => [], |
781
|
|
|
]; |
782
|
|
|
|
783
|
|
|
if (isset($tableIndex['where'])) { |
784
|
|
|
$options['where'] = $tableIndex['where']; |
785
|
|
|
} |
786
|
|
|
|
787
|
|
|
$result[$keyName] = [ |
788
|
|
|
'name' => $indexName, |
789
|
|
|
'columns' => [], |
790
|
|
|
'unique' => ! $tableIndex['non_unique'], |
791
|
4550 |
|
'primary' => $tableIndex['primary'], |
792
|
|
|
'flags' => $tableIndex['flags'] ?? [], |
793
|
4550 |
|
'options' => $options, |
794
|
|
|
]; |
795
|
4550 |
|
} |
796
|
4550 |
|
|
797
|
4550 |
|
$result[$keyName]['columns'][] = $tableIndex['column_name']; |
798
|
4550 |
|
$result[$keyName]['options']['lengths'][] = $tableIndex['length'] ?? null; |
799
|
|
|
} |
800
|
4550 |
|
|
801
|
3389 |
|
$eventManager = $this->_platform->getEventManager(); |
802
|
3389 |
|
|
803
|
|
|
$indexes = []; |
804
|
3389 |
|
foreach ($result as $indexKey => $data) { |
805
|
3389 |
|
$index = null; |
806
|
|
|
$defaultPrevented = false; |
807
|
|
|
|
808
|
4550 |
|
if ($eventManager !== null && $eventManager->hasListeners(Events::onSchemaIndexDefinition)) { |
809
|
4550 |
|
$eventArgs = new SchemaIndexDefinitionEventArgs($data, $tableName, $this->_conn); |
810
|
|
|
$eventManager->dispatchEvent(Events::onSchemaIndexDefinition, $eventArgs); |
811
|
|
|
|
812
|
4550 |
|
$defaultPrevented = $eventArgs->isDefaultPrevented(); |
813
|
|
|
$index = $eventArgs->getIndex(); |
814
|
|
|
} |
815
|
|
|
|
816
|
4550 |
|
if (! $defaultPrevented) { |
817
|
4550 |
|
$index = new Index($data['name'], $data['columns'], $data['unique'], $data['primary'], $data['flags'], $data['options']); |
818
|
|
|
} |
819
|
|
|
|
820
|
4550 |
|
if (! $index) { |
821
|
|
|
continue; |
822
|
|
|
} |
823
|
|
|
|
824
|
|
|
$indexes[$indexKey] = $index; |
825
|
|
|
} |
826
|
|
|
|
827
|
|
|
return $indexes; |
828
|
|
|
} |
829
|
|
|
|
830
|
|
|
/** |
831
|
|
|
* @param mixed[][] $tables |
832
|
|
|
* |
833
|
|
|
* @return string[] |
834
|
|
|
*/ |
835
|
|
|
protected function _getPortableTablesList(array $tables) : array |
836
|
|
|
{ |
837
|
|
|
$list = []; |
838
|
|
|
foreach ($tables as $value) { |
839
|
4536 |
|
$value = $this->_getPortableTableDefinition($value); |
840
|
|
|
|
841
|
4536 |
|
if (! $value) { |
842
|
4536 |
|
continue; |
843
|
4489 |
|
} |
844
|
4489 |
|
|
845
|
4485 |
|
$list[] = $value; |
846
|
|
|
} |
847
|
4489 |
|
|
848
|
|
|
return $list; |
849
|
4489 |
|
} |
850
|
|
|
|
851
|
4489 |
|
/** |
852
|
|
|
* @param mixed $table |
853
|
|
|
*/ |
854
|
4489 |
|
protected function _getPortableTableDefinition($table) : string |
855
|
621 |
|
{ |
856
|
|
|
return $table; |
857
|
|
|
} |
858
|
4489 |
|
|
859
|
4489 |
|
/** |
860
|
|
|
* @param mixed[][] $users |
861
|
4489 |
|
* |
862
|
4489 |
|
* @return string[][] |
863
|
4489 |
|
*/ |
864
|
4489 |
|
protected function _getPortableUsersList(array $users) : array |
865
|
|
|
{ |
866
|
|
|
$list = []; |
867
|
|
|
foreach ($users as $value) { |
868
|
4489 |
|
$value = $this->_getPortableUserDefinition($value); |
869
|
4489 |
|
|
870
|
|
|
if (! $value) { |
|
|
|
|
871
|
|
|
continue; |
872
|
4536 |
|
} |
873
|
|
|
|
874
|
4536 |
|
$list[] = $value; |
875
|
4536 |
|
} |
876
|
4489 |
|
|
877
|
4489 |
|
return $list; |
878
|
|
|
} |
879
|
4489 |
|
|
880
|
3364 |
|
/** |
881
|
3364 |
|
* @param string[] $user |
882
|
|
|
* |
883
|
3364 |
|
* @return string[] |
884
|
3364 |
|
*/ |
885
|
|
|
protected function _getPortableUserDefinition(array $user) : array |
886
|
|
|
{ |
887
|
4489 |
|
return $user; |
888
|
4489 |
|
} |
889
|
|
|
|
890
|
|
|
/** |
891
|
4489 |
|
* @param mixed[][] $views |
892
|
|
|
* |
893
|
|
|
* @return View[] |
894
|
|
|
*/ |
895
|
4489 |
|
protected function _getPortableViewsList(array $views) : array |
896
|
|
|
{ |
897
|
|
|
$list = []; |
898
|
4536 |
|
foreach ($views as $value) { |
899
|
|
|
$view = $this->_getPortableViewDefinition($value); |
900
|
|
|
$name = strtolower($view->getQuotedName($this->_platform)); |
901
|
|
|
$list[$name] = $view; |
902
|
|
|
} |
903
|
|
|
|
904
|
|
|
return $list; |
905
|
|
|
} |
906
|
4927 |
|
|
907
|
|
|
/** |
908
|
4927 |
|
* @param mixed[] $view |
909
|
4927 |
|
*/ |
910
|
4925 |
|
protected function _getPortableViewDefinition(array $view) : View |
911
|
|
|
{ |
912
|
4925 |
|
throw NotSupported::new('Views'); |
913
|
|
|
} |
914
|
|
|
|
915
|
|
|
/** |
916
|
4925 |
|
* @param mixed[][] $tableForeignKeys |
917
|
|
|
* |
918
|
|
|
* @return ForeignKeyConstraint[] |
919
|
4927 |
|
*/ |
920
|
|
|
protected function _getPortableTableForeignKeysList(array $tableForeignKeys) : array |
921
|
|
|
{ |
922
|
|
|
$list = []; |
923
|
|
|
|
924
|
|
|
foreach ($tableForeignKeys as $value) { |
925
|
|
|
$list[] = $this->_getPortableTableForeignKeyDefinition($value); |
926
|
|
|
} |
927
|
|
|
|
928
|
|
|
return $list; |
929
|
|
|
} |
930
|
|
|
|
931
|
|
|
/** |
932
|
|
|
* @param mixed $tableForeignKey |
933
|
|
|
*/ |
934
|
|
|
protected function _getPortableTableForeignKeyDefinition($tableForeignKey) : ForeignKeyConstraint |
935
|
|
|
{ |
936
|
|
|
return $tableForeignKey; |
937
|
|
|
} |
938
|
|
|
|
939
|
|
|
/** |
940
|
|
|
* @param string[]|string $sql |
941
|
|
|
*/ |
942
|
|
|
protected function _execSql($sql) : void |
943
|
|
|
{ |
944
|
|
|
foreach ((array) $sql as $query) { |
945
|
|
|
$this->_conn->executeUpdate($query); |
946
|
|
|
} |
947
|
|
|
} |
948
|
|
|
|
949
|
|
|
/** |
950
|
|
|
* Creates a schema instance for the current database. |
951
|
|
|
*/ |
952
|
|
|
public function createSchema() : Schema |
953
|
|
|
{ |
954
|
|
|
$namespaces = []; |
955
|
|
|
|
956
|
|
|
if ($this->_platform->supportsSchemas()) { |
957
|
|
|
$namespaces = $this->listNamespaceNames(); |
958
|
|
|
} |
959
|
|
|
|
960
|
|
|
$sequences = []; |
961
|
|
|
|
962
|
|
|
if ($this->_platform->supportsSequences()) { |
963
|
|
|
$sequences = $this->listSequences(); |
964
|
|
|
} |
965
|
|
|
|
966
|
|
|
$tables = $this->listTables(); |
967
|
|
|
|
968
|
3166 |
|
return new Schema($tables, $sequences, $this->createSchemaConfig(), $namespaces); |
969
|
|
|
} |
970
|
3166 |
|
|
971
|
3166 |
|
/** |
972
|
3166 |
|
* Creates the configuration for this schema. |
973
|
|
|
*/ |
974
|
3166 |
|
public function createSchemaConfig() : SchemaConfig |
975
|
|
|
{ |
976
|
|
|
$schemaConfig = new SchemaConfig(); |
977
|
|
|
$schemaConfig->setMaxIdentifierLength($this->_platform->getMaxIdentifierLength()); |
978
|
3166 |
|
|
979
|
3166 |
|
$searchPaths = $this->getSchemaSearchPaths(); |
980
|
|
|
if (isset($searchPaths[0])) { |
981
|
|
|
$schemaConfig->setName($searchPaths[0]); |
982
|
3166 |
|
} |
983
|
|
|
|
984
|
|
|
$params = $this->_conn->getParams(); |
985
|
|
|
if (! isset($params['defaultTableOptions'])) { |
986
|
|
|
$params['defaultTableOptions'] = []; |
987
|
|
|
} |
988
|
|
|
if (! isset($params['defaultTableOptions']['charset']) && isset($params['charset'])) { |
989
|
|
|
$params['defaultTableOptions']['charset'] = $params['charset']; |
990
|
|
|
} |
991
|
|
|
$schemaConfig->setDefaultTableOptions($params['defaultTableOptions']); |
992
|
|
|
|
993
|
|
|
return $schemaConfig; |
994
|
|
|
} |
995
|
|
|
|
996
|
|
|
/** |
997
|
|
|
* The search path for namespaces in the currently connected database. |
998
|
|
|
* |
999
|
|
|
* The first entry is usually the default namespace in the Schema. All |
1000
|
689 |
|
* further namespaces contain tables/sequences which can also be addressed |
1001
|
|
|
* with a short, not full-qualified name. |
1002
|
689 |
|
* |
1003
|
|
|
* For databases that don't support subschema/namespaces this method |
1004
|
689 |
|
* returns the name of the currently connected database. |
1005
|
657 |
|
* |
1006
|
|
|
* @return string[] |
1007
|
|
|
*/ |
1008
|
689 |
|
public function getSchemaSearchPaths() : array |
1009
|
|
|
{ |
1010
|
|
|
$database = $this->_conn->getDatabase(); |
1011
|
|
|
|
1012
|
|
|
if ($database !== null) { |
1013
|
|
|
return [$database]; |
1014
|
|
|
} |
1015
|
|
|
|
1016
|
|
|
return []; |
1017
|
|
|
} |
1018
|
|
|
|
1019
|
|
|
/** |
1020
|
|
|
* Given a table comment this method tries to extract a type hint for Doctrine Type. If the type hint is found, |
1021
|
|
|
* it's removed from the comment. |
1022
|
|
|
* |
1023
|
|
|
* @return string|null The extracted Doctrine type or NULL of the type hint was not found. |
1024
|
|
|
*/ |
1025
|
|
|
final protected function extractDoctrineTypeFromComment(?string &$comment) : ?string |
1026
|
5847 |
|
{ |
1027
|
|
|
if ($comment === null || ! preg_match('/(.*)\(DC2Type:(((?!\)).)+)\)(.*)/', $comment, $match)) { |
1028
|
5847 |
|
return null; |
1029
|
5847 |
|
} |
1030
|
|
|
|
1031
|
5793 |
|
$comment = $match[1] . $match[4]; |
1032
|
|
|
|
1033
|
|
|
return $match[2]; |
1034
|
|
|
} |
1035
|
|
|
|
1036
|
|
|
private function ensureDatabase(?string $database) : string |
1037
|
|
|
{ |
1038
|
4296 |
|
if ($database === null) { |
1039
|
|
|
throw new InvalidArgumentException('TMP: Needs a database'); |
1040
|
4296 |
|
} |
1041
|
|
|
|
1042
|
4296 |
|
return $database; |
1043
|
527 |
|
} |
1044
|
|
|
} |
1045
|
|
|
|
This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent.
Consider making the comparison explicit by using
empty(..)
or! empty(...)
instead.