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

renameColumn() public method

Rename table column

public renameColumn ( string $fromColumn, Column $toColumn )
$fromColumn	string
$toColumn	SQLBuilder\Universal\Syntax\Column

示例#1

文件： Migration.php 项目： corneltek/lazyrecord

 /**
  * Rename column requires $schema object.
  */
 public function renameColumn($table, $oldColumn, $newColumn)
 {
     if ($this->driver instanceof MySQLDriver && is_string($newColumn)) {
         throw new InvalidArgumentException('MySQLDriver requires the new column to be a column definition object.');
     }
     $query = new AlterTableQuery($table);
     $query->renameColumn($oldColumn, $newColumn);
     $sql = $query->toSql($this->driver, new ArgumentArray());
     $this->query($sql);
 }

示例#2

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

 public function testRenameColumnFromColumnClass()
 {
     $driver = new MySQLDriver();
     $args = new ArgumentArray();
     $q = new AlterTableQuery('products');
     $q->renameColumn(new Column('name'), new Column('title', 'varchar(30)'));
     $sql = $q->toSql($driver, $args);
     $this->assertQuery($q);
     is('ALTER TABLE `products` CHANGE COLUMN `name` `title` varchar(30)', $sql);
 }