Doctrine\DBAL\Platforms\PostgreSqlPlatform
PostgreSqlPlatform.
- Author: Roman Borschel <roman@code-factory.org>
Synopsis
class PostgreSqlPlatform
extends AbstractPlatform
{
- // Inherited constants from AbstractPlatform
- const CREATE_INDEXES = 1;
- const CREATE_FOREIGNKEYS = 2;
- const TRIM_UNSPECIFIED = 0;
- const TRIM_LEADING = 1;
- const TRIM_TRAILING = 2;
- const TRIM_BOTH = 3;
- // Inherited members from AbstractPlatform
- protected array $doctrineTypeMapping;
- protected array $doctrineTypeComments;
- protected EventManager $_eventManager;
- protected KeywordList $_keywords;
- // methods
- public void getSubstringExpression()
- public void getNowExpression()
- public void getRegexpExpression()
- public void getLocateExpression()
- public void getDateDiffExpression()
- public void getDateAddDaysExpression()
- public void getDateSubDaysExpression()
- public void getDateAddMonthExpression()
- public void getDateSubMonthExpression()
- public void supportsSequences()
- public void supportsSchemas()
- public void supportsIdentityColumns()
- public void supportsCommentOnStatement()
- public void prefersSequences()
- public void getListDatabasesSQL()
- public void getListSequencesSQL()
- public void getListTablesSQL()
- public void getListViewsSQL()
- public void getListTableForeignKeysSQL()
- public void getCreateViewSQL()
- public void getDropViewSQL()
- public void getListTableConstraintsSQL()
- public void getListTableIndexesSQL()
- private string getTableWhereClause()
- public void getListTableColumnsSQL()
- public void getCreateDatabaseSQL()
- public void getAdvancedForeignKeyOptionsSQL()
- public void getAlterTableSQL()
- public void getCreateSequenceSQL()
- public void getAlterSequenceSQL()
- public void getDropSequenceSQL()
- public void getDropForeignKeySQL()
- protected void _getCreateTableSQL()
- public void convertBooleans()
- public void getSequenceNextValSQL()
- public void getSetTransactionIsolationSQL()
- public void getBooleanTypeDeclarationSQL()
- public void getIntegerTypeDeclarationSQL()
- public void getBigIntTypeDeclarationSQL()
- public void getSmallIntTypeDeclarationSQL()
- public void getGuidTypeDeclarationSQL()
- public void getDateTimeTypeDeclarationSQL()
- public void getDateTimeTzTypeDeclarationSQL()
- public void getDateTypeDeclarationSQL()
- public void getTimeTypeDeclarationSQL()
- protected void _getCommonIntegerTypeDeclarationSQL()
- protected void getVarcharTypeDeclarationSQLSnippet()
- public void getClobTypeDeclarationSQL()
- public void getName()
- public void getSQLResultCasing()
- public void getDateTimeTzFormatString()
- public void getEmptyIdentityInsertSQL()
- public void getTruncateTableSQL()
- public void getReadLockSQL()
- protected void initializeDoctrineTypeMappings()
- public void getVarcharMaxLength()
- protected void getReservedKeywordsClass()
- public void getBlobTypeDeclarationSQL()
- // Inherited methods from AbstractPlatform
- public void __construct()
- public void setEventManager()
- public EventManager getEventManager()
- public abstract string getBooleanTypeDeclarationSQL()
- public abstract string getIntegerTypeDeclarationSQL()
- public abstract string getBigIntTypeDeclarationSQL()
- public abstract string getSmallIntTypeDeclarationSQL()
- protected abstract string _getCommonIntegerTypeDeclarationSQL()
- protected abstract void initializeDoctrineTypeMappings()
- public string getVarcharTypeDeclarationSQL()
- public string getGuidTypeDeclarationSQL()
- protected string getVarcharTypeDeclarationSQLSnippet()
- public abstract string getClobTypeDeclarationSQL()
- public abstract string getBlobTypeDeclarationSQL()
- public abstract string getName()
- public void registerDoctrineTypeMapping()
- public string getDoctrineTypeMapping()
- public boolean hasDoctrineTypeMappingFor()
- protected void initializeCommentedDoctrineTypes()
- public boolean isCommentedDoctrineType()
- public void markDoctrineTypeCommented()
- public string getDoctrineTypeComment()
- protected string getColumnComment()
- public string getIdentifierQuoteCharacter()
- public string getSqlCommentStartString()
- public string getSqlCommentEndString()
- public integer getVarcharMaxLength()
- public integer getVarcharDefaultLength()
- public array getWildcards()
- public string getRegexpExpression()
- public string getGuidExpression()
- public string getAvgExpression()
- public string getCountExpression()
- public string getMaxExpression()
- public string getMinExpression()
- public string getSumExpression()
- public string getMd5Expression()
- public string getLengthExpression()
- public string getSqrtExpression()
- public string getRoundExpression()
- public string getModExpression()
- public string getTrimExpression()
- public string getRtrimExpression()
- public string getLtrimExpression()
- public string getUpperExpression()
- public string getLowerExpression()
- public string getLocateExpression()
- public string getNowExpression()
- public string getSubstringExpression()
- public string getConcatExpression()
- public string getNotExpression()
- public string getInExpression()
- public string getIsNullExpression()
- public string getIsNotNullExpression()
- public string getBetweenExpression()
- public void getAcosExpression()
- public void getSinExpression()
- public void getPiExpression()
- public void getCosExpression()
- public string getDateDiffExpression()
- public string getDateAddDaysExpression()
- public string getDateSubDaysExpression()
- public string getDateAddMonthExpression()
- public string getDateSubMonthExpression()
- public string getBitAndComparisonExpression()
- public string getBitOrComparisonExpression()
- public void getForUpdateSQL()
- public string appendLockHint()
- public string getReadLockSQL()
- public string getWriteLockSQL()
- public string getDropDatabaseSQL()
- public string getDropTableSQL()
- public string getDropTemporaryTableSQL()
- public string getDropIndexSQL()
- public string getDropConstraintSQL()
- public string getDropForeignKeySQL()
- public array getCreateTableSQL()
- public void getCommentOnColumnSQL()
- protected array _getCreateTableSQL()
- public void getCreateTemporaryTableSnippetSQL()
- public string getCreateSequenceSQL()
- public string getAlterSequenceSQL()
- public string getCreateConstraintSQL()
- public string getCreateIndexSQL()
- protected string getCreateIndexSQLFlags()
- public string getCreatePrimaryKeySQL()
- public string quoteIdentifier()
- public string quoteSingleIdentifier()
- public string getCreateForeignKeySQL()
- public array getAlterTableSQL()
- protected boolean onSchemaAlterTableAddColumn()
- protected boolean onSchemaAlterTableRemoveColumn()
- protected boolean onSchemaAlterTableChangeColumn()
- protected boolean onSchemaAlterTableRenameColumn()
- protected boolean onSchemaAlterTable()
- protected void getPreAlterTableIndexForeignKeySQL()
- protected void getPostAlterTableIndexForeignKeySQL()
- protected array _getAlterTableIndexForeignKeySQL()
- public string getColumnDeclarationListSQL()
- public string getColumnDeclarationSQL()
- public string getDecimalTypeDeclarationSQL()
- public string getDefaultValueDeclarationSQL()
- public string getCheckDeclarationSQL()
- public string getUniqueConstraintDeclarationSQL()
- public string getIndexDeclarationSQL()
- public string getCustomTypeDeclarationSQL()
- public string getIndexFieldDeclarationListSQL()
- public string getTemporaryTableSQL()
- public string getTemporaryTableName()
- public string getShowDatabasesSQL()
- public string getForeignKeyDeclarationSQL()
- public string getAdvancedForeignKeyOptionsSQL()
- public string getForeignKeyReferentialActionSQL()
- public string getForeignKeyBaseDeclarationSQL()
- public string getUniqueFieldDeclarationSQL()
- public string getColumnCharsetDeclarationSQL()
- public string getColumnCollationDeclarationSQL()
- public boolean prefersSequences()
- public boolean prefersIdentityColumns()
- public mixed convertBooleans()
- public string getCurrentDateSQL()
- public string getCurrentTimeSQL()
- public string getCurrentTimestampSQL()
- protected string _getTransactionIsolationLevelSQL()
- public void getListDatabasesSQL()
- public void getListSequencesSQL()
- public void getListTableConstraintsSQL()
- public void getListTableColumnsSQL()
- public void getListTablesSQL()
- public void getListUsersSQL()
- public string getListViewsSQL()
- public string getListTableIndexesSQL()
- public void getListTableForeignKeysSQL()
- public void getCreateViewSQL()
- public void getDropViewSQL()
- public string getDropSequenceSQL()
- public void getSequenceNextValSQL()
- public string getCreateDatabaseSQL()
- public string getSetTransactionIsolationSQL()
- public string getDateTimeTypeDeclarationSQL()
- public string getDateTimeTzTypeDeclarationSQL()
- public string getDateTypeDeclarationSQL()
- public string getTimeTypeDeclarationSQL()
- public void getFloatDeclarationSQL()
- public integer getDefaultTransactionIsolationLevel()
- public boolean supportsSequences()
- public boolean supportsIdentityColumns()
- public boolean supportsIndexes()
- public boolean supportsAlterTable()
- public boolean supportsTransactions()
- public boolean supportsSavepoints()
- public boolean supportsReleaseSavepoints()
- public boolean supportsPrimaryConstraints()
- public boolean supportsForeignKeyConstraints()
- public boolean supportsForeignKeyOnUpdate()
- public boolean supportsSchemas()
- public boolean canEmulateSchemas()
- public boolean supportsCreateDropDatabase()
- public boolean supportsGettingAffectedRows()
- public boolean supportsInlineColumnComments()
- public boolean supportsCommentOnStatement()
- public void getIdentityColumnNullInsertSQL()
- public boolean supportsViews()
- public string getDateTimeFormatString()
- public string getDateTimeTzFormatString()
- public string getDateFormatString()
- public string getTimeFormatString()
- public final string modifyLimitQuery()
- protected string doModifyLimitQuery()
- public boolean supportsLimitOffset()
- public string getSQLResultCasing()
- public string fixSchemaElementName()
- public integer getMaxIdentifierLength()
- public string getEmptyIdentityInsertSQL()
- public string getTruncateTableSQL()
- public string getDummySelectSQL()
- public string createSavePoint()
- public string releaseSavePoint()
- public string rollbackSavePoint()
- public final KeywordList getReservedKeywordsList()
- protected string getReservedKeywordsClass()
Hierarchy
Tasks
Line | Task |
---|---|
34+ | Rename: PostgreSQLPlatform |
814 | fix this code: the method does not exist |
1202 | what do we do about this? |
Constants
Name | Value |
---|---|
CREATE_INDEXES | 1 |
CREATE_FOREIGNKEYS | 2 |
TRIM_UNSPECIFIED | 0 |
TRIM_LEADING | 1 |
TRIM_TRAILING | 2 |
TRIM_BOTH | 3 |
Members
protected
- $_eventManager — Doctrine\DBAL\Platforms\Doctrine\Common\EventManager
- $_keywords
—
\Doctrine\DBAL\Platforms\Keywords\KeywordList
Holds the KeywordList instance for the current platform. - $doctrineTypeComments
—
array
Contains a list of all columns that should generate parseable column comments for type-detection in reverse engineering scenarios. - $doctrineTypeMapping — array
Methods
private
protected
- _getCommonIntegerTypeDeclarationSQL() — {@inheritDoc}
- _getCreateTableSQL() — {@inheritDoc}
- getReservedKeywordsClass() — {@inheritDoc}
- getVarcharTypeDeclarationSQLSnippet() — {@inheritDoc}
- initializeDoctrineTypeMappings() — {@inheritDoc}
public
- convertBooleans() — {@inheritDoc}
- getAdvancedForeignKeyOptionsSQL() — {@inheritDoc}
- getAlterSequenceSQL() — {@inheritDoc}
- getAlterTableSQL() — {@inheritDoc}
- getBigIntTypeDeclarationSQL() — {@inheritDoc}
- getBlobTypeDeclarationSQL() — {@inheritDoc}
- getBooleanTypeDeclarationSQL() — {@inheritDoc}
- getClobTypeDeclarationSQL() — {@inheritDoc}
- getCreateDatabaseSQL() — {@inheritDoc}
- getCreateSequenceSQL() — {@inheritDoc}
- getCreateViewSQL()
- getDateAddDaysExpression() — {@inheritDoc}
- getDateAddMonthExpression() — {@inheritDoc}
- getDateDiffExpression() — {@inheritDoc}
- getDateSubDaysExpression() — {@inheritDoc}
- getDateSubMonthExpression() — {@inheritDoc}
- getDateTimeTypeDeclarationSQL() — {@inheritDoc}
- getDateTimeTzFormatString() — {@inheritDoc}
- getDateTimeTzTypeDeclarationSQL() — {@inheritDoc}
- getDateTypeDeclarationSQL() — {@inheritDoc}
- getDropForeignKeySQL() — {@inheritDoc}
- getDropSequenceSQL() — {@inheritDoc}
- getDropViewSQL()
- getEmptyIdentityInsertSQL() — {@inheritDoc}
- getGuidTypeDeclarationSQL() — {@inheritDoc}
- getIntegerTypeDeclarationSQL() — {@inheritDoc}
- getListDatabasesSQL()
- getListSequencesSQL()
- getListTableColumnsSQL()
- getListTableConstraintsSQL()
- getListTableForeignKeysSQL()
- getListTableIndexesSQL() — {@inheritDoc}
- getListTablesSQL()
- getListViewsSQL() — {@inheritDoc}
- getLocateExpression() — {@inheritDoc}
- getName() — {@inheritDoc}
- getNowExpression() — {@inheritDoc}
- getReadLockSQL() — {@inheritDoc}
- getRegexpExpression() — {@inheritDoc}
- getSQLResultCasing() — {@inheritDoc}
- getSequenceNextValSQL()
- getSetTransactionIsolationSQL() — {@inheritDoc}
- getSmallIntTypeDeclarationSQL() — {@inheritDoc}
- getSubstringExpression() — {@inheritDoc}
- getTimeTypeDeclarationSQL() — {@inheritDoc}
- getTruncateTableSQL() — {@inheritDoc}
- getVarcharMaxLength() — {@inheritDoc}
- prefersSequences() — {@inheritDoc}
- supportsCommentOnStatement() — {@inheritDoc}
- supportsIdentityColumns() — {@inheritDoc}
- supportsSchemas() — {@inheritDoc}
- supportsSequences() — {@inheritDoc}
Inherited from Doctrine\DBAL\Platforms\AbstractPlatform
protected
- _getAlterTableIndexForeignKeySQL() — Common code for alter table statement generation that updates the changed Index and Foreign Key definitions.
- _getCommonIntegerTypeDeclarationSQL() — Gets the SQL snippet that declares common properties of an integer column.
- _getCreateTableSQL() — Gets the SQL used to create a table.
- _getTransactionIsolationLevelSQL() — Get sql for transaction isolation level Connection constant
- doModifyLimitQuery() — Adds an driver-specific LIMIT clause to the query
- getColumnComment() — Return the comment of a passed column modified by potential doctrine type comment hints.
- getCreateIndexSQLFlags() — Adds additional flags for index generation
- getPostAlterTableIndexForeignKeySQL()
- getPreAlterTableIndexForeignKeySQL()
- getReservedKeywordsClass() — The class name of the reserved keywords list.
- getVarcharTypeDeclarationSQLSnippet()
- initializeCommentedDoctrineTypes() — Initialize the Doctrine Type comments instance variable for in_array() checks.
- initializeDoctrineTypeMappings() — Lazy load Doctrine Type Mappings
- onSchemaAlterTable()
- onSchemaAlterTableAddColumn()
- onSchemaAlterTableChangeColumn()
- onSchemaAlterTableRemoveColumn()
- onSchemaAlterTableRenameColumn()
public
- appendLockHint() — Honors that some SQL vendors such as MsSql use table hints for locking instead of the ANSI SQL FOR UPDATE specification.
- canEmulateSchemas() — Can this platform emulate schemas?
- convertBooleans() — Some platforms need the boolean values to be converted.
- createSavePoint() — Generate SQL to create a new savepoint
- fixSchemaElementName() — Makes any fixes to a name of a schema element (table, sequence, ...) that are required by restrictions of the platform, like a maximum length.
- getAcosExpression()
- getAdvancedForeignKeyOptionsSQL() — Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ...
- getAlterSequenceSQL() — Gets the SQL statement to change a sequence on this platform.
- getAlterTableSQL() — Gets the sql statements for altering an existing table.
- getAvgExpression() — Returns the average value of a column
- getBetweenExpression() — Returns SQL that checks if an expression evaluates to a value between two values.
- getBigIntTypeDeclarationSQL() — Gets the SQL snippet that declares an 8 byte integer column.
- getBitAndComparisonExpression() — Gets SQL bit AND comparison expression
- getBitOrComparisonExpression() — Gets SQL bit OR comparison expression
- getBlobTypeDeclarationSQL() — Gets the SQL Snippet used to declare a BLOB column type.
- getBooleanTypeDeclarationSQL() — Gets the SQL snippet that declares a boolean column.
- getCheckDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set a CHECK constraint declaration to be used in statements like CREATE TABLE.
- getClobTypeDeclarationSQL() — Gets the SQL snippet used to declare a CLOB column type.
- getColumnCharsetDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set the CHARACTER SET of a field declaration to be used in statements like CREATE TABLE.
- getColumnCollationDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set the COLLATION of a field declaration to be used in statements like CREATE TABLE.
- getColumnDeclarationListSQL() — Get declaration of a number of fields in bulk
- getColumnDeclarationSQL() — Obtain DBMS specific SQL code portion needed to declare a generic type field to be used in statements like CREATE TABLE.
- getCommentOnColumnSQL()
- getConcatExpression() — Returns a series of strings concatinated
- getCosExpression()
- getCountExpression() — Returns the number of rows (without a NULL value) of a column
- getCreateConstraintSQL() — Gets the SQL to create a constraint on a table on this platform.
- getCreateDatabaseSQL() — create a new database
- getCreateForeignKeySQL() — Create a new foreign key
- getCreateIndexSQL() — Gets the SQL to create an index on a table on this platform.
- getCreatePrimaryKeySQL() — Get SQL to create an unnamed primary key constraint.
- getCreateSequenceSQL() — Gets the SQL to create a sequence on this platform.
- getCreateTableSQL() — Gets the SQL statement(s) to create a table with the specified name, columns and constraints on this platform.
- getCreateTemporaryTableSnippetSQL()
- getCreateViewSQL()
- getCurrentDateSQL() — Gets the SQL specific for the platform to get the current date.
- getCurrentTimeSQL() — Gets the SQL specific for the platform to get the current time.
- getCurrentTimestampSQL() — Gets the SQL specific for the platform to get the current timestamp
- getCustomTypeDeclarationSQL() — getCustomTypeDeclarationSql Obtail SQL code portion needed to create a custom column, e.g. when a field has the "columnDefinition" keyword.
- getDateAddDaysExpression() — Add the number of given days to a date.
- getDateAddMonthExpression() — Add the number of given months to a date.
- getDateDiffExpression() — Calculate the difference in days between the two passed dates.
- getDateFormatString() — Gets the format string, as accepted by the date() function, that describes the format of a stored date value of this platform.
- getDateSubDaysExpression() — Substract the number of given days to a date.
- getDateSubMonthExpression() — Substract the number of given months to a date.
- getDateTimeFormatString() — Gets the format string, as accepted by the date() function, that describes the format of a stored datetime value of this platform.
- getDateTimeTypeDeclarationSQL() — Obtain DBMS specific SQL to be used to create datetime fields in statements like CREATE TABLE
- getDateTimeTzFormatString() — Gets the format string, as accepted by the date() function, that describes the format of a stored datetime with timezone value of this platform.
- getDateTimeTzTypeDeclarationSQL() — Obtain DBMS specific SQL to be used to create datetime with timezone offset fields.
- getDateTypeDeclarationSQL() — Obtain DBMS specific SQL to be used to create date fields in statements like CREATE TABLE.
- getDecimalTypeDeclarationSQL() — Gets the SQL snippet that declares a floating point column of arbitrary precision.
- getDefaultTransactionIsolationLevel() — Gets the default transaction isolation level of the platform.
- getDefaultValueDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set a default value declaration to be used in statements like CREATE TABLE.
- getDoctrineTypeComment() — Get the comment to append to a column comment that helps parsing this type in reverse engineering.
- getDoctrineTypeMapping() — Get the Doctrine type that is mapped for the given database column type.
- getDropConstraintSQL() — Get drop constraint sql
- getDropDatabaseSQL() — Get the SQL snippet to drop an existing database
- getDropForeignKeySQL()
- getDropIndexSQL() — Drop index from a table
- getDropSequenceSQL() — Get the SQL snippet to drop an existing sequence
- getDropTableSQL() — Drop a Table
- getDropTemporaryTableSQL() — Get SQL to safely drop a temporary table WITHOUT implicitly committing an open transaction.
- getDropViewSQL()
- getDummySelectSQL() — This is for test reasons, many vendors have special requirements for dummy statements.
- getEmptyIdentityInsertSQL() — Get the insert sql for an empty insert statement
- getEventManager() — Gets the EventManager used by the Platform.
- getFloatDeclarationSQL()
- getForUpdateSQL()
- getForeignKeyBaseDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set the FOREIGN KEY constraint of a field declaration to be used in statements like CREATE TABLE.
- getForeignKeyDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set the FOREIGN KEY constraint of a field declaration to be used in statements like CREATE TABLE.
- getForeignKeyReferentialActionSQL() — returns given referential action in uppercase if valid, otherwise throws an exception
- getGuidExpression() — Returns global unique identifier
- getGuidTypeDeclarationSQL() — Get the SQL Snippet to create a GUID/UUID field.
- getIdentifierQuoteCharacter() — Gets the character used for identifier quoting.
- getIdentityColumnNullInsertSQL()
- getInExpression() — Returns the SQL to check if a value is one in a set of given values.
- getIndexDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set an index declaration to be used in statements like CREATE TABLE.
- getIndexFieldDeclarationListSQL() — getIndexFieldDeclarationList Obtain DBMS specific SQL code portion needed to set an index declaration to be used in statements like CREATE TABLE.
- getIntegerTypeDeclarationSQL() — Gets the SQL snippet that declares a 4 byte integer column.
- getIsNotNullExpression() — Returns SQL that checks if a expression is not null.
- getIsNullExpression() — Returns SQL that checks if a expression is null.
- getLengthExpression() — Returns the length of a text field.
- getListDatabasesSQL()
- getListSequencesSQL()
- getListTableColumnsSQL()
- getListTableConstraintsSQL()
- getListTableForeignKeysSQL()
- getListTableIndexesSQL() — Get the list of indexes for the current database.
- getListTablesSQL()
- getListUsersSQL()
- getListViewsSQL() — Get the SQL to list all views of a database or user.
- getLocateExpression() — returns the position of the first occurrence of substring $substr in string $str
- getLowerExpression() — lower Returns the string $str with all characters changed to lowercase according to the current character set mapping.
- getLtrimExpression() — ltrim returns the string $str with leading space characters removed
- getMaxExpression() — Returns the highest value of a column
- getMaxIdentifierLength() — Maximum length of any given databse identifier, like tables or column names.
- getMd5Expression() — Returns the md5 sum of a field.
- getMinExpression() — Returns the lowest value of a column
- getModExpression() — Returns the remainder of the division operation $expression1 / $expression2.
- getName() — Gets the name of the platform.
- getNotExpression() — Returns the SQL for a logical not.
- getNowExpression() — Returns the current system date.
- getPiExpression()
- getReadLockSQL() — Get the sql snippet to append to any SELECT statement which locks rows in shared read lock.
- getRegexpExpression() — Returns the regular expression operator.
- getReservedKeywordsList() — Return the keyword list instance of this platform.
- getRoundExpression() — Rounds a numeric field to the number of decimals specified.
- getRtrimExpression() — rtrim returns the string $str with proceeding space characters removed
- getSQLResultCasing() — Gets the character casing of a column in an SQL result set of this platform.
- getSequenceNextValSQL()
- getSetTransactionIsolationSQL() — Get sql to set the transaction isolation level
- getShowDatabasesSQL() — Get sql query to show a list of database.
- getSinExpression()
- getSmallIntTypeDeclarationSQL() — Gets the SQL snippet that declares a 2 byte integer column.
- getSqlCommentEndString() — Gets the string portion that ends an SQL comment.
- getSqlCommentStartString() — Gets the string portion that starts an SQL comment.
- getSqrtExpression() — Returns the squared value of a column
- getSubstringExpression() — return string to call a function to get a substring inside an SQL statement
- getSumExpression() — Returns the total sum of a column
- getTemporaryTableName() — Some vendors require temporary table names to be qualified specially.
- getTemporaryTableSQL() — A method to return the required SQL string that fits between CREATE ... TABLE to create the table as a temporary table.
- getTimeFormatString() — Gets the format string, as accepted by the date() function, that describes the format of a stored time value of this platform.
- getTimeTypeDeclarationSQL() — Obtain DBMS specific SQL to be used to create time fields in statements like CREATE TABLE.
- getTrimExpression() — Trim a string, leading/trailing/both and with a given char which defaults to space.
- getTruncateTableSQL() — Generate a Truncate Table SQL statement for a given table.
- getUniqueConstraintDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set a unique constraint declaration to be used in statements like CREATE TABLE.
- getUniqueFieldDeclarationSQL() — Obtain DBMS specific SQL code portion needed to set the UNIQUE constraint of a field declaration to be used in statements like CREATE TABLE.
- getUpperExpression() — upper Returns the string $str with all characters changed to uppercase according to the current character set mapping.
- getVarcharDefaultLength() — Gets the default length of a varchar field.
- getVarcharMaxLength() — Gets the maximum length of a varchar field.
- getVarcharTypeDeclarationSQL() — Gets the SQL snippet used to declare a VARCHAR column type.
- getWildcards() — Gets all SQL wildcard characters of the platform.
- getWriteLockSQL() — Get the SQL snippet to append to any SELECT statement which obtains an exclusive lock on the rows.
- hasDoctrineTypeMappingFor() — Check if a database type is currently supported by this platform.
- isCommentedDoctrineType() — Is it necessary for the platform to add a parsable type comment to allow reverse engineering the given type?
- markDoctrineTypeCommented() — Mark this type as to be commented in ALTER TABLE and CREATE TABLE statements.
- modifyLimitQuery() — Modify limit query
- prefersIdentityColumns() — Whether the platform prefers identity columns (eg. autoincrement) for ID generation.
- prefersSequences() — Whether the platform prefers sequences for ID generation.
- quoteIdentifier() — Quotes a string so that it can be safely used as a table or column name, even if it is a reserved word of the platform. This also detects identifier chains separated by dot and quotes them independently.
- quoteSingleIdentifier() — Quote a single identifier (no dot chain separation)
- registerDoctrineTypeMapping() — Register a doctrine type to be used in conjunction with a column type of this platform.
- releaseSavePoint() — Generate SQL to release a savepoint
- rollbackSavePoint() — Generate SQL to rollback a savepoint
- setEventManager() — Sets the EventManager used by the Platform.
- supportsAlterTable() — Whether the platform supports altering tables.
- supportsCommentOnStatement() — Does this platform support the propriortary synatx "COMMENT ON asset"
- supportsCreateDropDatabase() — Some databases don't allow to create and drop databases at all or only with certain tools.
- supportsForeignKeyConstraints() — Does the platform supports foreign key constraints?
- supportsForeignKeyOnUpdate() — Does this platform supports onUpdate in foreign key constraints?
- supportsGettingAffectedRows() — Whether the platform supports getting the affected rows of a recent update/delete type query.
- supportsIdentityColumns() — Whether the platform supports identity columns.
- supportsIndexes() — Whether the platform supports indexes.
- supportsInlineColumnComments() — Does this plaform support to add inline column comments as postfix.
- supportsLimitOffset() — Does the database platform support offsets in modify limit clauses?
- supportsPrimaryConstraints() — Whether the platform supports primary key constraints.
- supportsReleaseSavepoints() — Whether the platform supports releasing savepoints.
- supportsSavepoints() — Whether the platform supports savepoints.
- supportsSchemas() — Whether the platform supports database schemas.
- supportsSequences() — Whether the platform supports sequences.
- supportsTransactions() — Whether the platform supports transactions.
- supportsViews() — Does this platform views ?