public function DatabaseSchema_sqlite::renameTable in Drupal 7
Rename a table.
Parameters
$table: The table to be renamed.
$new_name: The new name for the table.
Throws
DatabaseSchemaObjectDoesNotExistException If the specified table doesn't exist.
DatabaseSchemaObjectExistsException If a table with the specified new name already exists.
Overrides DatabaseSchema::renameTable
1 call to DatabaseSchema_sqlite::renameTable()
- DatabaseSchema_sqlite::alterTable in includes/
database/ sqlite/ schema.inc - Create a table with a new schema containing the old content.
File
- includes/
database/ sqlite/ schema.inc, line 233 - Database schema code for SQLite databases.
Class
Code
public function renameTable($table, $new_name) {
if (!$this
->tableExists($table)) {
throw new DatabaseSchemaObjectDoesNotExistException(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 DatabaseSchemaObjectExistsException(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 incase 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);
}
}