Examples of com.caucho.amber.expr.AmberExpr

com.caucho.amber.expr.AmberExpr
Represents an Amber query expression

  }


  void replaceJoin(JoinExpr join)
  {
    for (int i = 0; i < _resultList.size(); i++) {
      AmberExpr result = _resultList.get(i);


      _resultList.set(i, result.replaceJoin(join));
    }


    if (_where != null) {
      _where = _where.replaceJoin(join);
    }


    if (_orderList != null) {
      for (int i = 0; i < _orderList.size(); i++) {
        AmberExpr order = _orderList.get(i);


        _orderList.set(i, order.replaceJoin(join));
      }
    }
  }

View Full Code Here


    for (int i = 0; i < _resultList.size(); i++) {
      if (i != 0)
        cb.append(", ");


      AmberExpr expr = _resultList.get(i);


      if (_groupList == null && expr instanceof LoadEntityExpr)
        ((LoadEntityExpr) expr).generateSelect(cb, fullSelect);
      else
        expr.generateSelect(cb);
    }


    if (_hasFrom)
      cb.append(" from ");


    // jpa/114f: reorder from list for left outer join
    for (int i = 1; i < _fromList.size(); i++) {
      FromItem item = _fromList.get(i);


      if (item.isOuterJoin()) {
        JoinExpr join = item.getJoinExpr();


        if (join == null)
          continue;


        FromItem parent = join.getJoinParent();


        int index = _fromList.indexOf(parent);


        if (index < 0)
          continue;


        _fromList.remove(i);


        if (index < i)
          index++;


        _fromList.add(index, item);
      }
    }


    boolean hasJoinExpr = false;
    boolean isFirst = true;
    for (int i = 0; i < _fromList.size(); i++) {
      FromItem item = _fromList.get(i);


      // jpa/1178
      if (getParentQuery() != null) {
        ArrayList<FromItem> fromList = getParentQuery().getFromList();
        if (fromList != null) {
          if (fromList.contains(item)) {
            hasJoinExpr = true;
            continue;
          }
        }
      }


      if (isFirst) {
        isFirst = false;
      }
      else {
        if (item.isOuterJoin())
          cb.append(" left outer join ");
        else {
          cb.append(", ");


          if (item.getJoinExpr() != null)
            hasJoinExpr = true;
        }
      }


      cb.append(item.getTable().getName());
      cb.append(" ");
      cb.append(item.getName());


      if (item.getJoinExpr() != null && item.isOuterJoin()) {
        cb.append(" on ");
        item.getJoinExpr().generateJoin(cb);
      }


      EntityType entityType = item.getEntityType();


      // jpa/0l44, jpa/0l12
      /* XXX: jpa/0l47 move this to LoadExpr.generateSelect
      if (entityType != null) {
        AmberColumn discriminator = entityType.getDiscriminator();


        if (entityType instanceof SubEntityType &&
            discriminator != null) {
          // jpa/0l4b
          // XXX: needs to use parser.createTableName()
          FromItem discriminatorItem
            = new FromItem((EntityType) entityType,
                           discriminator.getTable(),
                           item.getName() + "_disc",
                           ++i);


          discriminatorItem.setQuery(this);


          _fromList.add(i, discriminatorItem);


          cb.append(", ");
          cb.append(discriminator.getTable().getName());
          cb.append(' ');
          cb.append(discriminatorItem.getName());
        }
      }
      */
    }


    // jpa/0l12
    // if (hasJoinExpr || _where != null) {


    boolean hasExpr = false;


    for (int i = 0; i < _fromList.size(); i++) {
      FromItem item = _fromList.get(i);


      AmberExpr expr = item.getJoinExpr();


      if (expr != null && ! item.isOuterJoin()) {
        if (hasExpr)
          cb.append(" and ");
        else {
          cb.append(" where ");
          hasExpr = true;
        }


        expr.generateJoin(cb);
      }


      EntityType entityType = item.getEntityType();


      // jpa/0l44

View Full Code Here

      // _currIndex += ((ResultSetImpl) rs).getNumberOfLoadingColumns();


      ArrayList<AmberExpr> resultList
        = ((AmberSelectQuery) _query).getResultList();


      AmberExpr expr = resultList.get(oldIndex-1);


      // jpa/1160
      if (expr instanceof LoadEntityExpr) {
        LoadEntityExpr entityExpr = (LoadEntityExpr) expr;
        joinFetch((ResultSetImpl) rs, entityExpr, (Entity) object);

View Full Code Here

        args.get(1).generateUpdateWhere(cb);


      if (n > 2) {
        cb.append(',');


        AmberExpr expr = args.get(2);


         if (select)
          expr.generateWhere(cb);
        else
          expr.generateUpdateWhere(cb);
      }


      cb.append(')');


      return;
    }


    // Postgres: jpa/1190, jpa/119b, jpa/119c


    cb.append("position(");


    if (select)
      args.get(0).generateWhere(cb);
    else
      args.get(0).generateUpdateWhere(cb);


    cb.append(" in substring(");


    if (select)
      args.get(1).generateWhere(cb);
    else
      args.get(1).generateUpdateWhere(cb);


    cb.append(" from ");


    int fromIndex = 1;


    AmberExpr expr = null;


    if (n == 2) {
      cb.append('1');
    }
    else {
      expr = args.get(2);


      try {
        fromIndex = Integer.parseInt(expr.toString());
      } catch (Exception ex) {
        // XXX: this validation should be moved to QueryParser
        // throw new QueryParseException(L.l("expected an integer for LOCATE 3rd argument"));
      }


      if (select)
        expr.generateWhere(cb);
      else
        expr.generateUpdateWhere(cb);
    }


    cb.append("))");
  }

