Trait SqlDialectTrait

_deleteQueryTranslatorsource protected

_deleteQueryTranslator( Cake\Database\Query $query )

Apply translation steps to delete queries.

Chops out aliases on delete query conditions as most database dialects do not support aliases in delete queries. This also removes aliases in table names as they frequently don't work either.

We are intentionally not supporting deletes with joins as they have even poorer support.

Parameters

Cake\Database\Query $query

The query to translate

Returns

Cake\Database\Query
The modified query

_expressionTranslatorssource protected

_expressionTranslators( )

Returns an associative array of methods that will transform Expression objects to conform with the specific SQL dialect. Keys are class names and values a method in this class.

Returns

array
array

_insertQueryTranslatorsource protected

_insertQueryTranslator( Cake\Database\Query $query )

Apply translation steps to insert queries.

Parameters

Cake\Database\Query $query

The query to translate

Returns

Cake\Database\Query
The modified query

_selectQueryTranslatorsource protected

_selectQueryTranslator( Cake\Database\Query $query )

Apply translation steps to select queries.

Parameters

Cake\Database\Query $query

The query to translate

Returns

Cake\Database\Query
The modified query

_transformDistinctsource protected

_transformDistinct( Cake\Database\Query $query )

Returns the passed query after rewriting the DISTINCT clause, so that drivers that do not support the "ON" part can provide the actual way it should be done

Parameters

Cake\Database\Query $query

The query to be transformed

Returns

Cake\Database\Query
\Cake\Database\Query

_updateQueryTranslatorsource protected

_updateQueryTranslator( Cake\Database\Query $query )

Apply translation steps to update queries.

Parameters

Cake\Database\Query $query

The query to translate

Returns

Cake\Database\Query
The modified query

queryTranslatorsource public

queryTranslator( string $type )

Returns a callable function that will be used to transform a passed Query object. This function, in turn, will return an instance of a Query object that has been transformed to accommodate any specificities of the SQL dialect in use.

Parameters

string $type

the type of query to be transformed (select, insert, update, delete)

Returns

callable
callable

quoteIdentifiersource public

quoteIdentifier( string $identifier )

Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words

Parameters

string $identifier

The identifier to quote.

Returns

string
string

releaseSavePointSQLsource public

releaseSavePointSQL( string $name )

Returns a SQL snippet for releasing a previously created save point

Parameters

string $name

save point name

Returns

string
string

rollbackSavePointSQLsource public

rollbackSavePointSQL( string $name )

Returns a SQL snippet for rollbacking a previously created save point

Parameters

string $name

save point name

Returns

string
string

savePointSQLsource public

savePointSQL( string $name )

Returns a SQL snippet for creating a new transaction savepoint

Parameters

string $name

save point name

Returns

string
string