Class EscapedFunctions


  • public class EscapedFunctions
    extends java.lang.Object
    This class stores supported escaped function
    Author:
    Xavier Poinsard
    • Field Summary

      Fields 
      Modifier and Type Field Description
      static java.lang.String ABS  
      static java.lang.String ACOS  
      static java.lang.String ASCII  
      static java.lang.String ASIN  
      static java.lang.String ATAN  
      static java.lang.String ATAN2  
      static java.lang.String CEILING  
      static java.lang.String CHAR  
      static java.lang.String CONCAT  
      static java.lang.String COS  
      static java.lang.String COT  
      static java.lang.String CURDATE  
      static java.lang.String CURTIME  
      static java.lang.String DATABASE  
      static java.lang.String DAYNAME  
      static java.lang.String DAYOFMONTH  
      static java.lang.String DAYOFWEEK  
      static java.lang.String DAYOFYEAR  
      static java.lang.String DEGREES  
      static java.lang.String EXP  
      static java.lang.String FLOOR  
      static java.lang.String HOUR  
      static java.lang.String IFNULL  
      static java.lang.String INSERT  
      static java.lang.String LCASE  
      static java.lang.String LEFT  
      static java.lang.String LENGTH  
      static java.lang.String LOCATE  
      static java.lang.String LOG  
      static java.lang.String LOG10  
      static java.lang.String LTRIM  
      static java.lang.String MINUTE  
      static java.lang.String MOD  
      static java.lang.String MONTH  
      static java.lang.String MONTHNAME  
      static java.lang.String NOW  
      static java.lang.String PI  
      static java.lang.String POWER  
      static java.lang.String QUARTER  
      static java.lang.String RADIANS  
      static java.lang.String REPEAT  
      static java.lang.String REPLACE  
      static java.lang.String RIGHT  
      static java.lang.String ROUND  
      static java.lang.String RTRIM  
      static java.lang.String SECOND  
      static java.lang.String SIGN  
      static java.lang.String SIN  
      static java.lang.String SPACE  
      static java.lang.String SQL_TSI_DAY  
      static java.lang.String SQL_TSI_FRAC_SECOND  
      static java.lang.String SQL_TSI_HOUR  
      static java.lang.String SQL_TSI_MINUTE  
      static java.lang.String SQL_TSI_MONTH  
      static java.lang.String SQL_TSI_QUARTER  
      static java.lang.String SQL_TSI_ROOT  
      static java.lang.String SQL_TSI_SECOND  
      static java.lang.String SQL_TSI_WEEK  
      static java.lang.String SQL_TSI_YEAR  
      static java.lang.String SQRT  
      static java.lang.String SUBSTRING  
      static java.lang.String TAN  
      static java.lang.String TIMESTAMPADD  
      static java.lang.String TIMESTAMPDIFF  
      static java.lang.String TRUNCATE  
      static java.lang.String UCASE  
      static java.lang.String USER  
      static java.lang.String WEEK  
      static java.lang.String YEAR  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.lang.reflect.Method getFunction​(java.lang.String functionName)
      get Method object implementing the given function
      static java.lang.String sqlceiling​(java.util.List<?> parsedArgs)
      ceiling to ceil translation
      static java.lang.String sqlchar​(java.util.List<?> parsedArgs)
      char to chr translation
      static java.lang.String sqlconcat​(java.util.List<?> parsedArgs)
      concat translation
      static java.lang.String sqlcurdate​(java.util.List<?> parsedArgs)
      curdate to current_date translation
      static java.lang.String sqlcurtime​(java.util.List<?> parsedArgs)
      curtime to current_time translation
      static java.lang.String sqldatabase​(java.util.List<?> parsedArgs)
      database translation
      static java.lang.String sqldayname​(java.util.List<?> parsedArgs)
      dayname translation
      static java.lang.String sqldayofmonth​(java.util.List<?> parsedArgs)
      dayofmonth translation
      static java.lang.String sqldayofweek​(java.util.List<?> parsedArgs)
      dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7
      static java.lang.String sqldayofyear​(java.util.List<?> parsedArgs)
      dayofyear translation
      static java.lang.String sqlhour​(java.util.List<?> parsedArgs)
      hour translation
      static java.lang.String sqlifnull​(java.util.List<?> parsedArgs)
      ifnull translation
      static java.lang.String sqlinsert​(java.util.List<?> parsedArgs)
      insert to overlay translation
      static java.lang.String sqllcase​(java.util.List<?> parsedArgs)
      lcase to lower translation
      static java.lang.String sqlleft​(java.util.List<?> parsedArgs)
      left to substring translation
      static java.lang.String sqllength​(java.util.List<?> parsedArgs)
      length translation
      static java.lang.String sqllocate​(java.util.List<?> parsedArgs)
      locate translation
      static java.lang.String sqllog​(java.util.List<?> parsedArgs)
      log to ln translation
      static java.lang.String sqllog10​(java.util.List<?> parsedArgs)
      log10 to log translation
      static java.lang.String sqlltrim​(java.util.List<?> parsedArgs)
      ltrim translation
      static java.lang.String sqlminute​(java.util.List<?> parsedArgs)
      minute translation
      static java.lang.String sqlmonth​(java.util.List<?> parsedArgs)
      month translation
      static java.lang.String sqlmonthname​(java.util.List<?> parsedArgs)
      monthname translation
      static java.lang.String sqlpower​(java.util.List<?> parsedArgs)
      power to pow translation
      static java.lang.String sqlquarter​(java.util.List<?> parsedArgs)
      quarter translation
      static java.lang.String sqlright​(java.util.List<?> parsedArgs)
      right to substring translation
      static java.lang.String sqlrtrim​(java.util.List<?> parsedArgs)
      rtrim translation
      static java.lang.String sqlsecond​(java.util.List<?> parsedArgs)
      second translation
      static java.lang.String sqlspace​(java.util.List<?> parsedArgs)
      space translation
      static java.lang.String sqlsubstring​(java.util.List<?> parsedArgs)
      substring to substr translation
      static java.lang.String sqltimestampadd​(java.util.List<?> parsedArgs)
      time stamp add
      static java.lang.String sqltimestampdiff​(java.util.List<?> parsedArgs)
      time stamp diff
      static java.lang.String sqltruncate​(java.util.List<?> parsedArgs)
      truncate to trunc translation
      static java.lang.String sqlucase​(java.util.List<?> parsedArgs)
      ucase to upper translation
      static java.lang.String sqluser​(java.util.List<?> parsedArgs)
      user translation
      static java.lang.String sqlweek​(java.util.List<?> parsedArgs)
      week translation
      static java.lang.String sqlyear​(java.util.List<?> parsedArgs)
      year translation
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • EscapedFunctions

        public EscapedFunctions()
    • 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 java.lang.String sqlceiling​(java.util.List<?> parsedArgs)
                                           throws java.sql.SQLException
        ceiling to ceil translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqllog

        public static java.lang.String sqllog​(java.util.List<?> parsedArgs)
                                       throws java.sql.SQLException
        log to ln translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqllog10

        public static java.lang.String sqllog10​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        log10 to log translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlpower

        public static java.lang.String sqlpower​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        power to pow translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqltruncate

        public static java.lang.String sqltruncate​(java.util.List<?> parsedArgs)
                                            throws java.sql.SQLException
        truncate to trunc translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlchar

        public static java.lang.String sqlchar​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        char to chr translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlconcat

        public static java.lang.String sqlconcat​(java.util.List<?> parsedArgs)
        concat translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
      • sqlinsert

        public static java.lang.String sqlinsert​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        insert to overlay translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqllcase

        public static java.lang.String sqllcase​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        lcase to lower translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlleft

        public static java.lang.String sqlleft​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        left to substring translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqllength

        public static java.lang.String sqllength​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        length translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqllocate

        public static java.lang.String sqllocate​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        locate translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlltrim

        public static java.lang.String sqlltrim​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        ltrim translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlright

        public static java.lang.String sqlright​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        right to substring translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlrtrim

        public static java.lang.String sqlrtrim​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        rtrim translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlspace

        public static java.lang.String sqlspace​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        space translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlsubstring

        public static java.lang.String sqlsubstring​(java.util.List<?> parsedArgs)
                                             throws java.sql.SQLException
        substring to substr translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlucase

        public static java.lang.String sqlucase​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        ucase to upper translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlcurdate

        public static java.lang.String sqlcurdate​(java.util.List<?> parsedArgs)
                                           throws java.sql.SQLException
        curdate to current_date translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlcurtime

        public static java.lang.String sqlcurtime​(java.util.List<?> parsedArgs)
                                           throws java.sql.SQLException
        curtime to current_time translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqldayname

        public static java.lang.String sqldayname​(java.util.List<?> parsedArgs)
                                           throws java.sql.SQLException
        dayname translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqldayofmonth

        public static java.lang.String sqldayofmonth​(java.util.List<?> parsedArgs)
                                              throws java.sql.SQLException
        dayofmonth translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqldayofweek

        public static java.lang.String sqldayofweek​(java.util.List<?> parsedArgs)
                                             throws java.sql.SQLException
        dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqldayofyear

        public static java.lang.String sqldayofyear​(java.util.List<?> parsedArgs)
                                             throws java.sql.SQLException
        dayofyear translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlhour

        public static java.lang.String sqlhour​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        hour translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlminute

        public static java.lang.String sqlminute​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        minute translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlmonth

        public static java.lang.String sqlmonth​(java.util.List<?> parsedArgs)
                                         throws java.sql.SQLException
        month translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlmonthname

        public static java.lang.String sqlmonthname​(java.util.List<?> parsedArgs)
                                             throws java.sql.SQLException
        monthname translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlquarter

        public static java.lang.String sqlquarter​(java.util.List<?> parsedArgs)
                                           throws java.sql.SQLException
        quarter translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlsecond

        public static java.lang.String sqlsecond​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        second translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlweek

        public static java.lang.String sqlweek​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        week translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlyear

        public static java.lang.String sqlyear​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        year translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqltimestampadd

        public static java.lang.String sqltimestampadd​(java.util.List<?> parsedArgs)
                                                throws java.sql.SQLException
        time stamp add
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqltimestampdiff

        public static java.lang.String sqltimestampdiff​(java.util.List<?> parsedArgs)
                                                 throws java.sql.SQLException
        time stamp diff
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqldatabase

        public static java.lang.String sqldatabase​(java.util.List<?> parsedArgs)
                                            throws java.sql.SQLException
        database translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqlifnull

        public static java.lang.String sqlifnull​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        ifnull translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens
      • sqluser

        public static java.lang.String sqluser​(java.util.List<?> parsedArgs)
                                        throws java.sql.SQLException
        user translation
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens