net.aditsu.depeche

Class PGProvider

java.lang.Object

net.aditsu.depeche.Provider

net.aditsu.depeche.PGProvider

All Implemented Interfaces:

Serializable

public class PGProvider
extends Provider

Provider implementation for PostgreSQL

Author:

aditsu

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
PGProvider(ConnSource cs) Creates a PGProvider using a connection source
PGProvider(String host, int port, String db, String user, String password) Creates a PGProvider using connection details including port number
PGProvider(String host, String db, String user, String password) Creates a PGProvider using connection details

Method Summary

Methods

Modifier and Type	Method and Description
static DSConnSource	createConnSource(String host, int port, String db, String user, String password) Creates a PostgreSQL connection source
RawQuery	getColumnCommentQuery(String table, String column, String value) Returns a query for setting a comment on a table column
List<String>	getEnumValues(Column c) Returns the list of values for a column with an enumerated type
long	getLongLastId(Conn conn) Returns the last generated auto-increment value in a given connection as a long value
List<UniqueConstraint>	getUniqueConstraints(Table t) Returns a list of all the unique constraints on the given table (not including the primary key)
String	getViewDefinition(Table view) Returns the definition of the given view
boolean	isEnum(String type)

Methods inherited from class net.aditsu.depeche.Provider

addColumn, addColumn, addFKey, addFKey, addUnique, addUnique, batchInsert, batchInsert, clearTable, close, createTable, createTable, createView, createView, dropColumn, dropColumn, dropFKey, dropFKey, dropTable, dropTable, dropView, dropView, execute, execute, filter, filter, filter, filterIn, getAddColumnSQL, getAddFKeySQL, getAddUniqueSQL, getAllTables, getAllViews, getColumnDesc, getCreateTableSQL, getCreateViewSQL, getDropColumnSQL, getDropFKeySQL, getDropTableSQL, getDropViewSQL, getGenericTableDetails, getGenericTables, getLastId, getName, getProviderRef, getRecord, getRecord, getRecord, getRecord, getRecord, getRecord, getTableInfo, getTableInfo, getTableInfo, getTableInfo, getTables, getTableTypes, getViews, hasFlag, joinCondition, joinCondition, joinCondition, newRecord, newRecord, newRecord, query, query, query, query, query, quote, rawQuery, rawQuery, rawQuote, resolveTable, resolveTable, run, setColumnComment, setColumnComment, setName, setProviderRef, transaction

Methods inherited from class java.lang.Object

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

Constructor Detail

PGProvider

public PGProvider(ConnSource cs)

Creates a PGProvider using a connection source

PGProvider

public PGProvider(String host,
          String db,
          String user,
          String password)

Creates a PGProvider using connection details

PGProvider

public PGProvider(String host,
          int port,
          String db,
          String user,
          String password)

Creates a PGProvider using connection details including port number

Method Detail

createConnSource

public static DSConnSource createConnSource(String host,
                            int port,
                            String db,
                            String user,
                            String password)

Creates a PostgreSQL connection source

getLongLastId

public long getLongLastId(Conn conn)

Description copied from class: Provider

Returns the last generated auto-increment value in a given connection as a long value

Overrides:

getLongLastId in class Provider

isEnum

public boolean isEnum(String type)

getEnumValues

public List<String> getEnumValues(Column c)

Description copied from class: Provider

Returns the list of values for a column with an enumerated type

Overrides:

getEnumValues in class Provider

getUniqueConstraints

public List<UniqueConstraint> getUniqueConstraints(Table t)

Description copied from class: Provider

Returns a list of all the unique constraints on the given table (not including the primary key)

Overrides:

getUniqueConstraints in class Provider

getViewDefinition

public String getViewDefinition(Table view)

Description copied from class: Provider

Returns the definition of the given view

Overrides:

getViewDefinition in class Provider

getColumnCommentQuery

public RawQuery getColumnCommentQuery(String table,
                             String column,
                             String value)

Description copied from class: Provider

Returns a query for setting a comment on a table column

Overrides:

getColumnCommentQuery in class Provider