class SQLiteGrammar 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.

from Grammar
string
compileExists( Builder $query)

Compile an exists statement into SQL.

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

Compile an insert statement into SQL.

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.

from Grammar
string
compileDelete( Builder $query)

Compile a delete statement into SQL.

from Grammar
array
compileTruncate( Builder $query)

Compile a truncate table statement into SQL.

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

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

in Grammar at line line 36
string compileSelect( Builder $query)

Compile a select query into SQL.

Parameters

Builder $query

Return Value

string

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

Compile an exists statement into SQL.

Parameters

Builder $query

Return Value

string

at line line 27
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 688
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

in Grammar at line line 700
string compileUpdate( Builder $query, array $values)

Compile an update statement into SQL.

Parameters

Builder $query
array $values

Return Value

string

in Grammar at line line 738
string compileDelete( Builder $query)

Compile a delete statement into SQL.

Parameters

Builder $query

Return Value

string

at line line 67
array compileTruncate( Builder $query)

Compile a truncate table statement into SQL.

Parameters

Builder $query

Return Value

array

in Grammar at line line 775
bool supportsSavepoints()

Determine if the grammar supports savepoints.

Return Value

bool

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

Compile the SQL statement to define a savepoint.

Parameters

string $name

Return Value

string

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

Compile the SQL statement to execute a savepoint rollback.

Parameters

string $name

Return Value

string