org.postgresql.jdbc2
Class EscapedFunctions

java.lang.Object
  org.postgresql.jdbc2.EscapedFunctions

public class EscapedFunctions
extends java.lang.Object

this class stores supported escaped function

Author:

Xavier Poinsard

Field Summary

static java.lang.String	ABS
static java.lang.String	ACOS
static java.lang.String	ASCII
static java.lang.String	ASIN
static java.lang.String	ATAN
static java.lang.String	ATAN2
static java.lang.String	CEILING
static java.lang.String	CHAR
static java.lang.String	CONCAT
static java.lang.String	COS
static java.lang.String	COT
static java.lang.String	CURDATE
static java.lang.String	CURTIME
static java.lang.String	DATABASE
static java.lang.String	DAYNAME
static java.lang.String	DAYOFMONTH
static java.lang.String	DAYOFWEEK
static java.lang.String	DAYOFYEAR
static java.lang.String	DEGREES
static java.lang.String	EXP
static java.lang.String	FLOOR
static java.lang.String	HOUR
static java.lang.String	IFNULL
static java.lang.String	INSERT
static java.lang.String	LCASE
static java.lang.String	LEFT
static java.lang.String	LENGTH
static java.lang.String	LOCATE
static java.lang.String	LOG
static java.lang.String	LOG10
static java.lang.String	LTRIM
static java.lang.String	MINUTE
static java.lang.String	MOD
static java.lang.String	MONTH
static java.lang.String	MONTHNAME
static java.lang.String	NOW
static java.lang.String	PI
static java.lang.String	POWER
static java.lang.String	QUARTER
static java.lang.String	RADIANS
static java.lang.String	REPEAT
static java.lang.String	REPLACE
static java.lang.String	RIGHT
static java.lang.String	ROUND
static java.lang.String	RTRIM
static java.lang.String	SECOND
static java.lang.String	SIGN
static java.lang.String	SIN
static java.lang.String	SPACE
static java.lang.String	SQL_TSI_DAY
static java.lang.String	SQL_TSI_FRAC_SECOND
static java.lang.String	SQL_TSI_HOUR
static java.lang.String	SQL_TSI_MINUTE
static java.lang.String	SQL_TSI_MONTH
static java.lang.String	SQL_TSI_QUARTER
static java.lang.String	SQL_TSI_ROOT
static java.lang.String	SQL_TSI_SECOND
static java.lang.String	SQL_TSI_WEEK
static java.lang.String	SQL_TSI_YEAR
static java.lang.String	SQRT
static java.lang.String	SUBSTRING
static java.lang.String	TAN
static java.lang.String	TIMESTAMPADD
static java.lang.String	TIMESTAMPDIFF
static java.lang.String	TRUNCATE
static java.lang.String	UCASE
static java.lang.String	USER
static java.lang.String	WEEK
static java.lang.String	YEAR

Constructor Summary

EscapedFunctions()

Method Summary

static java.lang.reflect.Method	getFunction(java.lang.String functionName) get Method object implementing the given function
static java.lang.String	sqlceiling(java.util.List parsedArgs) ceiling to ceil translation
static java.lang.String	sqlchar(java.util.List parsedArgs) char to chr translation
static java.lang.String	sqlconcat(java.util.List parsedArgs) concat translation
static java.lang.String	sqlcurdate(java.util.List parsedArgs) curdate to current_date translation
static java.lang.String	sqlcurtime(java.util.List parsedArgs) curtime to current_time translation
static java.lang.String	sqldatabase(java.util.List parsedArgs) database translation
static java.lang.String	sqldayname(java.util.List parsedArgs) dayname translation
static java.lang.String	sqldayofmonth(java.util.List parsedArgs) dayofmonth translation
static java.lang.String	sqldayofweek(java.util.List parsedArgs) dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7
static java.lang.String	sqldayofyear(java.util.List parsedArgs) dayofyear translation
static java.lang.String	sqlhour(java.util.List parsedArgs) hour translation
static java.lang.String	sqlifnull(java.util.List parsedArgs) ifnull translation
static java.lang.String	sqlinsert(java.util.List parsedArgs) insert to overlay translation
static java.lang.String	sqllcase(java.util.List parsedArgs) lcase to lower translation
static java.lang.String	sqlleft(java.util.List parsedArgs) left to substring translation
static java.lang.String	sqllength(java.util.List parsedArgs) length translation
static java.lang.String	sqllocate(java.util.List parsedArgs) locate translation
static java.lang.String	sqllog(java.util.List parsedArgs) log to ln translation
static java.lang.String	sqllog10(java.util.List parsedArgs) log10 to log translation
static java.lang.String	sqlltrim(java.util.List parsedArgs) ltrim translation
static java.lang.String	sqlminute(java.util.List parsedArgs) minute translation
static java.lang.String	sqlmonth(java.util.List parsedArgs) month translation
static java.lang.String	sqlmonthname(java.util.List parsedArgs) monthname translation
static java.lang.String	sqlpower(java.util.List parsedArgs) power to pow translation
static java.lang.String	sqlquarter(java.util.List parsedArgs) quarter translation
static java.lang.String	sqlright(java.util.List parsedArgs) right to substring translation
static java.lang.String	sqlrtrim(java.util.List parsedArgs) rtrim translation
static java.lang.String	sqlsecond(java.util.List parsedArgs) second translation
static java.lang.String	sqlspace(java.util.List parsedArgs) space translation
static java.lang.String	sqlsubstring(java.util.List parsedArgs) substring to substr translation
static java.lang.String	sqltimestampadd(java.util.List parsedArgs) time stamp add
static java.lang.String	sqltimestampdiff(java.util.List parsedArgs) time stamp diff
static java.lang.String	sqltruncate(java.util.List parsedArgs) truncate to trunc translation
static java.lang.String	sqlucase(java.util.List parsedArgs) ucase to upper translation
static java.lang.String	sqluser(java.util.List parsedArgs) user translation
static java.lang.String	sqlweek(java.util.List parsedArgs) week translation
static java.lang.String	sqlyear(java.util.List parsedArgs) year translation

