Файл: gapps/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/SqlServerGrammar.php
Строк: 879
<?php
namespace IlluminateDatabaseSchemaGrammars;
use IlluminateSupportFluent;
use IlluminateDatabaseSchemaBlueprint;
class SqlServerGrammar extends Grammar
{
/**
* The possible column modifiers.
*
* @var array
*/
protected $modifiers = ['Increment', 'Nullable', 'Default'];
/**
* The columns available as serials.
*
* @var array
*/
protected $serials = ['tinyInteger', 'smallInteger', 'mediumInteger', 'integer', 'bigInteger'];
/**
* Compile the query to determine if a table exists.
*
* @return string
*/
public function compileTableExists()
{
return "select * from sysobjects where type = 'U' and name = ?";
}
/**
* Compile the query to determine the list of columns.
*
* @param string $table
* @return string
*/
public function compileColumnExists($table)
{
return "select col.name from sys.columns as col
join sys.objects as obj on col.object_id = obj.object_id
where obj.type = 'U' and obj.name = '$table'";
}
/**
* Compile a create table command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileCreate(Blueprint $blueprint, Fluent $command)
{
$columns = implode(', ', $this->getColumns($blueprint));
return 'create table '.$this->wrapTable($blueprint)." ($columns)";
}
/**
* Compile a column addition table command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileAdd(Blueprint $blueprint, Fluent $command)
{
$table = $this->wrapTable($blueprint);
$columns = $this->getColumns($blueprint);
return 'alter table '.$table.' add '.implode(', ', $columns);
}
/**
* Compile a primary key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compilePrimary(Blueprint $blueprint, Fluent $command)
{
$columns = $this->columnize($command->columns);
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "alter table {$table} add constraint {$index} primary key ({$columns})";
}
/**
* Compile a unique key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileUnique(Blueprint $blueprint, Fluent $command)
{
$columns = $this->columnize($command->columns);
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "create unique index {$index} on {$table} ({$columns})";
}
/**
* Compile a plain index key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileIndex(Blueprint $blueprint, Fluent $command)
{
$columns = $this->columnize($command->columns);
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "create index {$index} on {$table} ({$columns})";
}
/**
* Compile a drop table command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDrop(Blueprint $blueprint, Fluent $command)
{
return 'drop table '.$this->wrapTable($blueprint);
}
/**
* Compile a drop table (if exists) command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropIfExists(Blueprint $blueprint, Fluent $command)
{
return 'if exists (select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME = ''.$blueprint->getTable().'') drop table ['.$blueprint->getTable().']';
}
/**
* Compile a drop column command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropColumn(Blueprint $blueprint, Fluent $command)
{
$columns = $this->wrapArray($command->columns);
$table = $this->wrapTable($blueprint);
return 'alter table '.$table.' drop column '.implode(', ', $columns);
}
/**
* Compile a drop primary key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropPrimary(Blueprint $blueprint, Fluent $command)
{
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "alter table {$table} drop constraint {$index}";
}
/**
* Compile a drop unique key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropUnique(Blueprint $blueprint, Fluent $command)
{
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "drop index {$index} on {$table}";
}
/**
* Compile a drop index command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropIndex(Blueprint $blueprint, Fluent $command)
{
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "drop index {$index} on {$table}";
}
/**
* Compile a drop foreign key command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileDropForeign(Blueprint $blueprint, Fluent $command)
{
$table = $this->wrapTable($blueprint);
$index = $this->wrap($command->index);
return "alter table {$table} drop constraint {$index}";
}
/**
* Compile a rename table command.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $command
* @return string
*/
public function compileRename(Blueprint $blueprint, Fluent $command)
{
$from = $this->wrapTable($blueprint);
return "sp_rename {$from}, ".$this->wrapTable($command->to);
}
/**
* Compile the command to enable foreign key constraints.
*
* @return string
*/
public function compileEnableForeignKeyConstraints()
{
return 'EXEC sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all";';
}
/**
* Compile the command to disable foreign key constraints.
*
* @return string
*/
public function compileDisableForeignKeyConstraints()
{
return 'EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all";';
}
/**
* Create the column definition for a char type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeChar(Fluent $column)
{
return "nchar({$column->length})";
}
/**
* Create the column definition for a string type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeString(Fluent $column)
{
return "nvarchar({$column->length})";
}
/**
* Create the column definition for a text type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeText(Fluent $column)
{
return 'nvarchar(max)';
}
/**
* Create the column definition for a medium text type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeMediumText(Fluent $column)
{
return 'nvarchar(max)';
}
/**
* Create the column definition for a long text type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeLongText(Fluent $column)
{
return 'nvarchar(max)';
}
/**
* Create the column definition for a integer type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeInteger(Fluent $column)
{
return 'int';
}
/**
* Create the column definition for a big integer type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeBigInteger(Fluent $column)
{
return 'bigint';
}
/**
* Create the column definition for a medium integer type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeMediumInteger(Fluent $column)
{
return 'int';
}
/**
* Create the column definition for a tiny integer type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeTinyInteger(Fluent $column)
{
return 'tinyint';
}
/**
* Create the column definition for a small integer type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeSmallInteger(Fluent $column)
{
return 'smallint';
}
/**
* Create the column definition for a float type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeFloat(Fluent $column)
{
return 'float';
}
/**
* Create the column definition for a double type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeDouble(Fluent $column)
{
return 'float';
}
/**
* Create the column definition for a decimal type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeDecimal(Fluent $column)
{
return "decimal({$column->total}, {$column->places})";
}
/**
* Create the column definition for a boolean type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeBoolean(Fluent $column)
{
return 'bit';
}
/**
* Create the column definition for an enum type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeEnum(Fluent $column)
{
return 'nvarchar(255)';
}
/**
* Create the column definition for a json type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeJson(Fluent $column)
{
return 'nvarchar(max)';
}
/**
* Create the column definition for a jsonb type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeJsonb(Fluent $column)
{
return 'nvarchar(max)';
}
/**
* Create the column definition for a date type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeDate(Fluent $column)
{
return 'date';
}
/**
* Create the column definition for a date-time type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeDateTime(Fluent $column)
{
return 'datetime';
}
/**
* Create the column definition for a date-time type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeDateTimeTz(Fluent $column)
{
return 'datetimeoffset(0)';
}
/**
* Create the column definition for a time type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeTime(Fluent $column)
{
return 'time';
}
/**
* Create the column definition for a time type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeTimeTz(Fluent $column)
{
return 'time';
}
/**
* Create the column definition for a timestamp type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeTimestamp(Fluent $column)
{
if ($column->useCurrent) {
return 'datetime default CURRENT_TIMESTAMP';
}
return 'datetime';
}
/**
* Create the column definition for a timestamp type.
*
* @link https://msdn.microsoft.com/en-us/library/bb630289(v=sql.120).aspx
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeTimestampTz(Fluent $column)
{
if ($column->useCurrent) {
return 'datetimeoffset(0) default CURRENT_TIMESTAMP';
}
return 'datetimeoffset(0)';
}
/**
* Create the column definition for a binary type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeBinary(Fluent $column)
{
return 'varbinary(max)';
}
/**
* Create the column definition for a uuid type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeUuid(Fluent $column)
{
return 'uniqueidentifier';
}
/**
* Create the column definition for an IP address type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeIpAddress(Fluent $column)
{
return 'nvarchar(45)';
}
/**
* Create the column definition for a MAC address type.
*
* @param IlluminateSupportFluent $column
* @return string
*/
protected function typeMacAddress(Fluent $column)
{
return 'nvarchar(17)';
}
/**
* Get the SQL for a nullable column modifier.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $column
* @return string|null
*/
protected function modifyNullable(Blueprint $blueprint, Fluent $column)
{
return $column->nullable ? ' null' : ' not null';
}
/**
* Get the SQL for a default column modifier.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $column
* @return string|null
*/
protected function modifyDefault(Blueprint $blueprint, Fluent $column)
{
if (! is_null($column->default)) {
return ' default '.$this->getDefaultValue($column->default);
}
}
/**
* Get the SQL for an auto-increment column modifier.
*
* @param IlluminateDatabaseSchemaBlueprint $blueprint
* @param IlluminateSupportFluent $column
* @return string|null
*/
protected function modifyIncrement(Blueprint $blueprint, Fluent $column)
{
if (in_array($column->type, $this->serials) && $column->autoIncrement) {
return ' identity primary key';
}
}
}