PHP Class Doctrine\DBAL\Platforms\SQLAnywherePlatform

Since: 2.5

Author: Steve Müller ([email protected])

Inheritance: extends Doctrine\DBAL\Platforms\AbstractPlatform

Afficher le fichier Open project: doctrine/dbal Class Usage Examples

Méthodes publiques

Méthode	Description
appendLockHint ( $fromClause, $lockMode )
fixSchemaElementName ( $schemaElementName )
getAdvancedForeignKeyOptionsSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )
getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff )
getBigIntTypeDeclarationSQL ( array $columnDef )
getBinaryDefaultLength ( )
getBinaryMaxLength ( )
getBlobTypeDeclarationSQL ( array $field )
getBooleanTypeDeclarationSQL ( array $columnDef )
getClobTypeDeclarationSQL ( array $field )
getCommentOnColumnSQL ( $tableName, $columnName, $comment )
getConcatExpression ( )
getCreateConstraintSQL ( Doctrine\DBAL\Schema\Constraint $constraint, $table )
getCreateDatabaseSQL ( $database )
getCreateIndexSQL ( Doctrine\DBAL\Schema\Index $index, $table )
getCreatePrimaryKeySQL ( Doctrine\DBAL\Schema\Index $index, $table )
getCreateTemporaryTableSnippetSQL ( )
getCreateViewSQL ( $name, $sql )
getCurrentDateSQL ( )
getCurrentTimeSQL ( )
getCurrentTimestampSQL ( )
getDateDiffExpression ( $date1, $date2 )
getDateTimeFormatString ( )
getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )
getDateTimeTzFormatString ( )
getDateTypeDeclarationSQL ( array $fieldDeclaration )
getDefaultTransactionIsolationLevel ( )
getDropDatabaseSQL ( $database )
getDropIndexSQL ( $index, $table = null )
getDropViewSQL ( $name )
getForUpdateSQL ( )
getForeignKeyBaseDeclarationSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )
getForeignKeyMatchClauseSQL ( integer $type ) : string	Returns foreign key MATCH clause for given type.
getForeignKeyReferentialActionSQL ( $action )
getGuidExpression ( )
getGuidTypeDeclarationSQL ( array $field )
getIndexDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )
getIntegerTypeDeclarationSQL ( array $columnDef )
getListDatabasesSQL ( )
getListTableColumnsSQL ( $table, $database = null )
getListTableConstraintsSQL ( $table )
getListTableForeignKeysSQL ( $table )
getListTableIndexesSQL ( $table, $currentDatabase = null )
getListTablesSQL ( )
getListUsersSQL ( )
getListViewsSQL ( $database )
getLocateExpression ( $str, $substr, $startPos = false )
getMaxIdentifierLength ( )
getMd5Expression ( $column )
getName ( )
getPrimaryKeyDeclarationSQL ( Doctrine\DBAL\Schema\Index $index, string $name = null ) : string	Obtain DBMS specific SQL code portion needed to set a primary key declaration to be used in statements like ALTER TABLE.
getSetTransactionIsolationSQL ( $level )
getSmallIntTypeDeclarationSQL ( array $columnDef )
getStartDatabaseSQL ( string $database ) : string	Returns the SQL statement for starting an existing database.
getStopDatabaseSQL ( string $database ) : string	Returns the SQL statement for stopping a running database.
getSubstringExpression ( $value, $from, $length = null )
getTemporaryTableSQL ( )
getTimeFormatString ( )
getTimeTypeDeclarationSQL ( array $fieldDeclaration )
getTrimExpression ( $str, $pos = self::TRIM_UNSPECIFIED, $char = false )
getTruncateTableSQL ( $tableName, $cascade = false )
getUniqueConstraintDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )
getVarcharDefaultLength ( )
getVarcharMaxLength ( )
hasNativeGuidType ( )
prefersIdentityColumns ( )
supportsCommentOnStatement ( )
supportsIdentityColumns ( )

Méthodes protégées

