1. class
  2. Illuminate
  3. Database
  4. Schema
  5. Grammars
  6. SqlServerGrammar

SqlServerGrammar

class SqlServerGrammar extends Grammar (View source)

Methods

array
wrapArray( array $values)

Wrap an array of values.

from Grammar
string
wrapTable( Expression|string $table)

Wrap a table in keyword identifiers.

from Grammar
string
wrap( Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

from Grammar
string
columnize( array $columns)

Convert an array of column names into a delimited string.

from Grammar
string
parameterize( array $values)

Create query parameter place-holders for an array.

from Grammar
string
parameter( mixed $value)

Get the appropriate query parameter place-holder for a value.

from Grammar
string
getValue( Expression $expression)

Get the value of a raw expression.

from Grammar
bool
isExpression( mixed $value)

Determine if the given value is a raw expression.

from Grammar
string
getDateFormat()

Get the format for database stored dates.

from Grammar
string
getTablePrefix()

Get the grammar's table prefix.

from Grammar
$this
setTablePrefix( string $prefix)

Set the grammar's table prefix.

from Grammar
array
compileRenameColumn( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

from Grammar
string
compileForeign( Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

from Grammar
array
prefixArray( string $prefix, array $values)

Add a prefix to an array of values.

from Grammar
array
compileChange( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

from Grammar
string
compileTableExists()

Compile the query to determine if a table exists.

string
compileColumnExists( string $table)

Compile the query to determine the list of columns.

string
compileCreate( Blueprint $blueprint, Fluent $command)

Compile a create table command.

string
compileAdd( Blueprint $blueprint, Fluent $command)

Compile a column addition table command.

string
compilePrimary( Blueprint $blueprint, Fluent $command)

Compile a primary key command.

string
compileUnique( Blueprint $blueprint, Fluent $command)

Compile a unique key command.

string
compileIndex( Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

string
compileDrop( Blueprint $blueprint, Fluent $command)

Compile a drop table command.

string
compileDropIfExists( Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

string
compileDropColumn( Blueprint $blueprint, Fluent $command)

Compile a drop column command.

string
compileDropPrimary( Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

string
compileDropUnique( Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

string
compileDropIndex( Blueprint $blueprint, Fluent $command)

Compile a drop index command.

string
compileDropForeign( Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

string
compileRename( Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Details

in Grammar at line line 22
array wrapArray( array $values)

Wrap an array of values.

Parameters

array $values

Return Value

array

in Grammar at line line 217
string wrapTable( Expression|string $table)

Wrap a table in keyword identifiers.

Parameters

Expression|string $table

Return Value

string

in Grammar at line line 229
string wrap( Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

Parameters

Expression|string $value
bool $prefixAlias

Return Value

string

in Grammar at line line 107
string columnize( array $columns)

Convert an array of column names into a delimited string.

Parameters

array $columns

Return Value

string

in Grammar at line line 118
string parameterize( array $values)

Create query parameter place-holders for an array.

Parameters

array $values

Return Value

string

in Grammar at line line 129
string parameter( mixed $value)

Get the appropriate query parameter place-holder for a value.

Parameters

mixed $value

Return Value

string

in Grammar at line line 140
string getValue( Expression $expression)

Get the value of a raw expression.

Parameters

Expression $expression

Return Value

string

in Grammar at line line 151
bool isExpression( mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed $value

Return Value

bool

in Grammar at line line 161
string getDateFormat()

Get the format for database stored dates.

Return Value

string

in Grammar at line line 171
string getTablePrefix()

Get the grammar's table prefix.

Return Value

string

in Grammar at line line 182
$this setTablePrefix( string $prefix)

Set the grammar's table prefix.

Parameters

string $prefix

Return Value

$this

in Grammar at line line 28
array compileRenameColumn( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

Parameters

Blueprint $blueprint
Fluent $command
Connection $connection

Return Value

array

in Grammar at line line 81
string compileForeign( Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in Grammar at line line 203
array prefixArray( string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string $prefix
array $values

Return Value

array

in Grammar at line line 285
array compileChange( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

Parameters

Blueprint $blueprint
Fluent $command
Connection $connection

Return Value

array

Exceptions

RuntimeException

at line line 29
string compileTableExists()

Compile the query to determine if a table exists.

Return Value

string

at line line 40
string compileColumnExists( string $table)

Compile the query to determine the list of columns.

Parameters

string $table

Return Value

string

at line line 54
string compileCreate( Blueprint $blueprint, Fluent $command)

Compile a create table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 68
string compileAdd( Blueprint $blueprint, Fluent $command)

Compile a column addition table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 84
string compilePrimary( Blueprint $blueprint, Fluent $command)

Compile a primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 102
string compileUnique( Blueprint $blueprint, Fluent $command)

Compile a unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 120
string compileIndex( Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 138
string compileDrop( Blueprint $blueprint, Fluent $command)

Compile a drop table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 150
string compileDropIfExists( Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 162
string compileDropColumn( Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 178
string compileDropPrimary( Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 194
string compileDropUnique( Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 210
string compileDropIndex( Blueprint $blueprint, Fluent $command)

Compile a drop index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 226
string compileDropForeign( Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line line 242
string compileRename( Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string