Top Description Fields Constructors Methods
org.postgresql.jdbc

public Class EscapedFunctions

extends Object
Class Inheritance
Annotations
@Deprecated
Imports
org.postgresql.util.GT, .PSQLException, .PSQLState, org.checkerframework.checker.nullness.qual.Nullable, java.lang.reflect.Method, java.sql.SQLException, java.util.HashMap, .List, .Locale, .Map

Deprecated

see EscapedFunctions2

This class stores supported escaped function.
Author
Xavier Poinsard

Field Summary

Modifier and TypeField and Description
public static final String
ABS

public static final String
ACOS

public static final String
ASCII

public static final String
ASIN

public static final String
ATAN

public static final String
ATAN2

public static final String
CEILING

public static final String
CHAR

public static final String
CONCAT

public static final String
COS

public static final String
COT

public static final String
CURDATE

public static final String
CURTIME

public static final String
DATABASE

public static final String
DAYNAME

public static final String
DAYOFMONTH

public static final String
DAYOFWEEK

public static final String
DAYOFYEAR

public static final String
DEGREES

public static final String
EXP

public static final String
FLOOR

private static Map<String, Method>
functionMap

storage for functions implementations.

public static final String
HOUR

public static final String
IFNULL

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
LOG

public static final String
LOG10

public static final String
LTRIM

public static final String
MINUTE

public static final String
MOD

public static final String
MONTH

public static final String
MONTHNAME

public static final String
NOW

public static final String
PI

public static final String
POWER

public static final String
QUARTER

public static final String
RADIANS

public static final String
REPEAT

public static final String
REPLACE

public static final String
RIGHT

public static final String
ROUND

public static final String
RTRIM

public static final String
SECOND

public static final String
SIGN

public static final String
SIN

public static final String
SPACE

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_ROOT

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
SQRT

public static final String
SUBSTRING

public static final String
TAN

public static final String
TIMESTAMPADD

public static final String
TIMESTAMPDIFF

public static final String
TRUNCATE

public static final String
UCASE

public static final String
USER

public static final String
WEEK

public static final String
YEAR

Constructor Summary

AccessConstructor and Description
public
EscapedFunctions()

Method Summary

Modifier and TypeMethod and Description
private static String
constantToDatePart(String type)

private static String
constantToInterval(String type, String value)

private static Map<String, Method>
createFunctionMap()

public static @Nullable Method

Returns:

a Method object or null if not found
getFunction(String
name of the searched function
functionName)

get Method object implementing the given function.

private static String
singleArgumentFunctionCall(String call, String functionName, List<?> parsedArgs)

public static String

Returns:

sql call
sqlceiling(List<?>
arguments
parsedArgs)

ceiling to ceil translation.

public static String

Returns:

sql call
sqlchar(List<?>
arguments
parsedArgs)

char to chr translation.

public static String

Returns:

sql call
sqlconcat(List<?>
arguments
parsedArgs)

concat translation.

public static String

Returns:

sql call
sqlcurdate(List<?>
arguments
parsedArgs)

curdate to current_date translation.

public static String

Returns:

sql call
sqlcurtime(List<?>
arguments
parsedArgs)

curtime to current_time translation.

public static String

Returns:

sql call
sqldatabase(List<?>
arguments
parsedArgs)

database translation.

public static String

Returns:

sql call
sqldayname(List<?>
arguments
parsedArgs)

dayname translation.

public static String

Returns:

sql call
sqldayofmonth(List<?>
arguments
parsedArgs)

dayofmonth translation.

public static String

Returns:

sql call
sqldayofweek(List<?>
arguments
parsedArgs)

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

public static String

Returns:

sql call
sqldayofyear(List<?>
arguments
parsedArgs)

dayofyear translation.

public static String

Returns:

sql call
sqlhour(List<?>
arguments
parsedArgs)

hour translation.

public static String

Returns:

sql call
sqlifnull(List<?>
arguments
parsedArgs)

ifnull translation.

public static String

Returns:

sql call
sqlinsert(List<?>
arguments
parsedArgs)

insert to overlay translation.

public static String

Returns:

sql call
sqllcase(List<?>
arguments
parsedArgs)

lcase to lower translation.

public static String

Returns:

sql call
sqlleft(List<?>
arguments
parsedArgs)

left to substring translation.

public static String

Returns:

sql call
sqllength(List<?>
arguments
parsedArgs)

length translation.

public static String

Returns:

sql call
sqllocate(List<?>
arguments
parsedArgs)

locate translation.

public static String

Returns:

sql call
sqllog(List<?>
arguments
parsedArgs)

log to ln translation.

public static String

Returns:

sql call
sqllog10(List<?>
arguments
parsedArgs)

log10 to log translation.

public static String

Returns:

sql call
sqlltrim(List<?>
arguments
parsedArgs)

ltrim translation.

public static String

Returns:

sql call
sqlminute(List<?>
arguments
parsedArgs)

minute translation.

public static String

Returns:

sql call
sqlmonth(List<?>
arguments
parsedArgs)

month translation.

public static String

Returns:

sql call
sqlmonthname(List<?>
arguments
parsedArgs)

monthname translation.

public static String

Returns:

sql call
sqlpower(List<?>
arguments
parsedArgs)

power to pow translation.

public static String

Returns:

sql call
sqlquarter(List<?>
arguments
parsedArgs)

quarter translation.

public static String

Returns:

sql call
sqlright(List<?>
arguments
parsedArgs)

right to substring translation.

public static String

Returns:

sql call
sqlrtrim(List<?>
arguments
parsedArgs)

rtrim translation.

public static String

Returns:

sql call
sqlsecond(List<?>
arguments
parsedArgs)

second translation.

public static String

Returns:

sql call
sqlspace(List<?>
arguments
parsedArgs)

space translation.

public static String

Returns:

sql call
sqlsubstring(List<?>
arguments
parsedArgs)

substring to substr translation.

public static String

Returns:

sql call
sqltimestampadd(List<? extends Object>
arguments
parsedArgs)

time stamp add.

public static String

Returns:

sql call
sqltimestampdiff(List<? extends Object>
arguments
parsedArgs)

time stamp diff.

public static String

Returns:

sql call
sqltruncate(List<?>
arguments
parsedArgs)

truncate to trunc translation.

public static String

Returns:

sql call
sqlucase(List<?>
arguments
parsedArgs)

ucase to upper translation.

public static String

Returns:

sql call
sqluser(List<?>
arguments
parsedArgs)

user translation.

public static String

Returns:

sql call
sqlweek(List<?>
arguments
parsedArgs)

week translation.

public static String

Returns:

sql call
sqlyear(List<?>
arguments
parsedArgs)

year translation.

private static String
twoArgumentsFunctionCall(String call, String functionName, List<?> parsedArgs)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait