/**
* 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;
}
