com.revolsys.gis.postgresql

Class PostgreSQLRecordStore

java.lang.Object

com.revolsys.io.AbstractObjectWithProperties

com.revolsys.data.record.schema.AbstractRecordStore

com.revolsys.jdbc.io.AbstractJdbcRecordStore

com.revolsys.gis.postgresql.PostgreSQLRecordStore

All Implemented Interfaces:

RecordStoreExtension, RecordDefinitionFactory, RecordStore, ObjectWithProperties, JdbcRecordStore, AutoCloseable

public class PostgreSQLRecordStore
extends AbstractJdbcRecordStore

Field Summary

Fields

Modifier and Type	Field and Description
static List<String>	POSTGRESQL_INTERNAL_SCHEMAS

Fields inherited from class com.revolsys.jdbc.io.AbstractJdbcRecordStore

DEFAULT_PERMISSIONS

Constructor Summary

Constructors

Constructor and Description
PostgreSQLRecordStore()
PostgreSQLRecordStore(DataSource dataSource)
PostgreSQLRecordStore(PostgreSQLDatabaseFactory databaseFactory, Map<String,? extends Object> connectionProperties)
PostgreSQLRecordStore(RecordFactory recordFactory)
PostgreSQLRecordStore(RecordFactory recordFactory, DataSource dataSource)

Method Summary

Methods

Modifier and Type	Method and Description
protected JdbcFieldDefinition	addField(RecordDefinitionImpl recordDefinition, String dbColumnName, String name, String dataType, int sqlType, int length, int scale, boolean required, String description)
void	appendQueryValue(Query query, StringBuilder sql, QueryValue queryValue)
static AbstractIterator<Record>	createPostgreSQLIterator(PostgreSQLRecordStore recordStore, Query query, Map<String,Object> properties)
String	getGeneratePrimaryKeySql(RecordDefinition recordDefinition)
JdbcConnection	getJdbcConnection()
JdbcConnection	getJdbcConnection(boolean autoCommit)
Object	getNextPrimaryKey(RecordDefinition recordDefinition)
Object	getNextPrimaryKey(String sequenceName)
String	getSequenceName(RecordDefinition recordDefinition)
void	initialize()
protected void	initSettings()
boolean	isSchemaExcluded(String schemaName)
boolean	isUseSchemaSequencePrefix()
ResultPager<Record>	page(Query query)
void	setUseSchemaSequencePrefix(boolean useSchemaSequencePrefix)

Methods inherited from class com.revolsys.jdbc.io.AbstractJdbcRecordStore

addAllSchemaNames, addExcludeTablePaths, addField, addFieldAdder, close, createJdbcIterator, createPrimaryIdValue, createReader, createWriter, createWriter, delete, delete, deleteAll, getAllSchemaNames, getBatchSize, getColumnNames, getDatabaseQualifiedTableName, getDatabaseSchemaName, getDatabaseSchemaName, getDatabaseSchemaNames, getDatabaseTableName, getDataSource, getExcludeTablePaths, getField, getHints, getIdFieldName, getRecordDefinition, getRowCount, getSequenceInsertSql, getSqlPrefix, getSqlSuffix, getTablePermissionsSql, getTransactionManager, getWriter, getWriter, initialize, insert, insertAll, isAutoCommit, isEditable, isEnabled, isExcluded, isFlushBetweenTypes, loadIdColumnNames, loadSchemaTablePermissions, postProcess, preProcess, refreshSchemaElements, setBatchSize, setCodeTables, setDataSource, setExcludeTablePaths, setExcludeTablePaths, setExcludeTablePatterns, setFlushBetweenTypes, setHints, setPrimaryKeySql, setSchemaPermissionsSql, setSqlPrefix, setSqlSuffix, setTablePermissionsSql, update, updateAll, write, write, writeAll

Methods inherited from class com.revolsys.data.record.schema.AbstractRecordStore

addCodeTable, addCodeTable, addCodeTables, addRecordDefinition, addRecordDefinitionProperties, addRecordStoreExtension, addStatistic, addStatistic, copy, create, create, create, createIterator, createQuery, createReader, createTransaction, createWithId, findRecordDefinition, getCodeTable, getCodeTableByFieldName, getCodeTableByFieldNameMap, getCodeTableColumNames, getConnectionProperties, getGeometryFactory, getIteratorFactory, getLabel, getRecordDefinition, getRecordDefinition, getRecordFactory, getRecordStoreExtensions, getRootSchema, getSchema, getSchemas, getSharedAttribute, getSharedAttributes, getStatistics, getStatistics, getString, getTypeNames, getTypes, getUrl, getUsername, hasSchema, load, load, lock, query, query, query, queryFirst, refreshSchema, refreshSchema, setCodeTableColumNames, setCommonRecordDefinitionProperties, setConnectionProperties, setGeometryFactory, setIteratorFactory, setLabel, setLogCounts, setRecordFactory, setSharedAttribute, setTypeRecordDefinitionProperties, toString

