• Home
• Doctrine
• DBAL
• Platforms
• SQLServerPlatform

PHP Class Doctrine\DBAL\Platforms\SQLServerPlatform

Show file Open project: doctrine/dbal Class Usage Examples

Public Methods

Method	Description
appendLockHint ( $fromClause, $lockMode )	{@inheritDoc}
convertBooleans ( $item )	{@inheritDoc}
createSavePoint ( $savepoint )	{@inheritDoc}
getAddExtendedPropertySQL ( string $name, string | null $value = null, string | null $level0Type = null, string | null $level0Name = null, string | null $level1Type = null, string | null $level1Name = null, string | null $level2Type = null, string | null $level2Name = null ) : string	Returns the SQL statement for adding an extended property to a database object.
getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff )	{@inheritDoc}
getBigIntTypeDeclarationSQL ( array $field )	{@inheritDoc}
getBinaryMaxLength ( )
getBlobTypeDeclarationSQL ( array $field )	{@inheritDoc}
getBooleanTypeDeclarationSQL ( array $field )	{@inheritDoc}
getClobTypeDeclarationSQL ( array $field )	{@inheritDoc}
getColumnDeclarationSQL ( $name, array $field )
getConcatExpression ( )	{@inheritDoc}
getCreateDatabaseSQL ( $name )	{@inheritDoc}
getCreateIndexSQL ( Doctrine\DBAL\Schema\Index $index, $table )	{@inheritDoc}
getCreatePrimaryKeySQL ( Doctrine\DBAL\Schema\Index $index, $table )	{@inheritDoc}
getCreateSchemaSQL ( $schemaName )	{@inheritDoc}
getCreateTemporaryTableSnippetSQL ( )	{@inheritDoc}
getCreateViewSQL ( $name, $sql )	{@inheritDoc}
getDateDiffExpression ( $date1, $date2 )	{@inheritDoc}
getDateFormatString ( )	{@inheritDoc}
getDateTimeFormatString ( )	{@inheritDoc}
getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getDateTimeTzFormatString ( )	{@inheritDoc}
getDateTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getDefaultConstraintDeclarationSQL ( string $table, array $column ) : string	Returns the SQL snippet for declaring a default constraint.
getDefaultSchemaName ( )
getDefaultValueDeclarationSQL ( $field )	{@inheritDoc}
getDropDatabaseSQL ( $name )	{@inheritDoc}
getDropExtendedPropertySQL ( string $name, string | null $level0Type = null, string | null $level0Name = null, string | null $level1Type = null, string | null $level1Name = null, string | null $level2Type = null, string | null $level2Name = null ) : string	Returns the SQL statement for dropping an extended property from a database object.
getDropForeignKeySQL ( $foreignKey, $table )	{@inheritDoc}
getDropIndexSQL ( $index, $table = null )	{@inheritDoc}
getDropViewSQL ( $name )	{@inheritDoc}
getEmptyIdentityInsertSQL ( $quotedTableName, $quotedIdentifierColumnName )	{@inheritDoc}
getForUpdateSQL ( )	{@inheritDoc}
getForeignKeyReferentialActionSQL ( $action )
getGuidExpression ( )	{@inheritDoc}
getGuidTypeDeclarationSQL ( array $field )	{@inheritDoc}
getIntegerTypeDeclarationSQL ( array $field )	{@inheritDoc}
getLengthExpression ( $column )	{@inheritDoc}
getListDatabasesSQL ( )	{@inheritDoc}
getListNamespacesSQL ( )	{@inheritDoc}
getListTableColumnsSQL ( $table, $database = null )	{@inheritDoc}
getListTableForeignKeysSQL ( $table, $database = null )	{@inheritDoc}
getListTableIndexesSQL ( $table, $currentDatabase = null )	{@inheritDoc}
getListTablesSQL ( )	{@inheritDoc}
getListViewsSQL ( $database )	{@inheritDoc}
getLocateExpression ( $str, $substr, $startPos = false )	{@inheritDoc}
getModExpression ( $expression1, $expression2 )	{@inheritDoc}
getName ( )	{@inheritDoc}
getSetTransactionIsolationSQL ( $level )	{@inheritDoc}
getSmallIntTypeDeclarationSQL ( array $field )	{@inheritDoc}
getSubstringExpression ( $value, $from, $length = null )	{@inheritDoc}
getTemporaryTableName ( $tableName )	{@inheritDoc}
getTimeFormatString ( )	{@inheritDoc}
getTimeTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getTrimExpression ( $str, $pos = self::TRIM_UNSPECIFIED, $char = false )	{@inheritDoc}
getTruncateTableSQL ( $tableName, $cascade = false )	{@inheritDoc}
getUniqueConstraintDeclarationSQL ( $name, Doctrine\DBAL\Schema\Index $index )	{@inheritDoc}
getUpdateExtendedPropertySQL ( string $name, string | null $value = null, string | null $level0Type = null, string | null $level0Name = null, string | null $level1Type = null, string | null $level1Name = null, string | null $level2Type = null, string | null $level2Name = null ) : string	Returns the SQL statement for updating an extended property of a database object.
hasNativeGuidType ( )	{@inheritDoc}
prefersIdentityColumns ( )	{@inheritDoc}
quoteSingleIdentifier ( $str )	{@inheritDoc}
releaseSavePoint ( $savepoint )	{@inheritDoc}
rollbackSavePoint ( $savepoint )	{@inheritDoc}
supportsColumnCollation ( )	{@inheritDoc}
supportsCreateDropDatabase ( )	{@inheritDoc}
supportsIdentityColumns ( )	{@inheritDoc}
supportsLimitOffset ( )	{@inheritDoc}
supportsReleaseSavepoints ( )	{@inheritDoc}
supportsSchemas ( )

