Sql dialect trait
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 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
Returns a callable function that will be used to transform a passed Query object.
Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words
_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.
\Cake\Database\Query $query The query to translate
\Cake\Database\QueryThe modified query
_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.
string[]_insertQueryTranslator(\Cake\Database\Query $query)
Apply translation steps to insert queries.
\Cake\Database\Query $query The query to translate
\Cake\Database\QueryThe modified query
_removeAliasesFromConditions(\Cake\Database\Query $query)
Removes aliases from the WHERE clause of a query.
\Cake\Database\Query $query The query to process.
\Cake\Database\QueryThe modified query.
RuntimeException_selectQueryTranslator(\Cake\Database\Query $query)
Apply translation steps to select queries.
\Cake\Database\Query $query The query to translate
\Cake\Database\QueryThe modified query
_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
\Cake\Database\Query $query The query to be transformed
\Cake\Database\Query_updateQueryTranslator(\Cake\Database\Query $query)
Apply translation steps to update queries.
Chops out aliases on update query conditions as not all database dialects do support aliases in update queries.
Just like for delete queries, joins are currently not supported for update queries.
\Cake\Database\Query $query The query to translate
\Cake\Database\QueryThe modified query
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.
string $type the type of query to be transformed (select, insert, update, delete)
\ClosurequoteIdentifier(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
string $identifier The identifier to quote.
stringreleaseSavePointSQL(mixed $name)
Returns a SQL snippet for releasing a previously created save point
string|int $name save point name
stringrollbackSavePointSQL(mixed $name)
Returns a SQL snippet for rollbacking a previously created save point
string|int $name save point name
stringsavePointSQL(mixed $name)
Returns a SQL snippet for creating a new transaction savepoint
string|int $name save point name
string
© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.1/trait-Cake.Database.Driver.SqlDialectTrait.html