PHP 클래스 Doctrine\DBAL\Platforms\SQLAnywherePlatform

부터: 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 ( )