# ======== Offline calculation of grades ============================================================================= # # Computing grades of a large number of students can take a long time. These routines allow grades to # be computed offline, by a batch process (eg cronjob). # # The grades are stored in the OfflineComputedGrade table of the courseware model. import json import logging import time import courseware.models from collections import namedtuple from json import JSONEncoder from courseware import grades, models from courseware.courses import get_course_by_id from django.contrib.auth.models import User, Group class MyEncoder(JSONEncoder): def _iterencode(self, obj, markers=None): if isinstance(obj, tuple) and hasattr(obj, '_asdict'): gen = self._iterencode_dict(obj._asdict(), markers) else: gen = JSONEncoder._iterencode(self, obj, markers) for chunk in gen: yield chunk def offline_grade_calculation(course_id): ''' Compute grades for all students for a specified course, and save results to the DB. ''' tstart = time.time() enrolled_students = User.objects.filter(courseenrollment__course_id=course_id).prefetch_related("groups").order_by('username') enc = MyEncoder() class DummyRequest(object): META = {} def __init__(self): return def get_host(self): return 'edx.mit.edu' def is_secure(self): return False request = DummyRequest() print "%d enrolled students" % len(enrolled_students) course = get_course_by_id(course_id) for student in enrolled_students: gradeset = grades.grade(student, request, course, keep_raw_scores=True) gs = enc.encode(gradeset) ocg, created = models.OfflineComputedGrade.objects.get_or_create(user=student, course_id=course_id) ocg.gradeset = gs ocg.save() print "%s done" % student # print statement used because this is run by a management command tend = time.time() dt = tend - tstart ocgl = models.OfflineComputedGradeLog(course_id=course_id, seconds=dt, nstudents=len(enrolled_students)) ocgl.save() print ocgl print "All Done!" def offline_grades_available(course_id): ''' Returns False if no offline grades available for specified course. Otherwise returns latest log field entry about the available pre-computed grades. ''' ocgl = models.OfflineComputedGradeLog.objects.filter(course_id=course_id) if not ocgl: return False return ocgl.latest('created') def student_grades(student, request, course, keep_raw_scores=False, use_offline=False): ''' This is the main interface to get grades. It has the same parameters as grades.grade, as well as use_offline. If use_offline is True then this will look for an offline computed gradeset in the DB. ''' if not use_offline: return grades.grade(student, request, course, keep_raw_scores=keep_raw_scores) try: ocg = models.OfflineComputedGrade.objects.get(user=student, course_id=course.id) except models.OfflineComputedGrade.DoesNotExist: return dict(raw_scores=[], section_breakdown=[], msg='Error: no offline gradeset available for %s, %s' % (student, course.id)) return json.loads(ocg.gradeset)