public static EventAssignment extractAssignment(ResultSet res) throws Exception {
        int id = res.getInt("id");
        int eventid = res.getInt("eventid");
        int userid = res.getInt("userid");
        int adminid = res.getInt("adminid");
        Timestamp timestamp = res.getTimestamp("timestamp");
        int done = res.getInt("done");
        return new EventAssignment(id, eventid, userid, adminid, timestamp, done);
    }