Methods inherited from class java.lang.Object

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

Field Detail

ABS

public static final java.lang.String ABS

See Also:

Constant Field Values

ACOS

public static final java.lang.String ACOS

See Also:

Constant Field Values

ASIN

public static final java.lang.String ASIN

See Also:

Constant Field Values

ATAN

public static final java.lang.String ATAN

See Also:

Constant Field Values

ATAN2

public static final java.lang.String ATAN2

See Also:

Constant Field Values

CEILING

public static final java.lang.String CEILING

See Also:

Constant Field Values

COS

public static final java.lang.String COS

See Also:

Constant Field Values

COT

public static final java.lang.String COT

See Also:

Constant Field Values

DEGREES

public static final java.lang.String DEGREES

See Also:

Constant Field Values

EXP

public static final java.lang.String EXP

See Also:

Constant Field Values

FLOOR

public static final java.lang.String FLOOR

See Also:

Constant Field Values

LOG

public static final java.lang.String LOG

See Also:

Constant Field Values

LOG10

public static final java.lang.String LOG10

See Also:

Constant Field Values

MOD

public static final java.lang.String MOD

See Also:

Constant Field Values

PI

public static final java.lang.String PI

See Also:

Constant Field Values

POWER

public static final java.lang.String POWER

See Also:

Constant Field Values

RADIANS

public static final java.lang.String RADIANS

See Also:

Constant Field Values

ROUND

public static final java.lang.String ROUND

See Also:

Constant Field Values

SIGN

public static final java.lang.String SIGN

See Also:

Constant Field Values

SIN

public static final java.lang.String SIN

See Also:

Constant Field Values

SQRT

public static final java.lang.String SQRT

See Also:

Constant Field Values

TAN

public static final java.lang.String TAN

See Also:

Constant Field Values

TRUNCATE

public static final java.lang.String TRUNCATE

See Also:

Constant Field Values

ASCII

public static final java.lang.String ASCII

See Also:

Constant Field Values

CHAR

public static final java.lang.String CHAR

See Also:

Constant Field Values

CONCAT

public static final java.lang.String CONCAT

See Also:

Constant Field Values

INSERT

public static final java.lang.String INSERT

See Also:

Constant Field Values

LCASE

public static final java.lang.String LCASE

See Also:

Constant Field Values

LEFT

public static final java.lang.String LEFT

See Also:

Constant Field Values

LENGTH

public static final java.lang.String LENGTH

See Also:

Constant Field Values

LOCATE

public static final java.lang.String LOCATE

See Also:

Constant Field Values

LTRIM

public static final java.lang.String LTRIM

See Also:

Constant Field Values

REPEAT

public static final java.lang.String REPEAT

See Also:

Constant Field Values

REPLACE

public static final java.lang.String REPLACE

See Also:

Constant Field Values

RIGHT

public static final java.lang.String RIGHT

See Also:

Constant Field Values

RTRIM

public static final java.lang.String RTRIM

See Also:

Constant Field Values

SPACE

public static final java.lang.String SPACE

See Also:

Constant Field Values

SUBSTRING

public static final java.lang.String SUBSTRING

See Also:

Constant Field Values

UCASE

public static final java.lang.String UCASE

See Also:

Constant Field Values

CURDATE

public static final java.lang.String CURDATE

See Also:

Constant Field Values

CURTIME

public static final java.lang.String CURTIME

See Also:

Constant Field Values

DAYNAME

public static final java.lang.String DAYNAME

See Also:

Constant Field Values

