class PgsqlPlatform extends DefaultPlatform
Postgresql 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)
Override to provide sequence names that conform to postgres' standard when no id-method-parameter specified. |
|
| getAddTablesDDL(Database $database) | ||
| string |
getBeginDDL()
Gets the requests to execute at the beginning of a DDL file |
from DefaultPlatform |
| string |
getEndDDL()
Gets the requests to execute at the end of a DDL file |
from DefaultPlatform |
| getDropTableDDL(Table $table) | ||
| getAddTableDDL(Table $table) | ||
| getColumnDDL(Column $col) | ||
| 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) | ||
| string |
getPrimaryKeyDDL(Table $table)
Returns the SQL for the primary key of a Table object |
from DefaultPlatform |
| string |
getDropPrimaryKeyDDL(Table $table)
Builds the DDL SQL to drop the primary key of a table. |
from DefaultPlatform |
| string |
getAddPrimaryKeyDDL(Table $table)
Builds the DDL SQL to add the primary key of a table. |
from DefaultPlatform |
| 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. |
from DefaultPlatform |
| string |
getDropIndexDDL(Index $index)
Overrides the implementation 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 |
| string |
getForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL for a ForeignKey object. |
from DefaultPlatform |
| 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)
Overrides the implementation from DefaultPlatform |
|
| string |
getModifyColumnsDDL($columnDiffs)
Overrides the implementation from DefaultPlatform |
|
| string |
getAddColumnDDL(Column $column)
Builds the DDL SQL to remove a column |
from DefaultPlatform |
| string |
getAddColumnsDDL($columns)
Overrides the implementation from DefaultPlatform |
|
| hasSize($sqlType) | ||
| 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 |
| string |
quoteIdentifier(string $text)
Quotes identifiers used in database SQL. |
from DefaultPlatform |
| setIdentifierQuoting($enabled = true) | from DefaultPlatform | |
| getIdentifierQuoting() | from DefaultPlatform | |
| supportsNativeDeleteTrigger() | ||
| boolean |
supportsInsertNullPk()
Whether RDBMS supports INSERT null values in autoincremented primary keys |
from DefaultPlatform |
| hasStreamBlobImpl() | ||
| supportsSchemas() | ||
| supportsMigrations() | from DefaultPlatform | |
| supportsVarcharWithoutSize() | ||
| getBooleanString($b) | ||
| string |
getTimestampFormatter()
Gets the preferred timestamp formatter for setting date/time values. |
from DefaultPlatform |
| 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. |
from DefaultPlatform | |
|
getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ')
Get the PHP snippet for getting a Pk from the database. |
||
| string |
disconnectedEscapeText(string $text)
Escape the string for RDBMS. |
|
| getAddSchemasDDL(Database $database) | ||
| getAddSchemaDDL(Table $table) | ||
| getUseSchemaDDL(Table $table) | ||
| getResetSchemaDDL(Table $table) |
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 127
public string
getDatabaseType()
Returns the short name of the database type that this platform represents.
For example MysqlPlatform->getDatabaseType() returns 'mysql'.
at line 59
public
getMaxColumnNameLength()
at line 49
public
getNativeIdMethod()
in DefaultPlatform at line 154
public
isNativeIdMethodAutoIncrement()
in DefaultPlatform at line 165
public Domain
getDomainForType(string $propelType)
Returns the db specific domain for a propelType.
in DefaultPlatform at line 177
public string
getNullString($notNull)
at line 54
public
getAutoIncrement()
at line 99
public string
getSequenceName(Table $table)
Override to provide sequence names that conform to postgres' standard when no id-method-parameter specified.
at line 195
public
getAddTablesDDL(Database $database)
in DefaultPlatform at line 249
public string
getBeginDDL()
Gets the requests to execute at the beginning of a DDL file
in DefaultPlatform at line 258
public string
getEndDDL()
Gets the requests to execute at the end of a DDL file
at line 284
public
getDropTableDDL(Table $table)
at line 212
public
getAddTableDDL(Table $table)
at line 303
public
getColumnDDL(Column $col)
in DefaultPlatform at line 345
public string
getColumnDefaultValueDDL(Column $col)
Returns the SQL for the default value of a Column object
in DefaultPlatform at line 381
public string
getColumnListDDL($columns, $delimiter = ',')
Creates a delimiter-delimited string list of column names, quoted using quoteIdentifier().
at line 297
public
getPrimaryKeyName(Table $table)
in DefaultPlatform at line 407
public string
getPrimaryKeyDDL(Table $table)
Returns the SQL for the primary key of a Table object
in DefaultPlatform at line 420
public string
getDropPrimaryKeyDDL(Table $table)
Builds the DDL SQL to drop the primary key of a table.
in DefaultPlatform at line 437
public string
getAddPrimaryKeyDDL(Table $table)
Builds the DDL SQL to add the primary key of a table.
in DefaultPlatform at line 454
public string
getAddIndicesDDL(Table $table)
Builds the DDL SQL to add the indices of a table.
in DefaultPlatform at line 469
public string
getAddIndexDDL(Index $index)
Builds the DDL SQL to add an Index.
at line 457
public string
getDropIndexDDL(Index $index)
Overrides the implementation from DefaultPlatform
in DefaultPlatform at line 504
public string
getIndexDDL(Index $index)
Builds the DDL SQL for an Index object.
at line 331
public
getUniqueDDL(Unique $unique)
in DefaultPlatform at line 530
public string
getAddForeignKeysDDL(Table $table)
Builds the DDL SQL to add the foreign keys of a table.
in DefaultPlatform at line 545
public string
getAddForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to add a foreign key.
in DefaultPlatform at line 565
public string
getDropForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL to drop a foreign key.
in DefaultPlatform at line 583
public string
getForeignKeyDDL(ForeignKey $fk)
Builds the DDL SQL for a ForeignKey object.
in DefaultPlatform at line 609
public
getCommentLineDDL($comment)
in DefaultPlatform at line 616
public
getCommentBlockDDL($comment)
in DefaultPlatform at line 632
public string
getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)
Builds the DDL SQL to modify a database based on a PropelDatabaseDiff instance
in DefaultPlatform at line 666
public string
getRenameTableDDL($fromTableName, $toTableName)
Builds the DDL SQL to rename a table
in DefaultPlatform at line 683
public string
getModifyTableDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance
in DefaultPlatform at line 748
public string
getModifyTableColumnsDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table based on a PropelTableDiff instance
in DefaultPlatform at line 777
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 795
public string
getModifyTableIndicesDDL(PropelTableDiff $tableDiff)
Builds the DDL SQL to alter a table's indices based on a PropelTableDiff instance
in DefaultPlatform at line 822
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 848
public string
getRemoveColumnDDL(Column $column)
Builds the DDL SQL to remove a column
in DefaultPlatform at line 863
public string
getRenameColumnDDL($fromColumn, $toColumn)
Builds the DDL SQL to rename a column
at line 369
public string
getModifyColumnDDL(PropelColumnDiff $columnDiff)
Overrides the implementation from DefaultPlatform
at line 425
public string
getModifyColumnsDDL($columnDiffs)
Overrides the implementation from DefaultPlatform
in DefaultPlatform at line 929
public string
getAddColumnDDL(Column $column)
Builds the DDL SQL to remove a column
at line 441
public string
getAddColumnsDDL($columns)
Overrides the implementation from DefaultPlatform
at line 347
public
hasSize($sqlType)
in DefaultPlatform at line 988
public boolean
hasScale(string $sqlType)
Returns if the RDBMS-specific SQL type has a scale attribute.
in DefaultPlatform at line 998
public string
quote(string $text)
Quote and escape needed characters in the string for unerlying RDBMS.
in DefaultPlatform at line 1026
public string
quoteIdentifier(string $text)
Quotes identifiers used in database SQL.
in DefaultPlatform at line 1031
public
setIdentifierQuoting($enabled = true)
in DefaultPlatform at line 1036
public
getIdentifierQuoting()
at line 86
public
supportsNativeDeleteTrigger()
in DefaultPlatform at line 1054
public boolean
supportsInsertNullPk()
Whether RDBMS supports INSERT null values in autoincremented primary keys
at line 352
public
hasStreamBlobImpl()
at line 342
public
supportsSchemas()
in DefaultPlatform at line 1079
public
supportsMigrations()
at line 357
public
supportsVarcharWithoutSize()
at line 78
public
getBooleanString($b)
in DefaultPlatform at line 1111
public string
getTimestampFormatter()
Gets the preferred timestamp formatter for setting date/time values.
in DefaultPlatform at line 1120
public string
getTimeFormatter()
Gets the preferred time formatter for setting date/time values.
in DefaultPlatform at line 1129
public string
getDateFormatter()
Gets the preferred date formatter for setting date/time values.
in DefaultPlatform at line 1139
public
getColumnBindingPHP($column, $identifier, $columnValueAccessor, $tab = ' ')
Get the PHP snippet for binding a value to a column.
Warning: duplicates logic from DBAdapter::bindValue().
Any code modification here must be ported there.
at line 477
public
getIdentifierPhp($columnValueMutator, $connectionVariableName = '$con', $sequenceName = '', $tab = ' ')
Get the PHP snippet for getting a Pk from the database.
Warning: duplicates logic from DBPostgres::getId().
Any code modification here must be ported there.
at line 69
public string
disconnectedEscapeText(string $text)
Escape the string for RDBMS.