Propel API
Class

PgsqlPlatform

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()

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()

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
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.

Parameters

PDO $con Optional database connection to use in this platform.

in DefaultPlatform at line 58
public setConnection(PDO $con = null)

Set the database connection to use for this Platform class.

Parameters

PDO $con Database connection to use in this platform.

in DefaultPlatform at line 67
public PDO getConnection()

Returns the database connection to use for this Platform class.

Return Value

PDO The database connection or NULL if none has been set.

in DefaultPlatform at line 77
public setGeneratorConfig(GeneratorConfig $config)

Sets the GeneratorConfig to use in the parsing.

Parameters

GeneratorConfig $config

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'.

Return Value

string

at line 59
public getMaxColumnNameLength()

at line 49
public getNativeIdMethod()

in DefaultPlatform at line 160
public Domain getDomainForType(string $propelType)

Returns the db specific domain for a propelType.

Parameters

string $propelType the Propel type name.

Return Value

Domain The db specific domain.

in DefaultPlatform at line 172
public string getNullString($notNull)

Parameters

$notNull

Return Value

string The RDBMS-specific SQL fragment for <code>NULL</code> or <code>NOT NULL</code>.

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.

Parameters

Table $table

Return Value

string

at line 195
public getAddTablesDDL(Database $database)

Parameters

Database $database

in DefaultPlatform at line 244
public string getBeginDDL()

Gets the requests to execute at the beginning of a DDL file

Return Value

string

in DefaultPlatform at line 253
public string getEndDDL()

Gets the requests to execute at the end of a DDL file

Return Value

string

at line 284
public getDropTableDDL(Table $table)

Parameters

Table $table

at line 212
public getAddTableDDL(Table $table)

Parameters

Table $table

at line 303
public getColumnDDL(Column $col)

Parameters

Column $col

in DefaultPlatform at line 340
public string getColumnDefaultValueDDL(Column $col)

Returns the SQL for the default value of a Column object

Parameters

Column $col

Return Value

string

in DefaultPlatform at line 376
public string getColumnListDDL($columns, $delimiter = ',')

Creates a delimiter-delimited string list of column names, quoted using quoteIdentifier().

Parameters

$columns
$delimiter

Return Value

string

at line 297
public getPrimaryKeyName(Table $table)

Parameters

Table $table

in DefaultPlatform at line 402
public string getPrimaryKeyDDL(Table $table)

Returns the SQL for the primary key of a Table object

Parameters

Table $table

Return Value

string

in DefaultPlatform at line 415
public string getDropPrimaryKeyDDL(Table $table)

Builds the DDL SQL to drop the primary key of a table.

Parameters

Table $table

Return Value

string

in DefaultPlatform at line 432
public string getAddPrimaryKeyDDL(Table $table)

Builds the DDL SQL to add the primary key of a table.

Parameters

Table $table

Return Value

string

in DefaultPlatform at line 449
public string getAddIndicesDDL(Table $table)

Builds the DDL SQL to add the indices of a table.

Parameters

Table $table

Return Value

string

in DefaultPlatform at line 464
public string getAddIndexDDL(Index $index)

Builds the DDL SQL to add an Index.

Parameters

Index $index

Return Value

string

at line 448
public string getDropIndexDDL(Index $index)

Overrides the implementation from DefaultPlatform

Parameters

Index $index

Return Value

string

See also

DefaultPlatform::getDropIndexDDL

in DefaultPlatform at line 499
public string getIndexDDL(Index $index)

Builds the DDL SQL for an Index object.

Parameters

Index $index

Return Value

string

at line 331
public getUniqueDDL(Unique $unique)

Parameters

Unique $unique

in DefaultPlatform at line 525
public string getAddForeignKeysDDL(Table $table)

Builds the DDL SQL to add the foreign keys of a table.

Parameters

Table $table

Return Value

string

in DefaultPlatform at line 540
public string getAddForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL to add a foreign key.

Parameters

ForeignKey $fk

Return Value

string

in DefaultPlatform at line 560
public string getDropForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL to drop a foreign key.

Parameters

ForeignKey $fk

Return Value

string

in DefaultPlatform at line 578
public string getForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL for a ForeignKey object.

Parameters

ForeignKey $fk

Return Value

string

in DefaultPlatform at line 604
public getCommentLineDDL($comment)

Parameters

$comment

in DefaultPlatform at line 611
public getCommentBlockDDL($comment)

Parameters

$comment

in DefaultPlatform at line 627
public string getModifyDatabaseDDL(PropelDatabaseDiff $databaseDiff)

Builds the DDL SQL to modify a database based on a PropelDatabaseDiff instance

Parameters

PropelDatabaseDiff $databaseDiff

Return Value

string

in DefaultPlatform at line 661
public string getRenameTableDDL($fromTableName, $toTableName)

