Ejemplo n.º 1
0
  /**
   * Prepares a derived (i.e., not explicitly defined in the query) select clause.
   *
   * @param fromClause The from clause to which this select clause is linked.
   */
  public void initializeDerivedSelectClause(FromClause fromClause) throws SemanticException {
    if (prepared) {
      throw new IllegalStateException("SelectClause was already prepared!");
    }
    // Used to be tested by the TCK but the test is no longer here
    //		if ( getSessionFactoryHelper().isStrictJPAQLComplianceEnabled() && !getWalker().isSubQuery()
    // ) {
    //			// NOTE : the isSubQuery() bit is a temporary hack...
    //			throw new QuerySyntaxException( "JPA-QL compliance requires select clause" );
    //		}
    List fromElements = fromClause.getProjectionList();

    ASTAppender appender =
        new ASTAppender(getASTFactory(), this); // Get ready to start adding nodes.
    int size = fromElements.size();
    ArrayList queryReturnTypeList = new ArrayList(size);

    Iterator iterator = fromElements.iterator();
    for (int k = 0; iterator.hasNext(); k++) {
      FromElement fromElement = (FromElement) iterator.next();
      Type type = fromElement.getSelectType();

      addCollectionFromElement(fromElement);

      if (type != null) {
        boolean collectionOfElements = fromElement.isCollectionOfValuesOrComponents();
        if (!collectionOfElements) {
          if (!fromElement.isFetch()) {
            // Add the type to the list of returned sqlResultTypes.
            queryReturnTypeList.add(type);
          }
          fromElementsForLoad.add(fromElement);
          // Generate the select expression.
          String text = fromElement.renderIdentifierSelect(size, k);
          SelectExpressionImpl generatedExpr =
              (SelectExpressionImpl) appender.append(SqlTokenTypes.SELECT_EXPR, text, false);
          if (generatedExpr != null) {
            generatedExpr.setFromElement(fromElement);
          }
        }
      }
    }

    // Get all the select expressions (that we just generated) and render the select.
    SelectExpression[] selectExpressions = collectSelectExpressions();

    if (getWalker().isShallowQuery()) {
      renderScalarSelects(selectExpressions, fromClause);
    } else {
      renderNonScalarSelects(selectExpressions, fromClause);
    }
    finishInitialization(queryReturnTypeList);
  }
Ejemplo n.º 2
0
 private void renderNonScalarProperties(
     ASTAppender appender, FromElement fromElement, int nonscalarSize, int k) {
   String text = fromElement.renderPropertySelect(nonscalarSize, k);
   appender.append(SqlTokenTypes.SQL_TOKEN, text, false);
   if (fromElement.getQueryableCollection() != null && fromElement.isFetch()) {
     text = fromElement.renderCollectionSelectFragment(nonscalarSize, k);
     appender.append(SqlTokenTypes.SQL_TOKEN, text, false);
   }
   // Look through the FromElement's children to find any collections of values that should be
   // fetched...
   ASTIterator iter = new ASTIterator(fromElement);
   while (iter.hasNext()) {
     FromElement child = (FromElement) iter.next();
     if (child.isCollectionOfValuesOrComponents() && child.isFetch()) {
       // Need a better way to define the suffixes here...
       text = child.renderValueCollectionSelectFragment(nonscalarSize, nonscalarSize + k);
       appender.append(SqlTokenTypes.SQL_TOKEN, text, false);
     }
   }
 }
Ejemplo n.º 3
0
 private void renderNonScalarIdentifiers(
     FromElement fromElement,
     int nonscalarSize,
     int j,
     SelectExpression expr,
     ASTAppender appender) {
   String text = fromElement.renderIdentifierSelect(nonscalarSize, j);
   if (!fromElement.getFromClause().isSubQuery()) {
     if (!scalarSelect && !getWalker().isShallowQuery()) {
       // TODO: is this a bit ugly?
       expr.setText(text);
     } else {
       appender.append(SqlTokenTypes.SQL_TOKEN, text, false);
     }
   }
 }