Méthode	Description
_getCommonIntegerTypeDeclarationSQL ( array $columnDef )
_getCreateTableSQL ( $tableName, array $columns, array $options = [] )
_getTransactionIsolationLevelSQL ( $level )
doModifyLimitQuery ( $query, $limit, $offset )
getAdvancedIndexOptionsSQL ( Doctrine\DBAL\Schema\Index $index ) : string	Return the INDEX query section dealing with non-standard SQL Anywhere options.
getAlterTableAddColumnClause ( Doctrine\DBAL\Schema\Column $column ) : string	Returns the SQL clause for creating a column in a table alteration.
getAlterTableChangeColumnClause ( Doctrine\DBAL\Schema\ColumnDiff $columnDiff ) : string \| null	Returns the SQL clause for altering a column in a table alteration.
getAlterTableClause ( Doctrine\DBAL\Schema\Identifier $tableName ) : string	Returns the SQL clause for altering a table.
getAlterTableRemoveColumnClause ( Doctrine\DBAL\Schema\Column $column ) : string	Returns the SQL clause for dropping a column in a table alteration.
getAlterTableRenameColumnClause ( string $oldColumnName, Doctrine\DBAL\Schema\Column $column ) : string	Returns the SQL clause for renaming a column in a table alteration.
getAlterTableRenameTableClause ( Doctrine\DBAL\Schema\Identifier $newTableName ) : string	Returns the SQL clause for renaming a table in a table alteration.
getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )
getCreateIndexSQLFlags ( Doctrine\DBAL\Schema\Index $index )
getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )
getRenameIndexSQL ( $oldIndexName, Doctrine\DBAL\Schema\Index $index, $tableName )
getReservedKeywordsClass ( )
getTableConstraintDeclarationSQL ( Doctrine\DBAL\Schema\Constraint $constraint, string \| null $name = null ) : string	Returns the SQL snippet for creating a table constraint.
getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )
initializeDoctrineTypeMappings ( )

Method Details

_getCommonIntegerTypeDeclarationSQL() protected méthode

protected _getCommonIntegerTypeDeclarationSQL ( array $columnDef )
$columnDef	array

_getCreateTableSQL() protected méthode

protected _getCreateTableSQL ( $tableName, array $columns, array $options = [] )
$columns	array
$options	array

_getTransactionIsolationLevelSQL() protected méthode

protected _getTransactionIsolationLevelSQL ( $level )

appendLockHint() public méthode

public appendLockHint ( $fromClause, $lockMode )

doModifyLimitQuery() protected méthode

protected doModifyLimitQuery ( $query, $limit, $offset )

fixSchemaElementName() public méthode

SQL Anywhere supports a maximum length of 128 bytes for identifiers.

public fixSchemaElementName ( $schemaElementName )

getAdvancedForeignKeyOptionsSQL() public méthode

public getAdvancedForeignKeyOptionsSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )
$foreignKey	Doctrine\DBAL\Schema\ForeignKeyConstraint

getAdvancedIndexOptionsSQL() protected méthode

Return the INDEX query section dealing with non-standard SQL Anywhere options.

protected getAdvancedIndexOptionsSQL ( Doctrine\DBAL\Schema\Index $index ) : string
$index	Doctrine\DBAL\Schema\Index	Index definition
Résultat	string

getAlterTableAddColumnClause() protected méthode

Returns the SQL clause for creating a column in a table alteration.

protected getAlterTableAddColumnClause ( Doctrine\DBAL\Schema\Column $column ) : string
$column	Doctrine\DBAL\Schema\Column	The column to add.
Résultat	string

getAlterTableChangeColumnClause() protected méthode

This method returns null in case that only the column comment has changed. Changes in column comments have to be handled differently.

protected getAlterTableChangeColumnClause ( Doctrine\DBAL\Schema\ColumnDiff $columnDiff ) : string \| null
$columnDiff	Doctrine\DBAL\Schema\ColumnDiff	The diff of the column to alter.
Résultat	string \| null

getAlterTableClause() protected méthode

Returns the SQL clause for altering a table.

protected getAlterTableClause ( Doctrine\DBAL\Schema\Identifier $tableName ) : string
$tableName	Doctrine\DBAL\Schema\Identifier	The quoted name of the table to alter.
Résultat	string

getAlterTableRemoveColumnClause() protected méthode

Returns the SQL clause for dropping a column in a table alteration.

protected getAlterTableRemoveColumnClause ( Doctrine\DBAL\Schema\Column $column ) : string
$column	Doctrine\DBAL\Schema\Column	The column to drop.
Résultat	string

getAlterTableRenameColumnClause() protected méthode

Returns the SQL clause for renaming a column in a table alteration.

protected getAlterTableRenameColumnClause ( string $oldColumnName, Doctrine\DBAL\Schema\Column $column ) : string
$oldColumnName	string	The quoted name of the column to rename.
$column	Doctrine\DBAL\Schema\Column	The column to rename to.
Résultat	string

getAlterTableRenameTableClause() protected méthode

