Map<String, Object> values = jdbcTemplate.queryForMap(sql, confirmation.getConfirmationNumber());
verifyInsertedValues(confirmation, dining, values);
}
private void verifyInsertedValues(RewardConfirmation confirmation, Dining dining, Map<String, Object> values) {
assertEquals(confirmation.getAccountContribution().getAmount(), new MonetaryAmount((Double) values
.get("REWARD_AMOUNT")));
assertEquals(SimpleDate.today().asDate(), values.get("REWARD_DATE"));
assertEquals(confirmation.getAccountContribution().getAccountNumber(), values.get("ACCOUNT_NUMBER"));
assertEquals(dining.getAmount(), new MonetaryAmount((Double) values.get("DINING_AMOUNT")));
assertEquals(dining.getMerchantNumber(), values.get("DINING_MERCHANT_NUMBER"));
assertEquals(SimpleDate.today().asDate(), values.get("DINING_DATE"));
}