\app\framework\Component\Database\Query\GrammarsGrammar

compileSelect()

compileSelect(\app\framework\Component\Database\Query\Builder  $query) : string

Compile a select query into SQL.

Parameters

Returns

compileInsert()

compileInsert(\app\framework\Component\Database\Query\Builder  $query, array  $values) : string

Compile a insert query into SQL

Parameters

Returns

columnize()

columnize(array  $columns) : string

Convert an array of column names into a delimited string.

Parameters

Returns

parameterize()

parameterize(array  $values) : string

Create query parameter place-holders for an array.

Parameters

Returns

parameter()

parameter(mixed  $value) : string

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

Parameters

Returns

quoteString()

quoteString(string|array  $value) : string

Quote the given string literal.

Parameters

Returns

wrapTable()

wrapTable(\app\framework\Component\Database\Query\Expression|string  $table) : string

Wrap a table in keyword identifiers.

Parameters

Returns

wrap()

wrap(\app\framework\Component\Database\Query\Expression|string  $value, boolean  $prefixAlias = false) : string

Wrap a value in keyword identifiers.

Parameters

Returns

getValue()

getValue(\app\framework\Component\Database\Query\Expression  $expression) : string

Get the value of a raw expression.

Parameters

Returns

isExpression()

isExpression(mixed  $value) : boolean

Determine if the given value is a raw expression.

Parameters

Returns

compileComponents()

compileComponents(\app\framework\Component\Database\Query\Builder  $query) : array

Compile the components necessary for a select clause.

Parameters

Returns

compileColumns()

compileColumns(\app\framework\Component\Database\Query\Builder  $query, array  $columns) : string|null

Compile the "select *" portion of the query.

Parameters

Returns

compileFrom()

compileFrom(\app\framework\Component\Database\Query\Builder  $query, string  $table) : string

Compile the "from" portion of the query.

Parameters

Returns

compileWheres()

compileWheres(\app\framework\Component\Database\Query\Builder  $query) : string

Compile the "where" portions of the query.

Parameters

Returns

compileOrders()

compileOrders(\app\framework\Component\Database\Query\Builder  $query,   $orders) 

Parameters

concatenateWhereClauses()

concatenateWhereClauses(\app\framework\Component\Database\Query\Builder  $query,   $wheres) 

Parameters

concatenate()

concatenate(array  $segments) : string

Concatenate an array of segments, removing empties.

Parameters

Returns

wrapAliasedValue()

wrapAliasedValue(string  $value, boolean  $prefixAlias = false) : string

Wrap a value that has an alias.

Parameters

Returns

wrapSegments()

wrapSegments(array  $segments) : string

Wrap the given value segments.

Parameters

Returns

wrapValue()

wrapValue(string  $value) : string

Wrap a single string in keyword identifiers.

Parameters

Returns