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

См. ссылку: www.doctrine-project.org

С версии: 2.5

Автор: Steve Müller ([email protected])

Наследование: extends Doctrine\DBAL\Platforms\AbstractPlatform

Показать файл Открыть проект Примеры использования класса

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

Метод	Описание
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 ( )

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

Метод	Описание
_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 ( )

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

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

protected _getCommonIntegerTypeDeclarationSQL ( array $columnDef )
$columnDef	array

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

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

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

protected _getTransactionIsolationLevelSQL ( $level )

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

public appendLockHint ( $fromClause, $lockMode )

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

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

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

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

public fixSchemaElementName ( $schemaElementName )

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

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

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

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
Результат	string

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

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.
Результат	string

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

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.
Результат	string \| null

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

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.
Результат	string

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

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.
Результат	string

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

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.
Результат	string

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

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.
Результат	string

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

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

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

public getBigIntTypeDeclarationSQL ( array $columnDef )
$columnDef	array

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

public getBinaryDefaultLength ( )

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

public getBinaryMaxLength ( )

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

protected getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )

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

public getBlobTypeDeclarationSQL ( array $field )
$field	array

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

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 getClobTypeDeclarationSQL ( array $field )
$field	array

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

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

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

public getConcatExpression ( )

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

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

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

public getCreateDatabaseSQL ( $database )

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

Appends SQL Anywhere specific flags if given.

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

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

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

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

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

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

public getCreateTemporaryTableSnippetSQL ( )

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

public getCreateViewSQL ( $name, $sql )

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

public getCurrentDateSQL ( )

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

public getCurrentTimeSQL ( )

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

public getCurrentTimestampSQL ( )

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

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

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

public getDateDiffExpression ( $date1, $date2 )

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

public getDateTimeFormatString ( )

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

public getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

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

public getDateTimeTzFormatString ( )

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

public getDateTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

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

public getDefaultTransactionIsolationLevel ( )

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

public getDropDatabaseSQL ( $database )

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

public getDropIndexSQL ( $index, $table = null )

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

public getDropViewSQL ( $name )

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

public getForUpdateSQL ( )

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

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

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

Returns foreign key MATCH clause for given type.

public getForeignKeyMatchClauseSQL ( integer $type ) : string
$type	integer	The foreign key match type
Результат	string

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

public getForeignKeyReferentialActionSQL ( $action )

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

public getGuidExpression ( )

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

public getGuidTypeDeclarationSQL ( array $field )
$field	array

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

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

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

public getIntegerTypeDeclarationSQL ( array $columnDef )
$columnDef	array

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

public getListDatabasesSQL ( )

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

public getListTableColumnsSQL ( $table, $database = null )

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

public getListTableConstraintsSQL ( $table )

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

public getListTableForeignKeysSQL ( $table )

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

public getListTableIndexesSQL ( $table, $currentDatabase = null )

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

public getListTablesSQL ( )

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

public getListUsersSQL ( )

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

public getListViewsSQL ( $database )

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

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

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

public getMaxIdentifierLength ( )

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

public getMd5Expression ( $column )

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

public getName ( )

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

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
Результат	string	DBMS specific SQL code portion needed to set a primary key

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

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

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

protected getReservedKeywordsClass ( )

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

public getSetTransactionIsolationSQL ( $level )

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

public getSmallIntTypeDeclarationSQL ( array $columnDef )
$columnDef	array

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

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.
Результат	string

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

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.
Результат	string

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

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

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

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.
Результат	string

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

public getTemporaryTableSQL ( )

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

public getTimeFormatString ( )

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

public getTimeTypeDeclarationSQL ( array $fieldDeclaration )
$fieldDeclaration	array

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

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

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

public getTruncateTableSQL ( $tableName, $cascade = false )

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

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

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

public getVarcharDefaultLength ( )

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

public getVarcharMaxLength ( )

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

protected getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )

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

public hasNativeGuidType ( )

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

protected initializeDoctrineTypeMappings ( )

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

public prefersIdentityColumns ( )

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

public supportsCommentOnStatement ( )

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

public supportsIdentityColumns ( )