private void buildConfig(final ResultSet rs, final long docId) throws SQLException {
final long docOid = rs.getLong("DOC_OID");
final Timestamp versionFrom = rs.getTimestamp("VER_FROM_INSTANT");
final Timestamp versionTo = rs.getTimestamp("VER_TO_INSTANT");
final Timestamp correctionFrom = rs.getTimestamp("CORR_FROM_INSTANT");
final Timestamp correctionTo = rs.getTimestamp("CORR_TO_INSTANT");
UniqueId uniqueId = createUniqueId(docOid, docId);
ManageableMarketDataSnapshot marketDataSnapshot;
// PLAT-1378
if (_includeData) {
LobHandler lob = getDialect().getLobHandler();
byte[] bytes = lob.getBlobAsBytes(rs, "DETAIL");
marketDataSnapshot =
FUDGE_CONTEXT.readObject(
ManageableMarketDataSnapshot.class, new ByteArrayInputStream(bytes));
if (!_includeData) {
marketDataSnapshot.setGlobalValues(null);
marketDataSnapshot.setYieldCurves(null);
}
} else {
marketDataSnapshot = new ManageableMarketDataSnapshot();
marketDataSnapshot.setName(rs.getString("NAME"));
marketDataSnapshot.setUniqueId(uniqueId);
}
MarketDataSnapshotDocument doc = new MarketDataSnapshotDocument();
doc.setUniqueId(uniqueId);
doc.setVersionFromInstant(DbDateUtils.fromSqlTimestamp(versionFrom));
doc.setVersionToInstant(DbDateUtils.fromSqlTimestampNullFarFuture(versionTo));
doc.setCorrectionFromInstant(DbDateUtils.fromSqlTimestamp(correctionFrom));
doc.setCorrectionToInstant(DbDateUtils.fromSqlTimestampNullFarFuture(correctionTo));
doc.setSnapshot(marketDataSnapshot);
_documents.add(doc);
}
/**
* Inserts a new document.
*
* @param document the document, not null
* @return the new document, not null
*/
@Override
protected MarketDataSnapshotDocument insert(final MarketDataSnapshotDocument document) {
ArgumentChecker.notNull(document.getSnapshot(), "document.snapshot");
ArgumentChecker.notNull(document.getName(), "document.name");
final ManageableMarketDataSnapshot marketDataSnaphshot = document.getSnapshot();
final long docId = nextId("snp_snapshot_seq");
final long docOid =
(document.getUniqueId() != null ? extractOid(document.getUniqueId()) : docId);
// set the uniqueId (needs to go in Fudge message)
final UniqueId uniqueId = createUniqueId(docOid, docId);
marketDataSnaphshot.setUniqueId(uniqueId);
document.setUniqueId(uniqueId);
// the arguments for inserting into the marketDataSnaphshot table
FudgeMsgEnvelope env = FUDGE_CONTEXT.toFudgeMsg(marketDataSnaphshot);
byte[] bytes = FUDGE_CONTEXT.toByteArray(env.getMessage());
final DbMapSqlParameterSource marketDataSnaphshotArgs =
new DbMapSqlParameterSource()
.addValue("doc_id", docId)
.addValue("doc_oid", docOid)
.addTimestamp("ver_from_instant", document.getVersionFromInstant())
.addTimestampNullFuture("ver_to_instant", document.getVersionToInstant())
.addTimestamp("corr_from_instant", document.getCorrectionFromInstant())
.addTimestampNullFuture("corr_to_instant", document.getCorrectionToInstant())
.addValue("name", document.getName())
.addValue("detail", new SqlLobValue(bytes, getDialect().getLobHandler()), Types.BLOB);
final String sql = getElSqlBundle().getSql("Insert", marketDataSnaphshotArgs);
getJdbcTemplate().update(sql, marketDataSnaphshotArgs);
return document;
}
/**
* @return JSON {@code [{basisViewName: basisViewName1, snapshots: [{id: snapshot1Id, name:
* snapshot1Name}, ...]}, ...]}
*/
@GET
@Produces(MediaType.APPLICATION_JSON)
public String getMarketDataSnapshotList() {
MarketDataSnapshotSearchRequest snapshotSearchRequest = new MarketDataSnapshotSearchRequest();
snapshotSearchRequest.setIncludeData(false);
Multimap<String, ManageableMarketDataSnapshot> snapshotsByBasisView =
LinkedListMultimap.create();
for (MarketDataSnapshotDocument doc :
MarketDataSnapshotSearchIterator.iterable(_snapshotMaster, snapshotSearchRequest)) {
ManageableMarketDataSnapshot snapshot = doc.getSnapshot();
if (snapshot.getUniqueId() == null) {
s_logger.warn("Ignoring snapshot with null unique identifier {}", snapshot.getName());
continue;
}
if (StringUtils.isBlank(snapshot.getName())) {
s_logger.warn("Ignoring snapshot {} with no name", snapshot.getUniqueId());
continue;
}
if (s_guidPattern.matcher(snapshot.getName()).find()) {
s_logger.debug(
"Ignoring snapshot which appears to have an auto-generated name: {}",
snapshot.getName());
continue;
}
String basisViewName =
snapshot.getBasisViewName() != null ? snapshot.getBasisViewName() : "unknown";
snapshotsByBasisView.put(basisViewName, snapshot);
}
// list of maps for each basis view: {"basisViewName": basisViewName, "snapshots", [...]}
List<Map<String, Object>> basisViewSnapshotList = new ArrayList<Map<String, Object>>();
for (String basisViewName : snapshotsByBasisView.keySet()) {
Collection<ManageableMarketDataSnapshot> viewSnapshots =
snapshotsByBasisView.get(basisViewName);
// list of maps containing snapshot IDs and names: {"id", snapshotId, "name", snapshotName}
List<Map<String, Object>> snapshotsList =
new ArrayList<Map<String, Object>>(viewSnapshots.size());
for (ManageableMarketDataSnapshot viewSnapshot : viewSnapshots) {
// map for a single snapshot: {"id", snapshotId, "name", snapshotName}
Map<String, Object> snapshotMap =
ImmutableMap.<String, Object>of(
ID, viewSnapshot.getUniqueId(), NAME, viewSnapshot.getName());
snapshotsList.add(snapshotMap);
}
basisViewSnapshotList.add(
ImmutableMap.of(BASIS_VIEW_NAME, basisViewName, SNAPSHOTS, snapshotsList));
}
return new JSONArray(basisViewSnapshotList).toString();
}