org.openware.job.data.postgres
Class PostgresConverter

java.lang.Object
  |
  +--org.openware.job.data.Converter
        |
        +--org.openware.job.data.postgres.PostgresConverter

All Implemented Interfaces:

java.io.Serializable

public class PostgresConverter

extends Converter

PostgreSQL specific type and value conversions.

Version:

$Revision: 1.3 $ $Date: 2001/04/26 06:31:58 $

Author:

Vincent Sheffer

See Also:

Serialized Form

Constructor Summary

PostgresConverter()

Method Summary

java.lang.String	booleanToSql(java.lang.String value) Get a SQL value for the given boolean as an internal value suitable for a SQL statement.
java.lang.String	dateColumnName(java.lang.String columnName, java.lang.String alias) Select statements with Date types need to convert the date to a known format.
java.lang.String	dateToSql(java.lang.String value) Get a SQL value for the given Date as an internal value suitable for a SQL statement.
java.lang.String	numberToSql(java.lang.String value) Get a SQL value for the given number as an internal value suitable for a SQL statement.
java.lang.String	stringToSql(java.lang.String value) Get a SQL value for the given String as an internal value suitable for a SQL statement.
java.lang.String	translateWhereClause(java.lang.String whereClause) Translate the where clause from some known syntax to the desired database.

Methods inherited from class org.openware.job.data.Converter

booleanToInternal, dateToInternal, doubleToInternal, escapeWhereClause, floatToInternal, internalToBoolean, internalToDate, internalToDouble, internalToFloat, internalToInt, internalToLong, internalToString, intToInternal, longToInternal, replaceStr, stringToInternal

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgresConverter

public PostgresConverter()

Method Detail

dateColumnName

public java.lang.String dateColumnName(java.lang.String columnName,
                                       java.lang.String alias)

Select statements with Date types need to convert the date to a known format. Usually, the SQL 'to_char' method is used to do this. This method will return a date type SELECT column appropriate for this purpose.

Overrides:

dateColumnName in class Converter

dateToSql

public java.lang.String dateToSql(java.lang.String value)

Description copied from class: Converter

Get a SQL value for the given Date as an internal value suitable for a SQL statement.

Overrides:

dateToSql in class Converter

Following copied from class: org.openware.job.data.Converter

Parameters:

string - The internal value to convert to a SQL value.

translateWhereClause

public java.lang.String translateWhereClause(java.lang.String whereClause)

Description copied from class: Converter

Translate the where clause from some known syntax to the desired database.

Overrides:

translateWhereClause in class Converter

numberToSql

public java.lang.String numberToSql(java.lang.String value)

Description copied from class: Converter

Get a SQL value for the given number as an internal value suitable for a SQL statement.

Overrides:

numberToSql in class Converter

Following copied from class: org.openware.job.data.Converter

Parameters:

string - The internal value to convert to a SQL value.

booleanToSql

public java.lang.String booleanToSql(java.lang.String value)

Description copied from class: Converter

Get a SQL value for the given boolean as an internal value suitable for a SQL statement.

Overrides:

booleanToSql in class Converter

Following copied from class: org.openware.job.data.Converter

Parameters:

string - The internal value to convert to a SQL value.

stringToSql

public java.lang.String stringToSql(java.lang.String value)

Description copied from class: Converter

Get a SQL value for the given String as an internal value suitable for a SQL statement.

Overrides:

stringToSql in class Converter

Following copied from class: org.openware.job.data.Converter

Parameters:

string - The internal value to convert to a SQL value.