Builds the DDL SQL to rename a table

Parameters

$fromTableName
$toTableName

Return Value

string

in DefaultPlatform at line 678
public string getModifyTableDDL(PropelTableDiff $tableDiff)

Builds the DDL SQL to alter a table based on a PropelTableDiff instance

Parameters

PropelTableDiff $tableDiff

Return Value

string

in DefaultPlatform at line 743
public string getModifyTableColumnsDDL(PropelTableDiff $tableDiff)

Builds the DDL SQL to alter a table based on a PropelTableDiff instance

Parameters

PropelTableDiff $tableDiff

Return Value

string

in DefaultPlatform at line 772
public string getModifyTablePrimaryKeyDDL(PropelTableDiff $tableDiff)

Builds the DDL SQL to alter a table's primary key based on a PropelTableDiff instance

Parameters

PropelTableDiff $tableDiff

Return Value

string

in DefaultPlatform at line 790
public string getModifyTableIndicesDDL(PropelTableDiff $tableDiff)

Builds the DDL SQL to alter a table's indices based on a PropelTableDiff instance

Parameters

PropelTableDiff $tableDiff

Return Value

string

in DefaultPlatform at line 817
public string getModifyTableForeignKeysDDL(PropelTableDiff $tableDiff)

Builds the DDL SQL to alter a table's foreign keys based on a PropelTableDiff instance

Parameters

PropelTableDiff $tableDiff

Return Value

string

in DefaultPlatform at line 843
public string getRemoveColumnDDL(Column $column)

Builds the DDL SQL to remove a column

Parameters

Column $column

Return Value

string

in DefaultPlatform at line 858
public string getRenameColumnDDL($fromColumn, $toColumn)

Builds the DDL SQL to rename a column

Parameters

$fromColumn
$toColumn

Return Value

string

at line 364
public string getModifyColumnDDL(PropelColumnDiff $columnDiff)

Overrides the implementation from DefaultPlatform

Parameters

PropelColumnDiff $columnDiff

Return Value

string

See also

DefaultPlatform::getModifyColumnDDL

at line 416
public string getModifyColumnsDDL($columnDiffs)

Overrides the implementation from DefaultPlatform

Parameters

$columnDiffs

Return Value

string

See also

DefaultPlatform::getModifyColumnsDDL

in DefaultPlatform at line 924
public string getAddColumnDDL(Column $column)

Builds the DDL SQL to remove a column

Parameters

Column $column

Return Value

string

at line 432
public string getAddColumnsDDL($columns)

Overrides the implementation from DefaultPlatform

Parameters

$columns

Return Value

string

See also

DefaultPlatform::getAddColumnsDLL

at line 347
public hasSize($sqlType)

Parameters

$sqlType

in DefaultPlatform at line 983
public boolean hasScale(string $sqlType)

Returns if the RDBMS-specific SQL type has a scale attribute.

Parameters

string $sqlType the SQL type

Return Value

boolean True if the type has a scale attribute

in DefaultPlatform at line 993
public string quote(string $text)

Quote and escape needed characters in the string for unerlying RDBMS.

Parameters

string $text

Return Value

string

in DefaultPlatform at line 1021
public string quoteIdentifier(string $text)

Quotes identifiers used in database SQL.

Parameters

string $text

Return Value

string Quoted identifier.

in DefaultPlatform at line 1026
public setIdentifierQuoting($enabled = true)

Parameters

$enabled

in DefaultPlatform at line 1031
public getIdentifierQuoting()

at line 86
public supportsNativeDeleteTrigger()

in DefaultPlatform at line 1049
public boolean supportsInsertNullPk()

Whether RDBMS supports INSERT null values in autoincremented primary keys

Return Value

boolean

at line 352
public hasStreamBlobImpl()

at line 342
public supportsSchemas()

See also

Platform::supportsSchemas()

at line 78
public getBooleanString($b)

Parameters

$b

in DefaultPlatform at line 1093
public string getTimestampFormatter()

Gets the preferred timestamp formatter for setting date/time values.

Return Value

string

in DefaultPlatform at line 1102
public string getTimeFormatter()

Gets the preferred time formatter for setting date/time values.

Return Value

string

in DefaultPlatform at line 1111
public string getDateFormatter()

Gets the preferred date formatter for setting date/time values.

Return Value

string

at line 69
public string disconnectedEscapeText(string $text)

Escape the string for RDBMS.

Parameters

string $text

Return Value

string

at line 148
public getAddSchemasDDL(Database $database)

Parameters

Database $database

at line 162
public getAddSchemaDDL(Table $table)

Parameters

Table $table

at line 174
public getUseSchemaDDL(Table $table)

Parameters

Table $table

at line 185
public getResetSchemaDDL(Table $table)

Parameters

Table $table