Class EscapedFunctions


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

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

      Constructors 
      Constructor Description
      EscapedFunctions()
      Deprecated.
       
    • Method Summary

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

      • getFunction

        public static java.lang.reflect.Method getFunction​(java.lang.String functionName)
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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)
        Deprecated.
        concat translation.
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
      • sqlinsert

        public static java.lang.String sqlinsert​(java.util.List<?> parsedArgs)
                                          throws java.sql.SQLException
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        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
        Deprecated.
        user translation.
        Parameters:
        parsedArgs - arguments
        Returns:
        sql call
        Throws:
        java.sql.SQLException - if something wrong happens