內容目录上一个主题< Class Phalcon\Db\Dialect\MySQL 下一个主题Class Phalcon\Db\Dialect\Postgresql > 本页 |
Class Phalcon\Db\Dialect\Oracle¶extends abstract class Phalcon\Db\Dialect implements Phalcon\Db\DialectInterface Generates database specific SQL for the Oracle RDBMS Methods¶public limit (unknown $sqlQuery, unknown $number) Generates the SQL for LIMIT clause public getColumnDefinition (Phalcon\Db\ColumnInterface $column) Gets the column name in Oracle public addColumn (unknown $tableName, unknown $schemaName, Phalcon\Db\ColumnInterface $column) Generates SQL to add a column to a table public modifyColumn (unknown $tableName, unknown $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnInterface $currentColumn]) Generates SQL to modify a column in a table public dropColumn (unknown $tableName, unknown $schemaName, unknown $columnName) Generates SQL to delete a column from a table public addIndex (unknown $tableName, unknown $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add an index to a table public dropIndex (unknown $tableName, unknown $schemaName, unknown $indexName) /** /** Generates SQL to delete an index from a table public addPrimaryKey (unknown $tableName, unknown $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add the primary key to a table public dropPrimaryKey (unknown $tableName, unknown $schemaName) Generates SQL to delete primary key from a table public addForeignKey (unknown $tableName, unknown $schemaName, Phalcon\Db\ReferenceInterface $reference) Generates SQL to add an index to a table public dropForeignKey (unknown $tableName, unknown $schemaName, unknown $referenceName) Generates SQL to delete a foreign key from a table public createTable (unknown $tableName, unknown $schemaName, array $definition) Generates SQL to create a table in Oracle public dropTable (unknown $tableName, unknown $schemaName, [unknown $ifExists]) Generates SQL to drop a table public createView (unknown $viewName, array $definition, [unknown $schemaName]) Generates SQL to create a view public dropView (unknown $viewName, [unknown $schemaName], [unknown $ifExists]) Generates SQL to drop a view public viewExists (unknown $viewName, [unknown $schemaName]) Generates SQL checking for the existence of a schema.view public listViews ([unknown $schemaName]) Generates the SQL to list all views of a schema or user public tableExists (unknown $tableName, [unknown $schemaName]) Generates SQL checking for the existence of a schema.table <?php
echo $dialect->tableExists("posts", "blog");
echo $dialect->tableExists("posts");
public describeColumns (unknown $table, [unknown $schema]) Generates SQL describing a table <?php
print_r($dialect->describeColumns("posts"));
public listTables ([unknown $schemaName]) List all tables in database <?php
print_r($dialect->listTables("blog"))
public describeIndexes (unknown $table, [unknown $schema]) Generates SQL to query indexes on a table public describeReferences (unknown $table, [unknown $schema]) Generates SQL to query foreign keys on a table public tableOptions (unknown $table, [unknown $schema]) Generates the SQL to describe the table creation options public supportsSavepoints () Checks whether the platform supports savepoints public supportsReleaseSavepoints () Checks whether the platform supports releasing savepoints. protected prepareTable (unknown $table, [unknown $schema], [unknown $alias], [unknown $escapeChar]) Prepares table for this RDBMS public registerCustomFunction (unknown $name, unknown $customFunction) inherited from Phalcon\Db\Dialect Registers custom SQL functions public getCustomFunctions () inherited from Phalcon\Db\Dialect Returns registered functions final public escape (unknown $str, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Escape identifiers public forUpdate (unknown $sqlQuery) inherited from Phalcon\Db\Dialect 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) inherited from Phalcon\Db\Dialect 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]) inherited from Phalcon\Db\Dialect Gets a list of columns with escaped identifiers <?php
echo $dialect->getColumnList(array('column1', 'column'));
final public getSqlColumn (unknown $column, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve Column expressions public getSqlExpression (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Transforms an intermediate representation for a expression into a database system valid expression final public getSqlTable (unknown $table, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Transform an intermediate representation of a schema/table into a database system valid expression public select (array $definition) inherited from Phalcon\Db\Dialect Builds a SELECT statement public createSavepoint (unknown $name) inherited from Phalcon\Db\Dialect Generate SQL to create a new savepoint public releaseSavepoint (unknown $name) inherited from Phalcon\Db\Dialect Generate SQL to release a savepoint public rollbackSavepoint (unknown $name) inherited from Phalcon\Db\Dialect Generate SQL to rollback a savepoint final protected getSqlExpressionScalar (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve Column expressions final protected getSqlExpressionObject (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve object expressions final protected getSqlExpressionQualified (array $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Resolve qualified expressions final protected getSqlExpressionBinaryOperations (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve binary operations expressions final protected getSqlExpressionUnaryOperations (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve unary operations expressions final protected getSqlExpressionFunctionCall (array $expression, unknown $escapeChar, [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve function calls final protected getSqlExpressionList (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve Lists final protected getSqlExpressionAll (array $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Resolve * final protected getSqlExpressionCastValue (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve CAST of values final protected getSqlExpressionConvertValue (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve CONVERT of values encodings final protected getSqlExpressionCase (array $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve CASE expressions final protected getSqlExpressionFrom (unknown $expression, [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Resolve a FROM clause final protected getSqlExpressionJoins (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a JOINs clause final protected getSqlExpressionWhere (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a WHERE clause final protected getSqlExpressionGroupBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a GROUP BY clause final protected getSqlExpressionHaving (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a HAVING clause final protected getSqlExpressionOrderBy (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a ORDER BY clause final protected getSqlExpressionLimit (unknown $expression, [unknown $escapeChar], [unknown $bindCounts]) inherited from Phalcon\Db\Dialect Resolve a LIMIT clause protected prepareColumnAlias (unknown $qualified, [unknown $alias], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Prepares column for this RDBMS protected prepareQualified (unknown $column, [unknown $domain], [unknown $escapeChar]) inherited from Phalcon\Db\Dialect Prepares qualified for this RDBMS |