Trait SqlserverDialectTrait

Contains functions that encapsulates the SQL dialect used by SQLServer, including query translators and schema introspection.

Namespace: Cake\Database\Dialect

Properties summary

  • $_endQuote protected
    string

    String used to end a database identifier quoting to make it safe

  • $_startQuote protected
    string

    String used to start a database identifier quoting to make it safe

Method Summary

Method Detail

_deleteQueryTranslator() protected 

_deleteQueryTranslator(mixed $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

_expressionTranslators() protected 

_expressionTranslators()

Returns a dictionary of expressions to be transformed when compiling a Query to SQL. Array keys are method names to be called in this class

Returns

array

_insertQueryTranslator() protected 

_insertQueryTranslator(mixed $query)

Apply translation steps to insert queries.

Parameters

\Cake\Database\Query $query

The query to translate

Returns

\Cake\Database\Query

The modified query

_pagingSubquery() protected 

_pagingSubquery(mixed $original, mixed $limit, mixed $offset)

Generate a paging subquery for older versions of SQLserver.

Prior to SQLServer 2012 there was no equivalent to LIMIT OFFSET, so a subquery must be used.

Parameters

\Cake\Database\Query $original

The query to wrap in a subquery.

int $limit

The number of rows to fetch.

int $offset

The number of rows to offset.

Returns

\Cake\Database\Query

Modified query object.

_removeAliasesFromConditions() protected 

_removeAliasesFromConditions(mixed $query)

Removes aliases from the WHERE clause of a query.

Parameters

\Cake\Database\Query $query

The query to process.

Returns

\Cake\Database\Query

The modified query.

Throws

RuntimeException
In case the processed query contains any joins, as removing aliases from the conditions can break references to the joined tables.

_selectQueryTranslator() protected 

_selectQueryTranslator(mixed $query)

Modify the limit/offset to TSQL

Parameters

\Cake\Database\Query $query

The query to translate

Returns

\Cake\Database\Query

The modified query

_transformDistinct() protected 

_transformDistinct(mixed $original)

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 $original

The query to be transformed

Returns

\Cake\Database\Query

_transformFunctionExpression() protected 

_transformFunctionExpression(\Cake\Database\Expression\FunctionExpression $expression)

Receives a FunctionExpression and changes it so that it conforms to this SQL dialect.

Parameters

\Cake\Database\Expression\FunctionExpression $expression

The function expression to convert to TSQL.

_transformTupleComparison() protected 

_transformTupleComparison(\Cake\Database\Expression\TupleComparison $expression, mixed $query)

Receives a TupleExpression and changes it so that it conforms to this SQL dialect.

It transforms expressions looking like '(a, b) IN ((c, d), (e, f))' into an equivalent expression of the form '((a = c) AND (b = d)) OR ((a = e) AND (b = f))'.

It can also transform transform expressions where the right hand side is a query selecting the same amount of columns as the elements in the left hand side of the expression:

(a, b) IN (SELECT c, d FROM a_table) is transformed into

1 = (SELECT 1 FROM a_table WHERE (a = c) AND (b = d))

Parameters

\Cake\Database\Expression\TupleComparison $expression

The expression to transform

\Cake\Database\Query $query

The query to update.

_updateQueryTranslator() protected 

_updateQueryTranslator(mixed $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.

Parameters

\Cake\Database\Query $query

The query to translate

Returns

\Cake\Database\Query

The modified query

_version() public 

_version()

Get the version of SQLserver we are connected to.

Returns

int

disableForeignKeySQL() public 

disableForeignKeySQL()

{@inheritDoc}

enableForeignKeySQL() public 

enableForeignKeySQL()

{@inheritDoc}

newCompiler() public 

newCompiler()

{@inheritDoc}

Returns

\Cake\Database\SqlserverCompiler

queryTranslator() public 

queryTranslator(mixed $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

quoteIdentifier() public 

quoteIdentifier(mixed $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

releaseSavePointSQL() public 

releaseSavePointSQL(mixed $name)

Returns a SQL snippet for releasing a previously created save point

Parameters

string $name

save point name

Returns

string

rollbackSavePointSQL() public 

rollbackSavePointSQL(mixed $name)

Returns a SQL snippet for rollbacking a previously created save point

Parameters

string $name

save point name

Returns

string

savePointSQL() public 

savePointSQL(mixed $name)

Returns a SQL snippet for creating a new transaction savepoint

Parameters

string $name

save point name

Returns

string

schemaDialect() public 

schemaDialect()

Get the schema dialect.

Used by Cake\Schema package to reflect schema and generate schema.

Returns

\Cake\Database\Schema\SqlserverSchema

Property Detail

$_endQuote protected

String used to end a database identifier quoting to make it safe

Type

string

$_startQuote protected

String used to start a database identifier quoting to make it safe

Type

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/3.9/trait-Cake.Database.Dialect.SqlserverDialectTrait.html