private List<EventTarget> getEventTargets(EventModel event) throws SQLException {
List<EventTarget> targets = new ArrayList();
EventTarget target = null;
String sql =
"SELECT description, mandatory, target_origin_id "
+ " FROM event_targets_origins, targets_origins \n"
+ " WHERE event_id = ? AND target_origin_id = targets_origins.id;";
Cursor cursor = this.database.rawQuery(sql, new String[] {String.valueOf(event.getId())});
while (cursor.moveToNext()) {
target = new EventTarget();
target.setTarget(
new TargetOrigin(
cursor.getInt(cursor.getColumnIndex("target_origin_id")),
cursor.getString(cursor.getColumnIndex("description"))));
target.setMandatory(cursor.getInt(cursor.getColumnIndex("mandatory")) > 0);
target.setEvent(event);
targets.add(target);
}
if (!cursor.isClosed()) {
cursor.close();
}
return targets;
}
