public final class EscapedFunctions2
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
private static java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> |
FUNCTION_MAP
storage for functions implementations
|
private static java.lang.String |
SQL_TSI_DAY |
private static java.lang.String |
SQL_TSI_FRAC_SECOND |
private static java.lang.String |
SQL_TSI_HOUR |
private static java.lang.String |
SQL_TSI_MINUTE |
private static java.lang.String |
SQL_TSI_MONTH |
private static java.lang.String |
SQL_TSI_QUARTER |
private static java.lang.String |
SQL_TSI_ROOT |
private static java.lang.String |
SQL_TSI_SECOND |
private static java.lang.String |
SQL_TSI_WEEK |
private static java.lang.String |
SQL_TSI_YEAR |
Constructor and Description |
---|
EscapedFunctions2() |
Modifier and Type | Method and Description |
---|---|
static void |
appendCall(java.lang.StringBuilder sb,
java.lang.String begin,
java.lang.String separator,
java.lang.String end,
java.util.List<? extends java.lang.CharSequence> args)
Appends
begin arg0 separator arg1 separator end sequence to the input StringBuilder |
private static void |
appendInterval(java.lang.StringBuilder buf,
java.lang.String type,
java.lang.String value) |
private static boolean |
appendSingleIntervalCast(java.lang.StringBuilder buf,
java.lang.String cmp,
java.lang.String type,
java.lang.String value,
java.lang.String pgType) |
private static boolean |
areSameTsi(java.lang.String a,
java.lang.String b)
Compares two TSI intervals.
|
private static java.lang.String |
constantToDatePart(java.lang.StringBuilder buf,
java.lang.String type) |
private static java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> |
createFunctionMap(java.lang.String prefix) |
static java.lang.reflect.Method |
getFunction(java.lang.String functionName)
get Method object implementing the given function
|
private static boolean |
isTsi(java.lang.String interval)
Checks if given input starts with
SQL_TSI_ROOT |
private static void |
singleArgumentFunctionCall(java.lang.StringBuilder buf,
java.lang.String call,
java.lang.String functionName,
java.util.List<? extends java.lang.CharSequence> parsedArgs) |
static void |
sqlceiling(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
ceiling to ceil translation
|
static void |
sqlchar(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
char to chr translation
|
static void |
sqlconcat(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
concat translation
|
static void |
sqlcurdate(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
curdate to current_date translation
|
static void |
sqlcurtime(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
curtime to current_time translation
|
static void |
sqldatabase(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
database translation
|
static void |
sqldayname(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayname translation
|
static void |
sqldayofmonth(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayofmonth translation
|
static void |
sqldayofweek(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7
|
static void |
sqldayofyear(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayofyear translation
|
static void |
sqlhour(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
hour translation
|
static void |
sqlifnull(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
ifnull translation
|
static void |
sqlinsert(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
insert to overlay translation
|
static void |
sqllcase(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
lcase to lower translation
|
static void |
sqlleft(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
left to substring translation
|
static void |
sqllength(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
length translation
|
static void |
sqllocate(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
locate translation
|
static void |
sqllog(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
log to ln translation
|
static void |
sqllog10(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
log10 to log translation
|
static void |
sqlltrim(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
ltrim translation
|
static void |
sqlminute(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
minute translation
|
static void |
sqlmonth(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
month translation
|
static void |
sqlmonthname(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
monthname translation
|
static void |
sqlpower(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
power to pow translation
|
static void |
sqlquarter(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
quarter translation
|
static void |
sqlright(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
right to substring translation
|
static void |
sqlrtrim(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
rtrim translation
|
static void |
sqlsecond(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
second translation
|
static void |
sqlspace(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
space translation
|
static void |
sqlsubstring(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
substring to substr translation
|
static void |
sqltimestampadd(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
time stamp add
|
static void |
sqltimestampdiff(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
time stamp diff
|
static void |
sqltruncate(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
truncate to trunc translation
|
static void |
sqlucase(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
ucase to upper translation
|
static void |
sqluser(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
user translation
|
static void |
sqlweek(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
week translation
|
static void |
sqlyear(java.lang.StringBuilder buf,
java.util.List<? extends java.lang.CharSequence> parsedArgs)
year translation
|
private static void |
twoArgumentsFunctionCall(java.lang.StringBuilder buf,
java.lang.String call,
java.lang.String functionName,
java.util.List<? extends java.lang.CharSequence> parsedArgs) |
private static void |
zeroArgumentFunctionCall(java.lang.StringBuilder buf,
java.lang.String call,
java.lang.String functionName,
java.util.List<? extends java.lang.CharSequence> parsedArgs) |
private static final java.lang.String SQL_TSI_ROOT
private static final java.lang.String SQL_TSI_DAY
private static final java.lang.String SQL_TSI_FRAC_SECOND
private static final java.lang.String SQL_TSI_HOUR
private static final java.lang.String SQL_TSI_MINUTE
private static final java.lang.String SQL_TSI_MONTH
private static final java.lang.String SQL_TSI_QUARTER
private static final java.lang.String SQL_TSI_SECOND
private static final java.lang.String SQL_TSI_WEEK
private static final java.lang.String SQL_TSI_YEAR
private static final java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> FUNCTION_MAP
private static java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> createFunctionMap(java.lang.String prefix)
public static java.lang.reflect.Method getFunction(java.lang.String functionName)
functionName
- name of the searched functionpublic static void sqlceiling(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqllog(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqllog10(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlpower(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqltruncate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlchar(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlconcat(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
buf
- The buffer to append intoparsedArgs
- argumentspublic static void sqlinsert(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqllcase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlleft(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqllength(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqllocate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlltrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlright(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlrtrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlspace(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlsubstring(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlucase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlcurdate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlcurtime(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqldayname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqldayofmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqldayofweek(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqldayofyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlhour(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlminute(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlmonthname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlquarter(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlsecond(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlweek(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqltimestampadd(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happensprivate static void appendInterval(java.lang.StringBuilder buf, java.lang.String type, java.lang.String value) throws java.sql.SQLException
java.sql.SQLException
private static boolean appendSingleIntervalCast(java.lang.StringBuilder buf, java.lang.String cmp, java.lang.String type, java.lang.String value, java.lang.String pgType)
private static boolean areSameTsi(java.lang.String a, java.lang.String b)
a
- first interval to compareb
- second interval to compareprivate static boolean isTsi(java.lang.String interval)
SQL_TSI_ROOT
interval
- input stringpublic static void sqltimestampdiff(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happensprivate static java.lang.String constantToDatePart(java.lang.StringBuilder buf, java.lang.String type) throws java.sql.SQLException
java.sql.SQLException
public static void sqldatabase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqlifnull(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happenspublic static void sqluser(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
buf
- The buffer to append intoparsedArgs
- argumentsjava.sql.SQLException
- if something wrong happensprivate static void zeroArgumentFunctionCall(java.lang.StringBuilder buf, java.lang.String call, java.lang.String functionName, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws PSQLException
PSQLException
private static void singleArgumentFunctionCall(java.lang.StringBuilder buf, java.lang.String call, java.lang.String functionName, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws PSQLException
PSQLException
private static void twoArgumentsFunctionCall(java.lang.StringBuilder buf, java.lang.String call, java.lang.String functionName, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws PSQLException
PSQLException
public static void appendCall(java.lang.StringBuilder sb, java.lang.String begin, java.lang.String separator, java.lang.String end, java.util.List<? extends java.lang.CharSequence> args)
begin arg0 separator arg1 separator end
sequence to the input StringBuilder
sb
- destination StringBuilderbegin
- begin stringseparator
- separator stringend
- end stringargs
- arguments