Package com.opengamma.util.db

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

122
123
124
125
126
127
128
129
130
131
132
    final DbMapSqlParameterSource args = new DbMapSqlParameterSource()
        .addTimestamp("version_as_of_instant", vc.getVersionAsOf())
        .addTimestamp("corrected_to_instant", vc.getCorrectedTo())
        .addValueNullIgnored("name", getDialect().sqlWildcardAdjustValue(request.getName()));
    if (request.getDepth() >= 0) {
      args.addValue("depth", request.getDepth());
    }
    if (portfolioObjectIds != null) {
      StringBuilder buf = new StringBuilder(portfolioObjectIds.size() * 10);
      for (ObjectId objectId : portfolioObjectIds) {
        checkScheme(objectId);
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
      for (ObjectId objectId : portfolioObjectIds) {
        checkScheme(objectId);
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_portfolio_ids", buf.toString());
    }
    if (nodeObjectIds != null) {
      StringBuilder buf = new StringBuilder(nodeObjectIds.size() * 10);
      for (ObjectId objectId : nodeObjectIds) {
        checkScheme(objectId);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
      for (ObjectId objectId : nodeObjectIds) {
        checkScheme(objectId);
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_node_ids", buf.toString());
    }
    args.addValue("visibility", request.getVisibility().getVisibilityLevel());
    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_node_ids", buf.toString());
    }
    args.addValue("visibility", request.getVisibility().getVisibilityLevel());
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());

    if (request.isIncludePositions()) {
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_node_ids", buf.toString());
    }
    args.addValue("visibility", request.getVisibility().getVisibilityLevel());
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());

    if (request.isIncludePositions()) {
      String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args) };
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_node_ids", buf.toString());
    }
    args.addValue("visibility", request.getVisibility().getVisibilityLevel());
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());

    if (request.isIncludePositions()) {
      String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args) };
      doSearch(request.getPagingRequest(), sql, args, new PortfolioDocumentExtractor(true, true), result);
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
      args.addValue("sql_search_node_ids", buf.toString());
    }
    args.addValue("visibility", request.getVisibility().getVisibilityLevel());
    args.addValue("sort_order", ORDER_BY_MAP.get(request.getSortOrder()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());

    if (request.isIncludePositions()) {
      String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args) };
      doSearch(request.getPagingRequest(), sql, args, new PortfolioDocumentExtractor(true, true), result);
    } else {
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
  @Override
  protected DbMapSqlParameterSource argsHistory(AbstractHistoryRequest request) {
    DbMapSqlParameterSource args = super.argsHistory(request);
    int depth = ((PortfolioHistoryRequest) request).getDepth();
    if (depth >= 0) {
      args.addValue("depth", depth);
    }
    return args;
  }

  //-------------------------------------------------------------------------
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
  public Pair<List<ViewResultEntry>, Paging> getBatchValues(final ObjectId batchId, final PagingRequest pagingRequest) {
    s_logger.info("Getting Batch values: ", pagingRequest);
   
    final Long runId = extractOid(batchId);
    final DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("run_id", runId);
    if (pagingRequest != null) {
      args.addValue("paging_offset", pagingRequest.getFirstItem());
      args.addValue("paging_fetch", pagingRequest.getPagingSize());
    }
   
View Full Code Here
354
355
356
357
358
359
360
361
362
363
364
   
    final Long runId = extractOid(batchId);
    final DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("run_id", runId);
    if (pagingRequest != null) {
      args.addValue("paging_offset", pagingRequest.getFirstItem());
      args.addValue("paging_fetch", pagingRequest.getPagingSize());
    }
   
    final String[] sql = {getElSqlBundle().getSql("GetBatchValues", args), getElSqlBundle().getSql("BatchValuesCount", args)};
    return searchWithPaging(pagingRequest, sql, args, new BatchValuesExtractor());
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.