Package org.postgresql.jdbc

Class EscapedFunctions

java.lang.Object

org.postgresql.jdbc.EscapedFunctions

public class EscapedFunctions
extends java.lang.Object

This class stores supported escaped function

Author:

Xavier Poinsard

Field Summary

Fields

Modifier and Type	Field	Description
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

Constructors

Constructor	Description
EscapedFunctions()

Method Summary

Modifier and Type	Method	Description
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

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqllog

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

log to ln translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqllog10

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

log10 to log translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlpower

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

power to pow translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqltruncate

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

truncate to trunc translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlchar

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

char to chr translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlconcat

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

concat translation

Parameters:

parsedArgs - arguments

Returns:

sql call

sqlinsert

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

insert to overlay translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqllcase

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

lcase to lower translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlleft

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

left to substring translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqllength

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

length translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqllocate

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

locate translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlltrim

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

ltrim translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlright

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

right to substring translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlrtrim

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

rtrim translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlspace

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

space translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlsubstring

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

substring to substr translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlucase

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

ucase to upper translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlcurdate

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

curdate to current_date translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlcurtime

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

curtime to current_time translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqldayname

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

dayname translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqldayofmonth

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

dayofmonth translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

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

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqldayofyear

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

dayofyear translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlhour

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

hour translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlminute

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

minute translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlmonth

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

month translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlmonthname

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

monthname translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlquarter

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

quarter translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlsecond

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

second translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlweek

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

week translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlyear

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

year translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqltimestampadd

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

time stamp add

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqltimestampdiff

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

time stamp diff

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqldatabase

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

database translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqlifnull

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

ifnull translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens

sqluser

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

user translation

Parameters:

parsedArgs - arguments

Returns:

sql call

Throws:

java.sql.SQLException - if something wrong happens