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

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)	Appends begin arg0 separator arg1 separator end sequence to the input StringBuilder
static java.lang.reflect.Method	getFunction(java.lang.String functionName)	get Method object implementing the given function
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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

EscapedFunctions2

public EscapedFunctions2()

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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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 into

parsedArgs - 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)

Appends begin arg0 separator arg1 separator end sequence to the input StringBuilder

Parameters:

sb - destination StringBuilder

begin - begin string

separator - separator string

end - end string

args - arguments