com.liferay.portal.tools.sql
Class DBUtil
java.lang.Object
com.liferay.portal.tools.sql.DBUtil
- All Implemented Interfaces:
- com.liferay.portal.tools.sql.DB
- Direct Known Subclasses:
- DB2Util, DerbyUtil, FirebirdUtil, HypersonicUtil, InformixUtil, IngresUtil, MySQLUtil, OracleUtil, PostgreSQLUtil, SAPUtil, SQLServerUtil, SybaseUtil
public abstract class DBUtil
- extends java.lang.Object
- implements com.liferay.portal.tools.sql.DB
View Source
- Author:
- Alexander Chow, Ganesh Ram
Constructor Summary |
protected |
DBUtil(java.lang.String type)
|
Method Summary |
protected java.lang.String[] |
buildColumnNameTokens(java.lang.String line)
|
protected java.lang.String[] |
buildColumnTypeTokens(java.lang.String line)
|
void |
buildCreateFile(java.lang.String databaseName)
|
void |
buildCreateFile(java.lang.String databaseName,
int population)
|
protected abstract java.lang.String |
buildCreateFileContent(java.lang.String databaseName,
int population)
|
abstract java.lang.String |
buildSQL(java.lang.String template)
|
void |
buildSQLFile(java.lang.String fileName)
|
protected java.lang.String |
buildTemplate(java.lang.String fileName)
|
protected java.lang.String |
convertTimestamp(java.lang.String data)
|
protected java.lang.String |
evaluateVM(java.lang.String template)
|
static DBUtil |
getInstance()
|
static DBUtil |
getInstance(java.lang.String type)
|
protected abstract java.lang.String |
getServerName()
|
protected java.lang.String |
getSuffix(int type)
|
protected abstract java.lang.String[] |
getTemplate()
|
java.lang.String |
getTemplateFalse()
|
java.lang.String |
getTemplateTrue()
|
java.lang.String |
getType()
|
boolean |
isSupportsAlterColumnName()
|
boolean |
isSupportsAlterColumnType()
|
boolean |
isSupportsDateMilliseconds()
|
boolean |
isSupportsStringCaseSensitiveQuery()
|
boolean |
isSupportsUpdateWithInnerJoin()
|
protected java.lang.String |
readSQL(java.lang.String fileName,
java.lang.String comments,
java.lang.String eol)
|
protected java.lang.String |
removeBooleanIndexes(java.lang.String data)
|
protected java.lang.String |
removeInserts(java.lang.String data)
|
protected java.lang.String |
removeLongInserts(java.lang.String data)
|
protected java.lang.String |
removeNull(java.lang.String content)
|
protected java.lang.String |
replaceTemplate(java.lang.String template,
java.lang.String[] actual)
|
protected abstract java.lang.String |
reword(java.lang.String data)
|
void |
runSQL(java.sql.Connection con,
java.lang.String sql)
|
void |
runSQL(java.sql.Connection con,
java.lang.String[] sqls)
|
void |
runSQL(java.lang.String sql)
|
void |
runSQL(java.lang.String[] sqls)
|
void |
runSQLTemplate(java.lang.String path)
|
void |
runSQLTemplate(java.lang.String path,
boolean failOnError)
|
void |
runSQLTemplateString(java.lang.String template,
boolean evaluate,
boolean failOnError)
|
static void |
setInstance(org.hibernate.dialect.Dialect dialect)
|
void |
setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
MINIMAL
public static final int MINIMAL
- See Also:
- Constant Field Values
POPULATED
public static final int POPULATED
- See Also:
- Constant Field Values
SHARDED
public static final int SHARDED
- See Also:
- Constant Field Values
TYPE_DB2
public static final java.lang.String TYPE_DB2
- See Also:
- Constant Field Values
TYPE_DERBY
public static final java.lang.String TYPE_DERBY
- See Also:
- Constant Field Values
TYPE_FIREBIRD
public static final java.lang.String TYPE_FIREBIRD
- See Also:
- Constant Field Values
TYPE_HYPERSONIC
public static final java.lang.String TYPE_HYPERSONIC
- See Also:
- Constant Field Values
TYPE_INFORMIX
public static final java.lang.String TYPE_INFORMIX
- See Also:
- Constant Field Values
TYPE_INGRES
public static final java.lang.String TYPE_INGRES
- See Also:
- Constant Field Values
TYPE_INTERBASE
public static final java.lang.String TYPE_INTERBASE
- See Also:
- Constant Field Values
TYPE_JDATASTORE
public static final java.lang.String TYPE_JDATASTORE
- See Also:
- Constant Field Values
TYPE_MYSQL
public static final java.lang.String TYPE_MYSQL
- See Also:
- Constant Field Values
TYPE_ORACLE
public static final java.lang.String TYPE_ORACLE
- See Also:
- Constant Field Values
TYPE_POSTGRESQL
public static final java.lang.String TYPE_POSTGRESQL
- See Also:
- Constant Field Values
TYPE_SAP
public static final java.lang.String TYPE_SAP
- See Also:
- Constant Field Values
TYPE_SQLSERVER
public static final java.lang.String TYPE_SQLSERVER
- See Also:
- Constant Field Values
TYPE_SYBASE
public static final java.lang.String TYPE_SYBASE
- See Also:
- Constant Field Values
TYPE_ALL
public static final java.lang.String[] TYPE_ALL
ALTER_COLUMN_TYPE
protected static java.lang.String ALTER_COLUMN_TYPE
ALTER_COLUMN_NAME
protected static java.lang.String ALTER_COLUMN_NAME
DROP_PRIMARY_KEY
protected static java.lang.String DROP_PRIMARY_KEY
REWORD_TEMPLATE
protected static java.lang.String[] REWORD_TEMPLATE
TEMPLATE
protected static java.lang.String[] TEMPLATE
DBUtil
protected DBUtil(java.lang.String type)
getInstance
public static DBUtil getInstance()
getInstance
public static DBUtil getInstance(java.lang.String type)
setInstance
public static void setInstance(org.hibernate.dialect.Dialect dialect)
buildCreateFile
public void buildCreateFile(java.lang.String databaseName)
throws java.io.IOException
- Throws:
java.io.IOException
buildCreateFile
public void buildCreateFile(java.lang.String databaseName,
int population)
throws java.io.IOException
- Throws:
java.io.IOException
buildSQL
public abstract java.lang.String buildSQL(java.lang.String template)
throws java.io.IOException
- Throws:
java.io.IOException
buildSQLFile
public void buildSQLFile(java.lang.String fileName)
throws java.io.IOException
- Throws:
java.io.IOException
getTemplateFalse
public java.lang.String getTemplateFalse()
getTemplateTrue
public java.lang.String getTemplateTrue()
getType
public java.lang.String getType()
- Specified by:
getType
in interface com.liferay.portal.tools.sql.DB
isSupportsAlterColumnName
public boolean isSupportsAlterColumnName()
- Specified by:
isSupportsAlterColumnName
in interface com.liferay.portal.tools.sql.DB
isSupportsAlterColumnType
public boolean isSupportsAlterColumnType()
- Specified by:
isSupportsAlterColumnType
in interface com.liferay.portal.tools.sql.DB
isSupportsDateMilliseconds
public boolean isSupportsDateMilliseconds()
- Specified by:
isSupportsDateMilliseconds
in interface com.liferay.portal.tools.sql.DB
isSupportsStringCaseSensitiveQuery
public boolean isSupportsStringCaseSensitiveQuery()
- Specified by:
isSupportsStringCaseSensitiveQuery
in interface com.liferay.portal.tools.sql.DB
isSupportsUpdateWithInnerJoin
public boolean isSupportsUpdateWithInnerJoin()
- Specified by:
isSupportsUpdateWithInnerJoin
in interface com.liferay.portal.tools.sql.DB
runSQL
public void runSQL(java.lang.String sql)
throws java.io.IOException,
java.sql.SQLException
- Specified by:
runSQL
in interface com.liferay.portal.tools.sql.DB
- Throws:
java.io.IOException
java.sql.SQLException
runSQL
public void runSQL(java.sql.Connection con,
java.lang.String sql)
throws java.io.IOException,
java.sql.SQLException
- Throws:
java.io.IOException
java.sql.SQLException
runSQL
public void runSQL(java.lang.String[] sqls)
throws java.io.IOException,
java.sql.SQLException
- Throws:
java.io.IOException
java.sql.SQLException
runSQL
public void runSQL(java.sql.Connection con,
java.lang.String[] sqls)
throws java.io.IOException,
java.sql.SQLException
- Throws:
java.io.IOException
java.sql.SQLException
runSQLTemplate
public void runSQLTemplate(java.lang.String path)
throws java.io.IOException,
javax.naming.NamingException,
java.sql.SQLException
- Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException
runSQLTemplate
public void runSQLTemplate(java.lang.String path,
boolean failOnError)
throws java.io.IOException,
javax.naming.NamingException,
java.sql.SQLException
- Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException
runSQLTemplateString
public void runSQLTemplateString(java.lang.String template,
boolean evaluate,
boolean failOnError)
throws java.io.IOException,
javax.naming.NamingException,
java.sql.SQLException
- Throws:
java.io.IOException
javax.naming.NamingException
java.sql.SQLException
setSupportsStringCaseSensitiveQuery
public void setSupportsStringCaseSensitiveQuery(boolean supportsStringCaseSensitiveQuery)
buildCreateFileContent
protected abstract java.lang.String buildCreateFileContent(java.lang.String databaseName,
int population)
throws java.io.IOException
- Throws:
java.io.IOException
buildColumnNameTokens
protected java.lang.String[] buildColumnNameTokens(java.lang.String line)
buildColumnTypeTokens
protected java.lang.String[] buildColumnTypeTokens(java.lang.String line)
buildTemplate
protected java.lang.String buildTemplate(java.lang.String fileName)
throws java.io.IOException
- Throws:
java.io.IOException
convertTimestamp
protected java.lang.String convertTimestamp(java.lang.String data)
evaluateVM
protected java.lang.String evaluateVM(java.lang.String template)
throws java.lang.Exception
- Throws:
java.lang.Exception
getServerName
protected abstract java.lang.String getServerName()
getSuffix
protected java.lang.String getSuffix(int type)
getTemplate
protected abstract java.lang.String[] getTemplate()
readSQL
protected java.lang.String readSQL(java.lang.String fileName,
java.lang.String comments,
java.lang.String eol)
throws java.io.IOException
- Throws:
java.io.IOException
removeBooleanIndexes
protected java.lang.String removeBooleanIndexes(java.lang.String data)
throws java.io.IOException
- Throws:
java.io.IOException
removeInserts
protected java.lang.String removeInserts(java.lang.String data)
throws java.io.IOException
- Throws:
java.io.IOException
removeLongInserts
protected java.lang.String removeLongInserts(java.lang.String data)
throws java.io.IOException
- Throws:
java.io.IOException
removeNull
protected java.lang.String removeNull(java.lang.String content)
replaceTemplate
protected java.lang.String replaceTemplate(java.lang.String template,
java.lang.String[] actual)
reword
protected abstract java.lang.String reword(java.lang.String data)
throws java.io.IOException
- Throws:
java.io.IOException