Examples of AggregateFunction

com.inadco.hbl.api.AggregateFunction
org.dashbuilder.dataset.group.AggregateFunction
Interface used to get the aggregate value of a given collection.
Aggregate functions are used to calculate the aggregate values of the intervals belonging to a given data set domain property.
org.eclipse.persistence.jpa.jpql.parser.AggregateFunction
In the SELECT clause the result of a query may be the result of an aggregate function applied to a path expression. The following aggregate functions can be used in the SELECT clause of a query: AVG, COUNT, MAX, MIN, SUM.
A single_valued_association_field is designated by the name of an association-field in a one-to-one or many-to-one relationship. The type of a single_valued_association_field and thus a single_valued_association_path_expression is the abstract schema type of the related entity.
The argument to an aggregate function may be preceded by the keyword DISTINCT to specify that duplicate values are to be eliminated before the aggregate function is applied. Null values are eliminated before the aggregate function is applied, regardless of whether the keyword DISTINCT is specified.
BNF: aggregate_expression ::= { AVG | MAX | MIN | SUM } ([DISTINCT] state_field_path_expression) | COUNT ([DISTINCT] identification_variable | state_field_path_expression | single_valued_object_path_expression)
@see AvgFunction @see CountFunction @see MaxFunction @see MinFunction @see SumFunction @version 2.4 @since 2.3 @author Pascal Filion
org.h2.api.AggregateFunction
A user-defined aggregate function needs to implement this interface. The class must be public and must have a public non-argument constructor.
org.lealone.api.AggregateFunction
A user-defined aggregate function needs to implement this interface. The class must be public and must have a public non-argument constructor.
org.ofbiz.sql.AggregateFunction
org.teiid.language.AggregateFunction
Represents an aggregate function.
org.teiid.query.function.aggregate.AggregateFunction
This represents the interface for an aggregate function. The basic lifecycle is that the AggregateFunction is initialize()'d with the type of the element being aggregated, then addInput() is called for every row in the group, then getResult() is called to retrieve the result.
reportgen.math.agregate.agregate.AggregateFunction
Используется при - как агрегирующая функция - в подзапросе (режим СКЛ) ! не выражение - в результате ! не выражение - в форматировании результата на всю ячейку ! не выражение - в форматировании результата на один элемент выражение - как функция модификации в простом форматировании ! не выражение имеет смысл добавить в форматирование результата по выражению. Из доступных в текущем контексте функция, везде выбираются те, которые подходят для текущего класса результата. Имеет смысл сделать класс-фильтр. Какой смысл в переносе группы из метода-фабрики в контекст? + Динамическое изменение в зависимости от класса - Контекст относится к мат выражению, а агр.функция используется практически везде не в выражении. + даже не в выражении все равно есть контекст. той же сериализации, на пример. @author axe

Examples of com.inadco.hbl.api.AggregateFunction

                               Aggregation.Builder accumulator,
                               Aggregation source,
                               SliceOperation operation) {


        for (String funcName : funcNames) {
            AggregateFunction func = functions.get(funcName);
            if (func == null)
                throw new UnsupportedOperationException(String.format("Unsupported aggregate function:\"%s\".",
                                                                      funcName));
            func.merge(accumulator, source, operation);
        }


    }

View Full Code Here

Examples of com.inadco.hbl.api.AggregateFunction

    public Object getAggregate(String measure, String functionName) throws HblException {
        try {
            Integer index = measureName2IndexMap.get(measure);
            if (index == null)
                throw new HblException(String.format("Invalid measure name:%s.", measure));
            AggregateFunction af = afr.findFunction(functionName);
            if (af == null)
                throw new HblException(String.format("Invalid function name:%s.", functionName));
            if (result == null)
                throw new HblException("no current result");
            Aggregation measureAggr = result[index];
            if (measureAggr == null) {
                Aggregation.Builder b = delegate.current().getMeasures()[index];
                result[index] = b == null ? null : (measureAggr = b.build()); // cache
            }


            return af.getAggrValue(measureAggr);
        } catch (IOException exc) {
            throw new HblException(exc.getMessage(), exc);
        }


    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

    List listOfNumbers = Arrays.asList(1, 2, 3, 4, 5);
    List listOfStrings = Arrays.asList("A", "B", "C", "A", "B");


    @Test
    public void testSumFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(SumFunction.CODE);
        double result = sf.aggregate(listOfNumbers);
        assertThat(result).isEqualTo(15);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

        assertThat(result).isEqualTo(15);
    }


    @Test
    public void testAvgFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(AverageFunction.CODE);
        double result = sf.aggregate(listOfNumbers);
        assertThat(result).isEqualTo(3);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

        assertThat(result).isEqualTo(3);
    }


    @Test
    public void testMaxFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(MaxFunction.CODE);
        double result = sf.aggregate(listOfNumbers);
        assertThat(result).isEqualTo(5);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

        assertThat(result).isEqualTo(5);
    }


    @Test
    public void testMinFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(MinFunction.CODE);
        double result = sf.aggregate(listOfNumbers);
        assertThat(result).isEqualTo(1);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

        assertThat(result).isEqualTo(1);
    }


    @Test
    public void testCountFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(CountFunction.CODE);
        double result = sf.aggregate(listOfStrings);
        assertThat(result).isEqualTo(5);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

        assertThat(result).isEqualTo(5);
    }


    @Test
    public void testDistinctFunction() throws Exception {
        AggregateFunction sf = aggregateFunctionManager.getFunctionByCode(DistinctFunction.CODE);
        double result = sf.aggregate(listOfStrings);
        assertThat(result).isEqualTo(3);
    }

View Full Code Here

Examples of org.dashbuilder.dataset.group.AggregateFunction

                Double sv = index.getAggValue(column.getId(), type);
                if (sv != null) return sv;
            }
            // Do the aggregate calculations.
            chronometer.start();
            AggregateFunction function = aggregateFunctionManager.getFunctionByCode(type.toString().toLowerCase());
            double aggValue = function.aggregate(column.getValues(), index.getRows());
            chronometer.stop();


            // Index the result
            if (index != null) {
                index.indexAggValue(column.getId(), type, aggValue, chronometer.elapsedTime());

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.AggregateFunction


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      AggregateFunction expression = stateObject.getExpression();


      // Identifier
      appendIdentifier((expression != null) ? expression.getActualIdentifier() : stateObject.getIdentifier(), stateObject.getIdentifier());


      // '('
      if (shouldOutput(expression) || expression.hasLeftParenthesis()) {
        writer.append(formatIdentifier(LEFT_PARENTHESIS));
      }


      // 'DISTINCT'
      if (stateObject.hasDistinct()) {
        appendIdentifier((expression != null) ? expression.getActualDistinctIdentifier() : DISTINCT, DISTINCT);


        if (shouldOutput(expression) || expression.hasSpaceAfterDistinct()) {
          writer.append(SPACE);
        }
      }


      // Encapsulated expression
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ')'
      if (shouldOutput(expression) || expression.hasRightParenthesis()) {
        writer.append(formatIdentifier(RIGHT_PARENTHESIS));
      }
    }
  }

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.