Table Of Contents

Previous topic

< Class Phalcon\Db\Dialect\Mysql

Next topic

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 RBDMS

Methods

public string getColumnDefinition (Phalcon\Db\ColumnInterface $column)

Gets the column name in Oracle

public string addColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column)

Generates SQL to add a column to a table

public string modifyColumn (string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column)

Generates SQL to modify a column in a table

public string dropColumn (string $tableName, string $schemaName, string $columnName)

Generates SQL to delete a column from a table

public string addIndex (string $tableName, string $schemaName, Phalcon\Db\Index $index)

Generates SQL to add an index to a table

public string dropIndex (string $tableName, string $schemaName, string $indexName)

Generates SQL to delete an index from a table

public string addPrimaryKey (string $tableName, string $schemaName, Phalcon\Db\Index $index)

Generates SQL to add the primary key to a table

public string dropPrimaryKey (string $tableName, string $schemaName)

Generates SQL to delete primary key from a table

public string addForeignKey (string $tableName, string $schemaName, Phalcon\Db\ReferenceInterface $reference)

Generates SQL to add an index to a table

public string dropForeignKey (string $tableName, string $schemaName, string $referenceName)

Generates SQL to delete a foreign key from a table

protected array _getTableOptions ()

Generates SQL to add the table creation options

public string createTable (string $tableName, string $schemaName, array $definition)

Generates SQL to create a table in PostgreSQL

public boolean dropTable (string $tableName, string $schemaName)

Generates SQL to drop a table

public string createView (string $viewName, array $definition, string $schemaName)

Generates SQL to create a view

public string dropView (string $viewName, string $schemaName, [boolean $ifExists])

Generates SQL to drop a view

public string tableExists (string $tableName, [string $schemaName])

Generates SQL checking for the existence of a schema.table

<?php

var_dump($dialect->tableExists("posts", "blog"));
var_dump($dialect->tableExists("posts"));

public string viewExists (string $viewName, [string $schemaName])

Generates SQL checking for the existence of a schema.view

public string describeColumns (string $table, [string $schema])

Generates a SQL describing a table

<?php

print_r($dialect->describeColumns("posts")); ?>

public array listTables ([string $schemaName])

List all tables on database

<?php

print_r($dialect->listTables("blog")) ?>

public array listViews ([string $schemaName])

Generates the SQL to list all views of a schema or user

public string describeIndexes (string $table, [string $schema])

Generates SQL to query indexes on a table

public string describeReferences (string $table, [string $schema])

Generates SQL to query foreign keys on a table

public string tableOptions (string $table, [string $schema])

Generates the SQL to describe the table creation options

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

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

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 select (array $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 forUpdate (string $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 string sharedLock (string $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

public string getColumnList (array $columnList) inherited from Phalcon\Db\Dialect

Gets a list of columns with escaped identifiers

<?php

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

public string getSqlExpression (array $expression, [string $escapeChar]) inherited from Phalcon\Db\Dialect

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

public string createSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to create a new savepoint

public string releaseSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to release a savepoint

public string rollbackSavepoint (string $name) inherited from Phalcon\Db\Dialect

Generate SQL to rollback a savepoint