sirius.db.jdbc.schema

Class MySQLDatabaseDialect

java.lang.Object

sirius.db.jdbc.schema.BasicDatabaseDialect

sirius.db.jdbc.schema.MySQLDatabaseDialect

All Implemented Interfaces:

DatabaseDialect

public class MySQLDatabaseDialect
extends BasicDatabaseDialect

Defines the dialect used to sync the schema against a MySQL database.

Field Summary

Fields inherited from class sirius.db.jdbc.schema.BasicDatabaseDialect

DEFAULT_MAX_CONSTRAINT_NAME_LENGTH, KEY_CURRENT, KEY_TARGET

Constructor Summary

Constructors

Constructor and Description
MySQLDatabaseDialect()

Method Summary

Modifier and Type	Method and Description
protected boolean	areTypesEqual(int type, int other)
String	generateAddColumn(Table table, TableColumn col) Generates an alter statement to add the given column.
List<String>	generateAlterColumnTo(Table table, String oldName, TableColumn toColumn) Alters the given column.
String	generateCreateTable(Table table) Builds a CREATE TABLE statement.
protected int	getConstraintCharacterLimit() Determines the length a constraint should have.
protected String	getTypeName(TableColumn column)
boolean	isColumnCaseSensitive() Determines whether casing of columns should be fixed.
boolean	shouldDropKey(Table targetTable, Table currentTable, Key key) Determines if the given key should be dropped.

Methods inherited from class sirius.db.jdbc.schema.BasicDatabaseDialect

areColumnsEqual, areDefaultsDifferent, checkColumnSettings, checkForEquality, completeTableInfos, ensurePositiveLength, equalValue, generateAddForeignKey, generateAddKey, generateAlterForeignKey, generateAlterKey, generateAlterPrimaryKey, generateDropColumn, generateDropForeignKey, generateDropKey, generateDropTable, getDefaultValueAsString, getEffectiveKeyName, getEngine, getJDBCType, hasEscapedDefaultValue, in, isNeedsQuotation, resolveType, translateColumnName

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLDatabaseDialect

public MySQLDatabaseDialect()

Method Detail

areTypesEqual

protected boolean areTypesEqual(int type,
                                int other)

Overrides:

areTypesEqual in class BasicDatabaseDialect

getTypeName

protected String getTypeName(TableColumn column)

Overrides:

getTypeName in class BasicDatabaseDialect

generateAddColumn

public String generateAddColumn(Table table,
                                TableColumn col)

Description copied from interface: DatabaseDialect

Generates an alter statement to add the given column.

Parameters:

table - the table to alter

col - the column to create

Returns:

the generated SQL statement

generateAlterColumnTo

public List<String> generateAlterColumnTo(Table table,
                                          String oldName,
                                          TableColumn toColumn)

Description copied from interface: DatabaseDialect

Alters the given column.

Parameters:

table - the table to alter

oldName - the old name of the column (if it was renamed)

toColumn - the column as expected in the schema

Returns:

the generated SQL statement

generateCreateTable

public String generateCreateTable(Table table)

Description copied from interface: DatabaseDialect

Builds a CREATE TABLE statement.

Parameters:

table - the table to create

Returns:

the generated SQL statement

isColumnCaseSensitive

public boolean isColumnCaseSensitive()

Description copied from interface: DatabaseDialect

Determines whether casing of columns should be fixed.

Returns:

true if column names are case sensitive

shouldDropKey

public boolean shouldDropKey(Table targetTable,
                             Table currentTable,
                             Key key)

Description copied from interface: DatabaseDialect

Determines if the given key should be dropped.

Parameters:

targetTable - the table being referenced

currentTable - the table referencing another

key - the key which defines the reference

Returns:

true if the key should be dropped, false otherwise

getConstraintCharacterLimit

protected int getConstraintCharacterLimit()

Description copied from class: BasicDatabaseDialect

Determines the length a constraint should have.

Overrides:

getConstraintCharacterLimit in class BasicDatabaseDialect

Returns:

the maximum allowed length of a constraint