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