public class EscapedFunctions extends Object
Constructor and Description |
---|
EscapedFunctions() |
Modifier and Type | Method and Description |
---|---|
static Method |
getFunction(String functionName)
get Method object implementing the given function
|
static String |
sqlceiling(List parsedArgs)
ceiling to ceil translation
|
static String |
sqlchar(List parsedArgs)
char to chr translation
|
static String |
sqlconcat(List parsedArgs)
concat translation
|
static String |
sqlcurdate(List parsedArgs)
curdate to current_date translation
|
static String |
sqlcurtime(List parsedArgs)
curtime to current_time translation
|
static String |
sqldatabase(List parsedArgs)
database translation
|
static String |
sqldayname(List parsedArgs)
dayname translation
|
static String |
sqldayofmonth(List parsedArgs)
dayofmonth translation
|
static String |
sqldayofweek(List parsedArgs)
dayofweek translation
adding 1 to postgresql function since we expect values from 1 to 7
|
static String |
sqldayofyear(List parsedArgs)
dayofyear translation
|
static String |
sqlhour(List parsedArgs)
hour translation
|
static String |
sqlifnull(List parsedArgs)
ifnull translation
|
static String |
sqlinsert(List parsedArgs)
insert to overlay translation
|
static String |
sqllcase(List parsedArgs)
lcase to lower translation
|
static String |
sqlleft(List parsedArgs)
left to substring translation
|
static String |
sqllength(List parsedArgs)
length translation
|
static String |
sqllocate(List parsedArgs)
locate translation
|
static String |
sqllog(List parsedArgs)
log to ln translation
|
static String |
sqllog10(List parsedArgs)
log10 to log translation
|
static String |
sqlltrim(List parsedArgs)
ltrim translation
|
static String |
sqlminute(List parsedArgs)
minute translation
|
static String |
sqlmonth(List parsedArgs)
month translation
|
static String |
sqlmonthname(List parsedArgs)
monthname translation
|
static String |
sqlpower(List parsedArgs)
power to pow translation
|
static String |
sqlquarter(List parsedArgs)
quarter translation
|
static String |
sqlright(List parsedArgs)
right to substring translation
|
static String |
sqlrtrim(List parsedArgs)
rtrim translation
|
static String |
sqlsecond(List parsedArgs)
second translation
|
static String |
sqlspace(List parsedArgs)
space translation
|
static String |
sqlsubstring(List parsedArgs)
substring to substr translation
|
static String |
sqltimestampadd(List parsedArgs)
time stamp add
|
static String |
sqltimestampdiff(List parsedArgs)
time stamp diff
|
static String |
sqltruncate(List parsedArgs)
truncate to trunc translation
|
static String |
sqlucase(List parsedArgs)
ucase to upper translation
|
static String |
sqluser(List parsedArgs)
user translation
|
static String |
sqlweek(List parsedArgs)
week translation
|
static String |
sqlyear(List parsedArgs)
year translation
|
public static final String ABS
public static final String ACOS
public static final String ASIN
public static final String ATAN
public static final String ATAN2
public static final String CEILING
public static final String COS
public static final String COT
public static final String DEGREES
public static final String EXP
public static final String FLOOR
public static final String LOG
public static final String LOG10
public static final String MOD
public static final String PI
public static final String POWER
public static final String RADIANS
public static final String ROUND
public static final String SIGN
public static final String SIN
public static final String SQRT
public static final String TAN
public static final String TRUNCATE
public static final String ASCII
public static final String CHAR
public static final String CONCAT
public static final String INSERT
public static final String LCASE
public static final String LEFT
public static final String LENGTH
public static final String LOCATE
public static final String LTRIM
public static final String REPEAT
public static final String REPLACE
public static final String RIGHT
public static final String RTRIM
public static final String SPACE
public static final String SUBSTRING
public static final String UCASE
public static final String CURDATE
public static final String CURTIME
public static final String DAYNAME
public static final String DAYOFMONTH
public static final String DAYOFWEEK
public static final String DAYOFYEAR
public static final String HOUR
public static final String MINUTE
public static final String MONTH
public static final String MONTHNAME
public static final String NOW
public static final String QUARTER
public static final String SECOND
public static final String WEEK
public static final String YEAR
public static final String TIMESTAMPADD
public static final String TIMESTAMPDIFF
public static final String SQL_TSI_ROOT
public static final String SQL_TSI_DAY
public static final String SQL_TSI_FRAC_SECOND
public static final String SQL_TSI_HOUR
public static final String SQL_TSI_MINUTE
public static final String SQL_TSI_MONTH
public static final String SQL_TSI_QUARTER
public static final String SQL_TSI_SECOND
public static final String SQL_TSI_WEEK
public static final String SQL_TSI_YEAR
public static final String DATABASE
public static final String IFNULL
public static final String USER
public static Method getFunction(String functionName)
functionName
- name of the searched functionpublic static String sqlceiling(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqllog(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqllog10(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlpower(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqltruncate(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlchar(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlconcat(List parsedArgs)
parsedArgs
- argumentspublic static String sqlinsert(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqllcase(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlleft(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqllength(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqllocate(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlltrim(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlright(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlrtrim(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlspace(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlsubstring(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlucase(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlcurdate(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlcurtime(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqldayname(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqldayofmonth(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqldayofweek(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqldayofyear(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlhour(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlminute(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlmonth(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlmonthname(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlquarter(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlsecond(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlweek(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlyear(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqltimestampadd(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqltimestampdiff(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqldatabase(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqlifnull(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happenspublic static String sqluser(List parsedArgs) throws SQLException
parsedArgs
- argumentsSQLException
- if something wrong happensCopyright © 2016 PostgreSQL Global Development Group. All rights reserved.