PHP Class Doctrine\DBAL\Platforms\DB2Platform

Inheritance: extends Doctrine\DBAL\Platforms\AbstractPlatform
Show file Open project: doctrine/dbal Class Usage Examples

Public Methods

Method Description
getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff ) {@inheritDoc}
getBigIntTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
getBinaryDefaultLength ( )
getBinaryMaxLength ( )
getBitAndComparisonExpression ( $value1, $value2 )
getBitOrComparisonExpression ( $value1, $value2 )
getBlobTypeDeclarationSQL ( array $field ) {@inheritDoc}
getBooleanTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
getClobTypeDeclarationSQL ( array $field ) {@inheritDoc}
getCreateDatabaseSQL ( $database ) {@inheritDoc}
getCreateTemporaryTableSnippetSQL ( ) {@inheritDoc}
getCreateViewSQL ( $name, $sql ) {@inheritDoc}
getCurrentDateSQL ( ) {@inheritDoc}
getCurrentTimeSQL ( ) {@inheritDoc}
getCurrentTimestampSQL ( ) {@inheritDoc}
getDateDiffExpression ( $date1, $date2 )
getDateTimeTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getDateTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getDefaultValueDeclarationSQL ( $field ) {@inheritDoc}
getDropDatabaseSQL ( $database ) {@inheritDoc}
getDropViewSQL ( $name ) {@inheritDoc}
getDummySelectSQL ( ) {@inheritDoc}
getEmptyIdentityInsertSQL ( $tableName, $identifierColumnName ) {@inheritDoc}
getForUpdateSQL ( ) {@inheritDoc}
getIndexDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index ) {@inheritDoc}
getIntegerTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
getListTableColumnsSQL ( string $table, string $database = null ) : string This code fragment is originally from the Zend_Db_Adapter_Db2 class, but has been edited.
getListTableForeignKeysSQL ( $table ) {@inheritDoc}
getListTableIndexesSQL ( $table, $currentDatabase = null ) {@inheritDoc}
getListTablesSQL ( ) {@inheritDoc}
getListViewsSQL ( $database ) {@inheritDoc}
getLocateExpression ( $str, $substr, $startPos = false ) {@inheritDoc}
getName ( ) {@inheritDoc}
getSQLResultCasing ( $column ) {@inheritDoc}
getSmallIntTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
getSubstringExpression ( $value, $from, $length = null ) {@inheritDoc}
getTemporaryTableName ( $tableName ) {@inheritDoc}
getTimeTypeDeclarationSQL ( array $fieldDeclaration ) {@inheritDoc}
getTruncateTableSQL ( $tableName, $cascade = false )
initializeDoctrineTypeMappings ( ) {@inheritDoc}
isCommentedDoctrineType ( Doctrine\DBAL\Types\Type $doctrineType )
prefersIdentityColumns ( ) {@inheritDoc}
supportsCommentOnStatement ( )
supportsCreateDropDatabase ( ) {@inheritDoc}
supportsIdentityColumns ( ) {@inheritDoc}
supportsReleaseSavepoints ( ) {@inheritDoc}
supportsSavepoints ( ) {@inheritDoc}

Protected Methods

Method Description
_getCommonIntegerTypeDeclarationSQL ( array $columnDef ) {@inheritDoc}
_getCreateTableSQL ( $tableName, array $columns, array $options = [] ) {@inheritDoc}
doModifyLimitQuery ( $query, $limit, $offset = null ) {@inheritDoc}
getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )
getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )
getPreAlterTableIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff ) {@inheritDoc}
getRenameIndexSQL ( $oldIndexName, Doctrine\DBAL\Schema\Index $index, $tableName )
getReservedKeywordsClass ( ) {@inheritDoc}
getVarcharTypeDeclarationSQLSnippet ( $length, $fixed ) {@inheritDoc}

Private Methods

Method Description
gatherAlterColumnSQL ( Doctrine\DBAL\Schema\Table $table, Doctrine\DBAL\Schema\ColumnDiff $columnDiff, array &$sql, array &$queryParts ) Gathers the table alteration SQL for a given column diff.
getAlterColumnClausesSQL ( Doctrine\DBAL\Schema\ColumnDiff $columnDiff ) : array Returns the ALTER COLUMN SQL clauses for altering a column described by the given column diff.

Method Details

_getCommonIntegerTypeDeclarationSQL() protected method

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

_getCreateTableSQL() protected method

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

doModifyLimitQuery() protected method

{@inheritDoc}
protected doModifyLimitQuery ( $query, $limit, $offset = null )

