Abstract class Phalcon\Db\Dialect

This is the base class to each database dialect. This implements common methods to transform intermediate code into its RDBM related syntax

Methods

public string limit (unknown $sqlQuery, unknown $number)

Generates the SQL for LIMIT clause

<?php

 $sql = $dialect->limit('SELECT * FROM robots', 10);
 echo $sql; // SELECT * FROM robots LIMIT 10

public string forUpdate (unknown $sqlQuery)

Returns a SQL modified with a FOR UPDATE clause

<?php

 $sql = $dialect->forUpdate('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots FOR UPDATE

public string sharedLock (unknown $sqlQuery)

Returns a SQL modified with a LOCK IN SHARE MODE clause

<?php

 $sql = $dialect->sharedLock('SELECT * FROM robots');
 echo $sql; // SELECT * FROM robots LOCK IN SHARE MODE

final public string getColumnList (unknown $columnList)

Gets a list of columns with escaped identifiers

<?php

 echo $dialect->getColumnList(array('column1', 'column'));

public string getSqlExpression (unknown $expression, [unknown $escapeChar])

Transforms an intermediate representation for a expression into a database system valid expression

final public string getSqlTable (unknown $table, [unknown $escapeChar])

Transform an intermediate representation of a schema/table into a database system valid expression

public string select (unknown $definition)

Builds a SELECT statement

public boolean supportsSavepoints ()

Checks whether the platform supports savepoints

public boolean supportsReleaseSavepoints ()

Checks whether the platform supports releasing savepoints.

public string createSavepoint (unknown $name)

Generate SQL to create a new savepoint

public string releaseSavepoint (unknown $name)

Generate SQL to release a savepoint

public string rollbackSavepoint (unknown $name)

Generate SQL to rollback a savepoint