Methods inherited from class com.revolsys.io.AbstractObjectWithProperties

clearProperties, getProperties, getProperty, getProperty, removeProperty, setProperties, setProperty, setPropertySoft, setPropertyWeak

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.revolsys.jdbc.io.JdbcRecordStore

createReader, getLabel, getStatistics, setLabel

Methods inherited from interface com.revolsys.data.record.schema.RecordStore

addCodeTable, addCodeTables, addStatistic, addStatistic, copy, create, create, create, createQuery, createTransaction, createWithId, getCodeTable, getCodeTableByFieldName, getCodeTableByFieldNameMap, getGeometryFactory, getRecordDefinition, getRecordDefinition, getRecordFactory, getRootSchema, getSchema, getSchemas, getStatistics, getTypeNames, getTypes, getUrl, getUsername, hasSchema, load, load, lock, query, query, query, queryFirst, setLogCounts, setRecordFactory

Methods inherited from interface com.revolsys.io.ObjectWithProperties

clearProperties, getProperties, getProperty, getProperty, removeProperty, setProperties, setProperty, setPropertySoft, setPropertyWeak

Field Detail

POSTGRESQL_INTERNAL_SCHEMAS

public static final List<String> POSTGRESQL_INTERNAL_SCHEMAS

Constructor Detail

PostgreSQLRecordStore

public PostgreSQLRecordStore()

PostgreSQLRecordStore

public PostgreSQLRecordStore(DataSource dataSource)

PostgreSQLRecordStore

public PostgreSQLRecordStore(PostgreSQLDatabaseFactory databaseFactory,
                     Map<String,? extends Object> connectionProperties)

PostgreSQLRecordStore

public PostgreSQLRecordStore(RecordFactory recordFactory)

PostgreSQLRecordStore

public PostgreSQLRecordStore(RecordFactory recordFactory,
                     DataSource dataSource)

Method Detail

createPostgreSQLIterator

public static final AbstractIterator<Record> createPostgreSQLIterator(PostgreSQLRecordStore recordStore,
                                                Query query,
                                                Map<String,Object> properties)

addField

protected JdbcFieldDefinition addField(RecordDefinitionImpl recordDefinition,
                           String dbColumnName,
                           String name,
                           String dataType,
                           int sqlType,
                           int length,
                           int scale,
                           boolean required,
                           String description)

Overrides:

addField in class AbstractJdbcRecordStore

appendQueryValue

public void appendQueryValue(Query query,
                    StringBuilder sql,
                    QueryValue queryValue)

Specified by:

appendQueryValue in interface RecordStore

Overrides:

appendQueryValue in class AbstractRecordStore

getGeneratePrimaryKeySql

public String getGeneratePrimaryKeySql(RecordDefinition recordDefinition)

Specified by:

getGeneratePrimaryKeySql in interface JdbcRecordStore

Overrides:

getGeneratePrimaryKeySql in class AbstractJdbcRecordStore

getJdbcConnection

public JdbcConnection getJdbcConnection()

Specified by:

getJdbcConnection in interface JdbcRecordStore

Overrides:

getJdbcConnection in class AbstractJdbcRecordStore

getJdbcConnection

public JdbcConnection getJdbcConnection(boolean autoCommit)

Specified by:

getJdbcConnection in interface JdbcRecordStore

Overrides:

getJdbcConnection in class AbstractJdbcRecordStore

getNextPrimaryKey

public Object getNextPrimaryKey(RecordDefinition recordDefinition)

getNextPrimaryKey

public Object getNextPrimaryKey(String sequenceName)

getSequenceName

public String getSequenceName(RecordDefinition recordDefinition)

initialize

@PostConstruct
public void initialize()

Specified by:

initialize in interface RecordStore

Specified by:

initialize in interface JdbcRecordStore

Overrides:

initialize in class AbstractJdbcRecordStore

initSettings

protected void initSettings()

isSchemaExcluded

public boolean isSchemaExcluded(String schemaName)

Specified by:

isSchemaExcluded in class AbstractJdbcRecordStore

isUseSchemaSequencePrefix

public boolean isUseSchemaSequencePrefix()

page

public ResultPager<Record> page(Query query)

Specified by:

page in interface RecordStore

Overrides:

page in class AbstractJdbcRecordStore

setUseSchemaSequencePrefix

public void setUseSchemaSequencePrefix(boolean useSchemaSequencePrefix)