Class EscapedFunctions2


  • public final class EscapedFunctions2
    extends 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 Detail

      • EscapedFunctions2

        public EscapedFunctions2()
    • Method Detail

      • getFunction

        public static Method getFunction​(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​(StringBuilder buf,
                                      List<? extends CharSequence> parsedArgs)
                               throws SQLException
        ceiling to ceil translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqllog10

        public static void sqllog10​(StringBuilder buf,
                                    List<? extends CharSequence> parsedArgs)
                             throws SQLException
        log10 to log translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlpower

        public static void sqlpower​(StringBuilder buf,
                                    List<? extends CharSequence> parsedArgs)
                             throws SQLException
        power to pow translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqltruncate

        public static void sqltruncate​(StringBuilder buf,
                                       List<? extends CharSequence> parsedArgs)
                                throws SQLException
        truncate to trunc translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlconcat

        public static void sqlconcat​(StringBuilder buf,
                                     List<? extends CharSequence> parsedArgs)
        concat translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
      • sqlinsert

        public static void sqlinsert​(StringBuilder buf,
                                     List<? extends CharSequence> parsedArgs)
                              throws SQLException
        insert to overlay translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqllcase

        public static void sqllcase​(StringBuilder buf,
                                    List<? extends CharSequence> parsedArgs)
                             throws SQLException
        lcase to lower translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlleft

        public static void sqlleft​(StringBuilder buf,
                                   List<? extends CharSequence> parsedArgs)
                            throws SQLException
        left to substring translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlright

        public static void sqlright​(StringBuilder buf,
                                    List<? extends CharSequence> parsedArgs)
                             throws SQLException
        right to substring translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlsubstring

        public static void sqlsubstring​(StringBuilder buf,
                                        List<? extends CharSequence> parsedArgs)
                                 throws SQLException
        substring to substr translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlucase

        public static void sqlucase​(StringBuilder buf,
                                    List<? extends CharSequence> parsedArgs)
                             throws SQLException
        ucase to upper translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlcurdate

        public static void sqlcurdate​(StringBuilder buf,
                                      List<? extends CharSequence> parsedArgs)
                               throws SQLException
        curdate to current_date translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlcurtime

        public static void sqlcurtime​(StringBuilder buf,
                                      List<? extends CharSequence> parsedArgs)
                               throws SQLException
        curtime to current_time translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqldayname

        public static void sqldayname​(StringBuilder buf,
                                      List<? extends CharSequence> parsedArgs)
                               throws SQLException
        dayname translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqldayofmonth

        public static void sqldayofmonth​(StringBuilder buf,
                                         List<? extends CharSequence> parsedArgs)
                                  throws SQLException
        dayofmonth translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqldayofweek

        public static void sqldayofweek​(StringBuilder buf,
                                        List<? extends CharSequence> parsedArgs)
                                 throws 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:
        SQLException - if something wrong happens
      • sqldayofyear

        public static void sqldayofyear​(StringBuilder buf,
                                        List<? extends CharSequence> parsedArgs)
                                 throws SQLException
        dayofyear translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlmonthname

        public static void sqlmonthname​(StringBuilder buf,
                                        List<? extends CharSequence> parsedArgs)
                                 throws SQLException
        monthname translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqlquarter

        public static void sqlquarter​(StringBuilder buf,
                                      List<? extends CharSequence> parsedArgs)
                               throws SQLException
        quarter translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqltimestampadd

        public static void sqltimestampadd​(StringBuilder buf,
                                           List<? extends CharSequence> parsedArgs)
                                    throws SQLException
        time stamp add
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqltimestampdiff

        public static void sqltimestampdiff​(StringBuilder buf,
                                            List<? extends CharSequence> parsedArgs)
                                     throws SQLException
        time stamp diff
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • sqldatabase

        public static void sqldatabase​(StringBuilder buf,
                                       List<? extends CharSequence> parsedArgs)
                                throws SQLException
        database translation
        Parameters:
        buf - The buffer to append into
        parsedArgs - arguments
        Throws:
        SQLException - if something wrong happens
      • appendCall

        public static void appendCall​(StringBuilder sb,
                                      String begin,
                                      String separator,
                                      String end,
                                      List<? extends 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