| public createTable ( string $table, array $columns, string $options = null ) : string | ||
| $table | string | the name of the table to be created. The name will be properly quoted by the method. |
| $columns | array | the columns (name => definition) in the new table. |
| $options | string | additional SQL fragment that will be appended to the generated SQL. |
| return | string | the SQL statement for creating a new DB table. |
public function createTable($table, $columns, $options = null)
{
$cols = [];
foreach ($columns as $name => $type) {
if (is_string($name)) {
$cols[] = "\t" . $this->db->quoteColumnName($name) . ' ' . $this->getColumnType($type);
} else {
$cols[] = "\t" . $type;
}
}
$sql = 'CREATE TABLE ' . $this->db->quoteTableName($table) . " (\n" . implode(",\n", $cols) . "\n)";
return $options === null ? $sql : $sql . ' ' . $options;
} /**
* @inheritdoc
*/
public function createTable($table, $columns, $options = null)
{
$sql = parent::createTable($table, $columns, $options);
foreach ($columns as $name => $type) {
if (!is_string($name)) {
continue;
}
if (strpos($type, Schema::TYPE_PK) === 0 || strpos($type, Schema::TYPE_BIGPK) === 0) {
$sqlTrigger = <<<SQLTRIGGER
CREATE TRIGGER tr_{$table}_{$name} FOR {$this->db->quoteTableName($table)}
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
if (NEW.{$this->db->quoteColumnName($name)} is NULL) then NEW.{$this->db->quoteColumnName($name)} = NEXT VALUE FOR seq_{$table}_{$name};
END
SQLTRIGGER;
$sqlBlock = <<<SQL
EXECUTE block AS
BEGIN
EXECUTE STATEMENT {$this->db->quoteValue($sql)};
EXECUTE STATEMENT {$this->db->quoteValue("CREATE SEQUENCE seq_{$table}_{$name}")};
EXECUTE STATEMENT {$this->db->quoteValue($sqlTrigger)};
END;
SQL;
return $sqlBlock;
}
}
return $sql;
}
