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

Package org.eclipse.persistence.jpa.jpql.parser

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

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


    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


    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


    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


    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

TOP

Related Classes of org.eclipse.persistence.jpa.jpql.parser.AggregateFunction

org.eclipse.persistence.jpa.jpql.model.AbstractActualJPQLQueryFormatter

org.eclipse.persistence.jpa.jpql.tools.model.AbstractActualJPQLQueryFormatter

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.