public class MySQLDatabase extends AbstractJdbcDatabase
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
PRODUCT_NAME |
currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingEndCharacter, quotingStartCharacter, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercased
PRIORITY_DATABASE, PRIORITY_DEFAULT
Constructor and Description |
---|
MySQLDatabase() |
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() |
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
public static final java.lang.String PRODUCT_NAME
public java.lang.String getShortName()
Database
public java.lang.String correctObjectName(java.lang.String name, java.lang.Class<? extends DatabaseObject> objectType)
Database
correctObjectName
in interface Database
correctObjectName
in class AbstractJdbcDatabase
protected java.lang.String getDefaultDatabaseProductName()
getDefaultDatabaseProductName
in class AbstractJdbcDatabase
public java.lang.Integer getDefaultPort()
public int getPriority()
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException
Database
DatabaseException
public java.lang.String getDefaultDriver(java.lang.String url)
Database
public boolean supportsSequences()
AbstractJdbcDatabase
supportsSequences
in interface Database
supportsSequences
in class AbstractJdbcDatabase
public boolean supportsInitiallyDeferrableColumns()
Database
public java.lang.String getLineComment()
AbstractJdbcDatabase
getLineComment
in interface Database
getLineComment
in class AbstractJdbcDatabase
protected java.lang.String getAutoIncrementClause()
getAutoIncrementClause
in class AbstractJdbcDatabase
protected boolean generateAutoIncrementBy(java.math.BigInteger incrementBy)
generateAutoIncrementBy
in class AbstractJdbcDatabase
protected java.lang.String getAutoIncrementOpening()
getAutoIncrementOpening
in class AbstractJdbcDatabase
protected java.lang.String getAutoIncrementClosing()
getAutoIncrementClosing
in class AbstractJdbcDatabase
protected java.lang.String getAutoIncrementStartWithClause()
getAutoIncrementStartWithClause
in class AbstractJdbcDatabase
public java.lang.String getConcatSql(java.lang.String... values)
Database
getConcatSql
in interface Database
getConcatSql
in class AbstractJdbcDatabase
public boolean supportsTablespaces()
public boolean supportsSchemas()
supportsSchemas
in interface Database
supportsSchemas
in class AbstractJdbcDatabase
public boolean supportsCatalogs()
supportsCatalogs
in interface Database
supportsCatalogs
in class AbstractJdbcDatabase
public java.lang.String escapeIndexName(java.lang.String catalogName, java.lang.String schemaName, java.lang.String indexName)
escapeIndexName
in interface Database
escapeIndexName
in class AbstractJdbcDatabase
public boolean supportsForeignKeyDisable()
supportsForeignKeyDisable
in interface Database
supportsForeignKeyDisable
in class AbstractJdbcDatabase
public boolean disableForeignKeyChecks() throws DatabaseException
disableForeignKeyChecks
in interface Database
disableForeignKeyChecks
in class AbstractJdbcDatabase
DatabaseException
public void enableForeignKeyChecks() throws DatabaseException
enableForeignKeyChecks
in interface Database
enableForeignKeyChecks
in class AbstractJdbcDatabase
DatabaseException
public CatalogAndSchema getSchemaFromJdbcInfo(java.lang.String rawCatalogName, java.lang.String rawSchemaName)
getSchemaFromJdbcInfo
in class AbstractJdbcDatabase
public java.lang.String escapeStringForDatabase(java.lang.String string)
escapeStringForDatabase
in interface Database
escapeStringForDatabase
in class AbstractJdbcDatabase
public boolean createsIndexesForForeignKeys()
createsIndexesForForeignKeys
in interface Database
createsIndexesForForeignKeys
in class AbstractJdbcDatabase
public boolean isReservedWord(java.lang.String string)
isReservedWord
in interface Database
isReservedWord
in class AbstractJdbcDatabase