PHPBoost Framework A.P.I.

PostgreSqlPlatform

Package: Doctrine\DBAL\Plateform License: LGPL 2.1 Author: Roman BORSCHEL roman@code-factory.org Author: Lukas Smith smith@pooteeweet.org (PEAR MDB2 library) Version: PHPBoost 5.2 - last update: 2016 10 28 Since: PHPBoost 4.0 - 2013 01 01 Link: https://www.doctrine-project.org Contributor: Julien BRISWALTER j1.seth@phpboost.com Located at: io/db/dbms/Doctrine/DBAL/Platform/PostgreSqlPlatform.php

PostgreSqlPlatform.

AbstractPlatform

PostgreSqlPlatform

Methods summary
`public`	# `__construct( )` Constructor. Creates a new PostgreSqlPlatform. Constructor. Creates a new PostgreSqlPlatform. Overrides `AbstractPlatform::__construct()`
`public string`	# `getMd5Expression( $column )` Returns the md5 sum of a field. Returns the md5 sum of a field. Note: Not SQL92, but common functionality md5() works with the default PostgreSQL 8 versions. If you are using PostgreSQL 7.x or older you need to make sure that the digest procedure is installed. If you use RPMS (Redhat and Mandrake) install the postgresql-contrib package. You must then install the procedure by running this shell command: psql [dbname] < /usr/share/pgsql/contrib/pgcrypto.sql You should make sure you run this as the postgres user. Returns string Override Overrides `AbstractPlatform::getMd5Expression()`
`public string`	# `getSubstringExpression( string $value, integer $from, integer $len = null )` Returns part of a string. Returns part of a string. Note: Not SQL92, but common functionality. Parameters `$value` the target $value the string or the string column. `$from` extract from this characeter. `$len` extract this amount of characters. Returns string sql that extracts part of a string. Override Overrides `AbstractPlatform::getSubstringExpression()`
`public string`	# `getAgeExpression( string $timestamp1, string $timestamp2 = null )` PostgreSQLs AGE( [, ]) function. PostgreSQLs AGE( [, ]) function. Parameters `$timestamp1` timestamp to subtract from NOW() `$timestamp2` optional; if given: subtract arguments Returns string
`public string`	# `getDatePartExpression( string $text, string $time )` PostgreSQLs DATE_PART( , ) function. PostgreSQLs DATE_PART( , ) function. Parameters `$text` what to extract `$time` timestamp or interval to extract from Returns string
`public string`	# `getToCharExpression( string $time, string $text )` PostgreSQLs TO_CHAR( , ) function. PostgreSQLs TO_CHAR( , ) function. Parameters `$time` timestamp or interval `$text` how to the format the output Returns string
`public string`	# `getNowExpression( )` Returns the SQL string to return the current system date and time. Returns the SQL string to return the current system date and time. Returns string Overrides `AbstractPlatform::getNowExpression()`
`public string`	# `getRegexpExpression( )` regexp regexp Returns string the regular expression operator Override Overrides `AbstractPlatform::getRegexpExpression()`
`public return`	# `getRandomExpression( )` return string to call a function to get random value inside an SQL statement return string to call a function to get random value inside an SQL statement Returns return string to generate float between 0 and 1 Override
`public string`	# `getMatchPatternExpression( array $pattern, string $operator = null, string $field = null )` build a pattern matching string build a pattern matching string EXPERIMENTAL WARNING: this function is experimental and may change signature at any time until labelled as non-experimental Parameters `$pattern` even keys are strings, odd are patterns (% and _) `$operator` optional pattern operator (LIKE, ILIKE and maybe others in the future) `$field` optional field name that is being matched against (might be required when emulating ILIKE) Returns string SQL pattern Override Overrides `AbstractPlatform::getMatchPatternExpression()`
`public boolean`	# `supportsSequences( )` Whether the platform supports sequences. Postgres has native support for sequences. Whether the platform supports sequences. Postgres has native support for sequences. Returns boolean Overrides `AbstractPlatform::supportsSequences()`
`public boolean`	# `supportsSchemas( )` Whether the platform supports database schemas. Whether the platform supports database schemas. Returns boolean Overrides `AbstractPlatform::supportsSchemas()`
`public boolean`	# `supportsIdentityColumns( )` Whether the platform supports identity columns. Postgres supports these through the SERIAL keyword. Whether the platform supports identity columns. Postgres supports these through the SERIAL keyword. Returns boolean Overrides `AbstractPlatform::supportsIdentityColumns()`
`public boolean`	# `prefersSequences( )` Whether the platform prefers sequences for ID generation. Whether the platform prefers sequences for ID generation. Returns boolean Overrides `AbstractPlatform::prefersSequences()`
`public`	# `getListDatabasesSql( )` Overrides `AbstractPlatform::getListDatabasesSql()`
`public`	# `getListFunctionsSql( )` Overrides `AbstractPlatform::getListFunctionsSql()`
`public`	# `getListSequencesSql( $database )` Overrides `AbstractPlatform::getListSequencesSql()`
`public`	# `getListTablesSql( )` Overrides `AbstractPlatform::getListTablesSql()`
`public`	# `getListViewsSql( )` Overrides `AbstractPlatform::getListViewsSql()`
`public`	# `getListTriggersSql( $table = null )` Overrides `AbstractPlatform::getListTriggersSql()`
`public`	# `getListUsersSql( )` Overrides `AbstractPlatform::getListUsersSql()`
`public`	# `getListTableForeignKeysSql( $table, $database = null )` Overrides `AbstractPlatform::getListTableForeignKeysSql()`
`public`	# `getCreateViewSql( $name, $sql )` Overrides `AbstractPlatform::getCreateViewSql()`
`public`	# `getDropViewSql( $name )` Overrides `AbstractPlatform::getDropViewSql()`
`public`	# `getListTableConstraintsSql( $table )` Overrides `AbstractPlatform::getListTableConstraintsSql()`
`public`	# `getListTableIndexesSql( $table )` Overrides `AbstractPlatform::getListTableIndexesSql()`
`public`	# `getListTableColumnsSql( $table )` Overrides `AbstractPlatform::getListTableColumnsSql()`
`public`	# `getCreateDatabaseSql( string $name )` create a new database create a new database Parameters `$name` name of the database that should be created Throws PDOException Override Overrides `AbstractPlatform::getCreateDatabaseSql()`
`public`	# `getDropDatabaseSql( string $name )` drop an existing database drop an existing database Parameters `$name` name of the database that should be dropped Throws PDOException Overrides `AbstractPlatform::getDropDatabaseSql()`
`public string`	# `getAdvancedForeignKeyOptionsSql( array $definition )` getAdvancedForeignKeyOptions Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ... getAdvancedForeignKeyOptions Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ... Parameters `$definition` foreign key definition Returns string Override Overrides `AbstractPlatform::getAdvancedForeignKeyOptionsSql()`
`public array`	# `getAlterTableSql( string $name, array $changes, boolean $check = false )` generates the sql for altering an existing table on postgresql generates the sql for altering an existing table on postgresql Parameters `$name` name of the table that is intended to be changed. `$changes` associative array that contains the details of each type * `$check` indicates whether the function should just check if the DBMS driver can perform the requested table alterations if the value is true or actually perform them otherwise. Returns array See Doctrine_Export::alterTable() Override Overrides `AbstractPlatform::getAlterTableSql()`
`public string`	# `getCreateSequenceSql( string $sequenceName, integer $start = 1, integer $allocationSize = 1 )` Gets the SQL to create a sequence on this platform. Gets the SQL to create a sequence on this platform. Parameters `$sequenceName` `$start` `$allocationSize` Returns string Throws `DoctrineException` Override Overrides `AbstractPlatform::getCreateSequenceSql()`
`public`	# `getDropSequenceSql( string $sequenceName )` drop existing sequence drop existing sequence Parameters `$sequenceName` name of the sequence to be dropped Override Overrides `AbstractPlatform::getDropSequenceSql()`
`public unknown`	# `getCreateTableSql( unknown_type $name, array $fields, array $options = array() )` Gets the SQL used to create a table. Gets the SQL used to create a table. Parameters `$name` `$fields` `$options` Returns unknown Overrides `AbstractPlatform::getCreateTableSql()`
`public`	# `convertBooleans( array $item )` Postgres wants boolean values converted to the strings 'true'/'false'. Postgres wants boolean values converted to the strings 'true'/'false'. Parameters `$item` Override Overrides `AbstractPlatform::convertBooleans()`
`public`	# `getSequenceNextValSql( $sequenceName )` Overrides `AbstractPlatform::getSequenceNextValSql()`
`public`	# `getSetTransactionIsolationSql( integer $level )` Get sql to set the transaction isolation level Get sql to set the transaction isolation level Parameters `$level` Overrides `AbstractPlatform::getSetTransactionIsolationSql()`
`public string`	# `getBooleanTypeDeclarationSql( array $field )` Parameters `$field` $columnDef Returns string Override
`public string`	# `getIntegerTypeDeclarationSql( array $field )` Parameters `$field` $columnDef Returns string Override
`public string`	# `getDefaultValueDeclarationSql( array $field )` Parameters `$field` field definition array Returns string DBMS specific SQL code portion needed to set a default value Override Overrides `AbstractPlatform::getDefaultValueDeclarationSql()`
`public string`	# `getBigIntTypeDeclarationSql( array $field )` Parameters `$field` $columnDef Returns string Override
`public string`	# `getSmallIntTypeDeclarationSql( array $field )` Parameters `$field` $columnDef Returns string Override
`public string`	# `getDateTimeTypeDeclarationSql( array $fieldDeclaration )` Parameters `$fieldDeclaration` Returns string Override Overrides `AbstractPlatform::getDateTimeTypeDeclarationSql()`
`public string`	# `getDateTypeDeclarationSql( array $fieldDeclaration )` Parameters `$fieldDeclaration` Returns string Override Overrides `AbstractPlatform::getDateTypeDeclarationSql()`
`protected string`	# `_getCommonIntegerTypeDeclarationSql( array $columnDef )` Parameters `$columnDef` Returns string Override
`public`	# `getVarcharTypeDeclarationSql( array $field )` Gets the SQL snippet used to declare a VARCHAR column on the MySql platform. Gets the SQL snippet used to declare a VARCHAR column on the MySql platform. Parameters `$field` Override Params array $field
`public`	# `getClobTypeDeclarationSql( array $field )` Parameters `$field` Override
`public string`	# `getName( )` Get the platform name for this instance Get the platform name for this instance Returns string
`public string`	# `getSqlResultCasing( string $column )` Gets the character casing of a column in an SQL result set. Gets the character casing of a column in an SQL result set. PostgreSQL returns all column names in SQL result sets in lowercase. Parameters `$column` The column name for which to get the correct character casing. Returns string The column name in the character casing used in SQL result sets. Overrides `AbstractPlatform::getSqlResultCasing()`
`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. Gets the format string, as accepted by the date() function, that describes the format of a stored datetime value of this platform. Returns string The format string. Overrides `AbstractPlatform::getDateTimeFormatString()`
`public string`	# `getEmptyIdentityInsertSql( string $quotedTableName, string $quotedIdentifierColumnName )` Get the insert sql for an empty insert statement Get the insert sql for an empty insert statement Parameters `$quotedTableName` $tableName `$quotedIdentifierColumnName` $identifierColumnName Returns string $sql Overrides `AbstractPlatform::getEmptyIdentityInsertSql()`

Methods inherited from AbstractPlatform
_getTransactionIsolationLevelSql(), fixSchemaElementName(), getAcosExpression(), getAvgExpression(), getBetweenExpression(), getCharsetFieldDeclaration(), getCheckDeclarationSql(), getColumnCharsetDeclarationSql(), getColumnCollationDeclarationSql(), getColumnDeclarationListSql(), getColumnDeclarationSql(), getConcatExpression(), getCosExpression(), getCountExpression(), getCreateConstraintSql(), getCreateForeignKeySql(), getCreateIndexSql(), getCreateTemporaryTableSnippetSql(), getCurrentDateSql(), getCurrentTimeSql(), getCurrentTimestampSql(), getDateFormatString(), getDecimalTypeDeclarationSql(), getDefaultTransactionIsolationLevel(), getDropConstraintSql(), getDropForeignKeySql(), getDropIndexSql(), getDropTableSql(), getFloatTypeDeclarationSql(), getForUpdateSql(), getForeignKeyBaseDeclarationSql(), getForeignKeyDeclarationSql(), getForeignKeyReferentialActionSql(), getIdentifierQuoteCharacter(), getIdentityColumnNullInsertSql(), getInExpression(), getIndexDeclarationSql(), getIndexFieldDeclarationListSql(), getIsNotNullExpression(), getIsNullExpression(), getLengthExpression(), getLocateExpression(), getLowerExpression(), getLtrimExpression(), getMaxExpression(), getMinExpression(), getModExpression(), getNotExpression(), getPiExpression(), getRoundExpression(), getRtrimExpression(), getSetCharsetSql(), getShowDatabasesSql(), getSinExpression(), getSqlCommentEndString(), getSqlCommentStartString(), getSumExpression(), getTemporaryTableSql(), getTimeFormatString(), getTrimExpression(), getUniqueFieldDeclarationSql(), getUpperExpression(), getVarcharMaxLength(), getWildcards(), modifyLimitQuery(), prefersIdentityColumns(), quoteIdentifier(), supportsForeignKeyConstraints(), supportsGettingAffectedRows(), supportsIndexes(), supportsPrimaryConstraints(), supportsSavepoints(), supportsTransactions(), writeLimitClause()

Overrides

Returns

Override

Overrides

Parameters

Returns

Override

Overrides

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Overrides

Returns

Override

Overrides

Returns

Override

Parameters

Returns

Override

Overrides

Returns

Overrides

Returns

Overrides

Returns

Overrides

Returns

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Parameters

Throws

Override

Overrides

Parameters

Throws

Overrides

Parameters

Returns

Override

Overrides

Parameters

Returns

See

Override

Overrides

Parameters

Returns

Throws

Override

Overrides

Parameters

Override

Overrides

Parameters

Returns

Overrides

Parameters

Override

Overrides

Overrides

Parameters

Overrides

Parameters