1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace Doctrine\DBAL\Platforms; |
4
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Schema\ForeignKeyConstraint; |
6
|
|
|
use Doctrine\DBAL\Schema\Identifier; |
7
|
|
|
use Doctrine\DBAL\Schema\Index; |
8
|
|
|
use Doctrine\DBAL\Schema\Table; |
9
|
|
|
use Doctrine\DBAL\Schema\TableDiff; |
10
|
|
|
use Doctrine\DBAL\TransactionIsolationLevel; |
11
|
|
|
use Doctrine\DBAL\Types\BlobType; |
12
|
|
|
use Doctrine\DBAL\Types\TextType; |
13
|
|
|
use InvalidArgumentException; |
14
|
|
|
use function array_diff_key; |
15
|
|
|
use function array_merge; |
16
|
|
|
use function array_unique; |
17
|
|
|
use function array_values; |
18
|
|
|
use function count; |
19
|
|
|
use function func_get_args; |
20
|
|
|
use function implode; |
21
|
|
|
use function in_array; |
22
|
|
|
use function is_numeric; |
23
|
|
|
use function is_string; |
24
|
|
|
use function sprintf; |
25
|
|
|
use function str_replace; |
26
|
|
|
use function strtoupper; |
27
|
|
|
use function trim; |
28
|
|
|
|
29
|
|
|
/** |
30
|
|
|
* The MySqlPlatform provides the behavior, features and SQL dialect of the |
31
|
|
|
* MySQL database platform. This platform represents a MySQL 5.0 or greater platform that |
32
|
|
|
* uses the InnoDB storage engine. |
33
|
|
|
* |
34
|
|
|
* @todo Rename: MySQLPlatform |
35
|
|
|
*/ |
36
|
|
|
class MySqlPlatform extends AbstractPlatform |
37
|
|
|
{ |
38
|
|
|
public const LENGTH_LIMIT_TINYTEXT = 255; |
39
|
|
|
public const LENGTH_LIMIT_TEXT = 65535; |
40
|
|
|
public const LENGTH_LIMIT_MEDIUMTEXT = 16777215; |
41
|
|
|
|
42
|
|
|
public const LENGTH_LIMIT_TINYBLOB = 255; |
43
|
|
|
public const LENGTH_LIMIT_BLOB = 65535; |
44
|
|
|
public const LENGTH_LIMIT_MEDIUMBLOB = 16777215; |
45
|
|
|
|
46
|
|
|
/** |
47
|
|
|
* {@inheritDoc} |
48
|
|
|
*/ |
49
|
436 |
|
protected function doModifyLimitQuery($query, $limit, $offset) |
50
|
|
|
{ |
51
|
436 |
|
if ($limit !== null) { |
52
|
260 |
|
$query .= ' LIMIT ' . $limit; |
53
|
|
|
|
54
|
260 |
|
if ($offset > 0) { |
55
|
260 |
|
$query .= ' OFFSET ' . $offset; |
56
|
|
|
} |
57
|
190 |
|
} elseif ($offset > 0) { |
58
|
|
|
// 2^64-1 is the maximum of unsigned BIGINT, the biggest limit possible |
59
|
95 |
|
$query .= ' LIMIT 18446744073709551615 OFFSET ' . $offset; |
60
|
|
|
} |
61
|
|
|
|
62
|
436 |
|
return $query; |
63
|
|
|
} |
64
|
|
|
|
65
|
|
|
/** |
66
|
|
|
* {@inheritDoc} |
67
|
|
|
*/ |
68
|
2242 |
|
public function getIdentifierQuoteCharacter() |
69
|
|
|
{ |
70
|
2242 |
|
return '`'; |
71
|
|
|
} |
72
|
|
|
|
73
|
|
|
/** |
74
|
|
|
* {@inheritDoc} |
75
|
|
|
*/ |
76
|
81 |
|
public function getRegexpExpression() |
77
|
|
|
{ |
78
|
81 |
|
return 'RLIKE'; |
79
|
|
|
} |
80
|
|
|
|
81
|
|
|
/** |
82
|
|
|
* {@inheritDoc} |
83
|
|
|
* |
84
|
|
|
* @deprecated Use application-generated UUIDs instead |
85
|
|
|
*/ |
86
|
28 |
|
public function getGuidExpression() |
87
|
|
|
{ |
88
|
28 |
|
return 'UUID()'; |
89
|
|
|
} |
90
|
|
|
|
91
|
|
|
/** |
92
|
|
|
* {@inheritDoc} |
93
|
|
|
*/ |
94
|
14 |
|
public function getLocateExpression($str, $substr, $startPos = false) |
95
|
|
|
{ |
96
|
14 |
|
if ($startPos === false) { |
97
|
14 |
|
return 'LOCATE(' . $substr . ', ' . $str . ')'; |
98
|
|
|
} |
99
|
|
|
|
100
|
14 |
|
return 'LOCATE(' . $substr . ', ' . $str . ', ' . $startPos . ')'; |
101
|
|
|
} |
102
|
|
|
|
103
|
|
|
/** |
104
|
|
|
* {@inheritDoc} |
105
|
|
|
*/ |
106
|
81 |
|
public function getConcatExpression() |
107
|
|
|
{ |
108
|
81 |
|
return sprintf('CONCAT(%s)', implode(', ', func_get_args())); |
109
|
|
|
} |
110
|
|
|
|
111
|
|
|
/** |
112
|
|
|
* {@inheritdoc} |
113
|
|
|
*/ |
114
|
14 |
|
protected function getDateArithmeticIntervalExpression($date, $operator, $interval, $unit) |
115
|
|
|
{ |
116
|
14 |
|
$function = $operator === '+' ? 'DATE_ADD' : 'DATE_SUB'; |
117
|
|
|
|
118
|
14 |
|
return $function . '(' . $date . ', INTERVAL ' . $interval . ' ' . $unit . ')'; |
119
|
|
|
} |
120
|
|
|
|
121
|
|
|
/** |
122
|
|
|
* {@inheritDoc} |
123
|
|
|
*/ |
124
|
42 |
|
public function getDateDiffExpression($date1, $date2) |
125
|
|
|
{ |
126
|
42 |
|
return 'DATEDIFF(' . $date1 . ', ' . $date2 . ')'; |
127
|
|
|
} |
128
|
|
|
|
129
|
|
|
/** |
130
|
|
|
* {@inheritDoc} |
131
|
|
|
*/ |
132
|
109 |
|
public function getListDatabasesSQL() |
133
|
|
|
{ |
134
|
109 |
|
return 'SHOW DATABASES'; |
135
|
|
|
} |
136
|
|
|
|
137
|
|
|
/** |
138
|
|
|
* {@inheritDoc} |
139
|
|
|
*/ |
140
|
|
|
public function getListTableConstraintsSQL($table) |
141
|
|
|
{ |
142
|
|
|
return 'SHOW INDEX FROM ' . $table; |
143
|
|
|
} |
144
|
|
|
|
145
|
|
|
/** |
146
|
|
|
* {@inheritDoc} |
147
|
|
|
* |
148
|
|
|
* Two approaches to listing the table indexes. The information_schema is |
149
|
|
|
* preferred, because it doesn't cause problems with SQL keywords such as "order" or "table". |
150
|
|
|
*/ |
151
|
776 |
|
public function getListTableIndexesSQL($table, $currentDatabase = null) |
152
|
|
|
{ |
153
|
776 |
|
if ($currentDatabase) { |
154
|
776 |
|
$currentDatabase = $this->quoteStringLiteral($currentDatabase); |
155
|
776 |
|
$table = $this->quoteStringLiteral($table); |
156
|
|
|
|
157
|
|
|
return 'SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name,' . |
158
|
|
|
' SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type' . |
159
|
776 |
|
' FROM information_schema.STATISTICS WHERE TABLE_NAME = ' . $table . |
160
|
776 |
|
' AND TABLE_SCHEMA = ' . $currentDatabase . |
161
|
776 |
|
' ORDER BY SEQ_IN_INDEX ASC'; |
162
|
|
|
} |
163
|
|
|
|
164
|
|
|
return 'SHOW INDEX FROM ' . $table; |
165
|
|
|
} |
166
|
|
|
|
167
|
|
|
/** |
168
|
|
|
* {@inheritDoc} |
169
|
|
|
*/ |
170
|
95 |
|
public function getListViewsSQL($database) |
171
|
|
|
{ |
172
|
95 |
|
$database = $this->quoteStringLiteral($database); |
173
|
|
|
|
174
|
95 |
|
return 'SELECT * FROM information_schema.VIEWS WHERE TABLE_SCHEMA = ' . $database; |
175
|
|
|
} |
176
|
|
|
|
177
|
|
|
/** |
178
|
|
|
* {@inheritDoc} |
179
|
|
|
*/ |
180
|
801 |
|
public function getListTableForeignKeysSQL($table, $database = null) |
181
|
|
|
{ |
182
|
801 |
|
$table = $this->quoteStringLiteral($table); |
183
|
|
|
|
184
|
801 |
|
if ($database !== null) { |
185
|
720 |
|
$database = $this->quoteStringLiteral($database); |
186
|
|
|
} |
187
|
|
|
|
188
|
|
|
$sql = 'SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, ' . |
189
|
|
|
'k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ ' . |
190
|
|
|
'FROM information_schema.key_column_usage k /*!50116 ' . |
191
|
|
|
'INNER JOIN information_schema.referential_constraints c ON ' . |
192
|
|
|
' c.constraint_name = k.constraint_name AND ' . |
193
|
801 |
|
' c.table_name = ' . $table . ' */ WHERE k.table_name = ' . $table; |
194
|
|
|
|
195
|
801 |
|
$databaseNameSql = $database ?? 'DATABASE()'; |
196
|
|
|
|
197
|
801 |
|
$sql .= ' AND k.table_schema = ' . $databaseNameSql . ' /*!50116 AND c.constraint_schema = ' . $databaseNameSql . ' */'; |
198
|
801 |
|
$sql .= ' AND k.`REFERENCED_COLUMN_NAME` is not NULL'; |
199
|
|
|
|
200
|
801 |
|
return $sql; |
201
|
|
|
} |
202
|
|
|
|
203
|
|
|
/** |
204
|
|
|
* {@inheritDoc} |
205
|
|
|
*/ |
206
|
14 |
|
public function getCreateViewSQL($name, $sql) |
207
|
|
|
{ |
208
|
14 |
|
return 'CREATE VIEW ' . $name . ' AS ' . $sql; |
209
|
|
|
} |
210
|
|
|
|
211
|
|
|
/** |
212
|
|
|
* {@inheritDoc} |
213
|
|
|
*/ |
214
|
14 |
|
public function getDropViewSQL($name) |
215
|
|
|
{ |
216
|
14 |
|
return 'DROP VIEW ' . $name; |
217
|
|
|
} |
218
|
|
|
|
219
|
|
|
/** |
220
|
|
|
* {@inheritDoc} |
221
|
|
|
*/ |
222
|
2353 |
|
protected function getVarcharTypeDeclarationSQLSnippet($length, $fixed) |
223
|
|
|
{ |
224
|
2353 |
|
return $fixed ? ($length ? 'CHAR(' . $length . ')' : 'CHAR(255)') |
225
|
2353 |
|
: ($length ? 'VARCHAR(' . $length . ')' : 'VARCHAR(255)'); |
226
|
|
|
} |
227
|
|
|
|
228
|
|
|
/** |
229
|
|
|
* {@inheritdoc} |
230
|
|
|
*/ |
231
|
109 |
|
protected function getBinaryTypeDeclarationSQLSnippet($length, $fixed) |
232
|
|
|
{ |
233
|
109 |
|
return $fixed ? 'BINARY(' . ($length ?: 255) . ')' : 'VARBINARY(' . ($length ?: 255) . ')'; |
234
|
|
|
} |
235
|
|
|
|
236
|
|
|
/** |
237
|
|
|
* Gets the SQL snippet used to declare a CLOB column type. |
238
|
|
|
* TINYTEXT : 2 ^ 8 - 1 = 255 |
239
|
|
|
* TEXT : 2 ^ 16 - 1 = 65535 |
240
|
|
|
* MEDIUMTEXT : 2 ^ 24 - 1 = 16777215 |
241
|
|
|
* LONGTEXT : 2 ^ 32 - 1 = 4294967295 |
242
|
|
|
* |
243
|
|
|
* {@inheritDoc} |
244
|
|
|
*/ |
245
|
1105 |
|
public function getClobTypeDeclarationSQL(array $field) |
246
|
|
|
{ |
247
|
1105 |
|
if (! empty($field['length']) && is_numeric($field['length'])) { |
248
|
122 |
|
$length = $field['length']; |
249
|
|
|
|
250
|
122 |
|
if ($length <= static::LENGTH_LIMIT_TINYTEXT) { |
251
|
95 |
|
return 'TINYTEXT'; |
252
|
|
|
} |
253
|
|
|
|
254
|
122 |
|
if ($length <= static::LENGTH_LIMIT_TEXT) { |
255
|
122 |
|
return 'TEXT'; |
256
|
|
|
} |
257
|
|
|
|
258
|
95 |
|
if ($length <= static::LENGTH_LIMIT_MEDIUMTEXT) { |
259
|
95 |
|
return 'MEDIUMTEXT'; |
260
|
|
|
} |
261
|
|
|
} |
262
|
|
|
|
263
|
1078 |
|
return 'LONGTEXT'; |
264
|
|
|
} |
265
|
|
|
|
266
|
|
|
/** |
267
|
|
|
* {@inheritDoc} |
268
|
|
|
*/ |
269
|
421 |
|
public function getDateTimeTypeDeclarationSQL(array $fieldDeclaration) |
270
|
|
|
{ |
271
|
421 |
|
if (isset($fieldDeclaration['version']) && $fieldDeclaration['version'] === true) { |
272
|
81 |
|
return 'TIMESTAMP'; |
273
|
|
|
} |
274
|
|
|
|
275
|
421 |
|
return 'DATETIME'; |
276
|
|
|
} |
277
|
|
|
|
278
|
|
|
/** |
279
|
|
|
* {@inheritDoc} |
280
|
|
|
*/ |
281
|
270 |
|
public function getDateTypeDeclarationSQL(array $fieldDeclaration) |
282
|
|
|
{ |
283
|
270 |
|
return 'DATE'; |
284
|
|
|
} |
285
|
|
|
|
286
|
|
|
/** |
287
|
|
|
* {@inheritDoc} |
288
|
|
|
*/ |
289
|
256 |
|
public function getTimeTypeDeclarationSQL(array $fieldDeclaration) |
290
|
|
|
{ |
291
|
256 |
|
return 'TIME'; |
292
|
|
|
} |
293
|
|
|
|
294
|
|
|
/** |
295
|
|
|
* {@inheritDoc} |
296
|
|
|
*/ |
297
|
305 |
|
public function getBooleanTypeDeclarationSQL(array $field) |
298
|
|
|
{ |
299
|
305 |
|
return 'TINYINT(1)'; |
300
|
|
|
} |
301
|
|
|
|
302
|
|
|
/** |
303
|
|
|
* Obtain DBMS specific SQL code portion needed to set the COLLATION |
304
|
|
|
* of a field declaration to be used in statements like CREATE TABLE. |
305
|
|
|
* |
306
|
|
|
* @deprecated Deprecated since version 2.5, Use {@link self::getColumnCollationDeclarationSQL()} instead. |
307
|
|
|
* |
308
|
|
|
* @param string $collation name of the collation |
309
|
|
|
* |
310
|
|
|
* @return string DBMS specific SQL code portion needed to set the COLLATION |
311
|
|
|
* of a field declaration. |
312
|
|
|
*/ |
313
|
|
|
public function getCollationFieldDeclaration($collation) |
314
|
|
|
{ |
315
|
|
|
return $this->getColumnCollationDeclarationSQL($collation); |
316
|
|
|
} |
317
|
|
|
|
318
|
|
|
/** |
319
|
|
|
* {@inheritDoc} |
320
|
|
|
* |
321
|
|
|
* MySql prefers "autoincrement" identity columns since sequences can only |
322
|
|
|
* be emulated with a table. |
323
|
|
|
*/ |
324
|
95 |
|
public function prefersIdentityColumns() |
325
|
|
|
{ |
326
|
95 |
|
return true; |
327
|
|
|
} |
328
|
|
|
|
329
|
|
|
/** |
330
|
|
|
* {@inheritDoc} |
331
|
|
|
* |
332
|
|
|
* MySql supports this through AUTO_INCREMENT columns. |
333
|
|
|
*/ |
334
|
123 |
|
public function supportsIdentityColumns() |
335
|
|
|
{ |
336
|
123 |
|
return true; |
337
|
|
|
} |
338
|
|
|
|
339
|
|
|
/** |
340
|
|
|
* {@inheritDoc} |
341
|
|
|
*/ |
342
|
5026 |
|
public function supportsInlineColumnComments() |
343
|
|
|
{ |
344
|
5026 |
|
return true; |
345
|
|
|
} |
346
|
|
|
|
347
|
|
|
/** |
348
|
|
|
* {@inheritDoc} |
349
|
|
|
*/ |
350
|
257 |
|
public function supportsColumnCollation() |
351
|
|
|
{ |
352
|
257 |
|
return true; |
353
|
|
|
} |
354
|
|
|
|
355
|
|
|
/** |
356
|
|
|
* {@inheritDoc} |
357
|
|
|
*/ |
358
|
1090 |
|
public function getListTablesSQL() |
359
|
|
|
{ |
360
|
1090 |
|
return "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"; |
361
|
|
|
} |
362
|
|
|
|
363
|
|
|
/** |
364
|
|
|
* {@inheritDoc} |
365
|
|
|
*/ |
366
|
888 |
|
public function getListTableColumnsSQL($table, $database = null) |
367
|
|
|
{ |
368
|
888 |
|
$table = $this->quoteStringLiteral($table); |
369
|
|
|
|
370
|
888 |
|
if ($database) { |
371
|
807 |
|
$database = $this->quoteStringLiteral($database); |
372
|
|
|
} else { |
373
|
81 |
|
$database = 'DATABASE()'; |
374
|
|
|
} |
375
|
|
|
|
376
|
|
|
return 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, ' . |
377
|
|
|
'COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, ' . |
378
|
|
|
'CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation ' . |
379
|
888 |
|
'FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ' . $database . ' AND TABLE_NAME = ' . $table . |
380
|
888 |
|
' ORDER BY ORDINAL_POSITION ASC'; |
381
|
|
|
} |
382
|
|
|
|
383
|
530 |
|
public function getListTableMetadataSQL(string $table, ?string $database = null) : string |
384
|
|
|
{ |
385
|
530 |
|
return sprintf( |
386
|
|
|
<<<'SQL' |
387
|
530 |
|
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS |
388
|
|
|
FROM information_schema.TABLES |
389
|
|
|
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = %s AND TABLE_NAME = %s |
390
|
|
|
SQL |
391
|
|
|
, |
392
|
530 |
|
$database ? $this->quoteStringLiteral($database) : 'DATABASE()', |
393
|
530 |
|
$this->quoteStringLiteral($table) |
394
|
|
|
); |
395
|
|
|
} |
396
|
|
|
|
397
|
|
|
/** |
398
|
|
|
* {@inheritDoc} |
399
|
|
|
*/ |
400
|
109 |
|
public function getCreateDatabaseSQL($name) |
401
|
|
|
{ |
402
|
109 |
|
return 'CREATE DATABASE ' . $name; |
403
|
|
|
} |
404
|
|
|
|
405
|
|
|
/** |
406
|
|
|
* {@inheritDoc} |
407
|
|
|
*/ |
408
|
109 |
|
public function getDropDatabaseSQL($name) |
409
|
|
|
{ |
410
|
109 |
|
return 'DROP DATABASE ' . $name; |
411
|
|
|
} |
412
|
|
|
|
413
|
|
|
/** |
414
|
|
|
* {@inheritDoc} |
415
|
|
|
*/ |
416
|
3568 |
|
protected function _getCreateTableSQL($tableName, array $columns, array $options = []) |
417
|
|
|
{ |
418
|
3568 |
|
$queryFields = $this->getColumnDeclarationListSQL($columns); |
419
|
|
|
|
420
|
3568 |
|
if (isset($options['uniqueConstraints']) && ! empty($options['uniqueConstraints'])) { |
421
|
|
|
foreach ($options['uniqueConstraints'] as $index => $definition) { |
422
|
|
|
$queryFields .= ', ' . $this->getUniqueConstraintDeclarationSQL($index, $definition); |
423
|
|
|
} |
424
|
|
|
} |
425
|
|
|
|
426
|
|
|
// add all indexes |
427
|
3568 |
|
if (isset($options['indexes']) && ! empty($options['indexes'])) { |
428
|
778 |
|
foreach ($options['indexes'] as $index => $definition) { |
429
|
778 |
|
$queryFields .= ', ' . $this->getIndexDeclarationSQL($index, $definition); |
430
|
|
|
} |
431
|
|
|
} |
432
|
|
|
|
433
|
|
|
// attach all primary keys |
434
|
3568 |
|
if (isset($options['primary']) && ! empty($options['primary'])) { |
435
|
1889 |
|
$keyColumns = array_unique(array_values($options['primary'])); |
436
|
1889 |
|
$queryFields .= ', PRIMARY KEY(' . implode(', ', $keyColumns) . ')'; |
437
|
|
|
} |
438
|
|
|
|
439
|
3568 |
|
$query = 'CREATE '; |
440
|
|
|
|
441
|
3568 |
|
if (! empty($options['temporary'])) { |
442
|
|
|
$query .= 'TEMPORARY '; |
443
|
|
|
} |
444
|
|
|
|
445
|
3568 |
|
$query .= 'TABLE ' . $tableName . ' (' . $queryFields . ') '; |
446
|
3568 |
|
$query .= $this->buildTableOptions($options); |
447
|
3568 |
|
$query .= $this->buildPartitionOptions($options); |
448
|
|
|
|
449
|
3568 |
|
$sql = [$query]; |
450
|
3568 |
|
$engine = 'INNODB'; |
451
|
|
|
|
452
|
3568 |
|
if (isset($options['engine'])) { |
453
|
271 |
|
$engine = strtoupper(trim($options['engine'])); |
454
|
|
|
} |
455
|
|
|
|
456
|
|
|
// Propagate foreign key constraints only for InnoDB. |
457
|
3568 |
|
if (isset($options['foreignKeys']) && $engine === 'INNODB') { |
458
|
2335 |
|
foreach ((array) $options['foreignKeys'] as $definition) { |
459
|
274 |
|
$sql[] = $this->getCreateForeignKeySQL($definition, $tableName); |
460
|
|
|
} |
461
|
|
|
} |
462
|
|
|
|
463
|
3568 |
|
return $sql; |
464
|
|
|
} |
465
|
|
|
|
466
|
|
|
/** |
467
|
|
|
* {@inheritdoc} |
468
|
|
|
*/ |
469
|
5107 |
|
public function getDefaultValueDeclarationSQL($field) |
470
|
|
|
{ |
471
|
|
|
// Unset the default value if the given field definition does not allow default values. |
472
|
5107 |
|
if ($field['type'] instanceof TextType || $field['type'] instanceof BlobType) { |
473
|
898 |
|
$field['default'] = null; |
474
|
|
|
} |
475
|
|
|
|
476
|
5107 |
|
return parent::getDefaultValueDeclarationSQL($field); |
477
|
|
|
} |
478
|
|
|
|
479
|
|
|
/** |
480
|
|
|
* Build SQL for table options |
481
|
|
|
* |
482
|
|
|
* @param mixed[] $options |
483
|
|
|
* |
484
|
|
|
* @return string |
485
|
|
|
*/ |
486
|
3568 |
|
private function buildTableOptions(array $options) |
487
|
|
|
{ |
488
|
3568 |
|
if (isset($options['table_options'])) { |
489
|
|
|
return $options['table_options']; |
490
|
|
|
} |
491
|
|
|
|
492
|
3568 |
|
$tableOptions = []; |
493
|
|
|
|
494
|
|
|
// Charset |
495
|
3568 |
|
if (! isset($options['charset'])) { |
496
|
3554 |
|
$options['charset'] = 'utf8'; |
497
|
|
|
} |
498
|
|
|
|
499
|
3568 |
|
$tableOptions[] = sprintf('DEFAULT CHARACTER SET %s', $options['charset']); |
500
|
|
|
|
501
|
|
|
// Collate |
502
|
3568 |
|
if (! isset($options['collate'])) { |
503
|
3554 |
|
$options['collate'] = $options['charset'] . '_unicode_ci'; |
504
|
|
|
} |
505
|
|
|
|
506
|
3568 |
|
$tableOptions[] = sprintf('COLLATE %s', $options['collate']); |
507
|
|
|
|
508
|
|
|
// Engine |
509
|
3568 |
|
if (! isset($options['engine'])) { |
510
|
3297 |
|
$options['engine'] = 'InnoDB'; |
511
|
|
|
} |
512
|
|
|
|
513
|
3568 |
|
$tableOptions[] = sprintf('ENGINE = %s', $options['engine']); |
514
|
|
|
|
515
|
|
|
// Auto increment |
516
|
3568 |
|
if (isset($options['auto_increment'])) { |
517
|
|
|
$tableOptions[] = sprintf('AUTO_INCREMENT = %s', $options['auto_increment']); |
518
|
|
|
} |
519
|
|
|
|
520
|
|
|
// Comment |
521
|
3568 |
|
if (isset($options['comment'])) { |
522
|
|
|
$comment = trim($options['comment'], " '"); |
523
|
|
|
|
524
|
|
|
$tableOptions[] = sprintf('COMMENT = %s ', $this->quoteStringLiteral($comment)); |
525
|
|
|
} |
526
|
|
|
|
527
|
|
|
// Row format |
528
|
3568 |
|
if (isset($options['row_format'])) { |
529
|
|
|
$tableOptions[] = sprintf('ROW_FORMAT = %s', $options['row_format']); |
530
|
|
|
} |
531
|
|
|
|
532
|
3568 |
|
return implode(' ', $tableOptions); |
533
|
|
|
} |
534
|
|
|
|
535
|
|
|
/** |
536
|
|
|
* Build SQL for partition options. |
537
|
|
|
* |
538
|
|
|
* @param mixed[] $options |
539
|
|
|
* |
540
|
|
|
* @return string |
541
|
|
|
*/ |
542
|
3568 |
|
private function buildPartitionOptions(array $options) |
543
|
|
|
{ |
544
|
3568 |
|
return isset($options['partition_options']) |
545
|
|
|
? ' ' . $options['partition_options'] |
546
|
3568 |
|
: ''; |
547
|
|
|
} |
548
|
|
|
|
549
|
|
|
/** |
550
|
|
|
* {@inheritDoc} |
551
|
|
|
*/ |
552
|
2409 |
|
public function getAlterTableSQL(TableDiff $diff) |
553
|
|
|
{ |
554
|
2409 |
|
$columnSql = []; |
555
|
2409 |
|
$queryParts = []; |
556
|
2409 |
|
if ($diff->newName !== false) { |
557
|
162 |
|
$queryParts[] = 'RENAME TO ' . $diff->getNewName()->getQuotedName($this); |
558
|
|
|
} |
559
|
|
|
|
560
|
2409 |
|
foreach ($diff->addedColumns as $column) { |
561
|
514 |
|
if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) { |
562
|
|
|
continue; |
563
|
|
|
} |
564
|
|
|
|
565
|
514 |
|
$columnArray = $column->toArray(); |
566
|
514 |
|
$columnArray['comment'] = $this->getColumnComment($column); |
567
|
514 |
|
$queryParts[] = 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray); |
568
|
|
|
} |
569
|
|
|
|
570
|
2409 |
|
foreach ($diff->removedColumns as $column) { |
571
|
257 |
|
if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) { |
572
|
|
|
continue; |
573
|
|
|
} |
574
|
|
|
|
575
|
257 |
|
$queryParts[] = 'DROP ' . $column->getQuotedName($this); |
576
|
|
|
} |
577
|
|
|
|
578
|
2409 |
|
foreach ($diff->changedColumns as $columnDiff) { |
579
|
799 |
|
if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) { |
580
|
|
|
continue; |
581
|
|
|
} |
582
|
|
|
|
583
|
799 |
|
$column = $columnDiff->column; |
584
|
799 |
|
$columnArray = $column->toArray(); |
585
|
|
|
|
586
|
|
|
// Don't propagate default value changes for unsupported column types. |
587
|
799 |
|
if ($columnDiff->hasChanged('default') && |
588
|
799 |
|
count($columnDiff->changedProperties) === 1 && |
589
|
799 |
|
($columnArray['type'] instanceof TextType || $columnArray['type'] instanceof BlobType) |
590
|
|
|
) { |
591
|
64 |
|
continue; |
592
|
|
|
} |
593
|
|
|
|
594
|
735 |
|
$columnArray['comment'] = $this->getColumnComment($column); |
595
|
735 |
|
$queryParts[] = 'CHANGE ' . ($columnDiff->getOldColumnName()->getQuotedName($this)) . ' ' |
596
|
735 |
|
. $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray); |
597
|
|
|
} |
598
|
|
|
|
599
|
2409 |
|
foreach ($diff->renamedColumns as $oldColumnName => $column) { |
600
|
338 |
|
if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) { |
601
|
|
|
continue; |
602
|
|
|
} |
603
|
|
|
|
604
|
338 |
|
$oldColumnName = new Identifier($oldColumnName); |
605
|
338 |
|
$columnArray = $column->toArray(); |
606
|
338 |
|
$columnArray['comment'] = $this->getColumnComment($column); |
607
|
338 |
|
$queryParts[] = 'CHANGE ' . $oldColumnName->getQuotedName($this) . ' ' |
608
|
338 |
|
. $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray); |
609
|
|
|
} |
610
|
|
|
|
611
|
2409 |
|
if (isset($diff->addedIndexes['primary'])) { |
612
|
298 |
|
$keyColumns = array_unique(array_values($diff->addedIndexes['primary']->getColumns())); |
613
|
298 |
|
$queryParts[] = 'ADD PRIMARY KEY (' . implode(', ', $keyColumns) . ')'; |
614
|
298 |
|
unset($diff->addedIndexes['primary']); |
615
|
2111 |
|
} elseif (isset($diff->changedIndexes['primary'])) { |
616
|
|
|
// Necessary in case the new primary key includes a new auto_increment column |
617
|
365 |
|
foreach ($diff->changedIndexes['primary']->getColumns() as $columnName) { |
618
|
365 |
|
if (isset($diff->addedColumns[$columnName]) && $diff->addedColumns[$columnName]->getAutoincrement()) { |
619
|
14 |
|
$keyColumns = array_unique(array_values($diff->changedIndexes['primary']->getColumns())); |
620
|
14 |
|
$queryParts[] = 'DROP PRIMARY KEY'; |
621
|
14 |
|
$queryParts[] = 'ADD PRIMARY KEY (' . implode(', ', $keyColumns) . ')'; |
622
|
14 |
|
unset($diff->changedIndexes['primary']); |
623
|
365 |
|
break; |
624
|
|
|
} |
625
|
|
|
} |
626
|
|
|
} |
627
|
|
|
|
628
|
2409 |
|
$sql = []; |
629
|
2409 |
|
$tableSql = []; |
630
|
|
|
|
631
|
2409 |
|
if (! $this->onSchemaAlterTable($diff, $tableSql)) { |
632
|
2409 |
|
if (count($queryParts) > 0) { |
633
|
1318 |
|
$sql[] = 'ALTER TABLE ' . $diff->getName($this)->getQuotedName($this) . ' ' . implode(', ', $queryParts); |
634
|
|
|
} |
635
|
2409 |
|
$sql = array_merge( |
636
|
2409 |
|
$this->getPreAlterTableIndexForeignKeySQL($diff), |
637
|
2409 |
|
$sql, |
638
|
2409 |
|
$this->getPostAlterTableIndexForeignKeySQL($diff) |
639
|
|
|
); |
640
|
|
|
} |
641
|
|
|
|
642
|
2409 |
|
return array_merge($sql, $tableSql, $columnSql); |
643
|
|
|
} |
644
|
|
|
|
645
|
|
|
/** |
646
|
|
|
* {@inheritDoc} |
647
|
|
|
*/ |
648
|
2409 |
|
protected function getPreAlterTableIndexForeignKeySQL(TableDiff $diff) |
649
|
|
|
{ |
650
|
2409 |
|
$sql = []; |
651
|
2409 |
|
$table = $diff->getName($this)->getQuotedName($this); |
652
|
|
|
|
653
|
2409 |
|
foreach ($diff->changedIndexes as $changedIndex) { |
654
|
460 |
|
$sql = array_merge($sql, $this->getPreAlterTableAlterPrimaryKeySQL($diff, $changedIndex)); |
655
|
|
|
} |
656
|
|
|
|
657
|
2409 |
|
foreach ($diff->removedIndexes as $remKey => $remIndex) { |
658
|
285 |
|
$sql = array_merge($sql, $this->getPreAlterTableAlterPrimaryKeySQL($diff, $remIndex)); |
659
|
|
|
|
660
|
285 |
|
foreach ($diff->addedIndexes as $addKey => $addIndex) { |
661
|
81 |
|
if ($remIndex->getColumns() === $addIndex->getColumns()) { |
662
|
81 |
|
$indexClause = 'INDEX ' . $addIndex->getName(); |
663
|
|
|
|
664
|
81 |
|
if ($addIndex->isPrimary()) { |
665
|
|
|
$indexClause = 'PRIMARY KEY'; |
666
|
81 |
|
} elseif ($addIndex->isUnique()) { |
667
|
81 |
|
$indexClause = 'UNIQUE INDEX ' . $addIndex->getName(); |
668
|
|
|
} |
669
|
|
|
|
670
|
81 |
|
$query = 'ALTER TABLE ' . $table . ' DROP INDEX ' . $remIndex->getName() . ', '; |
671
|
81 |
|
$query .= 'ADD ' . $indexClause; |
672
|
81 |
|
$query .= ' (' . $this->getIndexFieldDeclarationListSQL($addIndex) . ')'; |
673
|
|
|
|
674
|
81 |
|
$sql[] = $query; |
675
|
|
|
|
676
|
81 |
|
unset($diff->removedIndexes[$remKey], $diff->addedIndexes[$addKey]); |
677
|
|
|
|
678
|
285 |
|
break; |
679
|
|
|
} |
680
|
|
|
} |
681
|
|
|
} |
682
|
|
|
|
683
|
2409 |
|
$engine = 'INNODB'; |
684
|
|
|
|
685
|
2409 |
|
if ($diff->fromTable instanceof Table && $diff->fromTable->hasOption('engine')) { |
686
|
109 |
|
$engine = strtoupper(trim($diff->fromTable->getOption('engine'))); |
687
|
|
|
} |
688
|
|
|
|
689
|
|
|
// Suppress foreign key constraint propagation on non-supporting engines. |
690
|
2409 |
|
if ($engine !== 'INNODB') { |
691
|
81 |
|
$diff->addedForeignKeys = []; |
692
|
81 |
|
$diff->changedForeignKeys = []; |
693
|
81 |
|
$diff->removedForeignKeys = []; |
694
|
|
|
} |
695
|
|
|
|
696
|
2409 |
|
$sql = array_merge( |
697
|
2409 |
|
$sql, |
698
|
2409 |
|
$this->getPreAlterTableAlterIndexForeignKeySQL($diff), |
699
|
2409 |
|
parent::getPreAlterTableIndexForeignKeySQL($diff), |
700
|
2409 |
|
$this->getPreAlterTableRenameIndexForeignKeySQL($diff) |
701
|
|
|
); |
702
|
|
|
|
703
|
2409 |
|
return $sql; |
704
|
|
|
} |
705
|
|
|
|
706
|
|
|
/** |
707
|
|
|
* @return string[] |
708
|
|
|
*/ |
709
|
731 |
|
private function getPreAlterTableAlterPrimaryKeySQL(TableDiff $diff, Index $index) |
710
|
|
|
{ |
711
|
731 |
|
$sql = []; |
712
|
|
|
|
713
|
731 |
|
if (! $index->isPrimary() || ! $diff->fromTable instanceof Table) { |
714
|
285 |
|
return $sql; |
715
|
|
|
} |
716
|
|
|
|
717
|
446 |
|
$tableName = $diff->getName($this)->getQuotedName($this); |
718
|
|
|
|
719
|
|
|
// Dropping primary keys requires to unset autoincrement attribute on the particular column first. |
720
|
446 |
|
foreach ($index->getColumns() as $columnName) { |
721
|
446 |
|
if (! $diff->fromTable->hasColumn($columnName)) { |
722
|
81 |
|
continue; |
723
|
|
|
} |
724
|
|
|
|
725
|
446 |
|
$column = $diff->fromTable->getColumn($columnName); |
726
|
|
|
|
727
|
446 |
|
if ($column->getAutoincrement() !== true) { |
728
|
365 |
|
continue; |
729
|
|
|
} |
730
|
|
|
|
731
|
257 |
|
$column->setAutoincrement(false); |
732
|
|
|
|
733
|
257 |
|
$sql[] = 'ALTER TABLE ' . $tableName . ' MODIFY ' . |
734
|
257 |
|
$this->getColumnDeclarationSQL($column->getQuotedName($this), $column->toArray()); |
735
|
|
|
|
736
|
|
|
// original autoincrement information might be needed later on by other parts of the table alteration |
737
|
257 |
|
$column->setAutoincrement(true); |
738
|
|
|
} |
739
|
|
|
|
740
|
446 |
|
return $sql; |
741
|
|
|
} |
742
|
|
|
|
743
|
|
|
/** |
744
|
|
|
* @param TableDiff $diff The table diff to gather the SQL for. |
745
|
|
|
* |
746
|
|
|
* @return string[] |
747
|
|
|
*/ |
748
|
2409 |
|
private function getPreAlterTableAlterIndexForeignKeySQL(TableDiff $diff) |
749
|
|
|
{ |
750
|
2409 |
|
$sql = []; |
751
|
2409 |
|
$table = $diff->getName($this)->getQuotedName($this); |
752
|
|
|
|
753
|
2409 |
|
foreach ($diff->changedIndexes as $changedIndex) { |
754
|
|
|
// Changed primary key |
755
|
460 |
|
if (! $changedIndex->isPrimary() || ! ($diff->fromTable instanceof Table)) { |
756
|
109 |
|
continue; |
757
|
|
|
} |
758
|
|
|
|
759
|
351 |
|
foreach ($diff->fromTable->getPrimaryKeyColumns() as $columnName) { |
760
|
351 |
|
$column = $diff->fromTable->getColumn($columnName); |
761
|
|
|
|
762
|
|
|
// Check if an autoincrement column was dropped from the primary key. |
763
|
351 |
|
if (! $column->getAutoincrement() || in_array($columnName, $changedIndex->getColumns())) { |
764
|
270 |
|
continue; |
765
|
|
|
} |
766
|
|
|
|
767
|
|
|
// The autoincrement attribute needs to be removed from the dropped column |
768
|
|
|
// before we can drop and recreate the primary key. |
769
|
81 |
|
$column->setAutoincrement(false); |
770
|
|
|
|
771
|
81 |
|
$sql[] = 'ALTER TABLE ' . $table . ' MODIFY ' . |
772
|
81 |
|
$this->getColumnDeclarationSQL($column->getQuotedName($this), $column->toArray()); |
773
|
|
|
|
774
|
|
|
// Restore the autoincrement attribute as it might be needed later on |
775
|
|
|
// by other parts of the table alteration. |
776
|
351 |
|
$column->setAutoincrement(true); |
777
|
|
|
} |
778
|
|
|
} |
779
|
|
|
|
780
|
2409 |
|
return $sql; |
781
|
|
|
} |
782
|
|
|
|
783
|
|
|
/** |
784
|
|
|
* @param TableDiff $diff The table diff to gather the SQL for. |
785
|
|
|
* |
786
|
|
|
* @return string[] |
787
|
|
|
*/ |
788
|
1627 |
|
protected function getPreAlterTableRenameIndexForeignKeySQL(TableDiff $diff) |
789
|
|
|
{ |
790
|
1627 |
|
$sql = []; |
791
|
1627 |
|
$tableName = $diff->getName($this)->getQuotedName($this); |
792
|
|
|
|
793
|
1627 |
|
foreach ($this->getRemainingForeignKeyConstraintsRequiringRenamedIndexes($diff) as $foreignKey) { |
794
|
64 |
|
if (in_array($foreignKey, $diff->changedForeignKeys, true)) { |
795
|
|
|
continue; |
796
|
|
|
} |
797
|
|
|
|
798
|
64 |
|
$sql[] = $this->getDropForeignKeySQL($foreignKey, $tableName); |
799
|
|
|
} |
800
|
|
|
|
801
|
1627 |
|
return $sql; |
802
|
|
|
} |
803
|
|
|
|
804
|
|
|
/** |
805
|
|
|
* Returns the remaining foreign key constraints that require one of the renamed indexes. |
806
|
|
|
* |
807
|
|
|
* "Remaining" here refers to the diff between the foreign keys currently defined in the associated |
808
|
|
|
* table and the foreign keys to be removed. |
809
|
|
|
* |
810
|
|
|
* @param TableDiff $diff The table diff to evaluate. |
811
|
|
|
* |
812
|
|
|
* @return ForeignKeyConstraint[] |
813
|
|
|
*/ |
814
|
1627 |
|
private function getRemainingForeignKeyConstraintsRequiringRenamedIndexes(TableDiff $diff) |
815
|
|
|
{ |
816
|
1627 |
|
if (empty($diff->renamedIndexes) || ! $diff->fromTable instanceof Table) { |
817
|
1347 |
|
return []; |
818
|
|
|
} |
819
|
|
|
|
820
|
290 |
|
$foreignKeys = []; |
821
|
|
|
/** @var ForeignKeyConstraint[] $remainingForeignKeys */ |
822
|
290 |
|
$remainingForeignKeys = array_diff_key( |
823
|
290 |
|
$diff->fromTable->getForeignKeys(), |
824
|
290 |
|
$diff->removedForeignKeys |
825
|
|
|
); |
826
|
|
|
|
827
|
290 |
|
foreach ($remainingForeignKeys as $foreignKey) { |
828
|
64 |
|
foreach ($diff->renamedIndexes as $index) { |
829
|
64 |
|
if ($foreignKey->intersectsIndexColumns($index)) { |
830
|
64 |
|
$foreignKeys[] = $foreignKey; |
831
|
|
|
|
832
|
64 |
|
break; |
833
|
|
|
} |
834
|
|
|
} |
835
|
|
|
} |
836
|
|
|
|
837
|
290 |
|
return $foreignKeys; |
838
|
|
|
} |
839
|
|
|
|
840
|
|
|
/** |
841
|
|
|
* {@inheritdoc} |
842
|
|
|
*/ |
843
|
2409 |
|
protected function getPostAlterTableIndexForeignKeySQL(TableDiff $diff) |
844
|
|
|
{ |
845
|
2409 |
|
return array_merge( |
846
|
2409 |
|
parent::getPostAlterTableIndexForeignKeySQL($diff), |
847
|
2409 |
|
$this->getPostAlterTableRenameIndexForeignKeySQL($diff) |
848
|
|
|
); |
849
|
|
|
} |
850
|
|
|
|
851
|
|
|
/** |
852
|
|
|
* @param TableDiff $diff The table diff to gather the SQL for. |
853
|
|
|
* |
854
|
|
|
* @return string[] |
855
|
|
|
*/ |
856
|
1627 |
|
protected function getPostAlterTableRenameIndexForeignKeySQL(TableDiff $diff) |
857
|
|
|
{ |
858
|
1627 |
|
$sql = []; |
859
|
1627 |
|
$tableName = $diff->newName !== false |
860
|
108 |
|
? $diff->getNewName()->getQuotedName($this) |
861
|
1627 |
|
: $diff->getName($this)->getQuotedName($this); |
862
|
|
|
|
863
|
1627 |
|
foreach ($this->getRemainingForeignKeyConstraintsRequiringRenamedIndexes($diff) as $foreignKey) { |
864
|
64 |
|
if (in_array($foreignKey, $diff->changedForeignKeys, true)) { |
865
|
|
|
continue; |
866
|
|
|
} |
867
|
|
|
|
868
|
64 |
|
$sql[] = $this->getCreateForeignKeySQL($foreignKey, $tableName); |
869
|
|
|
} |
870
|
|
|
|
871
|
1627 |
|
return $sql; |
872
|
|
|
} |
873
|
|
|
|
874
|
|
|
/** |
875
|
|
|
* {@inheritDoc} |
876
|
|
|
*/ |
877
|
1467 |
|
protected function getCreateIndexSQLFlags(Index $index) |
878
|
|
|
{ |
879
|
1467 |
|
$type = ''; |
880
|
1467 |
|
if ($index->isUnique()) { |
881
|
313 |
|
$type .= 'UNIQUE '; |
882
|
1196 |
|
} elseif ($index->hasFlag('fulltext')) { |
883
|
95 |
|
$type .= 'FULLTEXT '; |
884
|
1101 |
|
} elseif ($index->hasFlag('spatial')) { |
885
|
95 |
|
$type .= 'SPATIAL '; |
886
|
|
|
} |
887
|
|
|
|
888
|
1467 |
|
return $type; |
889
|
|
|
} |
890
|
|
|
|
891
|
|
|
/** |
892
|
|
|
* {@inheritDoc} |
893
|
|
|
*/ |
894
|
3604 |
|
public function getIntegerTypeDeclarationSQL(array $field) |
895
|
|
|
{ |
896
|
3604 |
|
return 'INT' . $this->_getCommonIntegerTypeDeclarationSQL($field); |
897
|
|
|
} |
898
|
|
|
|
899
|
|
|
/** |
900
|
|
|
* {@inheritDoc} |
901
|
|
|
*/ |
902
|
210 |
|
public function getBigIntTypeDeclarationSQL(array $field) |
903
|
|
|
{ |
904
|
210 |
|
return 'BIGINT' . $this->_getCommonIntegerTypeDeclarationSQL($field); |
905
|
|
|
} |
906
|
|
|
|
907
|
|
|
/** |
908
|
|
|
* {@inheritDoc} |
909
|
|
|
*/ |
910
|
14 |
|
public function getSmallIntTypeDeclarationSQL(array $field) |
911
|
|
|
{ |
912
|
14 |
|
return 'SMALLINT' . $this->_getCommonIntegerTypeDeclarationSQL($field); |
913
|
|
|
} |
914
|
|
|
|
915
|
|
|
/** |
916
|
|
|
* {@inheritdoc} |
917
|
|
|
*/ |
918
|
710 |
|
public function getFloatDeclarationSQL(array $field) |
919
|
|
|
{ |
920
|
710 |
|
return 'DOUBLE PRECISION' . $this->getUnsignedDeclaration($field); |
921
|
|
|
} |
922
|
|
|
|
923
|
|
|
/** |
924
|
|
|
* {@inheritdoc} |
925
|
|
|
*/ |
926
|
766 |
|
public function getDecimalTypeDeclarationSQL(array $columnDef) |
927
|
|
|
{ |
928
|
766 |
|
return parent::getDecimalTypeDeclarationSQL($columnDef) . $this->getUnsignedDeclaration($columnDef); |
929
|
|
|
} |
930
|
|
|
|
931
|
|
|
/** |
932
|
|
|
* Get unsigned declaration for a column. |
933
|
|
|
* |
934
|
|
|
* @param mixed[] $columnDef |
935
|
|
|
* |
936
|
|
|
* @return string |
937
|
|
|
*/ |
938
|
4604 |
|
private function getUnsignedDeclaration(array $columnDef) |
939
|
|
|
{ |
940
|
4604 |
|
return ! empty($columnDef['unsigned']) ? ' UNSIGNED' : ''; |
941
|
|
|
} |
942
|
|
|
|
943
|
|
|
/** |
944
|
|
|
* {@inheritDoc} |
945
|
|
|
*/ |
946
|
3604 |
|
protected function _getCommonIntegerTypeDeclarationSQL(array $columnDef) |
947
|
|
|
{ |
948
|
3604 |
|
$autoinc = ''; |
949
|
3604 |
|
if (! empty($columnDef['autoincrement'])) { |
950
|
565 |
|
$autoinc = ' AUTO_INCREMENT'; |
951
|
|
|
} |
952
|
|
|
|
953
|
3604 |
|
return $this->getUnsignedDeclaration($columnDef) . $autoinc; |
954
|
|
|
} |
955
|
|
|
|
956
|
|
|
/** |
957
|
|
|
* {@inheritDoc} |
958
|
|
|
*/ |
959
|
721 |
|
public function getColumnCharsetDeclarationSQL($charset) |
960
|
|
|
{ |
961
|
721 |
|
return 'CHARACTER SET ' . $charset; |
962
|
721 |
|
} |
963
|
|
|
|
964
|
|
|
/** |
965
|
721 |
|
* {@inheritDoc} |
966
|
|
|
*/ |
967
|
721 |
|
public function getAdvancedForeignKeyOptionsSQL(ForeignKeyConstraint $foreignKey) |
968
|
|
|
{ |
969
|
|
|
$query = ''; |
970
|
|
|
if ($foreignKey->hasOption('match')) { |
971
|
|
|
$query .= ' MATCH ' . $foreignKey->getOption('match'); |
972
|
|
|
} |
973
|
944 |
|
$query .= parent::getAdvancedForeignKeyOptionsSQL($foreignKey); |
974
|
|
|
|
975
|
944 |
|
return $query; |
976
|
650 |
|
} |
977
|
304 |
|
|
978
|
304 |
|
/** |
979
|
|
|
* {@inheritDoc} |
980
|
|
|
*/ |
981
|
|
|
public function getDropIndexSQL($index, $table = null) |
982
|
|
|
{ |
983
|
944 |
|
if ($index instanceof Index) { |
984
|
14 |
|
$indexName = $index->getQuotedName($this); |
985
|
930 |
|
} elseif (is_string($index)) { |
986
|
|
|
$indexName = $index; |
987
|
|
|
} else { |
988
|
|
|
throw new InvalidArgumentException('MysqlPlatform::getDropIndexSQL() expects $index parameter to be string or \Doctrine\DBAL\Schema\Index.'); |
989
|
944 |
|
} |
990
|
|
|
|
991
|
|
|
if ($table instanceof Table) { |
992
|
527 |
|
$table = $table->getQuotedName($this); |
993
|
|
|
} elseif (! is_string($table)) { |
994
|
|
|
throw new InvalidArgumentException('MysqlPlatform::getDropIndexSQL() expects $table parameter to be string or \Doctrine\DBAL\Schema\Table.'); |
995
|
417 |
|
} |
996
|
|
|
|
997
|
|
|
if ($index instanceof Index && $index->isPrimary()) { |
998
|
|
|
// mysql primary keys are always named "PRIMARY", |
999
|
|
|
// so we cannot use them in statements because of them being keyword. |
1000
|
|
|
return $this->getDropPrimaryKeySQL($table); |
1001
|
|
|
} |
1002
|
|
|
|
1003
|
527 |
|
return 'DROP INDEX ' . $indexName . ' ON ' . $table; |
1004
|
|
|
} |
1005
|
527 |
|
|
1006
|
|
|
/** |
1007
|
|
|
* @param string $table |
1008
|
|
|
* |
1009
|
|
|
* @return string |
1010
|
|
|
*/ |
1011
|
81 |
|
protected function getDropPrimaryKeySQL($table) |
1012
|
|
|
{ |
1013
|
81 |
|
return 'ALTER TABLE ' . $table . ' DROP PRIMARY KEY'; |
1014
|
|
|
} |
1015
|
|
|
|
1016
|
|
|
/** |
1017
|
|
|
* {@inheritDoc} |
1018
|
|
|
*/ |
1019
|
1490 |
|
public function getSetTransactionIsolationSQL($level) |
1020
|
|
|
{ |
1021
|
1490 |
|
return 'SET SESSION TRANSACTION ISOLATION LEVEL ' . $this->_getTransactionIsolationLevelSQL($level); |
1022
|
|
|
} |
1023
|
|
|
|
1024
|
|
|
/** |
1025
|
|
|
* {@inheritDoc} |
1026
|
|
|
*/ |
1027
|
|
|
public function getName() |
1028
|
|
|
{ |
1029
|
|
|
return 'mysql'; |
1030
|
|
|
} |
1031
|
|
|
|
1032
|
|
|
/** |
1033
|
|
|
* {@inheritDoc} |
1034
|
|
|
*/ |
1035
|
487 |
|
public function getReadLockSQL() |
1036
|
|
|
{ |
1037
|
487 |
|
return 'LOCK IN SHARE MODE'; |
1038
|
|
|
} |
1039
|
|
|
|
1040
|
|
|
/** |
1041
|
|
|
* {@inheritDoc} |
1042
|
|
|
*/ |
1043
|
|
|
protected function initializeDoctrineTypeMappings() |
1044
|
|
|
{ |
1045
|
|
|
$this->doctrineTypeMapping = [ |
1046
|
|
|
'tinyint' => 'boolean', |
1047
|
|
|
'smallint' => 'smallint', |
1048
|
|
|
'mediumint' => 'integer', |
1049
|
|
|
'int' => 'integer', |
1050
|
|
|
'integer' => 'integer', |
1051
|
|
|
'bigint' => 'bigint', |
1052
|
|
|
'tinytext' => 'text', |
1053
|
|
|
'mediumtext' => 'text', |
1054
|
|
|
'longtext' => 'text', |
1055
|
|
|
'text' => 'text', |
1056
|
|
|
'varchar' => 'string', |
1057
|
|
|
'string' => 'string', |
1058
|
|
|
'char' => 'string', |
1059
|
|
|
'date' => 'date', |
1060
|
|
|
'datetime' => 'datetime', |
1061
|
|
|
'timestamp' => 'datetime', |
1062
|
|
|
'time' => 'time', |
1063
|
|
|
'float' => 'float', |
1064
|
|
|
'double' => 'float', |
1065
|
|
|
'real' => 'float', |
1066
|
|
|
'decimal' => 'decimal', |
1067
|
|
|
'numeric' => 'decimal', |
1068
|
|
|
'year' => 'date', |
1069
|
487 |
|
'longblob' => 'blob', |
1070
|
|
|
'blob' => 'blob', |
1071
|
|
|
'mediumblob' => 'blob', |
1072
|
|
|
'tinyblob' => 'blob', |
1073
|
|
|
'binary' => 'binary', |
1074
|
2353 |
|
'varbinary' => 'binary', |
1075
|
|
|
'set' => 'simple_array', |
1076
|
2353 |
|
]; |
1077
|
|
|
} |
1078
|
|
|
|
1079
|
|
|
/** |
1080
|
|
|
* {@inheritDoc} |
1081
|
|
|
*/ |
1082
|
271 |
|
public function getVarcharMaxLength() |
1083
|
|
|
{ |
1084
|
271 |
|
return 65535; |
1085
|
|
|
} |
1086
|
|
|
|
1087
|
|
|
/** |
1088
|
|
|
* {@inheritdoc} |
1089
|
|
|
*/ |
1090
|
1782 |
|
public function getBinaryMaxLength() |
1091
|
|
|
{ |
1092
|
1782 |
|
return 65535; |
1093
|
|
|
} |
1094
|
|
|
|
1095
|
|
|
/** |
1096
|
|
|
* {@inheritDoc} |
1097
|
|
|
*/ |
1098
|
|
|
protected function getReservedKeywordsClass() |
1099
|
|
|
{ |
1100
|
|
|
return Keywords\MySQLKeywords::class; |
1101
|
28 |
|
} |
1102
|
|
|
|
1103
|
28 |
|
/** |
1104
|
|
|
* {@inheritDoc} |
1105
|
28 |
|
* |
1106
|
|
|
* MySQL commits a transaction implicitly when DROP TABLE is executed, however not |
1107
|
|
|
* if DROP TEMPORARY TABLE is executed. |
1108
|
|
|
*/ |
1109
|
28 |
|
public function getDropTemporaryTableSQL($table) |
1110
|
|
|
{ |
1111
|
|
|
if ($table instanceof Table) { |
1112
|
|
|
$table = $table->getQuotedName($this); |
1113
|
|
|
} elseif (! is_string($table)) { |
1114
|
|
|
throw new InvalidArgumentException('getDropTemporaryTableSQL() expects $table parameter to be string or \Doctrine\DBAL\Schema\Table.'); |
1115
|
|
|
} |
1116
|
|
|
|
1117
|
|
|
return 'DROP TEMPORARY TABLE ' . $table; |
1118
|
|
|
} |
1119
|
|
|
|
1120
|
|
|
/** |
1121
|
352 |
|
* Gets the SQL Snippet used to declare a BLOB column type. |
1122
|
|
|
* TINYBLOB : 2 ^ 8 - 1 = 255 |
1123
|
352 |
|
* BLOB : 2 ^ 16 - 1 = 65535 |
1124
|
190 |
|
* MEDIUMBLOB : 2 ^ 24 - 1 = 16777215 |
1125
|
|
|
* LONGBLOB : 2 ^ 32 - 1 = 4294967295 |
1126
|
190 |
|
* |
1127
|
95 |
|
* {@inheritDoc} |
1128
|
|
|
*/ |
1129
|
|
|
public function getBlobTypeDeclarationSQL(array $field) |
1130
|
190 |
|
{ |
1131
|
95 |
|
if (! empty($field['length']) && is_numeric($field['length'])) { |
1132
|
|
|
$length = $field['length']; |
1133
|
|
|
|
1134
|
190 |
|
if ($length <= static::LENGTH_LIMIT_TINYBLOB) { |
1135
|
176 |
|
return 'TINYBLOB'; |
1136
|
|
|
} |
1137
|
|
|
|
1138
|
|
|
if ($length <= static::LENGTH_LIMIT_BLOB) { |
1139
|
352 |
|
return 'BLOB'; |
1140
|
|
|
} |
1141
|
|
|
|
1142
|
|
|
if ($length <= static::LENGTH_LIMIT_MEDIUMBLOB) { |
1143
|
|
|
return 'MEDIUMBLOB'; |
1144
|
|
|
} |
1145
|
2805 |
|
} |
1146
|
|
|
|
1147
|
2805 |
|
return 'LONGBLOB'; |
1148
|
|
|
} |
1149
|
2805 |
|
|
1150
|
|
|
/** |
1151
|
|
|
* {@inheritdoc} |
1152
|
|
|
*/ |
1153
|
|
|
public function quoteStringLiteral($str) |
1154
|
|
|
{ |
1155
|
27 |
|
$str = str_replace('\\', '\\\\', $str); // MySQL requires backslashes to be escaped aswell. |
1156
|
|
|
|
1157
|
27 |
|
return parent::quoteStringLiteral($str); |
1158
|
|
|
} |
1159
|
|
|
|
1160
|
|
|
/** |
1161
|
|
|
* {@inheritdoc} |
1162
|
|
|
*/ |
1163
|
3768 |
|
public function getDefaultTransactionIsolationLevel() |
1164
|
|
|
{ |
1165
|
3768 |
|
return TransactionIsolationLevel::REPEATABLE_READ; |
1166
|
|
|
} |
1167
|
|
|
|
1168
|
|
|
/** |
1169
|
|
|
* {@inheritdoc} |
1170
|
|
|
*/ |
1171
|
|
|
public function supportsColumnLengthIndexes() : bool |
1172
|
|
|
{ |
1173
|
|
|
return true; |
1174
|
|
|
} |
1175
|
|
|
} |
1176
|
|
|
|