Class SQLFunctionAverage

  • All Implemented Interfaces:
    SQLFunction

    public class SQLFunctionAverage
    extends SQLFunctionMathAbstract
    Compute the average value for a field. Uses the context to save the last average number. When different Number class are used, take the class with most precision.
    Author:
    Luca Garulli (l.garulli--(at)--gmail.com)
    • Constructor Detail

      • SQLFunctionAverage

        public SQLFunctionAverage()
    • Method Detail

      • execute

        public Object execute​(Object iThis,
                              Identifiable iCurrentRecord,
                              Object iCurrentResult,
                              Object[] iParams,
                              CommandContext iContext)
        Description copied from interface: SQLFunction
        Process a record.
        iCurrentRecord - : current record
        iCurrentResult - TODO
        iParams - : function parameters, number is ensured to be within minParams and maxParams.
        iContext - : object calling this function
        Returns:
        function result, can be null. Special cases : can be null if function aggregate results, can be null if function filter results : this mean result is excluded
      • sum

        protected void sum​(Number value)
      • getSyntax

        public String getSyntax()
        Description copied from interface: SQLFunction
        Returns a convenient SQL String representation of the function.

        Example :

          myFunction( param1, param2, [optionalParam3])
         

        This text will be used in exception messages.

        Returns:
        String , never null.