DAYOFMONTH

public static final java.lang.String DAYOFMONTH

See Also:

Constant Field Values

DAYOFWEEK

public static final java.lang.String DAYOFWEEK

See Also:

Constant Field Values

DAYOFYEAR

public static final java.lang.String DAYOFYEAR

See Also:

Constant Field Values

HOUR

public static final java.lang.String HOUR

See Also:

Constant Field Values

MINUTE

public static final java.lang.String MINUTE

See Also:

Constant Field Values

MONTH

public static final java.lang.String MONTH

See Also:

Constant Field Values

MONTHNAME

public static final java.lang.String MONTHNAME

See Also:

Constant Field Values

NOW

public static final java.lang.String NOW

See Also:

Constant Field Values

QUARTER

public static final java.lang.String QUARTER

See Also:

Constant Field Values

SECOND

public static final java.lang.String SECOND

See Also:

Constant Field Values

WEEK

public static final java.lang.String WEEK

See Also:

Constant Field Values

YEAR

public static final java.lang.String YEAR

See Also:

Constant Field Values

TIMESTAMPADD

public static final java.lang.String TIMESTAMPADD

See Also:

Constant Field Values

TIMESTAMPDIFF

public static final java.lang.String TIMESTAMPDIFF

See Also:

Constant Field Values

SQL_TSI_ROOT

public static final java.lang.String SQL_TSI_ROOT

See Also:

Constant Field Values

SQL_TSI_DAY

public static final java.lang.String SQL_TSI_DAY

See Also:

Constant Field Values

SQL_TSI_FRAC_SECOND

public static final java.lang.String SQL_TSI_FRAC_SECOND

See Also:

Constant Field Values

SQL_TSI_HOUR

public static final java.lang.String SQL_TSI_HOUR

See Also:

Constant Field Values

SQL_TSI_MINUTE

public static final java.lang.String SQL_TSI_MINUTE

See Also:

Constant Field Values

SQL_TSI_MONTH

public static final java.lang.String SQL_TSI_MONTH

See Also:

Constant Field Values

SQL_TSI_QUARTER

public static final java.lang.String SQL_TSI_QUARTER

See Also:

Constant Field Values

SQL_TSI_SECOND

public static final java.lang.String SQL_TSI_SECOND

See Also:

Constant Field Values

SQL_TSI_WEEK

public static final java.lang.String SQL_TSI_WEEK

See Also:

Constant Field Values

SQL_TSI_YEAR

public static final java.lang.String SQL_TSI_YEAR

See Also:

Constant Field Values

DATABASE

public static final java.lang.String DATABASE

See Also:

Constant Field Values

IFNULL

public static final java.lang.String IFNULL

See Also:

Constant Field Values

USER

public static final java.lang.String USER

See Also:

Constant Field Values

Constructor Detail

EscapedFunctions

public EscapedFunctions()

Method Detail

getFunction

public static java.lang.reflect.Method getFunction(java.lang.String functionName)

get Method object implementing the given function

Parameters:

functionName - name of the searched function

Returns:

a Method object or null if not found

sqlceiling

public static java.lang.String sqlceiling(java.util.List parsedArgs)
                                   throws java.sql.SQLException

ceiling to ceil translation

Throws:

java.sql.SQLException

sqllog

public static java.lang.String sqllog(java.util.List parsedArgs)
                               throws java.sql.SQLException

log to ln translation

Throws:

java.sql.SQLException

sqllog10

public static java.lang.String sqllog10(java.util.List parsedArgs)
                                 throws java.sql.SQLException

log10 to log translation

Throws:

java.sql.SQLException

sqlpower

public static java.lang.String sqlpower(java.util.List parsedArgs)
                                 throws java.sql.SQLException

power to pow translation

Throws:

java.sql.SQLException

sqltruncate

public static java.lang.String sqltruncate(java.util.List parsedArgs)
                                    throws java.sql.SQLException

truncate to trunc translation

Throws:

java.sql.SQLException

sqlchar

public static java.lang.String sqlchar(java.util.List parsedArgs)
                                throws java.sql.SQLException

char to chr translation

Throws:

java.sql.SQLException

sqlconcat

public static java.lang.String sqlconcat(java.util.List parsedArgs)

concat translation

sqlinsert

public static java.lang.String sqlinsert(java.util.List parsedArgs)
                                  throws java.sql.SQLException

insert to overlay translation

Throws:

java.sql.SQLException

sqllcase

public static java.lang.String sqllcase(java.util.List parsedArgs)
                                 throws java.sql.SQLException

lcase to lower translation

Throws:

java.sql.SQLException

sqlleft

public static java.lang.String sqlleft(java.util.List parsedArgs)
                                throws java.sql.SQLException

left to substring translation

Throws:

java.sql.SQLException

sqllength

