Package edu.ucsb.nceas.dbadapter

Class PostgresqlAdapter

java.lang.Object

edu.ucsb.nceas.dbadapter.AbstractDatabase

edu.ucsb.nceas.dbadapter.PostgresqlAdapter

public class PostgresqlAdapter
extends AbstractDatabase

The PostgreSQL db adapter implementation.

Constructor Summary

Constructors

Constructor	Description
PostgresqlAdapter()

Method Summary

Modifier and Type	Method	Description
String	getDateTimeFunction()	The PostgreSQL function name that gets the current date and time from the database server
String	getIsNULLFunction()	The PostgreSQL function name that is used to return non-NULL value
String	getLeftJoinQuery(String selectFields, String tableA, String tableB, String joinCriteria, String nonJoinCriteria)	PostgreSQL's syntax for doing a left join Add 'a.' in front of the fields for first table and 'b.' in front of the fields for the second table
String	getPagedQuery(String queryWithOrderBy, Integer start, Integer count)	for generating a query for paging
String	getReplicationDocumentListSQL()	Return a hard code string to get xml_document list in timed replcation
String	getStringDelimiter()	PostgreSQL's string delimiter character: single quote (')
long	getUniqueID(Connection conn, String tableName)	The PostgreSQL unique ID /sequence generator The name of the sequence used to generate the unique id is made from the name of the table that uses the id by appending "_id_seq" to it.

Methods inherited from class edu.ucsb.nceas.dbadapter.AbstractDatabase

createObject, main, toDate

Methods inherited from class java.lang.Object

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

Constructor Details

PostgresqlAdapter

public PostgresqlAdapter()

Method Details

getUniqueID

public long getUniqueID(Connection conn,
 String tableName)
                 throws SQLException

The PostgreSQL unique ID /sequence generator The name of the sequence used to generate the unique id is made from the name of the table that uses the id by appending "_id_seq" to it. When record is inserted in the table and insert trigger gets a nextval from that sequence, select currval of that sequence can return the generated key in the same db connection.

Specified by:

getUniqueID in class AbstractDatabase

Parameters:

conn - db connection in which the unique id was generated

tableName - the name of table which unique id was generate

Returns:

return the generated unique id as a long type

Throws:

SQLException - any SQLException that can be thrown during the db operation

getDateTimeFunction

public String getDateTimeFunction()

The PostgreSQL function name that gets the current date and time from the database server

Specified by:

getDateTimeFunction in class AbstractDatabase

Returns:

return the current date and time function name: "now()"

getIsNULLFunction

public String getIsNULLFunction()

The PostgreSQL function name that is used to return non-NULL value

Specified by:

getIsNULLFunction in class AbstractDatabase

Returns:

return the non-NULL function name: "coalesce"

getStringDelimiter

public String getStringDelimiter()

PostgreSQL's string delimiter character: single quote (')

Specified by:

getStringDelimiter in class AbstractDatabase

Returns:

return the string delimiter: single quote (')

getLeftJoinQuery

public String getLeftJoinQuery(String selectFields,
 String tableA,
 String tableB,
 String joinCriteria,
 String nonJoinCriteria)

PostgreSQL's syntax for doing a left join Add 'a.' in front of the fields for first table and 'b.' in front of the fields for the second table

Specified by:

getLeftJoinQuery in class AbstractDatabase

Parameters:

selectFields - fields that you want to be selected

tableA - first table in the join

tableB - second table in the join

joinCriteria - the criteria based on which the join will be made

nonJoinCriteria - all other criterias

Returns:

return the string for teh select query

getReplicationDocumentListSQL

public String getReplicationDocumentListSQL()

Return a hard code string to get xml_document list in timed replcation

Specified by:

getReplicationDocumentListSQL in class AbstractDatabase

Returns:

getPagedQuery

public String getPagedQuery(String queryWithOrderBy,
 Integer start,
 Integer count)

Description copied from class: AbstractDatabase

for generating a query for paging

Specified by:

getPagedQuery in class AbstractDatabase

Parameters:

queryWithOrderBy - - the complete query with SELECT, FROM, WHERE and ORDER BY clauses

start - the row number to start from

count - the number of records from start to return

Returns:

query specific to the RDBMS in use