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, 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 TypeMethodDescriptionprotected voidcreateSyncDeleteTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames) protected voidcreateSyncInsertTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) protected voidcreateSyncUpdateTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourceColumnNames, String[] targetColumnNames, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames, Map<String, String> defaultValuesMap) protected voiddropTrigger(Connection connection, String tableName, String triggerName) protected StringgetCopyTableStructureSQL(String tableName, String newTableName) static StringgetCreateRulesSQL(String tableName, String columnName) protected StringgetIndexColumnName(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[]booleanprotected booleanbooleanbooleanprotected StringlimitColumnLength(String column, int length) protected StringMethods 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, 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
-
PostgreSQLDB
public PostgreSQLDB(int majorVersion, int minorVersion)
-
-
Method Details
-
getCreateRulesSQL
-
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() -
isSupportsQueryingAfterException
public boolean isSupportsQueryingAfterException()- Specified by:
isSupportsQueryingAfterExceptionin interfacecom.liferay.portal.kernel.dao.db.DB- Overrides:
isSupportsQueryingAfterExceptionin classBaseDB
-
createSyncDeleteTrigger
protected void createSyncDeleteTrigger(Connection connection, String sourceTableName, String targetTableName, String triggerName, String[] sourcePrimaryKeyColumnNames, String[] targetPrimaryKeyColumnNames) throws Exception - Overrides:
createSyncDeleteTriggerin 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:
createSyncInsertTriggerin 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:
createSyncUpdateTriggerin classBaseDB- Throws:
Exception
-
dropTrigger
protected void dropTrigger(Connection connection, String tableName, String triggerName) throws Exception - Overrides:
dropTriggerin classBaseDB- Throws:
Exception
-
getCopyTableStructureSQL
- Overrides:
getCopyTableStructureSQLin classBaseDB
-
getIndexColumnName
- Overrides:
getIndexColumnNamein classBaseDB
-
getSQLTypes
protected int[] getSQLTypes()- Specified by:
getSQLTypesin classBaseDB
-
getSQLVarcharSizes
- Overrides:
getSQLVarcharSizesin classBaseDB
-
getTemplate
- Specified by:
getTemplatein classBaseDB
-
isSupportsDuplicatedIndexName
protected boolean isSupportsDuplicatedIndexName()- Overrides:
isSupportsDuplicatedIndexNamein classBaseDB
-
limitColumnLength
- Overrides:
limitColumnLengthin classBaseDB
-
reword
- Specified by:
rewordin classBaseDB- Throws:
IOException
-