Package com.opengamma.util.db

Examples of com.opengamma.util.db.DbMapSqlParameterSource.addValue()

200
201
202
203
204
205
206
207
208
209
210
        args.addValue("key_value" + i, id.getValue());
        i++;
      }
      args.addValue("sql_search_external_ids_type", externalIdSearch.getSearchType());
      args.addValue("sql_search_external_ids", sqlSelectIdKeys(externalIdSearch));
      args.addValue("id_search_size", externalIdSearch.getExternalIds().size());
    }
    if (objectIds != null) {
      StringBuilder buf = new StringBuilder(objectIds.size() * 10);
      for (ObjectId objectId : objectIds) {
        checkScheme(objectId);
View Full Code Here
209
210
211
212
213
214
215
216
217
218
219
      for (ObjectId objectId : objectIds) {
        checkScheme(objectId);
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args)};
    doSearch(request.getPagingRequest(), sql, args, new UserDocumentExtractor(), result);
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    final SecurityMasterDetailProvider detailProvider = getDetailProvider();  // lock against change
    if (detailProvider != null) {
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args)};
    doSearch(request.getPagingRequest(), sql, args, new UserDocumentExtractor(), result);
    return result;
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args)};
    doSearch(request.getPagingRequest(), sql, args, new UserDocumentExtractor(), result);
    return result;
  }
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    final SecurityMasterDetailProvider detailProvider = getDetailProvider();  // lock against change
    if (detailProvider != null) {
      detailProvider.extendSearch(request, args);
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());
   
    final SecurityMasterDetailProvider detailProvider = getDetailProvider();  // lock against change
    if (detailProvider != null) {
      detailProvider.extendSearch(request, args);
    }
View Full Code Here
316
317
318
319
320
321
322
323
324
325
326
        .addTimestamp("corr_from_instant", document.getCorrectionFromInstant())
        .addTimestampNullFuture("corr_to_instant", document.getCorrectionToInstant())
        .addValue("name", document.getSecurity().getName())
        .addValue("sec_type", document.getSecurity().getSecurityType());
      if (document.getSecurity() instanceof RawSecurity) {
        docArgs.addValue("detail_type", "R");
      } else if (document.getSecurity().getClass() == ManageableSecurity.class) {
        docArgs.addValue("detail_type", "M");
      } else {
        docArgs.addValue("detail_type", "D");
      }
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
        .addValue("name", document.getSecurity().getName())
        .addValue("sec_type", document.getSecurity().getSecurityType());
      if (document.getSecurity() instanceof RawSecurity) {
        docArgs.addValue("detail_type", "R");
      } else if (document.getSecurity().getClass() == ManageableSecurity.class) {
        docArgs.addValue("detail_type", "M");
      } else {
        docArgs.addValue("detail_type", "D");
      }
      // the arguments for inserting into the idkey tables
      final List<DbMapSqlParameterSource> assocList = new ArrayList<DbMapSqlParameterSource>();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.