public function DatabaseSchema_sqlite::renameTable
public DatabaseSchema_sqlite::renameTable($table, $new_name)
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
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 existsing 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); } }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!sqlite!schema.inc/function/DatabaseSchema_sqlite::renameTable/7.x