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.
-
-
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
static java.lang.reflect.Method
getFunction(java.lang.String functionName)
get Method object implementing the given functionstatic 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 translation
-
-
-
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 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
-
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
-
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
-
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
-
-