Package org.jumpmind.db.platform.postgresql

Class PostgreSqlDatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.postgresql.PostgreSqlDatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

Direct Known Subclasses:

GreenplumPlatform, PostgreSql95DatabasePlatform

public class PostgreSqlDatabasePlatform
extends AbstractJdbcDatabasePlatform

Field Summary

Fields

Modifier and Type	Field	Description
static final String	JDBC_DRIVER
static final String	JDBC_SUBPROTOCOL

Fields inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

dataSource, sqlTemplate, sqlTemplateDirty

Fields inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

clearCacheModelTimeoutInMs, databaseVersion, ddlBuilder, ddlReader, defaultCatalog, defaultSchema, log, metadataIgnoreCase, MODEL_DEFAULT_NAME, PERMISSION_TEST_TABLE_NAME, REQUIRED_FIELD_NULL_SUBSTITUTE, settings, sourceNodeId, storesLowerCaseIdentifiers, storesMixedCaseIdentifiers, storesUpperCaseIdentifiers, supportsMultiThreadedTransactions, supportsTransactions, supportsTruncate, tableCache, useMultiThreadSyncTriggers, ZERO_DATE_STRING

Constructor Summary

Constructors

Constructor	Description
PostgreSqlDatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
boolean	canColumnBeUsedInWhereClause(Column column)
protected String	cleanTextForTextBasedColumns(String text)
protected Array	createArray(Column column, String value)
protected PostgreSqlDdlBuilder	createDdlBuilder()
protected PostgreSqlDdlReader	createDdlReader()
protected PostgreSqlJdbcSqlTemplate	createSqlTemplate()
protected PostgreSqlJdbcSqlTemplate	createSqlTemplateDirty()
String	getCharSetName()
PermissionResult	getCreateSymTriggerPermission()
protected String	getDateTimeStringValue(String name, int type, Row row, boolean useVariableDates)
String	getDefaultCatalog()
String	getDefaultSchema()
String	getDeleteSql(Table table)
PermissionResult	getDropSymTriggerPermission()
long	getEstimatedRowCount(Table table)
PermissionResult	getLogMinePermission()
String	getName()
Object[]	getObjectValues(BinaryEncoding encoding, String[] values, Column[] orderedMetaData, boolean useVariableDates, boolean fitToColumn)
String	getSliceTableSql(String columnName, int sliceNum, int totalSlices)
protected String	getTimestampStringValue(String name, int type, Row row, boolean useVariableDates)
protected String	getTimestampTzStringValue(String name, int type, Row row, boolean useVariableDates)
List<Transaction>	getTransactions()
String	getTruncateSql(Table table)
protected static boolean	isBlobStoredByReference(String jdbcTypeName)
String	massageForLimitOffset(String sql, int limit, int offset)
String	massageForObjectAlreadyExists(String sql)
protected String	massageInfinityDate(String date)
protected static SqlTemplateSettings	overrideSettings(SqlTemplateSettings settings)
boolean	supportsLimitOffset()
boolean	supportsSliceTables()

Methods inherited from class org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

getDataSource, getSqlTemplate, getSqlTemplateDirty, resetDataSource

Methods inherited from class org.jumpmind.db.platform.AbstractDatabasePlatform

allowsUniqueIndexDuplicatesWithNulls, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterCaseToMatchDatabaseDefaultCase, alterDatabase, alterDatabase, alterTables, alterTables, appendString, checkSymTablePermissions, cleanNumber, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getAlterSymTablePermission, getClearCacheModelTimeoutInMs, getCreateSymFunctionPermission, getCreateSymRoutinePermission, getCreateSymTablePermission, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDdlBuilder, getDdlReader, getDropSymTablePermission, getExecuteSymPermission, getLobColumns, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSqlScriptReplacementTokens, getStringValues, getTableFromCache, getTableFromCache, getTimeZone, hasMatchingPlatform, isBlob, isClob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectDoesNotExist, parseBigDecimal, parseBigInteger, parseBoolean, parseDate, parseFloat, parseInteger, parseQualifiedTableName, parseTimestamp, prefixColumnNames, prefixDatabase, prefixForeignKeys, prefixIndexes, readDatabase, readDatabaseFromXml, readDatabaseFromXml, readFromDatabase, readTableFromDatabase, readTableFromDatabase, readTableFromDatabaseAllowException, resetCachedTableModel, scrubSql, setClearCacheModelTimeoutInMs, setDatabaseVersion, setMetadataIgnoreCase, supportsMultiThreadedTransactions, supportsParametersInSelect, supportsTransactions

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

JDBC_DRIVER

public static final String JDBC_DRIVER

See Also:

• Constant Field Values

JDBC_SUBPROTOCOL

public static final String JDBC_SUBPROTOCOL

See Also:

• Constant Field Values

Constructor Details

PostgreSqlDatabasePlatform

public PostgreSqlDatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

overrideSettings

protected static SqlTemplateSettings overrideSettings(SqlTemplateSettings settings)

