PHP 클래스 Phalcon\Db\Dialect\Oracle

Generates database specific SQL for the Oracle RDBMS.


use Phalcon\Db\Adapter\Pdo\Oracle;
use Phalcon\Db\Adapter\Pdo\Oracle as Connection;

$connection = new Connection([
    'dbname'       => '//localhost/enigma',
    'username'     => 'oracle',
    'password'     => 'secret',
    'dialectClass' => Oracle::class,
]);

상속: extends Phalcon\Db\Dialect

파일 보기 프로젝트 열기: phalcon/incubator 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$_escapeChar		@codingStandardsIgnoreStart

공개 메소드들

메소드	설명
addColumn ( string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column ) : string	Generates SQL to add a column to a table.
addForeignKey ( string $tableName, string $schemaName, Phalcon\Db\ReferenceInterface $reference ) : string	Generates SQL to add an index to a table.
addIndex ( string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index ) : string	Generates SQL to add an index to a table.
addPrimaryKey ( string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index ) : string	Generates SQL to add the primary key to a table.
createTable ( string $tableName, string $schemaName, array $definition ) : string	Generates SQL to create a table in Oracle.
createView ( string $viewName, array $definition, string $schemaName = null ) : string	Generates SQL to create a view.
describeColumns ( string $table, string $schema = null ) : string	Generates SQL to describe a table.
describeIndexes ( string $table, string $schema = null ) : string	Generates SQL to query indexes on a table.
describeReferences ( $table, $schema = null )
dropColumn ( string $tableName, string $schemaName, string $columnName ) : string	Generates SQL to delete a column from a table.
dropForeignKey ( string $tableName, string $schemaName, string $referenceName ) : string	Generates SQL to delete a foreign key from a table.
dropIndex ( string $tableName, string $schemaName, string $indexName ) : string	Generates SQL to delete an index from a table.
dropPrimaryKey ( string $tableName, string $schemaName ) : string	Generates SQL to delete primary key from a table.
dropTable ( string $tableName, string $schemaName, boolean $ifExists = true ) : string	Generates SQL to drop a table.
dropView ( string $viewName, string $schemaName = null, boolean $ifExists = true ) : string	Generates SQL to drop a view.
getColumnDefinition ( Phalcon\Db\ColumnInterface $column ) : string	Gets the column name in Oracle.
limit ( string $sqlQuery, mixed $number ) : string	Generates the SQL for LIMIT clause.
listTables ( string $schemaName = null ) : string	List all tables in database.
listViews ( string $schemaName = null ) : string	Generates the SQL to list all views of a schema or user.
modifyColumn ( string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column, Phalcon\Db\ColumnInterface $current = null ) : string	Generates SQL to modify a column in a table.
supportsReleaseSavepoints ( ) : boolean	Checks whether the platform supports releasing savepoints.
supportsSavepoints ( ) : boolean	Checks whether the platform supports savepoints.
tableExists ( string $tableName, string $schemaName = null ) : string	Generates SQL checking for the existence of a schema.table
tableOptions ( string $table, string $schema = null ) : string	Generates the SQL to describe the table creation options.
viewExists ( string $viewName, string $schemaName = null ) : string	Generates SQL checking for the existence of a schema.view

보호된 메소드들

메소드	설명
prepareTable ( string $table, string $schema = null, string $alias = null, string $escapeChar = null ) : string	Prepares table for this RDBMS.

메소드 상세

addColumn() 공개 메소드

Generates SQL to add a column to a table.

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

addForeignKey() 공개 메소드

Generates SQL to add an index to a table.

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

addIndex() 공개 메소드

Generates SQL to add an index to a table.

public addIndex ( string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index ) : string
$tableName	string
$schemaName	string
$index	Phalcon\Db\IndexInterface
리턴	string

addPrimaryKey() 공개 메소드

Generates SQL to add the primary key to a table.

public addPrimaryKey ( string $tableName, string $schemaName, Phalcon\Db\IndexInterface $index ) : string
$tableName	string
$schemaName	string
$index	Phalcon\Db\IndexInterface
리턴	string

createTable() 공개 메소드

Generates SQL to create a table in Oracle.

public createTable ( string $tableName, string $schemaName, array $definition ) : string
$tableName	string
$schemaName	string
$definition	array
리턴	string

createView() 공개 메소드

Generates SQL to create a view.

