Class 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.
    • 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)
      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