Abstract class Phalcon\Db\Dialect¶

Methods¶

public string limit (string $sqlQuery, int $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 (string $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 (string $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

public string getColumnList (array $columnList)

Gets a list of columns with escaped identifiers

<?php

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

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

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

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

Resolve CASE expressions

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

Resolve function calls

public string getSqlTable (array $table, [string $escapeChar])

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

public string select (array $definition, [unknown $count])

Builds a SELECT statement

public string insert (array $definition)

Builds a INSERT statement

public string update (array $definition, [unknown $quoting])

Builds a UPDATE statement

public string delete (array $definition)

Builds a DELETE statement

public boolean supportsSavepoints ()

Checks whether the platform supports savepoints

public boolean supportsReleaseSavepoints ()

Checks whether the platform supports releasing savepoints.

public string createSavepoint (string $name)

Generate SQL to create a new savepoint

public string releaseSavepoint (string $name)

Generate SQL to release a savepoint

public string rollbackSavepoint (string $name)

Generate SQL to rollback a savepoint

public string getEscapeChar ()

Return the escape char

public array registerCustomFunction (unknown $name, unknown $customFunction)

Registers custom SQL functions

public array getCustomFunctions ()

Returns registered functions

public string escape (string $str, [string $escapeChar])

Escape identifiers

public string escapeSchema (string $schema, [string $escapeChar])

Escape Schema

public string prepareTable (string $table, [string $schema], [string $alias], [string $escapeChar])

Prepares table for this RDBMS

abstract public getColumnDefinition (Phalcon\Db\ColumnInterface $column) inherited from Phalcon\Db\DialectInterface

Gets the column name in MySQL

abstract public string addColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column) inherited from Phalcon\Db\DialectInterface

Generates SQL to add a column to a table

abstract public string modifyColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnInterface $currentColumn]) inherited from Phalcon\Db\DialectInterface

Generates SQL to modify a column in a table

abstract public string dropColumn (string $tableName, string $schemaName, string $columnName) inherited from Phalcon\Db\DialectInterface

Generates SQL to delete a column from a table

abstract public string addIndex (string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index) inherited from Phalcon\Db\DialectInterface

Generates SQL to add an index to a table

abstract public string dropIndex (string $tableName, string $schemaName, string $indexName) inherited from Phalcon\Db\DialectInterface

Generates SQL to delete an index from a table

abstract public string addPrimaryKey (string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index) inherited from Phalcon\Db\DialectInterface

Generates SQL to add the primary key to a table

abstract public string dropPrimaryKey (string $tableName, string $schemaName) inherited from Phalcon\Db\DialectInterface

Generates SQL to delete primary key from a table

abstract public string addForeignKey (string $tableName, string $schemaName, Phalcon\Db\ReferenceInterface $reference) inherited from Phalcon\Db\DialectInterface

Generates SQL to add an index to a table

abstract public string dropForeignKey (string $tableName, string $schemaName, string $referenceName) inherited from Phalcon\Db\DialectInterface

Generates SQL to delete a foreign key from a table

abstract public string createTable (string $tableName, string $schemaName, array $definition) inherited from Phalcon\Db\DialectInterface

Generates SQL to create a table

abstract public string dropTable (string $tableName, string $schemaName) inherited from Phalcon\Db\DialectInterface

Generates SQL to drop a table

abstract public string createView (string $viewName, array $definition, string $schemaName) inherited from Phalcon\Db\DialectInterface

Generates SQL to create a view

abstract public string dropView (string $viewName, string $schemaName, [unknown $ifExists]) inherited from Phalcon\Db\DialectInterface

Generates SQL to drop a view

abstract public string tableExists (string $tableName, [string $schemaName]) inherited from Phalcon\Db\DialectInterface

Generates SQL checking for the existence of a schema.table

abstract public string viewExists (string $viewName, [string $schemaName]) inherited from Phalcon\Db\DialectInterface

Generates SQL checking for the existence of a schema.view

abstract public string describeColumns (string $table, [string $schema]) inherited from Phalcon\Db\DialectInterface

Generates SQL to describe a table

abstract public array listTables ([string $schemaName]) inherited from Phalcon\Db\DialectInterface

List all tables on database

abstract public array listViews ([string $schemaName]) inherited from Phalcon\Db\DialectInterface

List all views on database

abstract public string describeIndexes (string $table, [string $schema]) inherited from Phalcon\Db\DialectInterface

Generates SQL to query indexes on a table

abstract public string describeReferences (string $table, [string $schema]) inherited from Phalcon\Db\DialectInterface

Generates SQL to query foreign keys on a table

abstract public string tableOptions (string $table, [string $schema]) inherited from Phalcon\Db\DialectInterface

Generates the SQL to describe the table creation options

abstract public string getDefaultValue (unknown $defaultValue, unknown $columnType) inherited from Phalcon\Db\DialectInterface

Return the default value