コード例 #1
0
  /* (non-Javadoc)
   * @see edu.ku.brc.af.core.expresssearch.QueryAdjusterForDomain#getJoinClause(edu.ku.brc.dbsupport.DBTableInfo, boolean)
   */
  @Override
  public String getJoinClause(
      DBTableInfo tableInfo, boolean isHQL, final String aliasArg, boolean useLeftJoin) {
    String alias;
    if (aliasArg == null) {
      alias = tableInfo.getAbbrev();
    } else {
      alias = aliasArg;
    }
    String join;
    if (useLeftJoin) {
      join = "left join ";
    } else if (isHQL) {
      join = "join ";
    } else {
      join = "inner join ";
    }

    if (tableInfo.getTableId() == Agent.getClassTableId()
        || tableInfo.getTableId() == Accession.getClassTableId()
        || tableInfo.getTableId() == RepositoryAgreement.getClassTableId()
        || tableInfo.getTableId() == ExchangeIn.getClassTableId()
        || tableInfo.getTableId() == ExchangeOut.getClassTableId()) {
      if (isHQL) {
        return join + alias + ".division as dv" + (aliasArg == null ? "" : alias);
      }
      if (aliasArg != null) {
        return "";
        // throw new RuntimeException("SpecifyQueryAdjuster.getJoinClause does not work for SQL with
        // non-null alias.");
      }
      return join;

    } else if (tableInfo.getRelationshipByName("discipline") != null) {
      DBRelationshipInfo ri = tableInfo.getRelationshipByName("discipline");
      if (ri.getType() != DBRelationshipInfo.RelationshipType.OneToOne) {
        if (isHQL) {
          return join + alias + ".discipline as dsp" + (aliasArg == null ? "" : alias);
        }
        // if (aliasArg != null)
        // {
        // throw new RuntimeException("SpecifyQueryAdjuster.getJoinClause does not work for SQL with
        // non-null alias.");
        // }
        return join + "discipline as dsp ON " + aliasArg + ".DisciplineID = dsp.DisciplineID";
      }
    }
    return super.getJoinClause(tableInfo, isHQL, alias, useLeftJoin);
  }
コード例 #2
0
  /* (non-Javadoc)
   * @see edu.ku.brc.af.core.expresssearch.QueryAdjusterForDomain#getSpecialColumns(edu.ku.brc.dbsupport.DBTableInfo, boolean, boolean, java.lang.String)
   */
  @Override
  public String getSpecialColumns(
      final DBTableInfo tableInfo,
      final boolean isHQL,
      final boolean isLeftJoin,
      final String tblAlias) {
    if (tableInfo != null) {
      String prefix = tblAlias == null ? "" : tblAlias + ".";
      String criterion = null;
      String fld = null;
      boolean adjustFldToSQL = true;

      if (tableInfo.getFieldByName("collectionMemberId") != null) {
        fld = isHQL ? "collectionMemberId" : "CollectionMemberId";
        criterion = COLMEMID;

      } else if (tableInfo.getTableId() == Agent.getClassTableId()
          || tableInfo.getTableId() == Accession.getClassTableId()
          || tableInfo.getTableId() == RepositoryAgreement.getClassTableId()
          || tableInfo.getTableId() == ExchangeIn.getClassTableId()
          || tableInfo.getTableId() == ExchangeOut.getClassTableId()) {
        if (prefix.equals("")) {
          prefix = isHQL ? "dv." : "";
        } else {
          prefix = isHQL ? ("dv" + prefix) : prefix;
        }
        fld = isHQL ? "divisionId" : "DivisionID";
        criterion = DIVID;

      } else if (tableInfo.getRelationshipByName("discipline") != null) {
        DBRelationshipInfo ri = tableInfo.getRelationshipByName("discipline");
        if (ri.getType() != DBRelationshipInfo.RelationshipType.OneToOne) {
          if (prefix.equals("")) {
            // rods - 9/29/08 - This was messing up the Geography Count (SQL) but is needed for HQL
            prefix = isHQL ? "dsp." : "";
          } else {
            prefix = isHQL ? ("dsp" + prefix) : prefix;
          }
          fld = isHQL ? "disciplineId" : "DisciplineID";
          criterion = DSPLNID;
        }

        //            } else if (tableInfo.getTableId() == DeterminationStatus.getClassTableId())
        //            {
        //                fld = isHQL ? "disciplineId" : "DisciplineID";
        //                criterion = DSPLNID;
        //
      } else if (tableInfo.getTableId() == Geography.getClassTableId()) {
        fld = isHQL ? "definition" : "GeographyTreeDefID";
        criterion = GEOTREEDEFID;

      } else if (tableInfo.getTableId() == GeologicTimePeriod.getClassTableId()) {
        fld = isHQL ? "definition" : "GeologicTimePeriodTreeDefID";
        criterion = GTPTREEDEFID;

      } else if (tableInfo.getTableId() == LithoStrat.getClassTableId()) {
        fld = isHQL ? "definition" : "LithoStratTreeDefID";
        criterion = LITHOTREEDEFID;

      } else if (tableInfo.getTableId() == Storage.getClassTableId()) {
        fld = isHQL ? "definition" : "StorageTreeDefID";
        criterion = STORTREEDEFID;

      } else if (tableInfo.getTableId() == PrepType.getClassTableId()) {
        fld = isHQL ? "collection" : "CollectionID";
        criterion = COLLID;

      } else if (tableInfo.getTableId() == Taxon.getClassTableId()) {
        fld = isHQL ? "definition" : "TaxonTreeDefID";
        criterion = TAXTREEDEFID;

      } else if (tableInfo.getTableId() == Locality.getClassTableId()) {
        fld = isHQL ? "discipline" : "DisciplineID";
        criterion = DSPLNID;

      } else if (tableInfo.getTableId() == Locality.getClassTableId()) {
        fld = isHQL ? "discipline" : "DisciplineID";
        criterion = DSPLNID;

      } else if (tableInfo.getTableId() == Locality.getClassTableId()) {
        fld = isHQL ? "discipline" : "DisciplineID";
        criterion = DSPLNID;
      } /*else if (tableInfo.getTableId() == Agent.getClassTableId())
        {
            if (StringUtils.isEmpty(prefix))
            {
                prefix = "ag.";
            }
            criterion = DIVID;
            if (isHQL)
            {
                fld = criterion + " = " + prefix + "division.id";
                adjustFldToSQL = false;
            }
            else
            {
                //this probably won't actually work without additional
                //changes to the from clause for the query
                fld = criterion + " = " + prefix + "D";
                prefix = "";
                //throw new RuntimeException("Fix me I am probably broken!");
            }
        }*/

      if (criterion != null && fld != null) {
        String sql;
        if (adjustFldToSQL) {
          sql = "(" + prefix + fld + " = " + criterion + ")";
        } else {
          sql = fld;
        }
        if (isLeftJoin) {
          if (isHQL) {
            if (tblAlias != null) {
              sql = "(" + sql + " or " + tblAlias + " is null)";
            } else {
              log.error("can't adjust hql for left join without a tblAlias.");
            }
          } else {
            sql = "(" + sql + " or " + prefix + fld + " is null)";
          }
        }
        return adjustSQL(sql);
      }
    }
    return null;
  }