com.liferay.portal.dao.db

Class PostgreSQLDB

Object

com.liferay.portal.dao.db.BaseDB

com.liferay.portal.dao.db.PostgreSQLDB

All Implemented Interfaces:

com.liferay.portal.kernel.dao.db.DB

public class PostgreSQLDB
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

Constructor and Description
PostgreSQLDB(int majorVersion, int minorVersion)

Method Summary

Modifier and Type	Method and Description
String	buildSQL(String template)
static String	getCreateRulesSQL(String tableName, String columnName)
List<com.liferay.portal.kernel.dao.db.Index>	getIndexes(Connection con)
String	getPopulateSQL(String databaseName, String sqlContent)
String	getRecreateSQL(String databaseName)
protected int[]	getSQLTypes()
protected String[]	getTemplate()
boolean	isSupportsQueryingAfterException()
protected String	reword(String data)

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

addIndexes, buildColumnNameTokens, buildColumnTypeTokens, buildCreateFile, buildCreateFile, buildSQLFile, buildTableNameTokens, dropIndexes, getDBType, getMajorVersion, getMinorVersion, getSQLType, getTemplateBlob, getTemplateFalse, getTemplateTrue, getVersionString, increment, increment, increment, isSupportsAlterColumnName, isSupportsAlterColumnType, isSupportsInlineDistinct, isSupportsScrollableResults, isSupportsStringCaseSensitiveQuery, isSupportsUpdateWithInnerJoin, replaceTemplate, runSQL, runSQL, runSQL, runSQL, runSQLTemplate, runSQLTemplate, runSQLTemplateString, runSQLTemplateString, 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

getNewUuidFunctionName, isSupportsNewUuidFunction, runSQL, runSQL

Constructor Detail

PostgreSQLDB

public PostgreSQLDB(int majorVersion,
                    int minorVersion)

Method Detail

getCreateRulesSQL

public static String getCreateRulesSQL(String tableName,
                                       String columnName)

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

getPopulateSQL

public String getPopulateSQL(String databaseName,
                             String sqlContent)

getRecreateSQL

public String getRecreateSQL(String databaseName)

isSupportsQueryingAfterException

public boolean isSupportsQueryingAfterException()

Specified by:

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

Overrides:

isSupportsQueryingAfterException in class BaseDB

getSQLTypes

protected int[] getSQLTypes()

Specified by:

getSQLTypes 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