內容目录上一个主题下一个主题Class Phalcon\Db\Dialect\MySQL > 本页 |
Abstract class Phalcon\Db\Dialect¶implements Phalcon\Db\DialectInterface This is the base class to each database dialect. This implements common methods to transform intermediate code into its RDBMS related syntax Methods¶public registerCustomFunction (unknown $name, unknown $customFunction) Registers custom SQL functions public getCustomFunctions () Returns registered functions final public escape (unknown $str, [unknown $escapeChar]) Escape identifiers public 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
$sql = $dialect->limit('SELECT * FROM robots', [10, 50]);
echo $sql; // SELECT * FROM robots LIMIT 10 OFFSET 50
public 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 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 getColumnList (array $columnList, [unknown $escapeChar], [unknown $bindCounts]) Gets a list of columns with escaped identifiers <?php
echo $dialect->getColumnList(array('column1', 'column'));
final public getSqlColumn (unknown $column, [unknown $escapeChar], [unknown $bindCounts]) Resolve Column expressions public getSqlExpression (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Transforms an intermediate representation for a expression into a database system valid expression final public getSqlTable (unknown $table, [unknown $escapeChar]) Transform an intermediate representation of a schema/table into a database system valid expression public select (array $definition) Builds a SELECT statement public supportsSavepoints () Checks whether the platform supports savepoints public supportsReleaseSavepoints () Checks whether the platform supports releasing savepoints. public createSavepoint (unknown $name) Generate SQL to create a new savepoint public releaseSavepoint (unknown $name) Generate SQL to release a savepoint public rollbackSavepoint (unknown $name) Generate SQL to rollback a savepoint final protected getSqlExpressionScalar (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve Column expressions final protected getSqlExpressionObject (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve object expressions final protected getSqlExpressionQualified (array $expression, [unknown $escapeChar]) Resolve qualified expressions final protected getSqlExpressionBinaryOperations (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve binary operations expressions final protected getSqlExpressionUnaryOperations (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve unary operations expressions final protected getSqlExpressionFunctionCall (array $expression, unknown $escapeChar, [unknown $bindCounts]) Resolve function calls final protected getSqlExpressionList (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve Lists final protected getSqlExpressionAll (array $expression, [unknown $escapeChar]) Resolve * final protected getSqlExpressionCastValue (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve CAST of values final protected getSqlExpressionConvertValue (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve CONVERT of values encodings final protected getSqlExpressionCase (array $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve CASE expressions final protected getSqlExpressionFrom (unknown $expression, [unknown $escapeChar]) Resolve a FROM clause final protected getSqlExpressionJoins (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a JOINs clause final protected getSqlExpressionWhere (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a WHERE clause final protected getSqlExpressionGroupBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a GROUP BY clause final protected getSqlExpressionHaving (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a HAVING clause final protected getSqlExpressionOrderBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a ORDER BY clause final protected getSqlExpressionLimit (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) Resolve a LIMIT clause protected prepareColumnAlias (unknown $qualified, [unknown $alias], [unknown $escapeChar]) Prepares column for this RDBMS protected prepareTable (unknown $table, [unknown $schema], [unknown $alias], [unknown $escapeChar]) Prepares table for this RDBMS protected prepareQualified (unknown $column, [unknown $domain], [unknown $escapeChar]) Prepares qualified for this RDBMS abstract public getColumnDefinition (Phalcon\Db\ColumnInterface $column) inherited from Phalcon\Db\DialectInterface ... abstract public addColumn (unknown $tableName, unknown $schemaName, Phalcon\Db\ColumnInterface $column) inherited from Phalcon\Db\DialectInterface ... abstract public modifyColumn (unknown $tableName, unknown $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnInterface $currentColumn]) inherited from Phalcon\Db\DialectInterface ... abstract public dropColumn (unknown $tableName, unknown $schemaName, unknown $columnName) inherited from Phalcon\Db\DialectInterface ... abstract public addIndex (unknown $tableName, unknown $schemaName, Phalcon\Db\IndexInterface $index) inherited from Phalcon\Db\DialectInterface ... abstract public dropIndex (unknown $tableName, unknown $schemaName, unknown $indexName) inherited from Phalcon\Db\DialectInterface ... abstract public addPrimaryKey (unknown $tableName, unknown $schemaName, Phalcon\Db\IndexInterface $index) inherited from Phalcon\Db\DialectInterface ... abstract public dropPrimaryKey (unknown $tableName, unknown $schemaName) inherited from Phalcon\Db\DialectInterface ... abstract public addForeignKey (unknown $tableName, unknown $schemaName, Phalcon\Db\ReferenceInterface $reference) inherited from Phalcon\Db\DialectInterface ... abstract public dropForeignKey (unknown $tableName, unknown $schemaName, unknown $referenceName) inherited from Phalcon\Db\DialectInterface ... abstract public createTable (unknown $tableName, unknown $schemaName, array $definition) inherited from Phalcon\Db\DialectInterface ... abstract public createView (unknown $viewName, array $definition, [unknown $schemaName]) inherited from Phalcon\Db\DialectInterface ... abstract public dropTable (unknown $tableName, unknown $schemaName) inherited from Phalcon\Db\DialectInterface ... abstract public dropView (unknown $viewName, [unknown $schemaName], [unknown $ifExists]) inherited from Phalcon\Db\DialectInterface ... abstract public tableExists (unknown $tableName, [unknown $schemaName]) inherited from Phalcon\Db\DialectInterface ... abstract public viewExists (unknown $viewName, [unknown $schemaName]) inherited from Phalcon\Db\DialectInterface ... abstract public describeColumns (unknown $table, [unknown $schema]) inherited from Phalcon\Db\DialectInterface ... abstract public listTables ([unknown $schemaName]) inherited from Phalcon\Db\DialectInterface ... abstract public describeIndexes (unknown $table, [unknown $schema]) inherited from Phalcon\Db\DialectInterface ... abstract public describeReferences (unknown $table, [unknown $schema]) inherited from Phalcon\Db\DialectInterface ... abstract public tableOptions (unknown $table, [unknown $schema]) inherited from Phalcon\Db\DialectInterface ... |