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

public class MySQLDB
extends BaseDB

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, CREATE_TABLE, DROP_INDEX, DROP_PRIMARY_KEY, RENAME_TABLE_TEMPLATE, REWORD_TEMPLATE, TEMPLATE

Fields inherited from interface com.liferay.portal.kernel.dao.db.DB

BARE, DEFAULT

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	MySQLDB(com.liferay.portal.kernel.dao.db.DBType dbType, int majorVersion, int minorVersion)
	MySQLDB(int majorVersion, int minorVersion)

Method Summary

Modifier and Type	Method and Description
protected String	buildCreateFileContent(String sqlDir, String databaseName, int population)
String	buildSQL(String template)
List<com.liferay.portal.kernel.dao.db.Index>	getIndexes(Connection con)
protected String	getServerName()
protected String[]	getTemplate()
boolean	isSupportsUpdateWithInnerJoin()
protected String	reword(String data)

Methods inherited from class com.liferay.portal.dao.db.BaseDB

addIndexes, applyMaxStringIndexLengthLimitation, buildColumnNameTokens, buildColumnTypeTokens, buildCreateFile, buildCreateFile, buildSQLFile, buildTableNameTokens, buildTemplate, convertTimestamp, dropIndexes, evaluateVM, getCreateTablesContent, getDBType, getMajorVersion, getMinorVersion, getSuffix, getTemplateBlob, getTemplateFalse, getTemplateTrue, getVersionString, handleSQLException, increment, increment, increment, isSupportsAlterColumnName, isSupportsAlterColumnType, isSupportsInlineDistinct, isSupportsQueryingAfterException, isSupportsScrollableResults, isSupportsStringCaseSensitiveQuery, readFile, readSQL, removeBooleanIndexes, removeInserts, removeLongInserts, removeNull, replaceTemplate, runSQL, runSQL, runSQL, runSQL, runSQLTemplate, runSQLTemplate, runSQLTemplateString, runSQLTemplateString, setSupportsStringCaseSensitiveQuery, updateIndexes

Methods inherited from class 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

Constructor Detail

MySQLDB

public MySQLDB(int majorVersion,
               int minorVersion)

MySQLDB

protected MySQLDB(com.liferay.portal.kernel.dao.db.DBType dbType,
                  int majorVersion,
                  int minorVersion)

Method Detail

buildSQL

public String buildSQL(String template)
                throws IOException

Specified by:

buildSQL in interface com.liferay.portal.kernel.dao.db.DB

Specified by:

buildSQL in class BaseDB

Throws:

IOException

getIndexes

public List<com.liferay.portal.kernel.dao.db.Index> getIndexes(Connection con)
                                                        throws SQLException

Specified by:

getIndexes in interface com.liferay.portal.kernel.dao.db.DB

Overrides:

getIndexes in class BaseDB

Throws:

SQLException

isSupportsUpdateWithInnerJoin

public boolean isSupportsUpdateWithInnerJoin()

Specified by:

isSupportsUpdateWithInnerJoin in interface com.liferay.portal.kernel.dao.db.DB

Overrides:

isSupportsUpdateWithInnerJoin in class BaseDB

buildCreateFileContent

protected String buildCreateFileContent(String sqlDir,
                                        String databaseName,
                                        int population)
                                 throws IOException

Specified by:

buildCreateFileContent in class BaseDB

Throws:

IOException

getServerName

protected String getServerName()

Specified by:

getServerName in class BaseDB

getTemplate

protected String[] getTemplate()

Specified by:

getTemplate in class BaseDB

reword

protected String reword(String data)
                 throws IOException

Specified by:

reword in class BaseDB

Throws:

IOException