class Illuminate / Database / Query / Grammars / SQLiteGrammar
You are viewing an older version of the documentation. For the latest, please visit master documentation.

SQLiteGrammar

Extends

Properties

protected

$operators string[]

All of the available clause operators.

Default: array

Methods

protected

compileLock ( Builder $query , $value ) : string

Compile the lock into SQL.

Parameters

protected

wrapUnion ( $sql ) : string

Wrap a union subquery in parentheses.

Parameters

  • $sql string
protected

whereDate ( Builder $query , $where ) : string

Compile a "where date" clause.

Parameters

protected

whereDay ( Builder $query , $where ) : string

Compile a "where day" clause.

Parameters

protected

whereMonth ( Builder $query , $where ) : string

Compile a "where month" clause.

Parameters

protected

whereYear ( Builder $query , $where ) : string

Compile a "where year" clause.

Parameters

protected

whereTime ( Builder $query , $where ) : string

Compile a "where time" clause.

Parameters

protected

dateBasedWhere ( $type , Builder $query , $where ) : string

Compile a date based where clause.

Parameters

  • $type string
  • $query Builder
  • $where array
protected

compileJsonLength ( $column , $operator , $value ) : string

Compile a "JSON length" statement into SQL.

Parameters

  • $column string
  • $operator string
  • $value string
public

compileUpdate ( Builder $query , array $values ) : string

Compile an update statement into SQL.

Parameters

public

compileInsertOrIgnore ( Builder $query , array $values ) : string

Compile an insert ignore statement into SQL.

Parameters

protected

compileUpdateColumns ( Builder $query , array $values ) : string

Compile the columns for an update statement.

Parameters

public

compileUpsert ( Builder $query , array $values , array $uniqueBy , array $update ) : string

Compile an "upsert" statement into SQL.

Parameters

  • $query Builder
  • $values array
  • $uniqueBy array
  • $update array
protected

groupJsonColumnsForUpdate ( array $values ) : array

Group the nested JSON columns.

Parameters

  • $values array
protected

compileJsonPatch ( $column , $value ) : string

Compile a "JSON" patch statement into SQL.

Parameters

  • $column string
  • $value mixed
protected

compileUpdateWithJoinsOrLimit ( Builder $query , array $values ) : string

Compile an update statement with joins or limit into SQL.

Parameters

public

prepareBindingsForUpdate ( array $bindings , array $values ) : array

Prepare the bindings for an update statement.

Parameters

  • $bindings array
  • $values array
public

compileDelete ( Builder $query ) : string

Compile a delete statement into SQL.

Parameters

protected

compileDeleteWithJoinsOrLimit ( Builder $query ) : string

Compile a delete statement with joins or limit into SQL.

Parameters

public

compileTruncate ( Builder $query ) : array

Compile a truncate table statement into SQL.

Parameters

protected

wrapJsonSelector ( $value ) : string

Wrap the given JSON selector.

Parameters

  • $value string