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

toSql() public method

public toSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver	SQLBuilder\Driver\BaseDriver
$args	SQLBuilder\ArgumentArray

示例#1

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

 public function addColumn($table, $arg)
 {
     $column = buildColumn($arg);
     $query = new AlterTableQuery($table);
     $query->addColumn($column);
     $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);
 }