Ejemplo n.º 4
0
  /**
   * Prepares an explicitly defined select clause.
   *
   * @param fromClause The from clause linked to this select clause.
   * @throws SemanticException indicates a semntic issue with the explicit select clause.
   */
  public void initializeExplicitSelectClause(FromClause fromClause) throws SemanticException {
    if (prepared) {
      throw new IllegalStateException("SelectClause was already prepared!");
    }

    // explicit = true;	// This is an explict Select.
    // ArrayList sqlResultTypeList = new ArrayList();
    ArrayList queryReturnTypeList = new ArrayList();

    // First, collect all of the select expressions.
    // NOTE: This must be done *before* invoking setScalarColumnText() because setScalarColumnText()
    // changes the AST!!!
    SelectExpression[] selectExpressions = collectSelectExpressions();

    // we only support parameters in select in the case of INSERT...SELECT statements
    if (getParameterPositions().size() > 0
        && getWalker().getStatementType() != HqlSqlTokenTypes.INSERT) {
      throw new QueryException(
          "Parameters are only supported in SELECT clauses when used as part of a INSERT INTO DML statement");
    }

    for (int i = 0; i < selectExpressions.length; i++) {
      SelectExpression selectExpression = selectExpressions[i];

      if (AggregatedSelectExpression.class.isInstance(selectExpression)) {
        aggregatedSelectExpression = (AggregatedSelectExpression) selectExpression;
        queryReturnTypeList.addAll(aggregatedSelectExpression.getAggregatedSelectionTypeList());
        scalarSelect = true;
      } else {
        // we have no choice but to do this check here
        // this is not very elegant but the "right way" would most likely involve a bigger rewrite
        // so as to
        // treat ParameterNodes in select clauses as SelectExpressions
        boolean inSubquery =
            selectExpression instanceof QueryNode
                && ((QueryNode) selectExpression).getFromClause().getParentFromClause() != null;
        if (getWalker().getStatementType() == HqlSqlTokenTypes.INSERT && inSubquery) {
          // we do not support parameters for subqueries in INSERT...SELECT
          if (((QueryNode) selectExpression).getSelectClause().getParameterPositions().size() > 0) {
            throw new QueryException(
                "Use of parameters in subqueries of INSERT INTO DML statements is not supported.");
          }
        }

        Type type = selectExpression.getDataType();
        if (type == null) {
          throw new IllegalStateException(
              "No data type for node: "
                  + selectExpression.getClass().getName()
                  + " "
                  + new ASTPrinter(SqlTokenTypes.class).showAsString((AST) selectExpression, ""));
        }
        // sqlResultTypeList.add( type );

        // If the data type is not an association type, it could not have been in the FROM clause.
        if (selectExpression.isScalar()) {
          scalarSelect = true;
        }

        if (isReturnableEntity(selectExpression)) {
          fromElementsForLoad.add(selectExpression.getFromElement());
        }

        // Always add the type to the return type list.
        queryReturnTypeList.add(type);
      }
    }

    // init the aliases, after initing the constructornode
    initAliases(selectExpressions);

    if (!getWalker().isShallowQuery()) {
      // add the fetched entities
      List fromElements = fromClause.getProjectionList();

      ASTAppender appender =
          new ASTAppender(getASTFactory(), this); // Get ready to start adding nodes.
      int size = fromElements.size();

      Iterator iterator = fromElements.iterator();
      for (int k = 0; iterator.hasNext(); k++) {
        FromElement fromElement = (FromElement) iterator.next();

        if (fromElement.isFetch()) {
          FromElement origin = null;
          if (fromElement.getRealOrigin() == null) {
            // work around that crazy issue where the tree contains
            // "empty" FromElements (no text); afaict, this is caused
            // by FromElementFactory.createCollectionJoin()
            if (fromElement.getOrigin() == null) {
              throw new QueryException(
                  "Unable to determine origin of join fetch ["
                      + fromElement.getDisplayText()
                      + "]");
            } else {
              origin = fromElement.getOrigin();
            }
          } else {
            origin = fromElement.getRealOrigin();
          }
          if (!fromElementsForLoad.contains(origin)) {
            throw new QueryException(
                "query specified join fetching, but the owner "
                    + "of the fetched association was not present in the select list "
                    + "["
                    + fromElement.getDisplayText()
                    + "]");
          }
          Type type = fromElement.getSelectType();
          addCollectionFromElement(fromElement);
          if (type != null) {
            boolean collectionOfElements = fromElement.isCollectionOfValuesOrComponents();
            if (!collectionOfElements) {
              // Add the type to the list of returned sqlResultTypes.
              fromElement.setIncludeSubclasses(true);
              fromElementsForLoad.add(fromElement);
              // sqlResultTypeList.add( type );
              // Generate the select expression.
              String text = fromElement.renderIdentifierSelect(size, k);
              SelectExpressionImpl generatedExpr =
                  (SelectExpressionImpl) appender.append(SqlTokenTypes.SELECT_EXPR, text, false);
              if (generatedExpr != null) {
                generatedExpr.setFromElement(fromElement);
              }
            }
          }
        }
      }

      // generate id select fragment and then property select fragment for
      // each expression, just like generateSelectFragments().
      renderNonScalarSelects(collectSelectExpressions(), fromClause);
    }

    if (scalarSelect || getWalker().isShallowQuery()) {
      // If there are any scalars (non-entities) selected, render the select column aliases.
      renderScalarSelects(selectExpressions, fromClause);
    }

    finishInitialization(/*sqlResultTypeList,*/ queryReturnTypeList);
  }