コード例 #1
0
  @Override
  public void search(
      List<String> testQuery, SqlTransaction tx, final AsyncCallback<List<Integer>> callback) {
    final List<Integer> ids = new ArrayList<Integer>();
    String tableName = "Location";
    final String primaryKey = "LocationID";

    SqlQuery.select(primaryKey)
        .from(tableName.toLowerCase())
        .whereLikes("Name")
        .likeMany(testQuery)
        .execute(
            tx,
            new SqlResultCallback() {
              @Override
              public void onSuccess(SqlTransaction tx, SqlResultSet results) {
                for (SqlResultSetRow row : results.getRows()) {
                  ids.add(row.getInt(primaryKey));
                }
                callback.onSuccess(ids);
              }

              @Override
              public boolean onFailure(SqlException e) {
                return super.onFailure(e);
              }
            });
  }
コード例 #2
0
ファイル: Targets.java プロジェクト: umohi/activityinfo
  @Override
  public void setupQuery(PivotSites command, SqlQuery query) {
    query.from(Tables.TARGET_VALUE, "V");
    query.leftJoin(Tables.TARGET, "Target").on("V.TargetId = Target.TargetId");
    query.leftJoin(Tables.INDICATOR, "Indicator").on("V.IndicatorId = Indicator.IndicatorId");
    query.leftJoin(Tables.ACTIVITY, "Activity").on("Activity.ActivityId = Indicator.ActivityId");
    query.leftJoin(Tables.SITE, "Site").on("Site.ActivityId = Activity.ActivityId");
    query
        .leftJoin(Tables.USER_DATABASE, "UserDatabase")
        .on("UserDatabase.DatabaseId = Activity.DatabaseId");

    // don't use an actual sum query, target value is the same regardless of the number of sites
    query.appendColumn(String.valueOf(IndicatorDTO.AGGREGATE_SUM), ValueFields.AGGREGATION);
    query.appendColumn("V.Value", ValueFields.SUM);
    query.appendColumn("COUNT(V.Value)", ValueFields.COUNT);
  }