W3cubDocs

/Laravel 5.1

MySqlGrammar

class MySqlGrammar 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 the list of tables.
string compileColumnExists()

Compile the query to determine the list of columns.
string compileCreate( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a create table command.
string compileAdd( Blueprint $blueprint, Fluent $command)

Compile an add column 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

array wrapArray( array $values)

Wrap an array of values.

Parameters

array $values

Return Value

array

string wrapTable( Expression|string $table)

Wrap a table in keyword identifiers.

Parameters

Expression|string $table

Return Value

string

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

Wrap a value in keyword identifiers.

Parameters

Expression|string $value
bool $prefixAlias

Return Value

string

string columnize( array $columns)

Convert an array of column names into a delimited string.

Parameters

array $columns

Return Value

string

string parameterize( array $values)

Create query parameter place-holders for an array.

Parameters

array $values

Return Value

string

string parameter( mixed $value)

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

Parameters

mixed $value

Return Value

string

string getValue( Expression $expression)

Get the value of a raw expression.

Parameters

Expression $expression

Return Value

string

bool isExpression( mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed $value

Return Value

bool

string getDateFormat()

Get the format for database stored dates.

Return Value

string

string getTablePrefix()

Get the grammar's table prefix.

Return Value

string

$this setTablePrefix( string $prefix)

Set the grammar's table prefix.

Parameters

string $prefix

Return Value

$this

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

Compile a rename column command.

Parameters

Blueprint $blueprint
Fluent $command
Connection $connection

Return Value

array

string compileForeign( Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

array prefixArray( string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string $prefix
array $values

Return Value

array

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

string compileTableExists()

Compile the query to determine the list of tables.

Return Value

string

string compileColumnExists()

Compile the query to determine the list of columns.

Return Value

string

string compileCreate( Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a create table command.

Parameters

Blueprint $blueprint
Fluent $command
Connection $connection

Return Value

string

string compileAdd( Blueprint $blueprint, Fluent $command)

Compile an add column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compilePrimary( Blueprint $blueprint, Fluent $command)

Compile a primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileUnique( Blueprint $blueprint, Fluent $command)

Compile a unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileIndex( Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDrop( Blueprint $blueprint, Fluent $command)

Compile a drop table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropIfExists( Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropColumn( Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropPrimary( Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropUnique( Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropIndex( Blueprint $blueprint, Fluent $command)

Compile a drop index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropForeign( Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileRename( Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.1/Illuminate/Database/Schema/Grammars/MySqlGrammar.html