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, TEMPLATEFields 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 TypeMethodDescriptionvoidalterColumnType(Connection connection, String tableName, String columnName, String newColumnType) voidalterTableDropColumn(Connection connection, String tableName, String columnName) protected final voiddoRenameTables(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[]booleanbooleanbooleanprotected StringMethods 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, updateIndexesMethods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods 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:
alterColumnTypein interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
alterColumnTypein classBaseDB- Throws:
Exception
-
alterTableDropColumn
public void alterTableDropColumn(Connection connection, String tableName, String columnName) throws Exception - Specified by:
alterTableDropColumnin interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
alterTableDropColumnin classBaseDB- Throws:
Exception
-
buildSQL
- Specified by:
buildSQLin interfacecom.liferay.portal.kernel.dao.db.DB- Specified by:
buildSQLin classBaseDB- Throws:
IOException
-
getIndexes
public List<com.liferay.portal.kernel.dao.db.Index> getIndexes(Connection connection) throws SQLException - Specified by:
getIndexesin interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
getIndexesin classBaseDB- Throws:
SQLException
-
getNewUuidFunctionName
-
getPopulateSQL
-
getRecreateSQL
-
isSupportsDBPartition
public boolean isSupportsDBPartition()- Specified by:
isSupportsDBPartitionin interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
isSupportsDBPartitionin classBaseDB
-
isSupportsNewUuidFunction
public boolean isSupportsNewUuidFunction() -
isSupportsUpdateWithInnerJoin
public boolean isSupportsUpdateWithInnerJoin()- Specified by:
isSupportsUpdateWithInnerJoinin interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
isSupportsUpdateWithInnerJoinin classBaseDB
-
doRenameTables
protected final void doRenameTables(Connection connection, com.liferay.portal.kernel.util.ObjectValuePair<String, String>... tableNameObjectValuePairs) throws Exception- Overrides:
doRenameTablesin classBaseDB- Throws:
Exception
-
getSQLTypes
protected int[] getSQLTypes()- Specified by:
getSQLTypesin classBaseDB
-
getTemplate
- Specified by:
getTemplatein classBaseDB
-
reword
- Specified by:
rewordin classBaseDB- Throws:
IOException
-