PHP Класс Doctrine\DBAL\Platforms\PostgreSqlPlatform

С версии: 2.0
Автор: Roman Borschel ([email protected])
Наследование: extends Doctrine\DBAL\Platforms\AbstractPlatform
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
convertBooleans ( $item ) {@inheritDoc}
convertBooleansToDatabaseValue ( $item ) {@inheritDoc}
convertFromBoolean ( $item ) {@inheritDoc}
getAdvancedForeignKeyOptionsSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey ) {@inheritDoc}
getAlterSequenceSQL ( Doctrine\DBAL\Schema\Sequence $sequence ) {@inheritDoc}
getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff ) {@inheritDoc}
getBigIntTypeDeclarationSQL ( array $field ) {@inheritDoc}
getBinaryDefaultLength ( )
getBinaryMaxLength ( )
getBlobTypeDeclarationSQL ( array $field ) {@inheritDoc}
getBooleanTypeDeclarationSQL ( array $field ) {@inheritDoc}
getClobTypeDeclarationSQL ( array $field ) {@inheritDoc}
getCloseActiveDatabaseConnectionsSQL ( string $database ) : string Returns the SQL statement for closing currently active connections on the given database.
getCommentOnColumnSQL ( $tableName, $columnName, $comment )
getCreateDatabaseSQL ( $name ) {@inheritDoc}
getCreateSchemaSQL ( $schemaName ) {@inheritDoc}
getCreateSequenceSQL ( Doctrine\DBAL\Schema\Sequence $sequence ) {@inheritDoc}
getCreateViewSQL ( $name, $sql ) {@inheritDoc}
getDateDiffExpression ( $date1, $date2 ) {@inheritDoc}
getDateTimeTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getDateTimeTzFormatString ( ) {@inheritDoc}
getDateTimeTzTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getDateTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getDefaultSchemaName ( )
getDisallowDatabaseConnectionsSQL ( string $database ) : string Returns the SQL statement for disallowing new connections on the given database.
getDropForeignKeySQL ( $foreignKey, $table ) {@inheritDoc}
getDropSequenceSQL ( $sequence ) {@inheritDoc}
getDropViewSQL ( $name ) {@inheritDoc}
getEmptyIdentityInsertSQL ( $quotedTableName, $quotedIdentifierColumnName ) {@inheritDoc}
getGuidExpression ( ) {@inheritDoc}
getGuidTypeDeclarationSQL ( array $field ) {@inheritDoc}
getIdentitySequenceName ( $tableName, $columnName )
getIntegerTypeDeclarationSQL ( array $field ) {@inheritDoc}
getListDatabasesSQL ( ) {@inheritDoc}
getListNamespacesSQL ( ) {@inheritDoc}
getListSequencesSQL ( $database ) {@inheritDoc}
getListTableColumnsSQL ( $table, $database = null ) {@inheritDoc}
getListTableConstraintsSQL ( $table ) {@inheritDoc}
getListTableForeignKeysSQL ( $table, $database = null ) {@inheritDoc}
getListTableIndexesSQL ( $table, $currentDatabase = null ) {@inheritDoc}
getListTablesSQL ( ) {@inheritDoc}
getListViewsSQL ( $database ) {@inheritDoc}
getLocateExpression ( $str, $substr, $startPos = false ) {@inheritDoc}
getName ( ) {@inheritDoc}
getNowExpression ( ) {@inheritDoc}
getReadLockSQL ( ) {@inheritDoc}
getRegexpExpression ( ) {@inheritDoc}
getSQLResultCasing ( $column ) {@inheritDoc}
getSequenceNextValSQL ( $sequenceName ) {@inheritDoc}
getSetTransactionIsolationSQL ( $level ) {@inheritDoc}
getSmallIntTypeDeclarationSQL ( array $field ) {@inheritDoc}
getSubstringExpression ( $value, $from, $length = null ) {@inheritDoc}
getTimeTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getTruncateTableSQL ( $tableName, $cascade = false ) {@inheritDoc}
getVarcharMaxLength ( ) {@inheritDoc}
hasNativeGuidType ( ) {@inheritDoc}
prefersSequences ( ) {@inheritDoc}
quoteStringLiteral ( $str )
setUseBooleanTrueFalseStrings ( boolean $flag ) PostgreSQL has different behavior with some drivers with regard to how booleans have to be handled.
supportsCommentOnStatement ( ) {@inheritDoc}
supportsIdentityColumns ( ) {@inheritDoc}
supportsPartialIndexes ( )
supportsSchemas ( ) {@inheritDoc}
supportsSequences ( ) {@inheritDoc}
usesSequenceEmulatedIdentityColumns ( )

Защищенные методы

