public Integer deleteByDateInterval(
DeleteDataForm.DateIntervalType dateIntervalType, final Integer dateIntervalSize) {
String sql =
"DELETE FROM "
+ tableName
+ " WHERE occurred_at < DATE_SUB(CURDATE(), INTERVAL ? "
+ dateIntervalType.toString()
+ ")";
return jdbcTemplate.update(
sql,
new PreparedStatementSetter() {
public void setValues(PreparedStatement ps) throws SQLException {
ps.setInt(1, dateIntervalSize);
}
});
}