Protected Methods

Method	Description
_getCommonIntegerTypeDeclarationSQL ( array $columnDef )	{@inheritDoc}
_getCreateTableSQL ( $tableName, array $columns, array $options = [] )	{@inheritDoc}
doModifyLimitQuery ( $query, $limit, $offset = null )	{@inheritDoc}
getAlterColumnCommentSQL ( string $tableName, string $columnName, string $comment ) : string	Returns the SQL statement for altering a column comment.
getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )
getCreateColumnCommentSQL ( string $tableName, string $columnName, string $comment ) : string	Returns the SQL statement for creating a column comment.
getCreateIndexSQLFlags ( Doctrine\DBAL\Schema\Index $index )	{@inheritDoc}
getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )
getDropColumnCommentSQL ( string $tableName, string $columnName ) : string	Returns the SQL statement for dropping a column comment.
getRenameIndexSQL ( $oldIndexName, Doctrine\DBAL\Schema\Index $index, $tableName )
getReservedKeywordsClass ( )	{@inheritDoc}
getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )	{@inheritDoc}
initializeDoctrineTypeMappings ( )	{@inheritDoc}

Private Methods

Method	Description
_appendUniqueConstraintDefinition ( string $sql, Doctrine\DBAL\Schema\Index $index ) : string	Extend unique key constraint with required filters
alterColumnRequiresDropDefaultConstraint ( Doctrine\DBAL\Schema\ColumnDiff $columnDiff ) : boolean	Checks whether a column alteration requires dropping its default constraint first.
generateDefaultConstraintName ( string $table, string $column ) : string	Returns a unique default constraint name for a table and column.
generateIdentifierName ( string $identifier ) : string	Returns a hash value for a given identifier.
getAlterTableAddDefaultConstraintClause ( string $tableName, Doctrine\DBAL\Schema\Column $column ) : string	Returns the SQL clause for adding a default constraint in an ALTER TABLE statement.
getAlterTableDropDefaultConstraintClause ( string $tableName, string $columnName ) : string	Returns the SQL clause for dropping an existing default constraint in an ALTER TABLE statement.
getTableWhereClause ( string $table, string $schemaColumn, string $tableColumn ) : string	Returns the where clause to filter schema and table name in a query.
isOrderByInTopNSubquery ( string $query, integer $currentPosition ) : boolean	Check an ORDER BY clause to see if it is in a TOP N query or subquery.
scrubInnerOrderBy ( $query ) : string	Remove ORDER BY clauses in subqueries - they're not supported by SQL Server.

Method Details