Returns the SQL clause for renaming a table in a table alteration.

protected getAlterTableRenameTableClause ( Doctrine\DBAL\Schema\Identifier $newTableName ) : string
$newTableName	Doctrine\DBAL\Schema\Identifier	The quoted name of the table to rename to.
Résultat	string

getAlterTableSQL() public méthode

public getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff )
$diff	Doctrine\DBAL\Schema\TableDiff

getBigIntTypeDeclarationSQL() public méthode

public getBigIntTypeDeclarationSQL ( array $columnDef )
$columnDef	array

getBinaryDefaultLength() public méthode

public getBinaryDefaultLength ( )

getBinaryMaxLength() public méthode

public getBinaryMaxLength ( )

getBinaryTypeDeclarationSQLSnippet() protected méthode

protected getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )

getBlobTypeDeclarationSQL() public méthode

public getBlobTypeDeclarationSQL ( array $field )
$field	array

getBooleanTypeDeclarationSQL() public méthode

BIT type columns require an explicit NULL declaration in SQL Anywhere if they shall be nullable. Otherwise by just omitting the NOT NULL clause, SQL Anywhere will declare them NOT NULL nonetheless.

public getBooleanTypeDeclarationSQL ( array $columnDef )
$columnDef	array

getClobTypeDeclarationSQL() public méthode

public getClobTypeDeclarationSQL ( array $field )
$field	array

getCommentOnColumnSQL() public méthode

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

getConcatExpression() public méthode

public getConcatExpression ( )

getCreateConstraintSQL() public méthode

public getCreateConstraintSQL ( Doctrine\DBAL\Schema\Constraint $constraint, $table )
$constraint	Doctrine\DBAL\Schema\Constraint

getCreateDatabaseSQL() public méthode

public getCreateDatabaseSQL ( $database )

getCreateIndexSQL() public méthode

Appends SQL Anywhere specific flags if given.

public getCreateIndexSQL ( Doctrine\DBAL\Schema\Index $index, $table )
$index	Doctrine\DBAL\Schema\Index

getCreateIndexSQLFlags() protected méthode

protected getCreateIndexSQLFlags ( Doctrine\DBAL\Schema\Index $index )
$index	Doctrine\DBAL\Schema\Index

getCreatePrimaryKeySQL() public méthode

public getCreatePrimaryKeySQL ( Doctrine\DBAL\Schema\Index $index, $table )
$index	Doctrine\DBAL\Schema\Index

getCreateTemporaryTableSnippetSQL() public méthode

public getCreateTemporaryTableSnippetSQL ( )

getCreateViewSQL() public méthode

public getCreateViewSQL ( $name, $sql )

getCurrentDateSQL() public méthode

public getCurrentDateSQL ( )

getCurrentTimeSQL() public méthode

public getCurrentTimeSQL ( )

getCurrentTimestampSQL() public méthode

public getCurrentTimestampSQL ( )

getDateArithmeticIntervalExpression() protected méthode

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

getDateDiffExpression() public méthode

public getDateDiffExpression ( $date1, $date2 )

getDateTimeFormatString() public méthode

public getDateTimeFormatString ( )

getDateTimeTypeDeclarationSQL() public méthode

public getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

getDateTimeTzFormatString() public méthode

public getDateTimeTzFormatString ( )

getDateTypeDeclarationSQL() public méthode

public getDateTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

getDefaultTransactionIsolationLevel() public méthode

public getDefaultTransactionIsolationLevel ( )

getDropDatabaseSQL() public méthode

public getDropDatabaseSQL ( $database )

getDropIndexSQL() public méthode

public getDropIndexSQL ( $index, $table = null )

getDropViewSQL() public méthode

public getDropViewSQL ( $name )

getForUpdateSQL() public méthode

public getForUpdateSQL ( )

getForeignKeyBaseDeclarationSQL() public méthode

public getForeignKeyBaseDeclarationSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )
$foreignKey	Doctrine\DBAL\Schema\ForeignKeyConstraint

getForeignKeyMatchClauseSQL() public méthode

Returns foreign key MATCH clause for given type.

public getForeignKeyMatchClauseSQL ( integer $type ) : string
$type	integer	The foreign key match type
Résultat	string

getForeignKeyReferentialActionSQL() public méthode

public getForeignKeyReferentialActionSQL ( $action )

getGuidExpression() public méthode

public getGuidExpression ( )

getGuidTypeDeclarationSQL() public méthode

public getGuidTypeDeclarationSQL ( array $field )
$field	array

