public String getCalendars(String username) {
		try {
			pstmt = doQuery("SELECT calendar, createdBy FROM calendars WHERE active = true AND (isPublic = true OR calendar IN (SELECT calendar FROM usercalendars WHERE username = ?))");
			pstmt.setString(1, username);

			rs = pstmt.executeQuery();

			while(rs.next()) {
				String calendar = rs.getString("calendar");
				String createdBy = rs.getString("createdBy");

				calendars.calendars.add(new Calendar(calendar, createdBy, true));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return gson.toJson(calendars);
	}