public void update(ItemValue itemValue) {
jdbcTemplate.update(
"UPDATE item_value SET " + "data = ?, last_update = ?, update_count = ? " + "WHERE id = ?",
serializeData(itemValue),
toTimestamp(itemValue.getLastUpdate()),
itemValue.getUpdateCount(),
itemValue.getId());
}
public void insert(ItemValue itemValue) {
jdbcTemplate.update(
"INSERT INTO item_value "
+ "(creation,dashboard_id,data,item_name,last_update,update_count)"
+ " VALUES (?,?,?,?,?,?)",
toTimestamp(itemValue.getCreation()),
itemValue.getItemRef().getDashboardId(),
serializeData(itemValue),
itemValue.getItemRef().getItemName(),
toTimestamp(itemValue.getLastUpdate()),
itemValue.getUpdateCount());
}
private String serializeData(ItemValue itemValue) {
try {
return mapper.writeValueAsString(itemValue.getData());
} catch (IOException e) {
throw new DaoException(e);
}
}
@Override
public ItemValue mapRow(ResultSet rs, int rowNum) throws SQLException {
ItemValue val = new ItemValue();
val.setId(rs.getLong(1));
val.setCreation(toDateTime(rs.getTimestamp(2)));
ItemRef itemRef = new ItemRef(rs.getString(3), rs.getString(4));
val.setItemRef(itemRef);
val.setData(deserializeData(rs.getString(5)));
val.setLastUpdate(toDateTime(rs.getTimestamp(6)));
val.setUpdateCount(rs.getInt(7));
return val;
}