getAlterTableSQL() public method

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

getBigIntTypeDeclarationSQL() public method

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

getBinaryDefaultLength() public method

getBinaryMaxLength() public method

public getBinaryMaxLength ( )

getBinaryTypeDeclarationSQLSnippet() protected method

protected getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )

getBitAndComparisonExpression() public method

public getBitAndComparisonExpression ( $value1, $value2 )

getBitOrComparisonExpression() public method

public getBitOrComparisonExpression ( $value1, $value2 )

getBlobTypeDeclarationSQL() public method

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

getBooleanTypeDeclarationSQL() public method

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

getClobTypeDeclarationSQL() public method

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

getCreateDatabaseSQL() public method

{@inheritDoc}
public getCreateDatabaseSQL ( $database )

getCreateTemporaryTableSnippetSQL() public method

{@inheritDoc}

getCreateViewSQL() public method

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

getCurrentDateSQL() public method

{@inheritDoc}
public getCurrentDateSQL ( )

getCurrentTimeSQL() public method

{@inheritDoc}
public getCurrentTimeSQL ( )

getCurrentTimestampSQL() public method

{@inheritDoc}

getDateArithmeticIntervalExpression() protected method

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

getDateDiffExpression() public method

public getDateDiffExpression ( $date1, $date2 )

getDateTimeTypeDeclarationSQL() public method

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

getDateTypeDeclarationSQL() public method

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

getDefaultValueDeclarationSQL() public method

{@inheritDoc}
public getDefaultValueDeclarationSQL ( $field )

getDropDatabaseSQL() public method

{@inheritDoc}
public getDropDatabaseSQL ( $database )

getDropViewSQL() public method

{@inheritDoc}
public getDropViewSQL ( $name )

getDummySelectSQL() public method

{@inheritDoc}
public getDummySelectSQL ( )

getEmptyIdentityInsertSQL() public method

{@inheritDoc}
public getEmptyIdentityInsertSQL ( $tableName, $identifierColumnName )

getForUpdateSQL() public method

{@inheritDoc}
public getForUpdateSQL ( )

getIndexDeclarationSQL() public method

{@inheritDoc}
public getIndexDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )
$index Doctrine\DBAL\Schema\Index

getIntegerTypeDeclarationSQL() public method

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

getListTableColumnsSQL() public method

This code fragment is originally from the Zend_Db_Adapter_Db2 class, but has been edited.
public getListTableColumnsSQL ( string $table, string $database = null ) : string
$table string
$database string
return string

getListTableForeignKeysSQL() public method

{@inheritDoc}
public getListTableForeignKeysSQL ( $table )

getListTableIndexesSQL() public method

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

getListTablesSQL() public method

{@inheritDoc}
public getListTablesSQL ( )

getListViewsSQL() public method

{@inheritDoc}
public getListViewsSQL ( $database )

getLocateExpression() public method

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

getName() public method

{@inheritDoc}
public getName ( )

getPreAlterTableIndexForeignKeySQL() protected method

{@inheritDoc}
protected getPreAlterTableIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff )
$diff Doctrine\DBAL\Schema\TableDiff

getRenameIndexSQL() protected method

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

getReservedKeywordsClass() protected method

{@inheritDoc}
protected getReservedKeywordsClass ( )

getSQLResultCasing() public method

DB2 returns all column names in SQL result sets in uppercase.
public getSQLResultCasing ( $column )

getSmallIntTypeDeclarationSQL() public method

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

getSubstringExpression() public method

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

getTemporaryTableName() public method

{@inheritDoc}
public getTemporaryTableName ( $tableName )

getTimeTypeDeclarationSQL() public method

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

getTruncateTableSQL() public method

public getTruncateTableSQL ( $tableName, $cascade = false )

getVarcharTypeDeclarationSQLSnippet() protected method

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

initializeDoctrineTypeMappings() public method

{@inheritDoc}

isCommentedDoctrineType() public method

public isCommentedDoctrineType ( Doctrine\DBAL\Types\Type $doctrineType )
$doctrineType Doctrine\DBAL\Types\Type

prefersIdentityColumns() public method

{@inheritDoc}

supportsCommentOnStatement() public method

supportsCreateDropDatabase() public method

{@inheritDoc}

supportsIdentityColumns() public method

{@inheritDoc}

supportsReleaseSavepoints() public method

{@inheritDoc}

supportsSavepoints() public method

DB2 supports savepoints, but they work semantically different than on other vendor platforms. TODO: We have to investigate how to get DB2 up and running with savepoints.
public supportsSavepoints ( )