Метод Описание
_getCommonIntegerTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
_getCreateTableSQL ( $tableName, array $columns, array $options = [] ) {@inheritDoc}
getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )
getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )
getRenameIndexSQL ( $oldIndexName, Doctrine\DBAL\Schema\Index $index, $tableName )
getReservedKeywordsClass ( ) {@inheritDoc}
getVarcharTypeDeclarationSQLSnippet ( $length, $fixed ) {@inheritDoc}
initializeDoctrineTypeMappings ( ) {@inheritDoc}

Приватные методы

Метод Описание
convertSingleBooleanValue ( mixed $value, callable $callback ) : mixed Converts a single boolean value.
doConvertBooleans ( mixed $item, callable $callback ) : mixed Converts one or multiple boolean values.
getSequenceCacheSQL ( Doctrine\DBAL\Schema\Sequence $sequence ) : string Cache definition for sequences
getTableWhereClause ( string $table, string $classAlias = 'c', string $namespaceAlias = 'n' ) : string
isUnchangedBinaryColumn ( Doctrine\DBAL\Schema\ColumnDiff $columnDiff ) : boolean Checks whether a given column diff is a logically unchanged binary type column.

Описание методов

_getCommonIntegerTypeDeclarationSQL() защищенный Метод

{@inheritDoc}
protected _getCommonIntegerTypeDeclarationSQL ( array $columnDef )
$columnDef array

_getCreateTableSQL() защищенный Метод

{@inheritDoc}
protected _getCreateTableSQL ( $tableName, array $columns, array $options = [] )
$columns array
$options array

convertBooleans() публичный Метод

Postgres wants boolean values converted to the strings 'true'/'false'.
public convertBooleans ( $item )

convertBooleansToDatabaseValue() публичный Метод

{@inheritDoc}

convertFromBoolean() публичный Метод

{@inheritDoc}
public convertFromBoolean ( $item )

getAdvancedForeignKeyOptionsSQL() публичный Метод

{@inheritDoc}
public getAdvancedForeignKeyOptionsSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )
$foreignKey Doctrine\DBAL\Schema\ForeignKeyConstraint

getAlterSequenceSQL() публичный Метод

{@inheritDoc}
public getAlterSequenceSQL ( Doctrine\DBAL\Schema\Sequence $sequence )
$sequence Doctrine\DBAL\Schema\Sequence

getAlterTableSQL() публичный Метод

{@inheritDoc}
public getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff )
$diff Doctrine\DBAL\Schema\TableDiff

getBigIntTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getBigIntTypeDeclarationSQL ( array $field )
$field array

getBinaryDefaultLength() публичный Метод

getBinaryMaxLength() публичный Метод

public getBinaryMaxLength ( )

getBinaryTypeDeclarationSQLSnippet() защищенный Метод

protected getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )

getBlobTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getBlobTypeDeclarationSQL ( array $field )
$field array

getBooleanTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getBooleanTypeDeclarationSQL ( array $field )
$field array

getClobTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getClobTypeDeclarationSQL ( array $field )
$field array

getCloseActiveDatabaseConnectionsSQL() публичный Метод

This is useful to force DROP DATABASE operations which could fail because of active connections.
public getCloseActiveDatabaseConnectionsSQL ( string $database ) : string
$database string The name of the database to close currently active connections for.
Результат string

getCommentOnColumnSQL() публичный Метод

public getCommentOnColumnSQL ( $tableName, $columnName, $comment )

getCreateDatabaseSQL() публичный Метод

{@inheritDoc}
public getCreateDatabaseSQL ( $name )

getCreateSchemaSQL() публичный Метод

{@inheritDoc}
public getCreateSchemaSQL ( $schemaName )

getCreateSequenceSQL() публичный Метод

{@inheritDoc}
public getCreateSequenceSQL ( Doctrine\DBAL\Schema\Sequence $sequence )
$sequence Doctrine\DBAL\Schema\Sequence

getCreateViewSQL() публичный Метод

{@inheritDoc}
public getCreateViewSQL ( $name, $sql )

getDateArithmeticIntervalExpression() защищенный Метод

protected getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )

getDateDiffExpression() публичный Метод

{@inheritDoc}
public getDateDiffExpression ( $date1, $date2 )

getDateTimeTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration array

getDateTimeTzFormatString() публичный Метод

{@inheritDoc}

getDateTimeTzTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getDateTimeTzTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration array

getDateTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getDateTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration array

getDefaultSchemaName() публичный Метод

getDisallowDatabaseConnectionsSQL() публичный Метод

This is useful to force DROP DATABASE operations which could fail because of active connections.
public getDisallowDatabaseConnectionsSQL ( string $database ) : string
$database string The name of the database to disallow new connections for.
Результат string

getDropForeignKeySQL() публичный Метод

