@Override
public List<Event> getFutureEvents(int pageSize) {
Date today = DateUtils.getToday();
JdbcTemplate select = new JdbcTemplate(dataSource);
List<Event> events =
select.query(
"select event.id, event.title, event.description, event.island, event.location, event.content_source_id, event.url, event.start_datetime, event.end_datetime from event, content_source where event.start_datetime > ? and event.content_source_id = content_source.id order by start_datetime asc limit 0,?",
new Object[] {today, pageSize},
new EventRowMapper());
Collections.reverse(events); // reverse order because we want the latest event, first
return events;
}
