SQLBuilder\Universal\Query\AlterTableQuery::toSql PHP Метод

toSql() публичный Метод

public toSql ( BaseDriver $driver, SQLBuilder\ArgumentArray $args )
$driver SQLBuilder\Driver\BaseDriver
$args SQLBuilder\ArgumentArray
    public function toSql(BaseDriver $driver, ArgumentArray $args)
    {
        $sql = 'ALTER TABLE ' . $driver->quoteIdentifier($this->table) . ' ';
        $alterSpecSqls = array();
        foreach ($this->specs as $spec) {
            $alterSpecSqls[] = $spec->toSql($driver, $args);
        }
        $sql .= join(",\n  ", $alterSpecSqls);
        return $sql;
    }

Usage Example

Пример #1
0
 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);
 }
All Usage Examples Of SQLBuilder\Universal\Query\AlterTableQuery::toSql