Package org.postgresql.jdbc
Class EscapedFunctions2
- java.lang.Object
-
- org.postgresql.jdbc.EscapedFunctions2
-
public final class EscapedFunctions2 extends java.lang.Object
This class stores supported escaped function. Note: this is a pgjdbc-internal class, so it is not supposed to be used outside of the driver.
-
-
Field Summary
Fields Modifier and Type Field Description private static java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method>
FUNCTION_MAP
storage for functions implementationsprivate 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 Summary
Constructors Constructor Description EscapedFunctions2()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method 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)
Appendsbegin arg0 separator arg1 separator end
sequence to the inputStringBuilder
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.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 functionprivate static boolean
isTsi(java.lang.String interval)
Checks if given input starts withSQL_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 translationstatic void
sqlchar(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
char to chr translationstatic void
sqlconcat(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
concat translationstatic void
sqlcurdate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
curdate to current_date translationstatic void
sqlcurtime(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
curtime to current_time translationstatic void
sqldatabase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
database translationstatic void
sqldayname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayname translationstatic void
sqldayofmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayofmonth translationstatic 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 7static void
sqldayofyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
dayofyear translationstatic void
sqlhour(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
hour translationstatic void
sqlifnull(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
ifnull translationstatic void
sqlinsert(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
insert to overlay translationstatic void
sqllcase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
lcase to lower translationstatic void
sqlleft(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
left to substring translationstatic void
sqllength(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
length translationstatic void
sqllocate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
locate translationstatic void
sqllog(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
log to ln translationstatic void
sqllog10(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
log10 to log translationstatic void
sqlltrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
ltrim translationstatic void
sqlminute(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
minute translationstatic void
sqlmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
month translationstatic void
sqlmonthname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
monthname translationstatic void
sqlpower(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
power to pow translationstatic void
sqlquarter(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
quarter translationstatic void
sqlright(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
right to substring translationstatic void
sqlrtrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
rtrim translationstatic void
sqlsecond(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
second translationstatic void
sqlspace(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
space translationstatic void
sqlsubstring(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
substring to substr translationstatic void
sqltimestampadd(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
time stamp addstatic void
sqltimestampdiff(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
time stamp diffstatic void
sqltruncate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
truncate to trunc translationstatic void
sqlucase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
ucase to upper translationstatic void
sqluser(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
user translationstatic void
sqlweek(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
week translationstatic void
sqlyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
year translationprivate 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)
-
-
-
Field Detail
-
SQL_TSI_ROOT
private static final java.lang.String SQL_TSI_ROOT
- See Also:
- Constant Field Values
-
SQL_TSI_DAY
private static final java.lang.String SQL_TSI_DAY
- See Also:
- Constant Field Values
-
SQL_TSI_FRAC_SECOND
private static final java.lang.String SQL_TSI_FRAC_SECOND
- See Also:
- Constant Field Values
-
SQL_TSI_HOUR
private static final java.lang.String SQL_TSI_HOUR
- See Also:
- Constant Field Values
-
SQL_TSI_MINUTE
private static final java.lang.String SQL_TSI_MINUTE
- See Also:
- Constant Field Values
-
SQL_TSI_MONTH
private static final java.lang.String SQL_TSI_MONTH
- See Also:
- Constant Field Values
-
SQL_TSI_QUARTER
private static final java.lang.String SQL_TSI_QUARTER
- See Also:
- Constant Field Values
-
SQL_TSI_SECOND
private static final java.lang.String SQL_TSI_SECOND
- See Also:
- Constant Field Values
-
SQL_TSI_WEEK
private static final java.lang.String SQL_TSI_WEEK
- See Also:
- Constant Field Values
-
SQL_TSI_YEAR
private static final java.lang.String SQL_TSI_YEAR
- See Also:
- Constant Field Values
-
FUNCTION_MAP
private static final java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> FUNCTION_MAP
storage for functions implementations
-
-
Method Detail
-
createFunctionMap
private static java.util.concurrent.ConcurrentMap<java.lang.String,java.lang.reflect.Method> createFunctionMap(java.lang.String prefix)
-
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 void sqlceiling(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
ceiling to ceil translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqllog
public static void sqllog(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
log to ln translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqllog10
public static void sqllog10(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
log10 to log translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlpower
public static void sqlpower(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
power to pow translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqltruncate
public static void sqltruncate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
truncate to trunc translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlchar
public static void sqlchar(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
char to chr translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlconcat
public static void sqlconcat(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs)
concat translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments
-
sqlinsert
public static void sqlinsert(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
insert to overlay translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqllcase
public static void sqllcase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
lcase to lower translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlleft
public static void sqlleft(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
left to substring translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqllength
public static void sqllength(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
length translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqllocate
public static void sqllocate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
locate translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlltrim
public static void sqlltrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
ltrim translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlright
public static void sqlright(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
right to substring translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlrtrim
public static void sqlrtrim(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
rtrim translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlspace
public static void sqlspace(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
space translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlsubstring
public static void sqlsubstring(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
substring to substr translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlucase
public static void sqlucase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
ucase to upper translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlcurdate
public static void sqlcurdate(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
curdate to current_date translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlcurtime
public static void sqlcurtime(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
curtime to current_time translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqldayname
public static void sqldayname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
dayname translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqldayofmonth
public static void sqldayofmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
dayofmonth translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqldayofweek
public static void sqldayofweek(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqldayofyear
public static void sqldayofyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
dayofyear translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlhour
public static void sqlhour(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
hour translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlminute
public static void sqlminute(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
minute translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlmonth
public static void sqlmonth(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
month translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlmonthname
public static void sqlmonthname(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
monthname translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlquarter
public static void sqlquarter(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
quarter translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlsecond
public static void sqlsecond(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
second translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlweek
public static void sqlweek(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
week translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlyear
public static void sqlyear(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
year translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqltimestampadd
public static void sqltimestampadd(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
time stamp add- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
appendInterval
private static void appendInterval(java.lang.StringBuilder buf, java.lang.String type, java.lang.String value) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
appendSingleIntervalCast
private static boolean appendSingleIntervalCast(java.lang.StringBuilder buf, java.lang.String cmp, java.lang.String type, java.lang.String value, java.lang.String pgType)
-
areSameTsi
private static boolean areSameTsi(java.lang.String a, java.lang.String b)
Compares two TSI intervals. It is- Parameters:
a
- first interval to compareb
- second interval to compare- Returns:
- true when both intervals are equal (case insensitive)
-
isTsi
private static boolean isTsi(java.lang.String interval)
Checks if given input starts withSQL_TSI_ROOT
- Parameters:
interval
- input string- Returns:
- true if interval.startsWithIgnoreCase(SQL_TSI_ROOT)
-
sqltimestampdiff
public static void sqltimestampdiff(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
time stamp diff- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
constantToDatePart
private static java.lang.String constantToDatePart(java.lang.String type) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
sqldatabase
public static void sqldatabase(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
database translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqlifnull
public static void sqlifnull(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
ifnull translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
sqluser
public static void sqluser(java.lang.StringBuilder buf, java.util.List<? extends java.lang.CharSequence> parsedArgs) throws java.sql.SQLException
user translation- Parameters:
buf
- The buffer to append intoparsedArgs
- arguments- Throws:
java.sql.SQLException
- if something wrong happens
-
zeroArgumentFunctionCall
private 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
- Throws:
PSQLException
-
singleArgumentFunctionCall
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
- Throws:
PSQLException
-
twoArgumentsFunctionCall
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
- Throws:
PSQLException
-
appendCall
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)
Appendsbegin arg0 separator arg1 separator end
sequence to the inputStringBuilder
- Parameters:
sb
- destination StringBuilderbegin
- begin stringseparator
- separator stringend
- end stringargs
- arguments
-
-