Class:OraclePlatform - Superclass: AbstractPlatform AbstractPlatform
⌊ OraclePlatform
public class OraclePlatform
extends AbstractPlatform
www.doctrine-project.org
Fields inherited from Doctrine\DBAL\Platforms\AbstractPlatform | |
---|---|
CREATE_FOREIGNKEYS, CREATE_INDEXES, TRIM_BOTH, TRIM_LEADING, TRIM_TRAILING, TRIM_UNSPECIFIED |
Method Summary | |
---|---|
string | fixSchemaElementName(mixed schemaElementName, string schemaName) Makes any fixes to a name of a schema element (table, sequence, ...) that are required by restrictions of the platform, like a maximum length. |
array | getAlterTableSQL(TableDiff diff, string diff->name, array changes, boolean check) Gets the sql statements for altering an existing table. |
string | getBigIntTypeDeclarationSQL(mixed field, array columnDef) |
string | getBooleanTypeDeclarationSQL(mixed field, array columnDef) |
void | getClobTypeDeclarationSQL(array field) @override |
void | getCreateAutoincrementSql(mixed name, mixed table, mixed start) |
string | getCreateSequenceSQL(\Doctrine\DBAL\Schema\Sequence sequence) Gets the SQL used to create a sequence that starts with a given value and increments by the given allocation size. |
void | |
void | getCreateViewSQL(mixed name, mixed sql) |
string | Gets the format string, as accepted by the date() function, that describes the format of a stored datetime value of this platform. |
string | getDateTimeTypeDeclarationSQL(array fieldDeclaration) |
string | getDateTypeDeclarationSQL(array fieldDeclaration) |
void | getDropAutoincrementSql(mixed table) |
void | getDropDatabaseSQL(mixed database) |
string | getDropForeignKeySQL(ForeignKeyConstraint|string foreignKey, Table|string table) |
string | getDropSequenceSQL(\Doctrine\DBAL\Schema\Sequence sequence) |
void | getDropViewSQL(mixed name) |
string | Returns global unique identifier |
string | getIntegerTypeDeclarationSQL(mixed field, array columnDef) |
void | |
void | getListSequencesSQL(mixed database) |
void | getListTableColumnsSQL(mixed table) |
void | getListTableConstraintsSQL(mixed table) |
void | getListTableForeignKeysSQL(mixed table) |
string | getListTableIndexesSQL(string table) |
void | |
string | getListViewsSQL(string database) Get the SQL to list all views of a database or user. |
integer | getLocateExpression(string str, string substr, mixed startPos, int pos) returns the position of the first occurrence of substring $substr in string $str |
int | Maximum length of any given databse identifier, like tables or column names. |
string | getName() Get the platform name for this instance |
string | getNowExpression(mixed type) Return string to call a variable with the current timestamp inside an SQL statement There are three special variables for current date and time: - CURRENT_TIMESTAMP (date and time, TIMESTAMP type) - CURRENT_DATE (date, DATE type) - CURRENT_TIME (time, TIME type) |
string | getSQLResultCasing(string column) Gets the character casing of a column in an SQL result set of this platform. |
void | getSequenceNextValSQL(string sequenceName) {@inheritdoc} |
void | getSetTransactionIsolationSQL(integer level) {@inheritdoc} |
string | getSmallIntTypeDeclarationSQL(mixed field, array columnDef) |
string | getSubstringExpression(string value, integer position, integer length, integer from, integer len) return string to call a function to get a substring inside an SQL statementNote: Not SQL92, but common functionality. |
string | getTimeTypeDeclarationSQL(array fieldDeclaration) |
string | getTruncateTableSQL(string tableName, bool cascade) |
void | getVarcharTypeDeclarationSQL(array field) Gets the SQL snippet used to declare a VARCHAR column on the Oracle platform. |
string | modifyLimitQuery(string query, integer limit, integer offset) Adds an driver-specific LIMIT clause to the query |
boolean | Whether the platform prefers sequences for ID generation. |
bool | Does this platform supports onUpdate in foreign key constraints? |
boolean | Whether the platform supports sequences. |
public string fixSchemaElementName(mixed schemaElementName, string schemaName)
Makes any fixes to a name of a schema element (table, sequence, ...) that are required by restrictions of the platform, like a maximum length.
public array getAlterTableSQL(TableDiff diff, string diff->name, array changes, boolean check)
Gets the sql statements for altering an existing table.
The method returns an array of sql statements, since some platforms need several statements.
public string getBigIntTypeDeclarationSQL(mixed field, array columnDef)
public string getBooleanTypeDeclarationSQL(mixed field, array columnDef)
public void getClobTypeDeclarationSQL(array field)
public void getCreateAutoincrementSql(mixed name, mixed table, mixed start)
public string getCreateSequenceSQL(\Doctrine\DBAL\Schema\Sequence sequence)
Gets the SQL used to create a sequence that starts with a given value and increments by the given allocation size.
Need to specifiy minvalue, since start with is hidden in the system and MINVALUE <= START WITH. Therefore we can use MINVALUE to be able to get a hint what START WITH was for later introspection in listSequences()
public void getCreateTemporaryTableSnippetSQL()
public void getCreateViewSQL(mixed name, mixed sql)
public string getDateTimeFormatString()
Gets the format string, as accepted by the date() function, that describes the format of a stored datetime value of this platform.
public string getDateTimeTypeDeclarationSQL(array fieldDeclaration)
public string getDateTypeDeclarationSQL(array fieldDeclaration)
public void getDropAutoincrementSql(mixed table)
public void getDropDatabaseSQL(mixed database)
public string getDropForeignKeySQL(ForeignKeyConstraint|string foreignKey, Table|string table)
public string getDropSequenceSQL(\Doctrine\DBAL\Schema\Sequence sequence)
public void getDropViewSQL(mixed name)
public string getGuidExpression()
Returns global unique identifier
public string getIntegerTypeDeclarationSQL(mixed field, array columnDef)
public void getListDatabasesSQL()
public void getListSequencesSQL(mixed database)
public void getListTableColumnsSQL(mixed table)
public void getListTableConstraintsSQL(mixed table)
public void getListTableForeignKeysSQL(mixed table)
public string getListTableIndexesSQL(string table)
http://ezcomponents.org/docs/api/trunk/DatabaseSchema/ezcDbSchemaOracleReader.html
public void getListTablesSQL()
public string getListViewsSQL(string database)
Get the SQL to list all views of a database or user.
public integer getLocateExpression(string str, string substr, mixed startPos, int pos)
returns the position of the first occurrence of substring $substr in string $str
public int getMaxIdentifierLength()
Maximum length of any given databse identifier, like tables or column names.
public string getName()
Get the platform name for this instance
public string getNowExpression(mixed type)
Return string to call a variable with the current timestamp inside an SQL statement There are three special variables for current date and time: - CURRENT_TIMESTAMP (date and time, TIMESTAMP type) - CURRENT_DATE (date, DATE type) - CURRENT_TIME (time, TIME type)
public string getSQLResultCasing(string column)
Gets the character casing of a column in an SQL result set of this platform.
Oracle returns all column names in SQL result sets in uppercase.
public void getSequenceNextValSQL(string sequenceName)
public void getSetTransactionIsolationSQL(integer level)
public string getSmallIntTypeDeclarationSQL(mixed field, array columnDef)
public string getSubstringExpression(string value, integer position, integer length, integer from, integer len)
return string to call a function to get a substring inside an SQL statement
Note: Not SQL92, but common functionality.
public string getTimeTypeDeclarationSQL(array fieldDeclaration)
public string getTruncateTableSQL(string tableName, bool cascade)
public void getVarcharTypeDeclarationSQL(array field)
Gets the SQL snippet used to declare a VARCHAR column on the Oracle platform.
public string modifyLimitQuery(string query, integer limit, integer offset)
Adds an driver-specific LIMIT clause to the query
public boolean prefersSequences()
Whether the platform prefers sequences for ID generation.
public bool supportsForeignKeyOnUpdate()
Does this platform supports onUpdate in foreign key constraints?
public boolean supportsSequences()
Whether the platform supports sequences.
OraclePlatform.