public List<TodoEvent> findAll() {
		List<TodoEvent> allEvents = new ArrayList<TodoEvent>();
		try {
			// get connection
		    Statement stmt = ds.getStatement();
			ResultSet rs = stmt.executeQuery("select * from event");

			// fetch all events from database
			TodoEvent evt;
			
			while (rs.next()) {
				evt = new TodoEvent();
				evt.setId(rs.getString(1));
		        evt.setName(rs.getString(2));
				evt.setPriority(rs.getInt(3));
				evt.setDate(rs.getDate(4));				
				allEvents.add(evt);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
		    ds.close();
		}
		
		return allEvents;
	}