Package org.jumpmind.db.platform.postgresql

Class PostgreSqlDdlReader

java.lang.Object

org.jumpmind.db.platform.AbstractJdbcDdlReader

org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader

All Implemented Interfaces:

IDdlReader

Direct Known Subclasses:

GreenplumDdlReader

public class PostgreSqlDdlReader
extends AbstractJdbcDdlReader

Field Summary

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

log, platform

Constructor Summary

Constructors

Constructor	Description
PostgreSqlDdlReader(IDatabasePlatform platform)

Method Summary

Modifier and Type	Method	Description
protected void	detectAutoIncrementColumnsInUniqueIndices(Table table)	Detect and filter out PostgreSQL-specific unique indices for non-pk auto-increment columns which are of the form "[table]_[column]_key"
List<String>	getCatalogNames()
PlatformTrigger	getPlatformTrigger(IDatabasePlatform platform, Trigger trigger)
List<Trigger>	getTriggers(String catalog, String schema, String tableName)
protected boolean	isInternalForeignKeyIndex(Connection connection, DatabaseMetaDataWrapper metaData, Table table, ForeignKey fk, IIndex index)
protected boolean	isInternalPrimaryKeyIndex(Connection connection, DatabaseMetaDataWrapper metaData, Table table, IIndex index)
protected Integer	mapUnknownJdbcTypeForColumn(Map<String,Object> values)
protected Column	readColumn(DatabaseMetaDataWrapper metaData, Map<String,Object> values)
protected void	readForeignKey(DatabaseMetaDataWrapper metaData, Map<String,Object> values, Map<String,ForeignKey> knownFks)
protected void	readMetaDataAndPrimaryKeyConstraint(Connection connection, Table table)	Reads additional information about the table (meta data) in one round-trip to the database.
protected Table	readTable(Connection connection, DatabaseMetaDataWrapper metaData, Map<String,Object> values)

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

adjustColumnSize, adjustColumnSize, appendColumn, appendIdentifier, close, close, determineAutoIncrementFromResultSetMetaData, determineAutoIncrementFromResultSetMetaData, genericizeDefaultValuesAndUpdatePlatformColumn, getApplicationTriggersForModel, getColumnNames, getColumnsForColumn, getColumnsForFK, getColumnsForIndex, getColumnsForPK, getColumnsForTable, getConnectionHandler, getDatabase, getDefaultCatalogPattern, getDefaultColumnPattern, getDefaultSchemaPattern, getDefaultTablePattern, getDefaultTableTypes, getExportedForeignTableRows, getExportedKeys, getForeignKeys, getImportedForeignTableRows, getImportedForeignTableRows, getListOfTriggers, getName, getPlatform, getPlatformInfo, getResultSetCatalogName, getResultSetSchemaName, getSchemaNames, getSchemasHandleException, getTableNamePattern, getTableNamePatternForConstraints, getTableNames, getTableTypes, getTriggerFor, getUnsupportedTableTypes, getWithNoLockHint, initColumnsForColumn, initColumnsForFK, initColumnsForIndex, initColumnsForPK, initColumnsForTable, matches, postprocessModelFromDatabase, postprocessTableFromDatabase, processSchemaResultSet, readColumns, readExportedKey, readExportedKeys, readForeignKeyDeleteRule, readForeignKeys, readForeignKeyUpdateRule, readIndex, readIndices, readMetaData, readPrimaryKeyName, readPrimaryKeyNames, readPrimaryKeySequence, readTable, readTable, readTableFromConnection, readTables, readTables, removeColumnSize, removeGeneratedColumns, removeInternalForeignKeyIndex, removeInternalPrimaryKeyIndex, removePlatformColumnSize, removeSystemIndices, resetColumnSize, setDefaultCatalogPattern, setDefaultColumnPattern, setDefaultSchemaPattern, setDefaultTablePattern, setDefaultTableTypes, unescape

Methods inherited from class java.lang.Object

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

Constructor Details

PostgreSqlDdlReader

public PostgreSqlDdlReader(IDatabasePlatform platform)

Method Details

readTable

protected Table readTable(Connection connection,
 DatabaseMetaDataWrapper metaData,
 Map<String,Object> values)
                   throws SQLException

Overrides:

readTable in class AbstractJdbcDdlReader

Throws:

SQLException

detectAutoIncrementColumnsInUniqueIndices

protected void detectAutoIncrementColumnsInUniqueIndices(Table table)

Detect and filter out PostgreSQL-specific unique indices for non-pk auto-increment columns which are of the form "[table]_[column]_key"

readMetaDataAndPrimaryKeyConstraint

protected void readMetaDataAndPrimaryKeyConstraint(Connection connection,
 Table table)
                                            throws SQLException

Reads additional information about the table (meta data) in one round-trip to the database.

• Name of the Primary key constraint
• LOGGED mode (true/false)

Throws:

SQLException

mapUnknownJdbcTypeForColumn

protected Integer mapUnknownJdbcTypeForColumn(Map<String,Object> values)

Overrides:

mapUnknownJdbcTypeForColumn in class AbstractJdbcDdlReader

readColumn

protected Column readColumn(DatabaseMetaDataWrapper metaData,
 Map<String,Object> values)
                     throws SQLException

Overrides:

readColumn in class AbstractJdbcDdlReader

Throws:

SQLException

readForeignKey

protected void readForeignKey(DatabaseMetaDataWrapper metaData,
 Map<String,Object> values,
 Map<String,ForeignKey> knownFks)
                       throws SQLException

Overrides:

readForeignKey in class AbstractJdbcDdlReader

Throws:

SQLException

isInternalForeignKeyIndex

protected boolean isInternalForeignKeyIndex(Connection connection,
 DatabaseMetaDataWrapper metaData,
 Table table,
 ForeignKey fk,
 IIndex index)

Overrides:

isInternalForeignKeyIndex in class AbstractJdbcDdlReader

isInternalPrimaryKeyIndex

protected boolean isInternalPrimaryKeyIndex(Connection connection,
 DatabaseMetaDataWrapper metaData,
 Table table,
 IIndex index)

Overrides:

isInternalPrimaryKeyIndex in class AbstractJdbcDdlReader

getCatalogNames

public List<String> getCatalogNames()

Specified by:

getCatalogNames in interface IDdlReader

Overrides:

getCatalogNames in class AbstractJdbcDdlReader

getTriggers

public List<Trigger> getTriggers(String catalog,
 String schema,
 String tableName)

Specified by:

getTriggers in interface IDdlReader

Overrides:

getTriggers in class AbstractJdbcDdlReader

getPlatformTrigger

public PlatformTrigger getPlatformTrigger(IDatabasePlatform platform,
 Trigger trigger)

Specified by:

getPlatformTrigger in interface IDdlReader

Overrides:

getPlatformTrigger in class AbstractJdbcDdlReader