• Home
• Doctrine
• DBAL
• Platforms
• MySqlPlatform

PHP Class Doctrine\DBAL\Platforms\MySqlPlatform

Show file Open project: doctrine/dbal Class Usage Examples

Public Methods

Method	Description
getAdvancedForeignKeyOptionsSQL ( Doctrine\DBAL\Schema\ForeignKeyConstraint $foreignKey )	{@inheritDoc}
getAlterTableSQL ( Doctrine\DBAL\Schema\TableDiff $diff )	{@inheritDoc}
getBigIntTypeDeclarationSQL ( array $field )	{@inheritDoc}
getBinaryMaxLength ( )
getBlobTypeDeclarationSQL ( array $field ) : string	Gets the SQL Snippet used to declare a BLOB column type.
getBooleanTypeDeclarationSQL ( array $field )	{@inheritDoc}
getClobTypeDeclarationSQL ( array $field ) : string	Gets the SQL snippet used to declare a CLOB column type.
getCollationFieldDeclaration ( string $collation ) : string	Obtain DBMS specific SQL code portion needed to set the COLLATION of a field declaration to be used in statements like CREATE TABLE.
getConcatExpression ( )	{@inheritDoc}
getCreateDatabaseSQL ( $name )	{@inheritDoc}
getCreateViewSQL ( $name, $sql )	{@inheritDoc}
getDateDiffExpression ( $date1, $date2 )	{@inheritDoc}
getDateTimeTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getDateTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getDecimalTypeDeclarationSQL ( array $columnDef )
getDefaultValueDeclarationSQL ( $field )
getDropDatabaseSQL ( $name )	{@inheritDoc}
getDropIndexSQL ( $index, $table = null )	{@inheritDoc}
getDropTemporaryTableSQL ( $table )	{@inheritDoc}
getDropViewSQL ( $name )	{@inheritDoc}
getFloatDeclarationSQL ( array $field )
getGuidExpression ( )	{@inheritDoc}
getIdentifierQuoteCharacter ( )	{@inheritDoc}
getIntegerTypeDeclarationSQL ( array $field )	{@inheritDoc}
getListDatabasesSQL ( )	{@inheritDoc}
getListTableColumnsSQL ( $table, $database = null )	{@inheritDoc}
getListTableConstraintsSQL ( $table )	{@inheritDoc}
getListTableForeignKeysSQL ( $table, $database = null )	{@inheritDoc}
getListTableIndexesSQL ( $table, $currentDatabase = null )	{@inheritDoc}
getListTablesSQL ( )	{@inheritDoc}
getListViewsSQL ( $database )	{@inheritDoc}
getLocateExpression ( $str, $substr, $startPos = false )	{@inheritDoc}
getName ( )	{@inheritDoc}
getReadLockSQL ( )	{@inheritDoc}
getRegexpExpression ( )	{@inheritDoc}
getSetTransactionIsolationSQL ( $level )	{@inheritDoc}
getSmallIntTypeDeclarationSQL ( array $field )	{@inheritDoc}
getTimeTypeDeclarationSQL ( array $fieldDeclaration )	{@inheritDoc}
getVarcharMaxLength ( )	{@inheritDoc}
prefersIdentityColumns ( )	{@inheritDoc}
quoteStringLiteral ( $str )
supportsColumnCollation ( )	{@inheritDoc}
supportsIdentityColumns ( )	{@inheritDoc}
supportsInlineColumnComments ( )	{@inheritDoc}

Protected Methods

Method	Description
_getCommonIntegerTypeDeclarationSQL ( array $columnDef )	{@inheritDoc}
_getCreateTableSQL ( $tableName, array $columns, array $options = [] )	{@inheritDoc}
doModifyLimitQuery ( string $query, integer $limit, integer $offset ) : string	Adds MySQL-specific LIMIT clause to the query 18446744073709551615 is 2^64-1 maximum of unsigned BIGINT the biggest limit possible
getBinaryTypeDeclarationSQLSnippet ( $length, $fixed )
getCreateIndexSQLFlags ( Doctrine\DBAL\Schema\Index $index )	{@inheritDoc}
getDateArithmeticIntervalExpression ( $date, $operator, $interval, $unit )
getDropPrimaryKeySQL ( string $table ) : string
getPostAlterTableIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff )
getPostAlterTableRenameIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff ) : array
getPreAlterTableIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff )	{@inheritDoc}
getPreAlterTableRenameIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff ) : array
getReservedKeywordsClass ( )	{@inheritDoc}
getVarcharTypeDeclarationSQLSnippet ( $length, $fixed )	{@inheritDoc}
initializeDoctrineTypeMappings ( )	{@inheritDoc}

Private Methods

Method	Description
buildPartitionOptions ( array $options ) : string	Build SQL for partition options.
buildTableOptions ( array $options ) : string	Build SQL for table options
getPreAlterTableAlterIndexForeignKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff ) : array
getPreAlterTableAlterPrimaryKeySQL ( Doctrine\DBAL\Schema\TableDiff $diff, Doctrine\DBAL\Schema\Index $index ) : string[]
getRemainingForeignKeyConstraintsRequiringRenamedIndexes ( Doctrine\DBAL\Schema\TableDiff $diff ) : array	Returns the remaining foreign key constraints that require one of the renamed indexes.
getUnsignedDeclaration ( array $columnDef ) : string	Get unsigned declaration for a column.

Method Details