public Schema::renameTable($table, $new_name)
Rename a table.
Parameters
$table: The table to be renamed.
$new_name: The new name for the table.
Throws
\Drupal\Core\Database\SchemaObjectDoesNotExistException If the specified table doesn't exist.
\Drupal\Core\Database\SchemaObjectExistsException If a table with the specified new name already exists.
Overrides Schema::renameTable
File
- core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php, line 250
Class
- Schema
- SQLite implementation of \Drupal\Core\Database\Schema.
Namespace
Drupal\Core\Database\Driver\sqlite
Code
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 | public function renameTable($table, $new_name) { if (!$this->tableExists($table)) { throw new SchemaObjectDoesNotExistException(t("Cannot rename @table to @table_new: table @table doesn't exist.", array('@table' => $table, '@table_new' => $new_name))); } if ($this->tableExists($new_name)) { throw new SchemaObjectExistsException(t("Cannot rename @table to @table_new: table @table_new already exists.", array('@table' => $table, '@table_new' => $new_name))); } $schema = $this->introspectSchema($table); // SQLite doesn't allow you to rename tables outside of the current // database. So the syntax '... RENAME TO database.table' would fail. // So we must determine the full table name here rather than surrounding // the table with curly braces in case the db_prefix contains a reference // to a database outside of our existing database. $info = $this->getPrefixInfo($new_name); $this->connection->query('ALTER TABLE {' . $table . '} RENAME TO ' . $info['table']); // Drop the indexes, there is no RENAME INDEX command in SQLite. if (!empty($schema['unique keys'])) { foreach ($schema['unique keys'] as $key => $fields) { $this->dropIndex($table, $key); } } if (!empty($schema['indexes'])) { foreach ($schema['indexes'] as $index => $fields) { $this->dropIndex($table, $index); } } // Recreate the indexes. $statements = $this->createIndexSql($new_name, $schema); foreach ($statements as $statement) { $this->connection->query($statement); }} |
Please login to continue.