liquibase.database.core

Class MySQLDatabase

java.lang.Object

liquibase.database.AbstractJdbcDatabase

liquibase.database.core.MySQLDatabase

All Implemented Interfaces:

Database, PrioritizedService

public class MySQLDatabase
extends AbstractJdbcDatabase

Encapsulates MySQL database support.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	PRODUCT_NAME

Fields inherited from class liquibase.database.AbstractJdbcDatabase

currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingEndCharacter, quotingStartCharacter, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercased

Fields inherited from interface liquibase.servicelocator.PrioritizedService

PRIORITY_DATABASE, PRIORITY_DEFAULT

Constructor Summary

Constructors

Constructor and Description
MySQLDatabase()

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	correctObjectName(java.lang.String name, java.lang.Class<? extends DatabaseObject> objectType) Fix the object name to the format the database expects, handling changes in case, etc.
boolean	createsIndexesForForeignKeys()
boolean	disableForeignKeyChecks()
void	enableForeignKeyChecks()
java.lang.String	escapeIndexName(java.lang.String catalogName, java.lang.String schemaName, java.lang.String indexName)
java.lang.String	escapeStringForDatabase(java.lang.String string)
protected boolean	generateAutoIncrementBy(java.math.BigInteger incrementBy)
protected java.lang.String	getAutoIncrementClause()
protected java.lang.String	getAutoIncrementClosing()
protected java.lang.String	getAutoIncrementOpening()
protected java.lang.String	getAutoIncrementStartWithClause()
java.lang.String	getConcatSql(java.lang.String... values) Returns SQL to concat the passed values.
protected java.lang.String	getDefaultDatabaseProductName()
java.lang.String	getDefaultDriver(java.lang.String url) If this database understands the given url, return the default driver class name.
java.lang.Integer	getDefaultPort()
java.lang.String	getLineComment() Returns database-specific line comment string.
int	getPriority()
CatalogAndSchema	getSchemaFromJdbcInfo(java.lang.String rawCatalogName, java.lang.String rawSchemaName)
java.lang.String	getShortName() Returns an all-lower-case short name of the product.
boolean	isCorrectDatabaseImplementation(DatabaseConnection conn) Is this AbstractDatabase subclass the correct one to use for the given connection.
boolean	isReservedWord(java.lang.String string)
boolean	supportsCatalogs()
boolean	supportsForeignKeyDisable()
boolean	supportsInitiallyDeferrableColumns() Returns whether this database support initially deferrable columns.
boolean	supportsSchemas()
boolean	supportsSequences() Does the database type support sequence.
boolean	supportsTablespaces()

Methods inherited from class liquibase.database.AbstractJdbcDatabase

canCreateChangeLogTable, checkDatabaseChangeLogLockTable, checkDatabaseChangeLogTable, close, commit, correctSchema, correctSchema, dataTypeIsNotModifiable, doesTagExist, dropDatabaseObjects, equals, escapeColumnName, escapeColumnNameList, escapeConstraintName, escapeObjectName, escapeObjectName, escapeSequenceName, escapeTableName, escapeViewName, execute, executeRollbackStatements, executeStatements, generateAutoIncrementStartWith, generateDatabaseFunctionValue, generatePrimaryKeyName, getAutoCommitMode, getAutoIncrementByClause, getAutoIncrementClause, getConnection, getConnectionCatalogName, getConnectionSchemaName, getContainingObjects, getCurrentDateTimeFunction, getDatabaseChangeLogLockTableName, getDatabaseChangeLogTableName, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataTypeMaxParameters, getDateFunctions, getDateLiteral, getDateLiteral, getDateLiteral, getDateTimeLiteral, getDefaultCatalogName, getDefaultSchema, getDefaultSchemaName, getJdbcCatalogName, getJdbcCatalogName, getJdbcSchemaName, getJdbcSchemaName, getLiquibaseCatalogName, getLiquibaseSchemaName, getLiquibaseTablespaceName, getName, getNextChangeSetSequenceValue, getObjectQuotingStrategy, getOutputDefaultCatalog, getOutputDefaultSchema, getRanChangeSet, getRanChangeSetList, getRanDate, getRunStatus, getSystemTables, getSystemViews, getTimeLiteral, getViewDefinition, hasDatabaseChangeLogLockTable, hasDatabaseChangeLogTable, hashCode, isAutoCommit, isCaseSensitive, isDatabaseChangeLogLockTableInitialized, isDateOnly, isDateTime, isDefaultCatalog, isDefaultSchema, isFunction, isLiquibaseObject, isSafeToRunUpdate, isSystemObject, isSystemView, isTimeOnly, jdbcCallsCatalogsSchemas, markChangeSetExecStatus, parseDate, quoteObject, removeRanStatus, requiresPassword, requiresUsername, resetInternalState, resetRanChangeSetList, rollback, saveRollbackStatement, saveStatements, setAutoCommit, setCanCacheLiquibaseTableInfo, setConnection, setCurrentDateTimeFunction, setDatabaseChangeLogLockTableName, setDatabaseChangeLogTableName, setDefaultCatalogName, setDefaultSchemaName, setLiquibaseCatalogName, setLiquibaseSchemaName, setLiquibaseTablespaceName, setObjectQuotingStrategy, setOutputDefaultCatalog, setOutputDefaultSchema, startsWithNumeric, supportsAutoIncrement, supportsCatalogInObjectName, supportsDDLInTransaction, supportsDropTableCascadeConstraints, supportsPrimaryKeyNames, supportsRestrictForeignKeys, tag, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

