161
160
# a single query, and we cache the list of viewers for each offering.
162
161
offering_viewers_cache = {}
163
162
for (ssn, year, sem, name, psid, pspath, gid, offeringid) in store.find(
164
(Subject.short_name, Semester.year, Semester.url_name,
163
(Subject.short_name, Semester.year, Semester.semester,
165
164
ProjectGroup.name, ProjectSubmission.id, ProjectSubmission.path,
166
165
ProjectGroup.id, Offering.id),
167
166
Assessed.id == ProjectSubmission.assessed_id,