Package com.opengamma.util.db

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

320
321
322
323
324
325
326
327
328
329
330
      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>();
      final List<DbMapSqlParameterSource> idKeyList = new ArrayList<DbMapSqlParameterSource>();
      final String sqlSelectIdKey = getElSqlBundle().getSql("SelectIdKey");
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
          .addTimestamp("version_as_of_instant", vc.getVersionAsOf())
          .addTimestamp("corrected_to_instant", vc.getCorrectedTo())
          .addValueNullIgnored("name", getDialect().sqlWildcardAdjustValue(request.getName()));

      if (!request.getType().isInstance(Object.class)) {
        args.addValue("config_type", request.getType().getName());
      }
      if (objectIds != null) {
        StringBuilder buf = new StringBuilder(objectIds.size() * 10);
        for (ObjectId objectId : objectIds) {
          checkScheme(objectId);
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
        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
235
236
237
238
239
240
241
242
243
244
245
          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) };
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
        }
        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) };

      final NamedParameterJdbcOperations namedJdbc = getDbConnector().getJdbcTemplate();
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
        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) };

      final NamedParameterJdbcOperations namedJdbc = getDbConnector().getJdbcTemplate();
      ConfigDocumentExtractor configDocumentExtractor = new ConfigDocumentExtractor();
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
      .addTimestamp("corrected_to_instant", vc.getCorrectedTo())
      .addValueNullIgnored("name", getDialect().sqlWildcardAdjustValue(request.getName()));
    if (externalIdSearch != null && externalIdSearch.alwaysMatches() == false) {
      int i = 0;
      for (ExternalId id : externalIdSearch) {
        args.addValue("key_scheme" + i, id.getScheme().getName());
        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));
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
      .addValueNullIgnored("name", getDialect().sqlWildcardAdjustValue(request.getName()));
    if (externalIdSearch != null && externalIdSearch.alwaysMatches() == false) {
      int i = 0;
      for (ExternalId id : externalIdSearch) {
        args.addValue("key_scheme" + i, id.getScheme().getName());
        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());
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
      for (ExternalId id : externalIdSearch) {
        args.addValue("key_scheme" + i, id.getScheme().getName());
        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);
 
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
        args.addValue("key_scheme" + i, id.getScheme().getName());
        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) {
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.