View Full Code Here

        int offset = 0;


        for (int j = 0; j < len; j++) {
          int index = getColumn(j + 1);


          AmberExpr expr = _resultList.get(j);


          if (expr instanceof LoadEntityExpr) {
            LoadEntityExpr entityExpr = (LoadEntityExpr) expr;


            Object obj = entityExpr.getCacheObject(_session,
                                                   _rs,
                                                   index + offset,
                                                   _joinFetchMap);


            tail.setValue(i, j, obj);


            // jpa/11z1
            offset += entityExpr.getIndex();
          }
          else {
            Object obj = expr.getCacheObject(_session,
                                             _rs,
                                             index + offset);


            tail.setValue(i, j, obj);
          }

View Full Code Here

      }
    }
    else {
      int index = getColumn(column);


      AmberExpr expr = _resultList.get(column - 1);


      if (_session == null)
  throw new NullPointerException();


      value = expr.getObject(_session, _rs, index);


      /*
      if (expr instanceof LoadEntityExpr) {
        if (log.isLoggable(Level.FINER))
          log.log(Level.FINER, L.l("ResultSetImpl expr is instance of LoadEntityExpr"));

View Full Code Here

                                   obj));
    }
    else {
      int index = getColumn(column);


      AmberExpr expr = _resultList.get(column - 1);


      EntityItem item = expr.findItem(_session, _rs, index);


      return item;
    }
    /*
      FromItem item = _fromList.get(column - 1);

View Full Code Here

      // _currIndex += ((ResultSetImpl) rs).getNumberOfLoadingColumns();


      ArrayList<AmberExpr> resultList
        = ((SelectQuery) _query).getResultList();


      AmberExpr expr = resultList.get(oldIndex-1);


      // jpa/1160
      if (expr instanceof LoadEntityExpr) {
        LoadEntityExpr entityExpr = (LoadEntityExpr) expr;
        joinFetch((ResultSetImpl) rs, entityExpr, (Entity) object);

View Full Code Here

      AndExpr and = (AndExpr) _where;


      ArrayList<AmberExpr> components = and.getComponents();


      for (int i = components.size() - 1; i >= 0; i--) {
        AmberExpr component = components.get(i);


        if (component instanceof JoinExpr) {
          JoinExpr link = (JoinExpr) component;


          if (link.bindToFromItem()) {
            components.remove(i);
          }
        }
      }


      _where = and.getSingle();
    }


    if (_having instanceof AndExpr) {
      AndExpr and = (AndExpr) _having;


      ArrayList<AmberExpr> components = and.getComponents();


      for (int i = components.size() - 1; i >= 0; i--) {
        AmberExpr component = components.get(i);


        if (component instanceof JoinExpr) {
          JoinExpr link = (JoinExpr) component;


          if (link.bindToFromItem()) {
            components.remove(i);
          }
        }
      }


      _having = and.getSingle();
    }


    // Rolls up unused from items from the left to the right.
    // It's not necessary to roll up the rightmost items because
    // they're only created if they're actually needed
    for (int i = 0; i < _fromList.size(); i++) {
      FromItem item = _fromList.get(i);


      JoinExpr join = item.getJoinExpr();


      if (join == null)
        continue;


      // XXX: jpa/1173, jpa/1178
      // if (getParentQuery() != null)
      //   break;


      FromItem joinParent = join.getJoinParent();
      FromItem joinTarget = join.getJoinTarget();


      boolean isTarget = item == joinTarget;


      if (joinParent == null) {
      }
      else if (joinParent.getJoinExpr() == null
               && joinParent == joinTarget
               && ! usesFromData(joinParent)) {
        _fromList.remove(joinParent);


        replaceJoin(join);


        // XXX:
        item.setJoinExpr(null);
        //item.setOuterJoin(false);
        i = -1;


        AmberExpr joinWhere = join.getWhere();


        if (joinWhere != null)
          _where = AndExpr.create(_where, joinWhere);
      }
      else if (item == joinTarget
               && ! isJoinParent(item)
               && ! usesFromData(item)) {


        boolean isManyToOne = false;
        boolean isManyToMany = false;


        if (join instanceof ManyToOneJoinExpr) {
          // jpa/0h1c
          isManyToOne = true;


          // jpa/1144
          ManyToOneJoinExpr manyToOneJoinExpr;
          manyToOneJoinExpr = (ManyToOneJoinExpr) join;
          isManyToMany = manyToOneJoinExpr.isManyToMany();
        }


        // ejb/06u0, jpa/1144, jpa/0h1c, jpa/114g
        if (isManyToMany || (isManyToOne && ! item.isInnerJoin())) {
          // ejb/06u0 || isFromInnerJoin(item)))) {


          // Optimization for common children query:
          // SELECT o FROM TestBean o WHERE o.parent.id=?
          // jpa/0h1k
          // jpa/114g as negative exists test


          // jpa/0h1m
          if (i + 1 < _fromList.size()) {
            FromItem subItem = _fromList.get(i + 1);


            JoinExpr nextJoin = subItem.getJoinExpr();


            if (nextJoin != null
                && nextJoin instanceof ManyToOneJoinExpr) {
              continue;
            }
          }


          _fromList.remove(item);


          replaceJoin(join);


          i = -1;


          AmberExpr joinWhere = join.getWhere();


          if (joinWhere != null)
            _where = AndExpr.create(_where, joinWhere);
        }
      }

View Full Code Here

  /**
   * Returns the result type.
   */
  AmberType getResultType(int index)
  {
    AmberExpr expr = _resultList.get(index);


    return expr.getType();
  }

View Full Code Here

0 1 2

TOP

Related Classes of com.caucho.amber.expr.AmberExpr

com.caucho.amber.expr.fun.FunExpr

com.caucho.amber.expr.fun.LocateFunExpr

com.caucho.amber.manager.QueryImpl

com.caucho.amber.query.AbstractQuery

com.caucho.amber.query.AmberSelectQuery

com.caucho.amber.query.ResultSetImpl

com.caucho.amber.query.SelectQuery

com.caucho.amber.query.UpdateQuery

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.