SQLiteGrammar (Database\Query\Grammars)
SQLiteGrammar
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 |
bool | isExpression(mixed $value) Determine if the given value is a raw expression. | from Grammar |
string | getValue(Expression $expression) Get the value of 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 | compileRandom(string $seed) Compile the random statement 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 |
array | prepareBindingsForUpdate(array $bindings, array $values) Prepare the bindings for an update statement. | 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 |
array | getOperators() Get the grammar specific operators. | from Grammar |
Details
array wrapArray(array $values)
Wrap an array of values.
string wrapTable(Expression|string $table)
Wrap a table in keyword identifiers.
string wrap(Expression|string $value, bool $prefixAlias = false)
Wrap a value in keyword identifiers.
string columnize(array $columns)
Convert an array of column names into a delimited string.
string parameterize(array $values)
Create query parameter place-holders for an array.
string parameter(mixed $value)
Get the appropriate query parameter place-holder for a value.
bool isExpression(mixed $value)
Determine if the given value is a raw expression.
string getValue(Expression $expression)
Get the value of a raw expression.
string getDateFormat()
Get the format for database stored dates.
string getTablePrefix()
Get the grammar's table prefix.
$this setTablePrefix(string $prefix)
Set the grammar's table prefix.
string compileSelect(Builder $query)
Compile a select query into SQL.
string compileRandom(string $seed)
Compile the random statement into SQL.
string compileExists(Builder $query)
Compile an exists statement into SQL.
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.
string compileUpdate(Builder $query, array $values)
Compile an update statement into SQL.
array prepareBindingsForUpdate(array $bindings, array $values)
Prepare the bindings for an update statement.
string compileDelete(Builder $query)
Compile a delete statement into SQL.
array compileTruncate(Builder $query)
Compile a truncate table statement into SQL.
bool supportsSavepoints()
Determine if the grammar supports savepoints.
string compileSavepoint(string $name)
Compile the SQL statement to define a savepoint.
string compileSavepointRollBack(string $name)
Compile the SQL statement to execute a savepoint rollback.
array getOperators()
Get the grammar specific operators.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.4/Illuminate/Database/Query/Grammars/SQLiteGrammar.html