class OraclePlatform extends DefaultPlatform
Oracle PropelPlatformInterface implementation.
Methods
|
__construct(PDO $con = null)
Default constructor. |
from DefaultPlatform | |
|
setConnection(PDO $con = null)
Set the database connection to use for this Platform class. |
from DefaultPlatform | |
| PDO |
getConnection()
Returns the database connection to use for this Platform class. |
from DefaultPlatform |
|
setGeneratorConfig(GeneratorConfig $config)
Sets the GeneratorConfig to use in the parsing. |
from DefaultPlatform | |
| string |
getDatabaseType()
Returns the short name of the database type that this platform represents. |
from DefaultPlatform |
| getMaxColumnNameLength() | ||
| getNativeIdMethod() | ||
| isNativeIdMethodAutoIncrement() | from DefaultPlatform | |
| Domain |
getDomainForType(string $propelType)
Returns the db specific domain for a propelType. |
from DefaultPlatform |
| string | getNullString($notNull) | from DefaultPlatform |
| getAutoIncrement() | ||
| string |
getSequenceName(Table $table)
Gets the name to use for creating a sequence for a table. |
from DefaultPlatform |
| getAddTablesDDL(Database $database) | ||
| getBeginDDL() | ||
| string |
getEndDDL()
Gets the requests to execute at the end of a DDL file |
from DefaultPlatform |
| getDropTableDDL(Table $table) | ||
| getAddTableDDL(Table $table) | ||
| string |
getColumnDDL(Column $col)
Builds the DDL SQL for a Column object. |
from DefaultPlatform |
| string |
getColumnDefaultValueDDL(Column $col)
Returns the SQL for the default value of a Column object |
from DefaultPlatform |
| string |
getColumnListDDL($columns, $delimiter = ',')
Creates a delimiter-delimited string list of column names, quoted using quoteIdentifier(). |
from DefaultPlatform |
| getPrimaryKeyName(Table $table) | ||
| getPrimaryKeyDDL(Table $table) | ||
| string |
getDropPrimaryKeyDDL(Table $table)
Builds the DDL SQL to drop the primary key of a table. |
from DefaultPlatform |
| getAddPrimaryKeyDDL(Table $table) | ||
| string |
getAddIndicesDDL(Table $table)
Builds the DDL SQL to add the indices of a table. |
from DefaultPlatform |
| string |
getAddIndexDDL(Index $index)
Builds the DDL SQL to add an Index. |
|
| string |
getDropIndexDDL(Index $index)
Builds the DDL SQL to drop an Index. |
from DefaultPlatform |
| string |
getIndexDDL(Index $index)
Builds the DDL SQL for an Index object. |
from DefaultPlatform |
| getUniqueDDL(Unique $unique) | ||
| string |
getAddForeignKeysDDL(Table $table)
Builds the DDL SQL to add the foreign keys of a table. |
from DefaultPlatform |
| string |
getAddForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to add a foreign key. |
from DefaultPlatform |
| string |
getDropForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to drop a foreign key. |
from DefaultPlatform |
| getForeignKeyDDL(ForeignKey $fk) | ||
| getCommentLineDDL($comment) | from DefaultPlatform | |
| getCommentBlockDDL($comment) | from DefaultPlatform | |
| string |
getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)
Builds the DDL SQL to modify a database based on a PropelDatabaseDiff instance |
from DefaultPlatform |
| string |
getRenameTableDDL($fromTableName, $toTableName)
Builds the DDL SQL to rename a table |
from DefaultPlatform |
| string |
getModifyTableDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance |
from DefaultPlatform |
| string |
getModifyTableColumnsDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance |
from DefaultPlatform |
| string |
getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's primary key based on a PropelTableDiff instance |
from DefaultPlatform |
| string |
getModifyTableIndicesDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's indices based on a PropelTableDiff instance |
from DefaultPlatform |
| string |
getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's foreign keys based on a PropelTableDiff instance |
from DefaultPlatform |
| string |
getRemoveColumnDDL(Column $column)
Builds the DDL SQL to remove a column |
from DefaultPlatform |
| string |
getRenameColumnDDL($fromColumn, $toColumn)
Builds the DDL SQL to rename a column |
from DefaultPlatform |
| string |
getModifyColumnDDL(PropelColumnDiff $columnDiff)
Builds the DDL SQL to modify a column |
from DefaultPlatform |
| string |
getModifyColumnsDDL($columnDiffs)
Builds the DDL SQL to modify a list of columns |
from DefaultPlatform |
| string |
getAddColumnDDL(Column $column)
Builds the DDL SQL to remove a column |
from DefaultPlatform |
| string |
getAddColumnsDDL($columns)
Builds the DDL SQL to remove a list of columns |
from DefaultPlatform |
| boolean |
hasSize(string $sqlType)
Returns if the RDBMS-specific SQL type has a size attribute. |
from DefaultPlatform |
| boolean |
hasScale(string $sqlType)
Returns if the RDBMS-specific SQL type has a scale attribute. |
from DefaultPlatform |
| string |
quote(string $text)
Quote and escape needed characters in the string for unerlying RDBMS. |
from DefaultPlatform |
| quoteIdentifier($text) | ||
| setIdentifierQuoting($enabled = true) | from DefaultPlatform | |
| getIdentifierQuoting() | from DefaultPlatform | |
| supportsNativeDeleteTrigger() | ||
| boolean |
supportsInsertNullPk()
Whether RDBMS supports INSERT null values in autoincremented primary keys |
from DefaultPlatform |
| boolean |
hasStreamBlobImpl()
Whether the underlying PDO driver for this platform returns BLOB columns as streams (instead of strings). |
|
| supportsSchemas() | ||
| supportsMigrations() | from DefaultPlatform | |
| supportsVarcharWithoutSize() | from DefaultPlatform | |
| mixed |
getBooleanString($b)
Returns the boolean value for the RDBMS. |
from DefaultPlatform |
| getPhpArrayString($stringValue) | from DefaultPlatform | |
| getTimestampFormatter() | ||
| string |
getTimeFormatter()
Gets the preferred time formatter for setting date/time values. |
from DefaultPlatform |
| string |
getDateFormatter()
Gets the preferred date formatter for setting date/time values. |
from DefaultPlatform |
|
getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab = ' ')
Get the PHP snippet for binding a value to a column. |
||
|
getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ')
Get the PHP snippet for getting a Pk from the database. |
||
| getAddSequencesDDL(Table $table) | ||
| string |
generateBlockStorage(Table|Index $object, bool $isPrimaryKey = false)
Generate oracle block storage |
Details
in DefaultPlatform at line 48
public
__construct(PDO $con = null)
Default constructor.
in DefaultPlatform at line 58
public
setConnection(PDO $con = null)
Set the database connection to use for this Platform class.
in DefaultPlatform at line 67
public PDO
getConnection()
Returns the database connection to use for this Platform class.
in DefaultPlatform at line 77
public
setGeneratorConfig(GeneratorConfig $config)
Sets the GeneratorConfig to use in the parsing.
in DefaultPlatform at line 128
public string
getDatabaseType()
Returns the short name of the database type that this platform represents.
For example MysqlPlatform->getDatabaseType() returns 'mysql'.
at line 56
public
getMaxColumnNameLength()
at line 61
public
getNativeIdMethod()
in DefaultPlatform at line 156
public
isNativeIdMethodAutoIncrement()
in DefaultPlatform at line 168
public Domain
getDomainForType(string $propelType)
Returns the db specific domain for a propelType.
in DefaultPlatform at line 181
public string
getNullString($notNull)
at line 66
public
getAutoIncrement()
in DefaultPlatform at line 204
public string
getSequenceName(Table $table)
Gets the name to use for creating a sequence for a table.
This will create a new name or use one specified in an id-method-parameter
tag, if specified.
at line 84
public
getAddTablesDDL(Database $database)
at line 76
public
getBeginDDL()
in DefaultPlatform at line 263
public string
getEndDDL()
Gets the requests to execute at the end of a DDL file
at line 162
public
getDropTableDDL(Table $table)
at line 105
public
getAddTableDDL(Table $table)
in DefaultPlatform at line 323
public string
getColumnDDL(Column $col)
Builds the DDL SQL for a Column object.
in DefaultPlatform at line 351
public string
getColumnDefaultValueDDL(Column $col)
Returns the SQL for the default value of a Column object
in DefaultPlatform at line 395
public string
getColumnListDDL($columns, $delimiter = ',')
Creates a delimiter-delimited string list of column names, quoted using quoteIdentifier().
at line 176
public
getPrimaryKeyName(Table $table)
at line 185
public
getPrimaryKeyDDL(Table $table)
in DefaultPlatform at line 436
public string
getDropPrimaryKeyDDL(Table $table)
Builds the DDL SQL to drop the primary key of a table.
at line 141
public
getAddPrimaryKeyDDL(Table $table)
in DefaultPlatform at line 472
public string
getAddIndicesDDL(Table $table)
Builds the DDL SQL to add the indices of a table.
at line 322
public string
getAddIndexDDL(Index $index)
Builds the DDL SQL to add an Index.
in DefaultPlatform at line 508
public string
getDropIndexDDL(Index $index)
Builds the DDL SQL to drop an Index.
in DefaultPlatform at line 525
public string
getIndexDDL(Index $index)
Builds the DDL SQL for an Index object.
at line 198
public
getUniqueDDL(Unique $unique)
in DefaultPlatform at line 551
public string
getAddForeignKeysDDL(Table $table)
Builds the DDL SQL to add the foreign keys of a table.
in DefaultPlatform at line 567
public string
getAddForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to add a foreign key.
in DefaultPlatform at line 588
public string
getDropForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to drop a foreign key.
at line 206
public
getForeignKeyDDL(ForeignKey $fk)
in DefaultPlatform at line 633
public
getCommentLineDDL($comment)
in DefaultPlatform at line 641
public
getCommentBlockDDL($comment)
in DefaultPlatform at line 658
public string
getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)
Builds the DDL SQL to modify a database based on a PropelDatabaseDiff instance
in DefaultPlatform at line 692
public string
getRenameTableDDL($fromTableName, $toTableName)
Builds the DDL SQL to rename a table
in DefaultPlatform at line 710
public string
getModifyTableDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance
in DefaultPlatform at line 775
public string
getModifyTableColumnsDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance
in DefaultPlatform at line 804
public string
getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's primary key based on a PropelTableDiff instance
in DefaultPlatform at line 822
public string
getModifyTableIndicesDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's indices based on a PropelTableDiff instance
in DefaultPlatform at line 849
public string
getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's foreign keys based on a PropelTableDiff instance
in DefaultPlatform at line 875
public string
getRemoveColumnDDL(Column $column)
Builds the DDL SQL to remove a column
in DefaultPlatform at line 891
public string
getRenameColumnDDL($fromColumn, $toColumn)
Builds the DDL SQL to rename a column
in DefaultPlatform at line 909
public string
getModifyColumnDDL(PropelColumnDiff $columnDiff)
Builds the DDL SQL to modify a column
in DefaultPlatform at line 927
public string
getModifyColumnsDDL($columnDiffs)
Builds the DDL SQL to modify a list of columns
in DefaultPlatform at line 960
public string
getAddColumnDDL(Column $column)
Builds the DDL SQL to remove a column
in DefaultPlatform at line 977
public string
getAddColumnsDDL($columns)
Builds the DDL SQL to remove a list of columns
in DefaultPlatform at line 1010
public boolean
hasSize(string $sqlType)
Returns if the RDBMS-specific SQL type has a size attribute.
in DefaultPlatform at line 1021
public boolean
hasScale(string $sqlType)
Returns if the RDBMS-specific SQL type has a scale attribute.
in DefaultPlatform at line 1031
public string
quote(string $text)
Quote and escape needed characters in the string for unerlying RDBMS.
at line 236
public
quoteIdentifier($text)
in DefaultPlatform at line 1064
public
setIdentifierQuoting($enabled = true)
in DefaultPlatform at line 1069
public
getIdentifierQuoting()
at line 71
public
supportsNativeDeleteTrigger()
in DefaultPlatform at line 1087
public boolean
supportsInsertNullPk()
Whether RDBMS supports INSERT null values in autoincremented primary keys
at line 231
public boolean
hasStreamBlobImpl()
Whether the underlying PDO driver for this platform returns BLOB columns as streams (instead of strings).
at line 252
public
supportsSchemas()
in DefaultPlatform at line 1112
public
supportsMigrations()
in DefaultPlatform at line 1118
public
supportsVarcharWithoutSize()
in DefaultPlatform at line 1134
public mixed
getBooleanString($b)
Returns the boolean value for the RDBMS.
This value should match the boolean value that is set
when using Propel's PreparedStatement::setBoolean().
This function is used to set default column values when building
SQL.
in DefaultPlatform at line 1141
public
getPhpArrayString($stringValue)
at line 241
public
getTimestampFormatter()
in DefaultPlatform at line 1175
public string
getTimeFormatter()
Gets the preferred time formatter for setting date/time values.
in DefaultPlatform at line 1184
public string
getDateFormatter()
Gets the preferred date formatter for setting date/time values.
at line 347
public
getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab = ' ')
Get the PHP snippet for binding a value to a column.
Warning: duplicates logic from DBOracle::bindValue().
Any code modification here must be ported there.
at line 369
public
getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ')
Get the PHP snippet for getting a Pk from the database.
Warning: duplicates logic from DBOracle::getId().
Any code modification here must be ported there.
at line 148
public
getAddSequencesDDL(Table $table)
at line 265
public string
generateBlockStorage(Table|Index $object, bool $isPrimaryKey = false)
Generate oracle block storage