public createView ( string $viewName, array $definition, string $schemaName = null ) : string
$viewName	string
$definition	array
$schemaName	string
리턴	string

describeColumns() 공개 메소드

Generates SQL to describe a table.

public describeColumns ( string $table, string $schema = null ) : string
$table	string
$schema	string
리턴	string

describeIndexes() 공개 메소드

Generates SQL to query indexes on a table.

public describeIndexes ( string $table, string $schema = null ) : string
$table	string
$schema	string
리턴	string

describeReferences() 공개 메소드

public describeReferences ( $table, $schema = null )

dropColumn() 공개 메소드

Generates SQL to delete a column from a table.

public dropColumn ( string $tableName, string $schemaName, string $columnName ) : string
$tableName	string
$schemaName	string
$columnName	string
리턴	string

dropForeignKey() 공개 메소드

Generates SQL to delete a foreign key from a table.

public dropForeignKey ( string $tableName, string $schemaName, string $referenceName ) : string
$tableName	string
$schemaName	string
$referenceName	string
리턴	string

dropIndex() 공개 메소드

Generates SQL to delete an index from a table.

public dropIndex ( string $tableName, string $schemaName, string $indexName ) : string
$tableName	string
$schemaName	string
$indexName	string
리턴	string

dropPrimaryKey() 공개 메소드

Generates SQL to delete primary key from a table.

public dropPrimaryKey ( string $tableName, string $schemaName ) : string
$tableName	string
$schemaName	string
리턴	string

dropTable() 공개 메소드

Generates SQL to drop a table.

public dropTable ( string $tableName, string $schemaName, boolean $ifExists = true ) : string
$tableName	string
$schemaName	string
$ifExists	boolean
리턴	string

dropView() 공개 메소드

Generates SQL to drop a view.

public dropView ( string $viewName, string $schemaName = null, boolean $ifExists = true ) : string
$viewName	string
$schemaName	string
$ifExists	boolean
리턴	string

getColumnDefinition() 공개 메소드

Gets the column name in Oracle.

public getColumnDefinition ( Phalcon\Db\ColumnInterface $column ) : string
$column	Phalcon\Db\ColumnInterface
리턴	string

limit() 공개 메소드

Generates the SQL for LIMIT clause.

public limit ( string $sqlQuery, mixed $number ) : string
$sqlQuery	string
$number	mixed
리턴	string

listTables() 공개 메소드


print_r($dialect->listTables('blog'));

public listTables ( string $schemaName = null ) : string
$schemaName	string
리턴	string

listViews() 공개 메소드

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

public listViews ( string $schemaName = null ) : string
$schemaName	string
리턴	string

modifyColumn() 공개 메소드

Generates SQL to modify a column in a table.

public modifyColumn ( string $tableName, string $schemaName, Phalcon\Db\ColumnInterface $column, Phalcon\Db\ColumnInterface $current = null ) : string
$tableName	string
$schemaName	string
$column	Phalcon\Db\ColumnInterface
$current	Phalcon\Db\ColumnInterface
리턴	string

prepareTable() 보호된 메소드

Prepares table for this RDBMS.

protected prepareTable ( string $table, string $schema = null, string $alias = null, string $escapeChar = null ) : string
$table	string
$schema	string
$alias	string
$escapeChar	string
리턴	string

supportsReleaseSavepoints() 공개 메소드

Checks whether the platform supports releasing savepoints.

public supportsReleaseSavepoints ( ) : boolean
리턴	boolean

supportsSavepoints() 공개 메소드

Checks whether the platform supports savepoints.

public supportsSavepoints ( ) : boolean
리턴	boolean

tableExists() 공개 메소드


echo $dialect->tableExists('posts', 'blog');
echo $dialect->tableExists('posts');

public tableExists ( string $tableName, string $schemaName = null ) : string
$tableName	string
$schemaName	string
리턴	string

tableOptions() 공개 메소드

Generates the SQL to describe the table creation options.

public tableOptions ( string $table, string $schema = null ) : string
$table	string
$schema	string
리턴	string

viewExists() 공개 메소드

Generates SQL checking for the existence of a schema.view

public viewExists ( string $viewName, string $schemaName = null ) : string
$viewName	string
$schemaName	string
리턴	string

프로퍼티 상세

$_escapeChar 보호되어 있는 프로퍼티

@codingStandardsIgnoreStart

protected $_escapeChar