コード例 #1
0
  /**
   * Return the clause to constrain the browse to a specific value. Will return something of the
   * form: <code>
   * [field] = '[value]'
   * </code> such as: <code>
   * sort_value = 'some author'
   * </code>
   *
   * @return the value clause
   */
  private void buildWhereClauseFilterValue(StringBuffer queryBuf, List params) {
    // assemble the value clause if we are to have one
    if (value != null && valueField != null) {
      buildWhereClauseOpInsert(queryBuf);
      queryBuf.append(" ");
      if (tableDis != null && tableMap != null) {
        queryBuf.append(table).append(".item_id=mappings.item_id ");
      } else {
        queryBuf.append(valueField);
        if (valuePartial) {
          queryBuf.append(" LIKE ? ");

          if (valueField.startsWith("sort_")) {
            params.add("%" + utils.truncateSortValue(value) + "%");
          } else {
            params.add("%" + utils.truncateValue(value) + "%");
          }
        } else {
          queryBuf.append("=? ");

          if (valueField.startsWith("sort_")) {
            params.add(utils.truncateSortValue(value));
          } else {
            params.add(utils.truncateValue(value));
          }
        }
      }
    }
  }
コード例 #2
0
ファイル: BrowseDAOPostgres.java プロジェクト: nesovi/DSpace
  /**
   * Build the clauses required for the view used in focused or scoped queries.
   *
   * @param queryBuf
   * @param params
   */
  private void buildFocusedSelectClauses(StringBuffer queryBuf, List<Serializable> params) {
    if (tableMap != null && tableDis != null) {
      queryBuf.append(tableMap).append(".distinct_id=").append(tableDis).append(".id");
      queryBuf.append(" AND ");
      if (authority == null) {
        queryBuf.append(tableDis).append(".authority IS NULL");
        queryBuf.append(" AND ");
        queryBuf.append(tableDis).append(".").append(valueField);

        if (valuePartial) {
          queryBuf.append(" LIKE ? ");

          if (valueField.startsWith("sort_")) {
            params.add("%" + utils.truncateSortValue(value) + "%");
          } else {
            params.add("%" + utils.truncateValue(value) + "%");
          }
        } else {
          queryBuf.append("=? ");

          if (valueField.startsWith("sort_")) {
            params.add(utils.truncateSortValue(value));
          } else {
            params.add(utils.truncateValue(value));
          }
        }
      } else {
        queryBuf.append(tableDis).append(".authority=?");
        params.add(utils.truncateValue(authority, 100));
      }
    }

    if (containerTable != null && containerIDField != null && containerID != -1) {
      if (tableMap != null) {
        if (tableDis != null) {
          queryBuf.append(" AND ");
        }

        queryBuf
            .append(tableMap)
            .append(".item_id=")
            .append(containerTable)
            .append(".item_id AND ");
      }

      queryBuf.append(containerTable).append(".").append(containerIDField);
      queryBuf.append("=? ");

      params.add(Integer.valueOf(containerID));
    }
  }
コード例 #3
0
  /**
   * Get the clause to get the browse to start from a given focus value. Will return something of
   * the form: <code>
   * [field] (<[=] | >[=]) '[value]'
   * </code> such as: <code>
   * sort_value <= 'my text'
   * </code>
   *
   * @return the focus clause
   */
  private void buildWhereClauseJumpTo(StringBuffer queryBuf, List params) {
    // get the operator (<[=] | >[=]) which the focus of the browse will
    // be matched using
    String focusComparator = getFocusComparator();

    // assemble the focus clase if we are to have one
    // it will look like one of the following
    // - sort_value <= myvalue
    // - sort_1 >= myvalue
    if (focusField != null && focusValue != null) {
      buildWhereClauseOpInsert(queryBuf);
      queryBuf.append(" ");
      queryBuf.append(focusField);
      queryBuf.append(focusComparator);
      queryBuf.append("? ");

      if (focusField.startsWith("sort_")) {
        params.add(utils.truncateSortValue(focusValue));
      } else {
        params.add(utils.truncateValue(focusValue));
      }
    }
  }