Examples of DbMapSqlParameterSource

com.opengamma.util.db.DbMapSqlParameterSource
Parameter source for Spring JDBC templating.
This class extends {@link MapSqlParameterSource} from Spring to provideadditional support for types.

Examples of com.opengamma.util.db.DbMapSqlParameterSource

  @Override
  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());
    }
    
    final String[] sql = {getElSqlBundle().getSql("GetBatchValues", args), getElSqlBundle().getSql("BatchValuesCount", args)};
    return searchWithPaging(pagingRequest, sql, args, new BatchValuesExtractor());
  }

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

        selectSql = selectComputationTargetSpecificationWithNullVersionSql;
      } else {
        selectSql = selectComputationTargetSpecificationSql;
      }


      final DbMapSqlParameterSource selectArgs = new DbMapSqlParameterSource();
      for (String attribName : attribs.keySet()) {
        selectArgs.addValue(attribName, attribs.get(attribName));
      }
      List<Map<String, Object>> results = getJdbcTemplate().queryForList(selectSql, selectArgs);
      if (results.isEmpty()) {
        // select avoids creating unecessary id, but id may still not be used
        final long id = nextId(RSK_SEQUENCE_NAME);
        final DbMapSqlParameterSource insertArgs = new DbMapSqlParameterSource().addValue("id", id);
        for (String attribName : attribs.keySet()) {
          insertArgs.addValue(attribName, attribs.get(attribName));
        }
        insertArgsList.add(insertArgs);
        //
        for (ComputationTargetSpecification obj : attribsToObjects.getValue()) {
          cache.put(obj, id);

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

    final List<DbMapSqlParameterSource> insertArgsList = new ArrayList<DbMapSqlParameterSource>();


    Map<T, Long> cache = newHashMap();
    for (Map.Entry<Map<String, Object>, Collection<T>> attribsToObjects : data.entrySet()) {
      Map<String, Object> attribs = attribsToObjects.getKey();
      final DbMapSqlParameterSource selectArgs = new DbMapSqlParameterSource();
      for (String attribName : attribs.keySet()) {
        selectArgs.addValue(attribName, attribs.get(attribName));
      }
      List<Map<String, Object>> results = getJdbcTemplate().queryForList(selectSql, selectArgs);
      if (results.isEmpty()) {
        // select avoids creating unecessary id, but id may still not be used
        final long id = nextId(pkSequenceName);
        final DbMapSqlParameterSource insertArgs = new DbMapSqlParameterSource().addValue("id", id);
        for (String attribName : attribs.keySet()) {
          insertArgs.addValue(attribName, attribs.get(attribName));
        }
        insertArgsList.add(insertArgs);
        //
        for (T obj : attribsToObjects.getValue()) {
          cache.put(obj, id);

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource


    return cache;
  }


  protected Map<String, Object> getAttributes(Map<String, Object> attribs, String selectSql) {
    final DbMapSqlParameterSource selectArgs = new DbMapSqlParameterSource();
    for (String paramName : attribs.keySet()) {
      selectArgs.addValue(paramName, attribs.get(paramName));
    }
    List<Map<String, Object>> results = getJdbcTemplate().queryForList(selectSql, selectArgs);
    if (results.isEmpty()) {
      return null;
    } else if (results.size() == 1) {

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource


    for (MarketDataValue value : values) {
      final ComputationTargetSpecification targetSpec = value.getComputationTargetSpecification();
      final long id = nextId(RSK_SEQUENCE_NAME);
      ids.add(id);
      final DbMapSqlParameterSource insertArgs = new DbMapSqlParameterSource()
        .addValue("id", id)
        .addValue("snapshot_id", marketData.getId())
        .addValue("computation_target_id", _computationTargets.get(targetSpec))
        .addValue("name", value.getName())
        .addValue("value", value.getValue());

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

  private long getId(SqlParameterSource args) {
    return (Long) args.getValue("id");
  }


  private DbMapSqlParameterSource getFailureReasonArgs(long failureReasonId, long failureId, long computeFailureId) {
    final DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("id", failureReasonId);
    args.addValue("rsk_failure_id", failureId);
    args.addValue("compute_failure_id", computeFailureId);
    return args;
  }

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

    return args;
  }


  private SqlParameterSource getSuccessArgs(long successId, long riskRunId, Instant evalInstant, long calcConfId,
      long computationTargetId, long valueSpecificationId, long functionUniqueId, long computeNodeId, String valueName, Double doubleValue) {
    DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("id", successId);
    args.addValue("calculation_configuration_id", calcConfId);
    args.addValue("name", valueName);
    args.addValue("value_specification_id", valueSpecificationId);
    args.addValue("function_unique_id", functionUniqueId);
    args.addValue("computation_target_id", computationTargetId);
    args.addValue("run_id", riskRunId);
    args.addValue("value", doubleValue);
    args.addTimestamp("eval_instant", evalInstant);
    args.addValue("compute_node_id", computeNodeId);
    return args;
  }

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

    args.addValue("compute_node_id", computeNodeId);
    return args;
  }


  private SqlParameterSource getTargetPropertyArgs(long targetPropertyId, long computationTargetId, String propertyKey, String propertyValue) {
    DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("id", targetPropertyId);
    args.addValue("target_id", computationTargetId);
    args.addValue("property_key", propertyKey);
    args.addValue("property_value", propertyValue);
    return args;
  }

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

    return args;
  }


  private SqlParameterSource getFailureArgs(long failureId, long riskRunId, Instant evalInstant, long calcConfId,
      long computationTargetId, long valueSpecificationId, long functionUniqueId, long computeNodeId, String valueName) {
    DbMapSqlParameterSource args = new DbMapSqlParameterSource();
    args.addValue("id", failureId);
    args.addValue("calculation_configuration_id", calcConfId);
    args.addValue("name", valueName);
    args.addValue("value_specification_id", valueSpecificationId);
    args.addValue("function_unique_id", functionUniqueId);
    args.addValue("computation_target_id", computationTargetId);
    args.addValue("run_id", riskRunId);
    args.addTimestamp("eval_instant", evalInstant);
    args.addValue("compute_node_id", computeNodeId);
    return args;
  }

View Full Code Here

Examples of com.opengamma.util.db.DbMapSqlParameterSource

    if (organizationObjectIds != null && organizationObjectIds.size() == 0) {
      result.setPaging(Paging.of(request.getPagingRequest(), 0));
      return result;
    }
    
    final DbMapSqlParameterSource args = new DbMapSqlParameterSource()
        .addTimestamp("version_as_of_instant", vc.getVersionAsOf())
        .addTimestamp("corrected_to_instant", vc.getCorrectedTo())
        .addValueNullIgnored("obligor_short_name", getDialect().sqlWildcardAdjustValue(request.getObligorShortName()))
        .addValueNullIgnored("obligor_red_code", getDialect().sqlWildcardAdjustValue(request.getObligorREDCode()))
        .addValueNullIgnored("obligor_ticker", getDialect().sqlWildcardAdjustValue(request.getObligorTicker()));
    args.addValue("paging_offset", request.getPagingRequest().getFirstItem());
    args.addValue("paging_fetch", request.getPagingRequest().getPagingSize());


    if (organizationObjectIds != null) {
      StringBuilder buf = new StringBuilder(organizationObjectIds.size() * 10);
      for (ObjectId objectId : organizationObjectIds) {
        checkScheme(objectId);
        buf.append(extractOid(objectId)).append(", ");
      }
      buf.setLength(buf.length() - 2);
      args.addValue("sql_search_object_ids", buf.toString());
    }
    
    String[] sql = {getElSqlBundle().getSql("Search", args), getElSqlBundle().getSql("SearchCount", args)};
    doSearch(request.getPagingRequest(), sql, args, new OrganizationDocumentExtractor(), result);
    return result;

View Full Code Here

0 1 2 3 4 5

TOP

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.