PRODUCT_NAME

public static final java.lang.String PRODUCT_NAME

See Also:

Constant Field Values

Constructor Detail

MySQLDatabase

public MySQLDatabase()

Method Detail

getShortName

public java.lang.String getShortName()

Description copied from interface: Database

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

correctObjectName

public java.lang.String correctObjectName(java.lang.String name,
                                 java.lang.Class<? extends DatabaseObject> objectType)

Description copied from interface: Database

Fix the object name to the format the database expects, handling changes in case, etc.

Specified by:

correctObjectName in interface Database

Overrides:

correctObjectName in class AbstractJdbcDatabase

getDefaultDatabaseProductName

protected java.lang.String getDefaultDatabaseProductName()

Specified by:

getDefaultDatabaseProductName in class AbstractJdbcDatabase

getDefaultPort

public java.lang.Integer getDefaultPort()

getPriority

public int getPriority()

isCorrectDatabaseImplementation

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn)
                                        throws DatabaseException

Description copied from interface: Database

Is this AbstractDatabase subclass the correct one to use for the given connection.

Throws:

DatabaseException

getDefaultDriver

public java.lang.String getDefaultDriver(java.lang.String url)

Description copied from interface: Database

If this database understands the given url, return the default driver class name. Otherwise return null.

supportsSequences

public boolean supportsSequences()

Description copied from class: AbstractJdbcDatabase

Does the database type support sequence.

Specified by:

supportsSequences in interface Database

Overrides:

supportsSequences in class AbstractJdbcDatabase

supportsInitiallyDeferrableColumns

public boolean supportsInitiallyDeferrableColumns()

Description copied from interface: Database

Returns whether this database support initially deferrable columns.

getLineComment

public java.lang.String getLineComment()

Description copied from class: AbstractJdbcDatabase

Returns database-specific line comment string.

Specified by:

getLineComment in interface Database

Overrides:

getLineComment in class AbstractJdbcDatabase

getAutoIncrementClause

protected java.lang.String getAutoIncrementClause()

Overrides:

getAutoIncrementClause in class AbstractJdbcDatabase

generateAutoIncrementBy

protected boolean generateAutoIncrementBy(java.math.BigInteger incrementBy)

Overrides:

generateAutoIncrementBy in class AbstractJdbcDatabase

getAutoIncrementOpening

protected java.lang.String getAutoIncrementOpening()

Overrides:

getAutoIncrementOpening in class AbstractJdbcDatabase

getAutoIncrementClosing

protected java.lang.String getAutoIncrementClosing()

Overrides:

getAutoIncrementClosing in class AbstractJdbcDatabase

getAutoIncrementStartWithClause

protected java.lang.String getAutoIncrementStartWithClause()

Overrides:

getAutoIncrementStartWithClause in class AbstractJdbcDatabase

getConcatSql

public java.lang.String getConcatSql(java.lang.String... values)

Description copied from interface: Database

Returns SQL to concat the passed values.

Specified by:

getConcatSql in interface Database

Overrides:

getConcatSql in class AbstractJdbcDatabase

supportsTablespaces

public boolean supportsTablespaces()

supportsSchemas

public boolean supportsSchemas()

Specified by:

supportsSchemas in interface Database

Overrides:

supportsSchemas in class AbstractJdbcDatabase

supportsCatalogs

public boolean supportsCatalogs()

Specified by:

supportsCatalogs in interface Database

Overrides:

supportsCatalogs in class AbstractJdbcDatabase

escapeIndexName

public java.lang.String escapeIndexName(java.lang.String catalogName,
                               java.lang.String schemaName,
                               java.lang.String indexName)

Specified by:

escapeIndexName in interface Database

Overrides:

escapeIndexName in class AbstractJdbcDatabase

supportsForeignKeyDisable

public boolean supportsForeignKeyDisable()

Specified by:

supportsForeignKeyDisable in interface Database

Overrides:

supportsForeignKeyDisable in class AbstractJdbcDatabase

disableForeignKeyChecks

public boolean disableForeignKeyChecks()
                                throws DatabaseException

Specified by:

disableForeignKeyChecks in interface Database

Overrides:

disableForeignKeyChecks in class AbstractJdbcDatabase

Throws:

DatabaseException

enableForeignKeyChecks

public void enableForeignKeyChecks()
                            throws DatabaseException

Specified by:

enableForeignKeyChecks in interface Database

Overrides:

enableForeignKeyChecks in class AbstractJdbcDatabase

Throws:

DatabaseException

getSchemaFromJdbcInfo

public CatalogAndSchema getSchemaFromJdbcInfo(java.lang.String rawCatalogName,
                                     java.lang.String rawSchemaName)

Overrides:

getSchemaFromJdbcInfo in class AbstractJdbcDatabase

escapeStringForDatabase

public java.lang.String escapeStringForDatabase(java.lang.String string)

Specified by:

escapeStringForDatabase in interface Database

Overrides:

escapeStringForDatabase in class AbstractJdbcDatabase

createsIndexesForForeignKeys

public boolean createsIndexesForForeignKeys()

Specified by:

createsIndexesForForeignKeys in interface Database

Overrides:

createsIndexesForForeignKeys in class AbstractJdbcDatabase

isReservedWord

public boolean isReservedWord(java.lang.String string)

Specified by:

isReservedWord in interface Database

Overrides:

isReservedWord in class AbstractJdbcDatabase