Package 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
- 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 TypeMethodDescriptionprotected void
createSyncDeleteTrigger
(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames) protected void
createSyncInsertTrigger
(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) protected void
createSyncUpdateTrigger
(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) protected void
dropTrigger
(Connection connection, String tableName, String triggerName) protected String
getCopyTableStructureSQL
(String tableName, String newTableName) static String
getCreateRulesSQL
(String tableName, String columnName) protected String
getIndexColumnName
(String indexColumnName) List<com.liferay.portal.kernel.dao.db.Index>
getIndexes
(Connection connection) getPopulateSQL
(String databaseName, String sqlContent) getRecreateSQL
(String databaseName) protected int[]
protected String[]
boolean
protected boolean
boolean
boolean
protected String
limitColumnLength
(String column, int length) protected String
Methods inherited from class com.liferay.portal.dao.db.BaseDB
addIndexes, addPrimaryKey, alterColumnName, alterColumnType, alterTableAddColumn, alterTableDropColumn, buildColumnNameTokens, buildColumnTypeTokens, buildTableNameTokens, copyTableRows, copyTableStructure, doRenameTables, dropIndexes, dropIndexes, getDBType, getDefaultValue, getIndexMetadatas, getIndexResultSet, getMajorVersion, getMinorVersion, getPrimaryKeyColumnNames, getRenameTableSQL, getSQLType, getSQLTypeDecimalDigits, getSQLTypeSize, getTemplateBlob, getTemplateFalse, getTemplateTrue, getVersionString, isSupportsAlterColumnName, isSupportsAlterColumnType, isSupportsDDLRollback, isSupportsInlineDistinct, isSupportsScrollableResults, isSupportsStringCaseSensitiveQuery, isSupportsUpdateWithInnerJoin, 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
-
PostgreSQLDB
public PostgreSQLDB(int majorVersion, int minorVersion)
-
-
Method Details
-
getCreateRulesSQL
-
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() -
isSupportsQueryingAfterException
public boolean isSupportsQueryingAfterException()- Specified by:
isSupportsQueryingAfterException
in interfacecom.liferay.portal.kernel.dao.db.DB
- Overrides:
isSupportsQueryingAfterException
in classBaseDB
-
createSyncDeleteTrigger
protected void createSyncDeleteTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames) throws Exception - Overrides:
createSyncDeleteTrigger
in classBaseDB
- Throws:
Exception
-
createSyncInsertTrigger
protected void createSyncInsertTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) throws Exception- Overrides:
createSyncInsertTrigger
in classBaseDB
- Throws:
Exception
-
createSyncUpdateTrigger
protected void createSyncUpdateTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) throws Exception- Overrides:
createSyncUpdateTrigger
in classBaseDB
- Throws:
Exception
-
dropTrigger
protected void dropTrigger(Connection connection, String tableName, String triggerName) throws Exception - Overrides:
dropTrigger
in classBaseDB
- Throws:
Exception
-
getCopyTableStructureSQL
- Overrides:
getCopyTableStructureSQL
in classBaseDB
-
getIndexColumnName
- Overrides:
getIndexColumnName
in classBaseDB
-
getSQLTypes
protected int[] getSQLTypes()- Specified by:
getSQLTypes
in classBaseDB
-
getSQLVarcharSizes
- Overrides:
getSQLVarcharSizes
in classBaseDB
-
getTemplate
- Specified by:
getTemplate
in classBaseDB
-
isSupportsDuplicatedIndexName
protected boolean isSupportsDuplicatedIndexName()- Overrides:
isSupportsDuplicatedIndexName
in classBaseDB
-
limitColumnLength
- Overrides:
limitColumnLength
in classBaseDB
-
reword
- Specified by:
reword
in classBaseDB
- Throws:
IOException
-