Package com.liferay.portal.dao.db
Class MySQLDB
Object
com.liferay.portal.dao.db.BaseDB
com.liferay.portal.dao.db.MySQLDB
- All Implemented Interfaces:
com.liferay.portal.kernel.dao.db.DB
- Direct Known Subclasses:
MariaDBDB
- Author:
- Alexander Chow, Sandeep Soni, Ganesh Ram
-
Field Summary
Fields inherited from class com.liferay.portal.dao.db.BaseDB
ALTER_COLUMN_NAME, ALTER_COLUMN_TYPE, ALTER_TABLE_NAME, columnTypePattern, CREATE_TABLE, DROP_INDEX, DROP_PRIMARY_KEY, RENAME_TABLE_TEMPLATE, REWORD_TEMPLATE, SQL_VARCHAR_TYPES, TEMPLATE
Fields inherited from interface com.liferay.portal.kernel.dao.db.DB
SQL_SIZE_NONE, SQL_VARCHAR_MAX_SIZE, SQL_VARCHAR_MAX_SIZE_THRESHOLD
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
alterColumnType
(Connection connection, String tableName, String columnName, String newColumnType) void
alterTableDropColumn
(Connection connection, String tableName, String columnName) protected final void
doRenameTables
(Connection connection, com.liferay.portal.kernel.util.ObjectValuePair<String, String>... tableNameObjectValuePairs) List<com.liferay.portal.kernel.dao.db.Index>
getIndexes
(Connection connection) getPopulateSQL
(String databaseName, String sqlContent) getRecreateSQL
(String databaseName) protected int[]
protected String[]
boolean
boolean
boolean
protected String
Methods inherited from class com.liferay.portal.dao.db.BaseDB
addIndexes, addPrimaryKey, alterColumnName, alterTableAddColumn, buildColumnNameTokens, buildColumnTypeTokens, buildTableNameTokens, copyTableRows, copyTableStructure, createSyncDeleteTrigger, createSyncInsertTrigger, createSyncUpdateTrigger, dropIndexes, dropIndexes, dropTrigger, getCopyTableStructureSQL, getDBType, getDefaultValue, getIndexColumnName, getIndexMetadatas, getIndexResultSet, getMajorVersion, getMinorVersion, getPrimaryKeyColumnNames, getRenameTableSQL, getSQLType, getSQLTypeDecimalDigits, getSQLTypeSize, getSQLVarcharSizes, getTemplateBlob, getTemplateFalse, getTemplateTrue, getVersionString, isSupportsAlterColumnName, isSupportsAlterColumnType, isSupportsDDLRollback, isSupportsDuplicatedIndexName, isSupportsInlineDistinct, isSupportsQueryingAfterException, isSupportsScrollableResults, isSupportsStringCaseSensitiveQuery, limitColumnLength, process, removePrimaryKey, renameTables, replaceTemplate, runSQL, runSQL, runSQL, runSQL, runSQLTemplate, runSQLTemplate, setSupportsStringCaseSensitiveQuery, syncTables, updateIndexes
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface com.liferay.portal.kernel.dao.db.DB
runSQL, runSQL, runSQLTemplateString, runSQLTemplateString
-
Constructor Details
-
MySQLDB
public MySQLDB(int majorVersion, int minorVersion) -
MySQLDB
protected MySQLDB(com.liferay.portal.kernel.dao.db.DBType dbType, int majorVersion, int minorVersion)
-
-
Method Details
-
alterColumnType
public void alterColumnType(Connection connection, String tableName, String columnName, String newColumnType) throws Exception - Specified by:
alterColumnType
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
alterColumnType
in classBaseDB
- Throws:
Exception
-
alterTableDropColumn
public void alterTableDropColumn(Connection connection, String tableName, String columnName) throws Exception - Specified by:
alterTableDropColumn
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
alterTableDropColumn
in classBaseDB
- Throws:
Exception
-
buildSQL
- Specified by:
buildSQL
in interfacecom.liferay.portal.kernel.dao.db.DB
- Specified by:
buildSQL
in classBaseDB
- Throws:
IOException
-
getIndexes
public List<com.liferay.portal.kernel.dao.db.Index> getIndexes(Connection connection) throws SQLException - Specified by:
getIndexes
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
getIndexes
in classBaseDB
- Throws:
SQLException
-
getNewUuidFunctionName
-
getPopulateSQL
-
getRecreateSQL
-
isSupportsDBPartition
public boolean isSupportsDBPartition()- Specified by:
isSupportsDBPartition
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
isSupportsDBPartition
in classBaseDB
-
isSupportsNewUuidFunction
public boolean isSupportsNewUuidFunction() -
isSupportsUpdateWithInnerJoin
public boolean isSupportsUpdateWithInnerJoin()- Specified by:
isSupportsUpdateWithInnerJoin
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
isSupportsUpdateWithInnerJoin
in classBaseDB
-
doRenameTables
protected final void doRenameTables(Connection connection, com.liferay.portal.kernel.util.ObjectValuePair<String, String>... tableNameObjectValuePairs) throws Exception- Overrides:
doRenameTables
in classBaseDB
- Throws:
Exception
-
getSQLTypes
protected int[] getSQLTypes()- Specified by:
getSQLTypes
in classBaseDB
-
getTemplate
- Specified by:
getTemplate
in classBaseDB
-
reword
- Specified by:
reword
in classBaseDB
- Throws:
IOException
-