Examples of AmberExpr

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

Examples of com.caucho.amber.expr.AmberExpr

   * Returns true if the from item is used by the query.
   */
  public boolean usesFrom(FromItem item, int type)
  {
    for (int j = 0; j < _resultList.size(); j++) {
      AmberExpr result = _resultList.get(j);


      if (result.usesFrom(item, type)) {
        return true;
      }
    }


    if (_where != null && _where.usesFrom(item, type)) {
      return true;
    }


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


        if (order.usesFrom(item, type)) {
          return true;
        }
      }
    }


    // jpa/1123
    if (_groupList != null) {
      for (int j = 0; j < _groupList.size(); j++) {
        AmberExpr group = _groupList.get(j);


        // jpa/1123 if (group.usesFrom(item, type)) {
        if (group.usesFrom(item, AmberExpr.IS_INNER_JOIN)) {
          return true;
        }
      }


      if (_having != null && _having.usesFrom(item, type))

View Full Code Here

Examples of com.caucho.amber.expr.AmberExpr

  }


  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

Examples of com.caucho.amber.expr.AmberExpr


    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

Examples of com.caucho.amber.expr.AmberExpr

      if (i != 0)
        cb.append(", ");


      // cb.append(_fieldList.get(i).generateSelect(null));


      AmberExpr expr = _fieldList.get(i);


      // jpa/1202, jpa/0k15
      if (getMetaData().supportsUpdateTableAlias()
          && (_fromList.size() > 1))
        expr.generateWhere(cb);
      else
        expr.generateUpdateWhere(cb);


      cb.append("=");


      // jpa/1231
      if (getMetaData().supportsUpdateTableAlias() || hasSubQuery())
        _valueList.get(i).generateWhere(cb);
      else
        _valueList.get(i).generateUpdateWhere(cb);
    }


    String updateJoin = null;


    if (_where != null) {
      // jpa/1200 vs jpa/1201 and jpa/1231
      if (_fromList.size() == 1 && ! hasSubQuery()) {
        cb.append(" where ");


        _where.generateUpdateWhere(cb);
      }
      else {
        boolean isFirst = true;


        // jpa/1201: postgres 8.0.x/8.2.x compatibility
        if (getMetaData() instanceof PostgresMetaData) {
          item = _fromList.get(0);


          EntityType type = item.getEntityType();


          String targetId = type.getId().generateSelect(item.getName());


          cb.append(" FROM ");


          String tableName = item.getTable().getName();


          cb.append(tableName);
          cb.append(' ');
          cb.append(item.getName());


          isFirst = false;


          cb.append(" where ");


          cb.append(targetId);
          cb.append(" = ");
          cb.append(type.getId().generateSelect(item.getTable().getName()));
        }


        // jpa/1231, jpa/1202 vs jpa/1201 and jpa/1203
        if (_fromList.size() > 1
            && ! getMetaData().supportsUpdateTableList()) {
          // Postgres: jpa/1201 and Oracle: jpa/1203
          item = _fromList.get(1);


          EntityType type = item.getEntityType();


          String relatedId = type.getId().generateSelect(item.getName());


          if (isFirst) {
            isFirst = false;
            cb.append(" where ");
          }
          else
            cb.append(" and ");


          cb.append("exists (select ");


          cb.append(relatedId);


          cb.append(" from ");


          generateFromList(cb, true);


          // jpa/1231
          isFirst = true;
        }


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


          AmberExpr expr = item.getJoinExpr();


          if (expr != null && ! item.isOuterJoin()) {
            // jpa/1231
            if (isFirst) {
              isFirst = false;
              cb.append(" where ");
            }
            else
              cb.append(" and ");


            expr.generateJoin(cb);
          }


          EntityType entityType = item.getEntityType();


          // jpa/0l44

View Full Code Here

Examples of com.caucho.amber.expr.AmberExpr

   * Binds the expression as a select item.
   */
  public AmberExpr bindSelect(QueryParser parser)
  {
    for (int i = 0; i < _args.size(); i++) {
      AmberExpr arg = _args.get(i);


      arg = arg.bindSelect(parser);


      _args.set(i, arg);
    }


    return this;

View Full Code Here

Examples of com.caucho.amber.expr.AmberExpr

   * Returns true if the expression uses the from item.
   */
  public boolean usesFrom(FromItem from, int type, boolean isNot)
  {
    for (int i = 0; i < _args.size(); i++) {
      AmberExpr arg = _args.get(i);


      if (arg instanceof IdExpr) {
        IdExpr id = (IdExpr) arg;


        // jpa/0i18
        if (id.getFromItem() == from)
          return true;
      }


      if (arg instanceof KeyColumnExpr) {
        KeyColumnExpr key = (KeyColumnExpr) arg;


        // jpa/1123
        if (key.usesFrom(from, IS_INNER_JOIN, false))
          return true;
      }


      if (arg.usesFrom(from, type))
        return true;
    }


    return false;
  }

View Full Code Here

0 1 2

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.