本文整理汇总了PHP中JDatabaseDriver::renameTable方法的典型用法代码示例。如果您正苦于以下问题:PHP JDatabaseDriver::renameTable方法的具体用法?PHP JDatabaseDriver::renameTable怎么用?PHP JDatabaseDriver::renameTable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类JDatabaseDriver
的用法示例。
在下文中一共展示了JDatabaseDriver::renameTable方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: renameTable
/**
* Renames a table in the database.
*
* @param string $oldTable The name of the table to be renamed
* @param string $newTable The new name for the table.
* @param string $backup Non-MySQL: Table prefix
* @param string $prefix Non-MySQL: For the table - used to rename constraints in non-mysql databases
*
* @return self Returns this object to support chaining.
*
* @throws \RuntimeException
*/
public function renameTable($oldTable, $newTable, $backup = null, $prefix = null)
{
$this->_db->renameTable($oldTable, $newTable, $backup, $prefix);
return $this;
}
示例2: backupDatabase
/**
* Method to backup all tables in a database with a given prefix.
*
* @param JDatabaseDriver $db JDatabaseDriver object.
* @param string $prefix Database table prefix.
*
* @return boolean True on success.
*
* @since 3.1
*/
public function backupDatabase($db, $prefix)
{
$return = true;
$backup = 'bak_' . $prefix;
// Get the tables in the database.
$tables = $db->getTableList();
if ($tables) {
foreach ($tables as $table) {
// If the table uses the given prefix, back it up.
if (strpos($table, $prefix) === 0) {
// Backup table name.
$backupTable = str_replace($prefix, $backup, $table);
// Drop the backup table.
try {
$db->dropTable($backupTable, true);
} catch (RuntimeException $e) {
JFactory::getApplication()->enqueueMessage(JText::sprintf('INSTL_DATABASE_ERROR_BACKINGUP', $e->getMessage()), 'notice');
$return = false;
}
// Rename the current table to the backup table.
try {
$db->renameTable($table, $backupTable, $backup, $prefix);
} catch (RuntimeException $e) {
JFactory::getApplication()->enqueueMessage(JText::sprintf('INSTL_DATABASE_ERROR_BACKINGUP', $e->getMessage()), 'notice');
$return = false;
}
}
}
}
return $return;
}
示例3: backupDatabase
/**
* Method to backup all tables in a database with a given prefix.
*
* @param JDatabaseDriver $db JDatabaseDriver object.
* @param string $name Name of the database to process.
* @param string $prefix Database table prefix.
*
* @return boolean True on success.
*
* @since 3.0
*/
public function backupDatabase($db, $name, $prefix)
{
$return = true;
$backup = 'bak_' . $prefix;
// Get the tables in the database.
$tables = $db->getTableList();
if ($tables) {
foreach ($tables as $table) {
// If the table uses the given prefix, back it up.
if (strpos($table, $prefix) === 0) {
// Backup table name.
$backupTable = str_replace($prefix, $backup, $table);
// Drop the backup table.
try {
$db->dropTable($backupTable, true);
} catch (RuntimeException $e) {
$this->setError($e->getMessage());
$return = false;
}
// Rename the current table to the backup table.
try {
$db->renameTable($table, $backupTable, $backup, $prefix);
} catch (RuntimeException $e) {
$this->setError($e->getMessage());
$return = false;
}
}
}
}
return $return;
}