doctrine /
dbal
| @@ 331-343 (lines=13) @@ | ||
| 328 | /** |
|
| 329 | * {@inheritDoc} |
|
| 330 | */ |
|
| 331 | public function getListTableColumnsSQL($table, $database = null) |
|
| 332 | { |
|
| 333 | if ($database) { |
|
| 334 | $database = "'" . $database . "'"; |
|
| 335 | } else { |
|
| 336 | $database = 'DATABASE()'; |
|
| 337 | } |
|
| 338 | ||
| 339 | return "SELECT COLUMN_NAME, DATA_TYPE, COLUMN_COMMENT, IS_NULLABLE, IS_AUTO_INCREMENT, CHARACTER_MAXIMUM_LENGTH, COLUMN_DEFAULT," . |
|
| 340 | " NUMERIC_PRECISION, NUMERIC_SCALE, COLLATION_NAME" . |
|
| 341 | " FROM DATA_DICTIONARY.COLUMNS" . |
|
| 342 | " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME = '" . $table . "'"; |
|
| 343 | } |
|
| 344 | ||
| 345 | /** |
|
| 346 | * {@inheritDoc} |
|
| @@ 348-359 (lines=12) @@ | ||
| 345 | /** |
|
| 346 | * {@inheritDoc} |
|
| 347 | */ |
|
| 348 | public function getListTableForeignKeysSQL($table, $database = null) |
|
| 349 | { |
|
| 350 | if ($database) { |
|
| 351 | $database = "'" . $database . "'"; |
|
| 352 | } else { |
|
| 353 | $database = 'DATABASE()'; |
|
| 354 | } |
|
| 355 | ||
| 356 | return "SELECT CONSTRAINT_NAME, CONSTRAINT_COLUMNS, REFERENCED_TABLE_NAME, REFERENCED_TABLE_COLUMNS, UPDATE_RULE, DELETE_RULE" . |
|
| 357 | " FROM DATA_DICTIONARY.FOREIGN_KEYS" . |
|
| 358 | " WHERE CONSTRAINT_SCHEMA=" . $database . " AND CONSTRAINT_TABLE='" . $table . "'"; |
|
| 359 | } |
|
| 360 | ||
| 361 | /** |
|
| 362 | * {@inheritDoc} |
|
| @@ 364-375 (lines=12) @@ | ||
| 361 | /** |
|
| 362 | * {@inheritDoc} |
|
| 363 | */ |
|
| 364 | public function getListTableIndexesSQL($table, $database = null) |
|
| 365 | { |
|
| 366 | if ($database) { |
|
| 367 | $database = "'" . $database . "'"; |
|
| 368 | } else { |
|
| 369 | $database = 'DATABASE()'; |
|
| 370 | } |
|
| 371 | ||
| 372 | return "SELECT INDEX_NAME AS 'key_name', COLUMN_NAME AS 'column_name', IS_USED_IN_PRIMARY AS 'primary', IS_UNIQUE=0 AS 'non_unique'" . |
|
| 373 | " FROM DATA_DICTIONARY.INDEX_PARTS" . |
|
| 374 | " WHERE TABLE_SCHEMA=" . $database . " AND TABLE_NAME='" . $table . "'"; |
|
| 375 | } |
|
| 376 | ||
| 377 | /** |
|
| 378 | * {@inheritDoc} |
|