getIndexDeclarationSQL() public méthode

public getIndexDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )
$index	Doctrine\DBAL\Schema\Index

getIntegerTypeDeclarationSQL() public méthode

public getIntegerTypeDeclarationSQL ( array $columnDef )
$columnDef	array

getListDatabasesSQL() public méthode

public getListDatabasesSQL ( )

getListTableColumnsSQL() public méthode

public getListTableColumnsSQL ( $table, $database = null )

getListTableConstraintsSQL() public méthode

public getListTableConstraintsSQL ( $table )

getListTableForeignKeysSQL() public méthode

public getListTableForeignKeysSQL ( $table )

getListTableIndexesSQL() public méthode

public getListTableIndexesSQL ( $table, $currentDatabase = null )

getListTablesSQL() public méthode

public getListTablesSQL ( )

getListUsersSQL() public méthode

public getListUsersSQL ( )

getListViewsSQL() public méthode

public getListViewsSQL ( $database )

getLocateExpression() public méthode

public getLocateExpression ( $str, $substr, $startPos = false )

getMaxIdentifierLength() public méthode

public getMaxIdentifierLength ( )

getMd5Expression() public méthode

public getMd5Expression ( $column )

getName() public méthode

public getName ( )

getPrimaryKeyDeclarationSQL() public méthode

Obtain DBMS specific SQL code portion needed to set a primary key declaration to be used in statements like ALTER TABLE.

public getPrimaryKeyDeclarationSQL ( Doctrine\DBAL\Schema\Index $index, string $name = null ) : string
$index	Doctrine\DBAL\Schema\Index	Index definition
$name	string	Name of the primary key
Résultat	string	DBMS specific SQL code portion needed to set a primary key

getRenameIndexSQL() protected méthode

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

getReservedKeywordsClass() protected méthode

protected getReservedKeywordsClass ( )

getSetTransactionIsolationSQL() public méthode

public getSetTransactionIsolationSQL ( $level )

getSmallIntTypeDeclarationSQL() public méthode

public getSmallIntTypeDeclarationSQL ( array $columnDef )
$columnDef	array

getStartDatabaseSQL() public méthode

In SQL Anywhere you can start and stop databases on a database server instance. This is a required statement after having created a new database as it has to be explicitly started to be usable. SQL Anywhere does not automatically start a database after creation!

public getStartDatabaseSQL ( string $database ) : string
$database	string	Name of the database to start.
Résultat	string

getStopDatabaseSQL() public méthode

In SQL Anywhere you can start and stop databases on a database server instance. This is a required statement before dropping an existing database as it has to be explicitly stopped before it can be dropped.

public getStopDatabaseSQL ( string $database ) : string
$database	string	Name of the database to stop.
Résultat	string

getSubstringExpression() public méthode

public getSubstringExpression ( $value, $from, $length = null )

getTableConstraintDeclarationSQL() protected méthode

Returns the SQL snippet for creating a table constraint.

protected getTableConstraintDeclarationSQL ( Doctrine\DBAL\Schema\Constraint $constraint, string \| null $name = null ) : string
$constraint	Doctrine\DBAL\Schema\Constraint	The table constraint to create the SQL snippet for.
$name	string \| null	The table constraint name to use if any.
Résultat	string

getTemporaryTableSQL() public méthode

public getTemporaryTableSQL ( )

getTimeFormatString() public méthode

public getTimeFormatString ( )

getTimeTypeDeclarationSQL() public méthode

public getTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

getTrimExpression() public méthode

public getTrimExpression ( $str, $pos = self::TRIM_UNSPECIFIED, $char = false )

getTruncateTableSQL() public méthode

public getTruncateTableSQL ( $tableName, $cascade = false )

getUniqueConstraintDeclarationSQL() public méthode

public getUniqueConstraintDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )
$index	Doctrine\DBAL\Schema\Index

getVarcharDefaultLength() public méthode

public getVarcharDefaultLength ( )

getVarcharMaxLength() public méthode

public getVarcharMaxLength ( )

getVarcharTypeDeclarationSQLSnippet() protected méthode

protected getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )

hasNativeGuidType() public méthode

public hasNativeGuidType ( )

initializeDoctrineTypeMappings() protected méthode

protected initializeDoctrineTypeMappings ( )

prefersIdentityColumns() public méthode

public prefersIdentityColumns ( )

supportsCommentOnStatement() public méthode

public supportsCommentOnStatement ( )

supportsIdentityColumns() public méthode

public supportsIdentityColumns ( )