isBlobStoredByReference

protected static boolean isBlobStoredByReference(String jdbcTypeName)

createDdlBuilder

protected PostgreSqlDdlBuilder createDdlBuilder()

Specified by:

createDdlBuilder in class AbstractJdbcDatabasePlatform

createDdlReader

protected PostgreSqlDdlReader createDdlReader()

Specified by:

createDdlReader in class AbstractJdbcDatabasePlatform

createSqlTemplate

protected PostgreSqlJdbcSqlTemplate createSqlTemplate()

Overrides:

createSqlTemplate in class AbstractJdbcDatabasePlatform

createSqlTemplateDirty

protected PostgreSqlJdbcSqlTemplate createSqlTemplateDirty()

Overrides:

createSqlTemplateDirty in class AbstractJdbcDatabasePlatform

getName

public String getName()

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultSchema

public String getDefaultSchema()

getDefaultCatalog

public String getDefaultCatalog()

createArray

protected Array createArray(Column column,
 String value)

Overrides:

createArray in class AbstractDatabasePlatform

cleanTextForTextBasedColumns

protected String cleanTextForTextBasedColumns(String text)

Overrides:

cleanTextForTextBasedColumns in class AbstractDatabasePlatform

getObjectValues

public Object[] getObjectValues(BinaryEncoding encoding,
 String[] values,
 Column[] orderedMetaData,
 boolean useVariableDates,
 boolean fitToColumn)

Specified by:

getObjectValues in interface IDatabasePlatform

Overrides:

getObjectValues in class AbstractDatabasePlatform

getCreateSymTriggerPermission

public PermissionResult getCreateSymTriggerPermission()

Overrides:

getCreateSymTriggerPermission in class AbstractDatabasePlatform

getDropSymTriggerPermission

public PermissionResult getDropSymTriggerPermission()

Overrides:

getDropSymTriggerPermission in class AbstractDatabasePlatform

getLogMinePermission

public PermissionResult getLogMinePermission()

Specified by:

getLogMinePermission in interface IDatabasePlatform

Overrides:

getLogMinePermission in class AbstractDatabasePlatform

getEstimatedRowCount

public long getEstimatedRowCount(Table table)

Specified by:

getEstimatedRowCount in interface IDatabasePlatform

Overrides:

getEstimatedRowCount in class AbstractDatabasePlatform

getTruncateSql

public String getTruncateSql(Table table)

Specified by:

getTruncateSql in interface IDatabasePlatform

Overrides:

getTruncateSql in class AbstractDatabasePlatform

getDeleteSql

public String getDeleteSql(Table table)

Specified by:

getDeleteSql in interface IDatabasePlatform

Overrides:

getDeleteSql in class AbstractDatabasePlatform

getTransactions

public List<Transaction> getTransactions()

Specified by:

getTransactions in interface IDatabasePlatform

Overrides:

getTransactions in class AbstractDatabasePlatform

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface IDatabasePlatform

Overrides:

supportsLimitOffset in class AbstractDatabasePlatform

massageForLimitOffset

public String massageForLimitOffset(String sql,
 int limit,
 int offset)

Specified by:

massageForLimitOffset in interface IDatabasePlatform

Overrides:

massageForLimitOffset in class AbstractDatabasePlatform

massageForObjectAlreadyExists

public String massageForObjectAlreadyExists(String sql)

Specified by:

massageForObjectAlreadyExists in interface IDatabasePlatform

Overrides:

massageForObjectAlreadyExists in class AbstractDatabasePlatform

supportsSliceTables

public boolean supportsSliceTables()

Specified by:

supportsSliceTables in interface IDatabasePlatform

Overrides:

supportsSliceTables in class AbstractDatabasePlatform

getSliceTableSql

public String getSliceTableSql(String columnName,
 int sliceNum,
 int totalSlices)

Specified by:

getSliceTableSql in interface IDatabasePlatform

Overrides:

getSliceTableSql in class AbstractDatabasePlatform

canColumnBeUsedInWhereClause

public boolean canColumnBeUsedInWhereClause(Column column)

Specified by:

canColumnBeUsedInWhereClause in interface IDatabasePlatform

Overrides:

canColumnBeUsedInWhereClause in class AbstractDatabasePlatform

getCharSetName

public String getCharSetName()

Specified by:

getCharSetName in interface IDatabasePlatform

Overrides:

getCharSetName in class AbstractDatabasePlatform

getDateTimeStringValue

protected String getDateTimeStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

Overrides:

getDateTimeStringValue in class AbstractDatabasePlatform

getTimestampStringValue

protected String getTimestampStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

Overrides:

getTimestampStringValue in class AbstractDatabasePlatform

getTimestampTzStringValue

protected String getTimestampTzStringValue(String name,
 int type,
 Row row,
 boolean useVariableDates)

Overrides:

getTimestampTzStringValue in class AbstractDatabasePlatform

massageInfinityDate

protected String massageInfinityDate(String date)