com.scooterframework.orm.sqldataexpress.vendor
Class PostgreSQLDBAdapter

java.lang.Object
  com.scooterframework.orm.sqldataexpress.vendor.DBAdapter
      com.scooterframework.orm.sqldataexpress.vendor.PostgreSQLDBAdapter

public class PostgreSQLDBAdapter
extends DBAdapter

PostgreSQLDBAdapter class applies to PostgreSQL database.

Field Summary

Fields inherited from class com.scooterframework.orm.sqldataexpress.vendor.DBAdapter

IGNORE, USE_LOGIN_USER_ID_AS_SCHEMA

Constructor Summary

PostgreSQLDBAdapter()

Method Summary

java.lang.String[]	getCatalogAndSchema(java.lang.String connName) Returns both catalog and schema of a connection.
java.lang.String	getExpandedTableName(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) PostgreSQL does not support catalog.
java.lang.String	getOneRowSelectSQL(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) Returns a SQL SELECT query which retrieves only one record from a table.
protected java.lang.String	getPostgreSQLSchema(java.lang.String connName)
java.lang.String	preparePaginationSql(java.lang.String selectSql, java.util.Map<java.lang.String,java.lang.Object> inputs, java.util.Map<java.lang.String,java.lang.String> outputFilters) Returns a SQL query for pagination.

Methods inherited from class com.scooterframework.orm.sqldataexpress.vendor.DBAdapter

canChangeTableNameCase, dotCount, getBlobData, getClobData, getExpandedTableName, getExpandedTableName, getInputStream, getLoginPassword, getLoginUserId, getObjectFromResultSetByType, getObjectFromStatementByType, getOneRowSelectSQL, getRetrieveAllSQL, getRetrieveAllSQL, getTotalCountSQL, getTotalCountSQL, getType, isEmpty, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTable, resolveCatalogAndSchemaAndTableFromTableName, useLoginAsSchema, vendorSpecificSetObject

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLDBAdapter

public PostgreSQLDBAdapter()

Method Detail

getCatalogAndSchema

public java.lang.String[] getCatalogAndSchema(java.lang.String connName)

Description copied from class: DBAdapter

Returns both catalog and schema of a connection.

Specified by:

getCatalogAndSchema in class DBAdapter

Parameters:

connName - database connection name

Returns:

a string array containing catalog and schema

getPostgreSQLSchema

protected java.lang.String getPostgreSQLSchema(java.lang.String connName)

getExpandedTableName

public java.lang.String getExpandedTableName(java.lang.String catalog,
                                             java.lang.String schema,
                                             java.lang.String tableName)

PostgreSQL does not support catalog. Therefore it is ignored.

Overrides:

getExpandedTableName in class DBAdapter

Parameters:

catalog - catalog name

schema - schema name

tableName - table name

Returns:

an expanded table name

getOneRowSelectSQL

public java.lang.String getOneRowSelectSQL(java.lang.String catalog,
                                           java.lang.String schema,
                                           java.lang.String tableName)

Description copied from class: DBAdapter

Returns a SQL SELECT query which retrieves only one record from a table. This query is used for retrieving meta data of the underlining table.

Specified by:

getOneRowSelectSQL in class DBAdapter

Parameters:

catalog - catalog name

schema - schema name

tableName - table name

Returns:

a SELECT query string

preparePaginationSql

public java.lang.String preparePaginationSql(java.lang.String selectSql,
                                             java.util.Map<java.lang.String,java.lang.Object> inputs,
                                             java.util.Map<java.lang.String,java.lang.String> outputFilters)

Description copied from class: DBAdapter

Returns a SQL query for pagination. This method converts a generic SQL query statement to a SQL query for pagination.

Specified by:

preparePaginationSql in class DBAdapter

Parameters:

selectSql - the original SQL statement

inputs - inputs

outputFilters - outputFilters

Returns:

a SQL query for pagination