コード例 #1
0
  /**
   * Método para setar o alias do from da consulta.
   *
   * @param fromAlias - alias do from
   */
  public void fromAlias(String fromAlias) {

    this.fromAlias = fromAlias;
    this.select.alias(fromAlias);

    ConditionBuilder.updateAliasForCondition(this.where, entityClass, fromAlias);

    if (this.orderBy != null) {
      this.orderBy.setFromAlias(fromAlias);
    }

    if (this.groupBy != null) {
      this.groupBy.setFromAlias(fromAlias);
    }

    for (Join j : joins) {
      if (j.getClazzFrom().equals(entityClass)) {
        j.fromAlias(fromAlias);
      }
    }
  }
コード例 #2
0
  @Override
  public String buildSQL() {
    final StringBuilder sql = new StringBuilder();
    sql.append(SELECT.getSQLSelectType());
    sql.append(" ");

    if (distinct) {
      sql.append(DISTINCT.getSQLSelectType());
      sql.append(" ");
    }

    boolean readFieldsOfJoins = false;
    if (select.getFields().isEmpty()) {
      readFieldsOfJoins = true;

      Class<?> superTypeClass = entityClass.getSuperclass();
      if (!(Object.class.equals(superTypeClass))) {
        addJoin(JoinBuilder.newJoin(entityClass, fromAlias));
      }
    }

    sql.append(select.buildSQL());

    if (readFieldsOfJoins) {
      for (Join j : joins) {
        if (!(sql.toString().endsWith(" "))) {
          sql.append(", ");
        }

        Select selectJoin = j.builSelect();
        sql.append(selectJoin.buildSQL());
      }
    }

    sql.append(" ");
    sql.append(FROM.getSQLSelectType());
    sql.append(" ");
    sql.append(getTableName(entityClass));

    if (fromAlias != null && !(fromAlias.isEmpty())) {
      sql.append(" " + AS.getSQLSelectType() + " " + fromAlias);
    }

    if (!joins.isEmpty()) {
      for (Join j : joins) {
        sql.append(" ");
        sql.append(j.buildSQL());
      }
    }

    if (where != null) {
      sql.append(" ");
      sql.append(WHERE.getSQLSelectType());
      sql.append(" ");
      sql.append(where.buildSQL());
    }

    if (groupBy != null) {
      sql.append(" ");
      sql.append(groupBy.buildSQL());
    }

    if (orderBy != null) {
      sql.append(" ");
      sql.append(orderBy.buildSQL());
    }

    if (offset > DEFAULT_LIMIT_AND_OFFSET) {
      sql.append(" ");
      sql.append(OFFSET.getSQLSelectType());
      sql.append(" ");
      sql.append(offset);
    }

    if (limit > DEFAULT_LIMIT_AND_OFFSET) {
      sql.append(" ");
      sql.append(LIMIT.getSQLSelectType());
      sql.append(" ");
      sql.append(limit);
    }

    if (union != null) {
      sql.append(" ");
      sql.append(unionType.getUnionType());
      sql.append(" ");
      sql.append(union.buildSQL());
    }

    return sql.toString();
  }