Package org.jumpmind.db.platform.redshift

Class RedshiftDatabasePlatform

java.lang.Object

org.jumpmind.db.platform.AbstractDatabasePlatform

org.jumpmind.db.platform.AbstractJdbcDatabasePlatform

org.jumpmind.db.platform.redshift.RedshiftDatabasePlatform

All Implemented Interfaces:

IDatabasePlatform

public class RedshiftDatabasePlatform
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
RedshiftDatabasePlatform(DataSource dataSource, SqlTemplateSettings settings)

Method Summary

Modifier and Type	Method	Description
protected RedshiftDdlBuilder	createDdlBuilder()
protected RedshiftDdlReader	createDdlReader()
protected RedshiftJdbcSqlTemplate	createSqlTemplate()
protected RedshiftJdbcSqlTemplate	createSqlTemplateDirty()
PermissionResult	getAlterSymTablePermission(Database database)
PermissionResult	getCreateSymTablePermission(Database database)
String	getDefaultCatalog()
String	getDefaultSchema()
PermissionResult	getDropSymTablePermission()
PermissionResult	getDropSymTriggerPermission()
String	getName()
Map<String,String>	getSqlScriptReplacementTokens()
boolean	isClob(int type)
String	massageForLimitOffset(String sql, int limit, int offset)
protected static SqlTemplateSettings	overrideSettings(SqlTemplateSettings settings)
boolean	supportsLimitOffset()

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, canColumnBeUsedInWhereClause, checkSymTablePermissions, cleanNumber, cleanTextForTextBasedColumns, createArray, createDatabase, createDmlStatement, createDmlStatement, createDmlStatement, createDmlStatement, createTables, dropDatabase, dropTables, getCharSetName, getClearCacheModelTimeoutInMs, getCreateSymFunctionPermission, getCreateSymRoutinePermission, getCreateSymTriggerPermission, getCsvStringValue, getDatabaseInfo, getDatabaseVersion, getDateTimeStringValue, getDdlBuilder, getDdlReader, getDeleteSql, getEstimatedRowCount, getExecuteSymPermission, getLobColumns, getLogMinePermission, getObjectValue, getObjectValues, getObjectValues, getObjectValues, getObjectValues, getPermissionTableDefinition, getSliceTableSql, getStringValues, getTableFromCache, getTableFromCache, getTimestampStringValue, getTimestampTzStringValue, getTimeZone, getTransactions, getTruncateSql, hasMatchingPlatform, isBlob, isClob, isLob, isMetadataIgnoreCase, isStoresLowerCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isUseMultiThreadSyncTriggers, logFailedResults, makeAllColumnsPrimaryKeys, makePlatformSpecific, massageForObjectAlreadyExists, 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, supportsSliceTables, 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

RedshiftDatabasePlatform

public RedshiftDatabasePlatform(DataSource dataSource,
 SqlTemplateSettings settings)

Method Details

overrideSettings

protected static SqlTemplateSettings overrideSettings(SqlTemplateSettings settings)

createDdlBuilder

protected RedshiftDdlBuilder createDdlBuilder()

Specified by:

createDdlBuilder in class AbstractJdbcDatabasePlatform

createDdlReader

protected RedshiftDdlReader createDdlReader()

Specified by:

createDdlReader in class AbstractJdbcDatabasePlatform

createSqlTemplate

protected RedshiftJdbcSqlTemplate createSqlTemplate()

Overrides:

createSqlTemplate in class AbstractJdbcDatabasePlatform

createSqlTemplateDirty

protected RedshiftJdbcSqlTemplate createSqlTemplateDirty()

Overrides:

createSqlTemplateDirty in class AbstractJdbcDatabasePlatform

getName

public String getName()

Returns:

a constant that represents this database type from DatabaseNamesConstants

See Also:

• DatabaseNamesConstants

getDefaultCatalog

public String getDefaultCatalog()

getDefaultSchema

public String getDefaultSchema()

getSqlScriptReplacementTokens

public Map<String,String> getSqlScriptReplacementTokens()

Specified by:

getSqlScriptReplacementTokens in interface IDatabasePlatform

Overrides:

getSqlScriptReplacementTokens in class AbstractDatabasePlatform

isClob

public boolean isClob(int type)

getCreateSymTablePermission

public PermissionResult getCreateSymTablePermission(Database database)

Overrides:

getCreateSymTablePermission in class AbstractDatabasePlatform

getDropSymTablePermission

public PermissionResult getDropSymTablePermission()

Overrides:

getDropSymTablePermission in class AbstractDatabasePlatform

getAlterSymTablePermission

public PermissionResult getAlterSymTablePermission(Database database)

Overrides:

getAlterSymTablePermission in class AbstractDatabasePlatform

getDropSymTriggerPermission

public PermissionResult getDropSymTriggerPermission()

Overrides:

getDropSymTriggerPermission 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