public class MySQLDatabase extends AbstractJdbcDatabase
| Modifier and Type | Field and Description |
|---|---|
static String |
PRODUCT_NAME |
caseSensitive, currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingEndCharacter, quotingEndReplacement, quotingStartCharacter, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercasedCOMPARATOR, PRIORITY_DATABASE, PRIORITY_DEFAULT| Constructor and Description |
|---|
MySQLDatabase() |
| Modifier and Type | Method and Description |
|---|---|
String |
correctObjectName(String name,
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() |
String |
escapeIndexName(String catalogName,
String schemaName,
String indexName) |
String |
escapeStringForDatabase(String string) |
protected boolean |
generateAutoIncrementBy(BigInteger incrementBy) |
protected boolean |
generateAutoIncrementStartWith(BigInteger startWith) |
protected String |
getAutoIncrementClause() |
protected String |
getAutoIncrementClosing() |
protected String |
getAutoIncrementOpening() |
protected String |
getAutoIncrementStartWithClause() |
String |
getConcatSql(String... values)
Returns SQL to concat the passed values.
|
int |
getDatabasePatchVersion() |
protected String |
getDefaultDatabaseProductName() |
String |
getDefaultDriver(String url)
If this database understands the given url, return the default driver class name.
|
Integer |
getDefaultPort() |
String |
getLineComment()
Returns database-specific line comment string.
|
int |
getPriority() |
CatalogAndSchema |
getSchemaFromJdbcInfo(String rawCatalogName,
String rawSchemaName) |
String |
getShortName()
Returns an all-lower-case short name of the product.
|
String |
getTableOptionAutoIncrementStartWithClause(BigInteger startWith) |
boolean |
isCorrectDatabaseImplementation(DatabaseConnection conn)
Is this AbstractDatabase subclass the correct one to use for the given connection.
|
boolean |
isReservedWord(String string) |
protected boolean |
mustQuoteObjectName(String objectName,
Class<? extends DatabaseObject> objectType) |
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() |
addReservedWords, canCreateChangeLogTable, close, commit, correctSchema, correctSchema, dataTypeIsNotModifiable, doesTagExist, dropDatabaseObjects, equals, escapeColumnName, escapeColumnName, escapeColumnNameList, escapeConstraintName, escapeDataTypeName, escapeObjectName, escapeObjectName, escapeSequenceName, escapeTableName, escapeViewName, execute, executeRollbackStatements, executeRollbackStatements, executeStatements, filterRollbackVisitors, generateDatabaseFunctionValue, generatePrimaryKeyName, get, getAutoCommitMode, getAutoIncrementByClause, getAutoIncrementClause, getConnection, getConnectionCatalogName, getConnectionSchemaName, getConnectionSchemaNameCallStatement, getContainingObjects, getCurrentDateTimeFunction, getDatabaseChangeLogLockTableName, getDatabaseChangeLogTableName, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataTypeMaxParameters, getDateFunctions, getDateLiteral, getDateLiteral, getDateLiteral, getDateTimeLiteral, getDefaultCatalogName, getDefaultSchema, getDefaultSchemaName, getFetchSize, getJdbcCatalogName, getJdbcCatalogName, getJdbcSchemaName, getJdbcSchemaName, getLiquibaseCatalogName, getLiquibaseSchemaName, getLiquibaseTablespaceName, getName, getObjectQuotingStrategy, getOutputDefaultCatalog, getOutputDefaultSchema, getRanChangeSet, getRanChangeSetList, getRanDate, getRunStatus, getSystemSchema, getSystemTables, getSystemViews, getTimeLiteral, getViewDefinition, hashCode, isAutoCommit, isCaseSensitive, isDateOnly, isDateTime, isDefaultCatalog, isDefaultSchema, isFunction, isLiquibaseObject, isSafeToRunUpdate, isSystemObject, isSystemView, isTimeOnly, isTimestamp, jdbcCallsCatalogsSchemas, markChangeSetExecStatus, parseDate, quoteObject, removeRanStatus, requiresPassword, requiresUsername, resetInternalState, rollback, saveRollbackStatement, saveStatements, set, setAutoCommit, setCanCacheLiquibaseTableInfo, setCaseSensitive, setConnection, setCurrentDateTimeFunction, setDatabaseChangeLogLockTableName, setDatabaseChangeLogTableName, setDefaultCatalogName, setDefaultSchemaName, setLiquibaseCatalogName, setLiquibaseSchemaName, setLiquibaseTablespaceName, setObjectQuotingStrategy, setOutputDefaultCatalog, setOutputDefaultSchema, startsWithNumeric, supportsAutoIncrement, supportsCatalogInObjectName, supportsDDLInTransaction, supportsDropTableCascadeConstraints, supportsPrimaryKeyNames, supportsRestrictForeignKeys, tag, toString, unescapeDataTypeName, unescapeDataTypeString, validatepublic static final String PRODUCT_NAME
public String getShortName()
Databasepublic String correctObjectName(String name, Class<? extends DatabaseObject> objectType)
DatabasecorrectObjectName in interface DatabasecorrectObjectName in class AbstractJdbcDatabaseprotected String getDefaultDatabaseProductName()
getDefaultDatabaseProductName in class AbstractJdbcDatabasepublic Integer getDefaultPort()
public int getPriority()
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException
DatabaseDatabaseExceptionpublic String getDefaultDriver(String url)
Databasepublic boolean supportsSequences()
AbstractJdbcDatabasesupportsSequences in interface DatabasesupportsSequences in class AbstractJdbcDatabasepublic boolean supportsInitiallyDeferrableColumns()
Databaseprotected boolean mustQuoteObjectName(String objectName, Class<? extends DatabaseObject> objectType)
mustQuoteObjectName in class AbstractJdbcDatabasepublic String getLineComment()
AbstractJdbcDatabasegetLineComment in interface DatabasegetLineComment in class AbstractJdbcDatabaseprotected String getAutoIncrementClause()
getAutoIncrementClause in class AbstractJdbcDatabaseprotected boolean generateAutoIncrementStartWith(BigInteger startWith)
generateAutoIncrementStartWith in class AbstractJdbcDatabasepublic String getTableOptionAutoIncrementStartWithClause(BigInteger startWith)
protected boolean generateAutoIncrementBy(BigInteger incrementBy)
generateAutoIncrementBy in class AbstractJdbcDatabaseprotected String getAutoIncrementOpening()
getAutoIncrementOpening in class AbstractJdbcDatabaseprotected String getAutoIncrementClosing()
getAutoIncrementClosing in class AbstractJdbcDatabaseprotected String getAutoIncrementStartWithClause()
getAutoIncrementStartWithClause in class AbstractJdbcDatabasepublic String getConcatSql(String... values)
DatabasegetConcatSql in interface DatabasegetConcatSql in class AbstractJdbcDatabasepublic boolean supportsTablespaces()
public boolean supportsSchemas()
supportsSchemas in interface DatabasesupportsSchemas in class AbstractJdbcDatabasepublic boolean supportsCatalogs()
supportsCatalogs in interface DatabasesupportsCatalogs in class AbstractJdbcDatabasepublic String escapeIndexName(String catalogName, String schemaName, String indexName)
escapeIndexName in interface DatabaseescapeIndexName in class AbstractJdbcDatabasepublic boolean supportsForeignKeyDisable()
supportsForeignKeyDisable in interface DatabasesupportsForeignKeyDisable in class AbstractJdbcDatabasepublic boolean disableForeignKeyChecks()
throws DatabaseException
disableForeignKeyChecks in interface DatabasedisableForeignKeyChecks in class AbstractJdbcDatabaseDatabaseExceptionpublic void enableForeignKeyChecks()
throws DatabaseException
enableForeignKeyChecks in interface DatabaseenableForeignKeyChecks in class AbstractJdbcDatabaseDatabaseExceptionpublic CatalogAndSchema getSchemaFromJdbcInfo(String rawCatalogName, String rawSchemaName)
getSchemaFromJdbcInfo in class AbstractJdbcDatabasepublic String escapeStringForDatabase(String string)
escapeStringForDatabase in interface DatabaseescapeStringForDatabase in class AbstractJdbcDatabasepublic boolean createsIndexesForForeignKeys()
createsIndexesForForeignKeys in interface DatabasecreatesIndexesForForeignKeys in class AbstractJdbcDatabasepublic boolean isReservedWord(String string)
isReservedWord in interface DatabaseisReservedWord in class AbstractJdbcDatabasepublic int getDatabasePatchVersion()
throws DatabaseException
DatabaseExceptionCopyright © 2018 Liquibase.org. All rights reserved.