PHP SQLBuilder\Universal\Query AlterTableQuery::rename示例

rename() public method

Rename Table

public rename ( string $toTable )
$toTable	string	table name

示例#1

文件： AlterTableQueryTest.php 项目： Ruyka/SQLBuilder

 public function testRenameTable()
 {
     $driver = new MySQLDriver();
     $args = new ArgumentArray();
     $q = new AlterTableQuery('products');
     $q->rename('products_new');
     $sql = $q->toSql($driver, $args);
     $this->assertQuery($q);
     is('ALTER TABLE `products` RENAME TO `products_new`', $sql);
     $q = new AlterTableQuery('products_new');
     $q->rename('products');
     $sql = $q->toSql($driver, $args);
     $this->assertQuery($q);
     is('ALTER TABLE `products_new` RENAME TO `products`', $sql);
 }