public static java.lang.String sqllength(java.util.List parsedArgs)
                                  throws java.sql.SQLException

length translation

Throws:

java.sql.SQLException

sqllocate

public static java.lang.String sqllocate(java.util.List parsedArgs)
                                  throws java.sql.SQLException

locate translation

Throws:

java.sql.SQLException

sqlltrim

public static java.lang.String sqlltrim(java.util.List parsedArgs)
                                 throws java.sql.SQLException

ltrim translation

Throws:

java.sql.SQLException

sqlright

public static java.lang.String sqlright(java.util.List parsedArgs)
                                 throws java.sql.SQLException

right to substring translation

Throws:

java.sql.SQLException

sqlrtrim

public static java.lang.String sqlrtrim(java.util.List parsedArgs)
                                 throws java.sql.SQLException

rtrim translation

Throws:

java.sql.SQLException

sqlspace

public static java.lang.String sqlspace(java.util.List parsedArgs)
                                 throws java.sql.SQLException

space translation

Throws:

java.sql.SQLException

sqlsubstring

public static java.lang.String sqlsubstring(java.util.List parsedArgs)
                                     throws java.sql.SQLException

substring to substr translation

Throws:

java.sql.SQLException

sqlucase

public static java.lang.String sqlucase(java.util.List parsedArgs)
                                 throws java.sql.SQLException

ucase to upper translation

Throws:

java.sql.SQLException

sqlcurdate

public static java.lang.String sqlcurdate(java.util.List parsedArgs)
                                   throws java.sql.SQLException

curdate to current_date translation

Throws:

java.sql.SQLException

sqlcurtime

public static java.lang.String sqlcurtime(java.util.List parsedArgs)
                                   throws java.sql.SQLException

curtime to current_time translation

Throws:

java.sql.SQLException

sqldayname

public static java.lang.String sqldayname(java.util.List parsedArgs)
                                   throws java.sql.SQLException

dayname translation

Throws:

java.sql.SQLException

sqldayofmonth

public static java.lang.String sqldayofmonth(java.util.List parsedArgs)
                                      throws java.sql.SQLException

dayofmonth translation

Throws:

java.sql.SQLException

sqldayofweek

public static java.lang.String sqldayofweek(java.util.List parsedArgs)
                                     throws java.sql.SQLException

dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7

Throws:

java.sql.SQLException

sqldayofyear

public static java.lang.String sqldayofyear(java.util.List parsedArgs)
                                     throws java.sql.SQLException

dayofyear translation

Throws:

java.sql.SQLException

sqlhour

public static java.lang.String sqlhour(java.util.List parsedArgs)
                                throws java.sql.SQLException

hour translation

Throws:

java.sql.SQLException

sqlminute

public static java.lang.String sqlminute(java.util.List parsedArgs)
                                  throws java.sql.SQLException

minute translation

Throws:

java.sql.SQLException

sqlmonth

public static java.lang.String sqlmonth(java.util.List parsedArgs)
                                 throws java.sql.SQLException

month translation

Throws:

java.sql.SQLException

sqlmonthname

public static java.lang.String sqlmonthname(java.util.List parsedArgs)
                                     throws java.sql.SQLException

monthname translation

Throws:

java.sql.SQLException

sqlquarter

public static java.lang.String sqlquarter(java.util.List parsedArgs)
                                   throws java.sql.SQLException

quarter translation

Throws:

java.sql.SQLException

sqlsecond

public static java.lang.String sqlsecond(java.util.List parsedArgs)
                                  throws java.sql.SQLException

second translation

Throws:

java.sql.SQLException

sqlweek

public static java.lang.String sqlweek(java.util.List parsedArgs)
                                throws java.sql.SQLException

week translation

Throws:

java.sql.SQLException

sqlyear

public static java.lang.String sqlyear(java.util.List parsedArgs)
                                throws java.sql.SQLException

year translation

Throws:

java.sql.SQLException

sqltimestampadd

public static java.lang.String sqltimestampadd(java.util.List parsedArgs)
                                        throws java.sql.SQLException

time stamp add

Throws:

java.sql.SQLException

sqltimestampdiff

public static java.lang.String sqltimestampdiff(java.util.List parsedArgs)
                                         throws java.sql.SQLException

time stamp diff

Throws:

java.sql.SQLException

sqldatabase

public static java.lang.String sqldatabase(java.util.List parsedArgs)
                                    throws java.sql.SQLException

database translation

Throws:

java.sql.SQLException

sqlifnull

public static java.lang.String sqlifnull(java.util.List parsedArgs)
                                  throws java.sql.SQLException

ifnull translation

Throws:

java.sql.SQLException

sqluser

public static java.lang.String sqluser(java.util.List parsedArgs)
                                throws java.sql.SQLException

user translation

Throws:

java.sql.SQLException