{@inheritDoc}
public getDropForeignKeySQL ( $foreignKey, $table )

getDropSequenceSQL() публичный Метод

{@inheritDoc}
public getDropSequenceSQL ( $sequence )

getDropViewSQL() публичный Метод

{@inheritDoc}
public getDropViewSQL ( $name )

getEmptyIdentityInsertSQL() публичный Метод

{@inheritDoc}
public getEmptyIdentityInsertSQL ( $quotedTableName, $quotedIdentifierColumnName )

getGuidExpression() публичный Метод

{@inheritDoc}
public getGuidExpression ( )

getGuidTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getGuidTypeDeclarationSQL ( array $field )
$field array

getIdentitySequenceName() публичный Метод

public getIdentitySequenceName ( $tableName, $columnName )

getIntegerTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getIntegerTypeDeclarationSQL ( array $field )
$field array

getListDatabasesSQL() публичный Метод

{@inheritDoc}
public getListDatabasesSQL ( )

getListNamespacesSQL() публичный Метод

{@inheritDoc}

getListSequencesSQL() публичный Метод

{@inheritDoc}
public getListSequencesSQL ( $database )

getListTableColumnsSQL() публичный Метод

{@inheritDoc}
public getListTableColumnsSQL ( $table, $database = null )

getListTableConstraintsSQL() публичный Метод

{@inheritDoc}
public getListTableConstraintsSQL ( $table )

getListTableForeignKeysSQL() публичный Метод

{@inheritDoc}
public getListTableForeignKeysSQL ( $table, $database = null )

getListTableIndexesSQL() публичный Метод

{@inheritDoc}
public getListTableIndexesSQL ( $table, $currentDatabase = null )

getListTablesSQL() публичный Метод

{@inheritDoc}
public getListTablesSQL ( )

getListViewsSQL() публичный Метод

{@inheritDoc}
public getListViewsSQL ( $database )

getLocateExpression() публичный Метод

{@inheritDoc}
public getLocateExpression ( $str, $substr, $startPos = false )

getName() публичный Метод

{@inheritDoc}
public getName ( )

getNowExpression() публичный Метод

{@inheritDoc}
public getNowExpression ( )

getReadLockSQL() публичный Метод

{@inheritDoc}
public getReadLockSQL ( )

getRegexpExpression() публичный Метод

{@inheritDoc}
public getRegexpExpression ( )

getRenameIndexSQL() защищенный Метод

protected getRenameIndexSQL ( $oldIndexName, Doctrine\DBAL\Schema\Index $index, $tableName )
$index Doctrine\DBAL\Schema\Index

getReservedKeywordsClass() защищенный Метод

{@inheritDoc}
protected getReservedKeywordsClass ( )

getSQLResultCasing() публичный Метод

PostgreSQL returns all column names in SQL result sets in lowercase.
public getSQLResultCasing ( $column )

getSequenceNextValSQL() публичный Метод

{@inheritDoc}
public getSequenceNextValSQL ( $sequenceName )

getSetTransactionIsolationSQL() публичный Метод

{@inheritDoc}
public getSetTransactionIsolationSQL ( $level )

getSmallIntTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getSmallIntTypeDeclarationSQL ( array $field )
$field array

getSubstringExpression() публичный Метод

{@inheritDoc}
public getSubstringExpression ( $value, $from, $length = null )

getTimeTypeDeclarationSQL() публичный Метод

{@inheritDoc}
public getTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration array

getTruncateTableSQL() публичный Метод

{@inheritDoc}
public getTruncateTableSQL ( $tableName, $cascade = false )

getVarcharMaxLength() публичный Метод

{@inheritDoc}
public getVarcharMaxLength ( )

getVarcharTypeDeclarationSQLSnippet() защищенный Метод

{@inheritDoc}
protected getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )

hasNativeGuidType() публичный Метод

{@inheritDoc}
public hasNativeGuidType ( )

initializeDoctrineTypeMappings() защищенный Метод

{@inheritDoc}

prefersSequences() публичный Метод

{@inheritDoc}
public prefersSequences ( )

quoteStringLiteral() публичный Метод

public quoteStringLiteral ( $str )

setUseBooleanTrueFalseStrings() публичный Метод

Enables use of 'true'/'false' or otherwise 1 and 0 instead.

supportsCommentOnStatement() публичный Метод

{@inheritDoc}

supportsIdentityColumns() публичный Метод

{@inheritDoc}

supportsPartialIndexes() публичный Метод

supportsSchemas() публичный Метод

{@inheritDoc}
public supportsSchemas ( )

supportsSequences() публичный Метод

{@inheritDoc}
public supportsSequences ( )

usesSequenceEmulatedIdentityColumns() публичный Метод