コード例 #1
0
  public String toString(ValueContext vc) {
    valid = false;
    if (queryDefn == null) return "Query Definition is NULL";

    StringBuffer errorMsg = new StringBuffer();
    if (queryDefn.getErrors() != null) {
      List errors = queryDefn.getErrors();
      for (int i = 0; i < errors.size(); i++) errorMsg.append(errors.get(i) + ".\n");
    }
    if (select == null) {
      errorMsg.append("Query select is NULL.");
    } else {
      if (select.getErrors() != null) {
        List errors = select.getErrors();
        for (int i = 0; i < errors.size(); i++) errorMsg.append(errors.get(i) + ".\n");
      }
    }
    if (errorMsg.length() > 0) return errorMsg.toString();

    List showFields = select.getReportFields();
    int showFieldsCount = showFields.size();
    for (int sf = 0; sf < showFieldsCount; sf++) {
      QueryField field = (QueryField) showFields.get(sf);
      String selClauseAndLabel = field.getSelectClauseExprAndLabel();
      if (selClauseAndLabel != null) selectClause.add(field.getSelectClauseExprAndLabel());
      addJoin(field);
    }

    QueryConditions allSelectConditions = select.getConditions();
    QueryConditions usedSelectConditions = allSelectConditions.getUsedConditions(this, vc);

    // add join tables which have the auto-include flag set and their respective conditions to the
    // from and where clause lists. If the join is already in the 'joins' list, no need to add it
    // in.
    List autoIncJoinList = this.queryDefn.getAutoIncJoins();
    for (Iterator it = autoIncJoinList.iterator(); it.hasNext(); ) {
      this.addJoin((QueryJoin) it.next());
    }

    StringBuffer sql = new StringBuffer();

    int selectCount = selectClause.size();
    int selectLast = selectCount - 1;
    sql.append("select ");
    if (select.distinctRowsOnly()) sql.append("distinct \n");
    else sql.append("\n");
    for (int sc = 0; sc < selectCount; sc++) {
      sql.append("  " + selectClause.get(sc));
      if (sc != selectLast) sql.append(", ");
      sql.append("\n");
    }

    int fromCount = fromClause.size();
    int fromLast = fromCount - 1;
    sql.append("from \n");
    for (int fc = 0; fc < fromCount; fc++) {
      sql.append("  " + fromClause.get(fc));
      if (fc != fromLast) sql.append(", ");
      sql.append("\n");
    }

    boolean haveJoinWheres = false;
    int whereCount = whereJoinClause.size();
    int whereLast = whereCount - 1;
    if (whereCount > 0) {
      sql.append("where\n  (\n");
      for (int wc = 0; wc < whereCount; wc++) {
        sql.append("  " + whereJoinClause.get(wc));
        if (wc != whereLast) sql.append(" and ");
        sql.append("\n");
      }
      sql.append("  )");
      haveJoinWheres = true;
    }

    boolean haveCondWheres = false;
    int usedCondsCount = usedSelectConditions.size();
    if (usedCondsCount > 0) {
      if (haveJoinWheres) sql.append(" and (\n");
      else sql.append("where\n  (\n");
      usedSelectConditions.createSql(this, vc, usedSelectConditions, sql);
      sql.append("  )\n");
      haveCondWheres = true;
    }

    List whereExprs = select.getWhereExpressions();
    if (whereExprs != null && whereExprs.size() > 0) {
      int whereExprsLast = whereExprs.size() - 1;
      boolean first = false;
      if (!haveJoinWheres && !haveCondWheres) {
        sql.append("where\n  (\n");
        first = true;
      }

      int whereExprsCount = whereExprs.size();
      for (int we = 0; we < whereExprsCount; we++) {
        SqlWhereExpression expr = (SqlWhereExpression) whereExprs.get(we);
        if (first) first = false;
        else sql.append(expr.getConnectorSql());

        sql.append(" (");
        sql.append(expr.getWhereCondExpr(this));
        sql.append("  )\n");
      }
    }
    List groupBys = select.getGroupBy();
    int groupBysCount = groupBys.size();
    if (groupBysCount > 0) {
      int groupByLast = groupBysCount - 1;
      sql.append("group by\n");
      for (int gb = 0; gb < groupBysCount; gb++) {
        QueryField field = (QueryField) groupBys.get(gb);
        sql.append("  " + field.getQualifiedColName());
        if (gb != groupByLast) {
          sql.append(", ");
        }
        sql.append("\n");
      }
    }

    List orderBys = select.getOrderBy();
    int orderBysCount = orderBys.size();
    int orderBysLast = orderBysCount - 1;
    if (orderBysCount > 0) {
      sql.append("order by\n");
      for (int ob = 0; ob < orderBysCount; ob++) {
        QuerySortFieldRef sortRef = (QuerySortFieldRef) orderBys.get(ob);
        QueryField[] fields = sortRef.getFields(vc);
        if (fields == null) {
          return "Order by field '"
              + sortRef.getFieldName().getId()
              + "' did not evaluate to an appropriate QueryField.\n";
        } else {
          int lastField = fields.length - 1;
          for (int i = 0; i < fields.length; i++) {
            QueryField field = fields[i];
            if (field == null)
              return "Order by field ["
                  + i
                  + "] in '"
                  + sortRef.getFieldName().getId()
                  + "' did not evaluate to an appropriate QueryField.\n";

            sql.append("  " + field.getOrderByClauseExpr());
            if (sortRef.isDescending()) sql.append(" desc");

            if (i != lastField) {
              sql.append(", ");
              sql.append("\n");
            }
          }
        }

        if (ob != orderBysLast) sql.append(", ");
        sql.append("\n");
      }
    }

    valid = true;
    return sql.toString();
  }
コード例 #2
0
 public SelectStmtGenerator(QuerySelect select) {
   this.queryDefn = select.getQueryDefn();
   this.select = select;
 }