1. class
  2. Illuminate
  3. Database
  4. Query
  5. Grammars
  6. MySqlGrammar

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
string
compileSelect( Builder $query)

Compile a select query into SQL.

string
compileExists( Builder $query)

Compile an exists statement into SQL.

from Grammar
string
compileInsert( Builder $query, array $values)

Compile an insert statement into SQL.

from Grammar
string
compileInsertGetId( Builder $query, array $values, string $sequence)

Compile an insert and get ID statement into SQL.

from Grammar
string
compileUpdate( Builder $query, array $values)

Compile an update statement into SQL.

string
compileDelete( Builder $query)

Compile a delete statement into SQL.

array
compileTruncate( Builder $query)

Compile a truncate table statement into SQL.

from Grammar
bool
supportsSavepoints()

Determine if the grammar supports savepoints.

from Grammar
string
compileSavepoint( string $name)

Compile the SQL statement to define a savepoint.

from Grammar
string
compileSavepointRollBack( string $name)

Compile the SQL statement to execute a savepoint rollback.

from Grammar
array
getOperators()

Get the gramar specific operators.

from Grammar

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 33
string wrapTable( Expression|string $table)

Wrap a table in keyword identifiers.

Parameters

Expression|string $table

Return Value

string

in Grammar at line line 49
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

at line line 35
string compileSelect( Builder $query)

Compile a select query into SQL.

Parameters

Builder $query

Return Value

string

in Grammar at line line 661
string compileExists( Builder $query)

Compile an exists statement into SQL.

Parameters

Builder $query

Return Value

string

in Grammar at line line 675
string compileInsert( Builder $query, array $values)

Compile an insert statement into SQL.

Parameters

Builder $query
array $values

Return Value

string

in Grammar at line line 710
string compileInsertGetId( Builder $query, array $values, string $sequence)

Compile an insert and get ID statement into SQL.

Parameters

Builder $query
array $values
string $sequence

Return Value

string

at line line 82
string compileUpdate( Builder $query, array $values)

Compile an update statement into SQL.

Parameters

Builder $query
array $values

Return Value

string

at line line 103
string compileDelete( Builder $query)

Compile a delete statement into SQL.

Parameters

Builder $query

Return Value

string

in Grammar at line line 775
array compileTruncate( Builder $query)

Compile a truncate table statement into SQL.

Parameters

Builder $query

Return Value

array

in Grammar at line line 797
bool supportsSavepoints()

Determine if the grammar supports savepoints.

Return Value

bool

in Grammar at line line 808
string compileSavepoint( string $name)

Compile the SQL statement to define a savepoint.

Parameters

string $name

Return Value

string

in Grammar at line line 819
string compileSavepointRollBack( string $name)

Compile the SQL statement to execute a savepoint rollback.

Parameters

string $name

Return Value

string

in Grammar at line line 853
array getOperators()

Get the gramar specific operators.

Return Value

array