def test_get_student_exam_attempt_features(self):
query_features = [
'email', 'exam_name', 'allowed_time_limit_mins',
'is_sample_attempt', 'started_at', 'completed_at', 'status',
'Suspicious Count', 'Suspicious Comments', 'Rules Violation Count',
'Rules Violation Comments', 'track'
]
proctored_exam_id = create_exam(self.course_key, 'Test Content',
'Test Exam', 1)
ProctoredExamStudentAttempt.create_exam_attempt(
proctored_exam_id, self.users[0].id, 'Test Code 1', True, False,
'ad13')
ProctoredExamStudentAttempt.create_exam_attempt(
proctored_exam_id, self.users[1].id, 'Test Code 2', True, False,
'ad13')
ProctoredExamStudentAttempt.create_exam_attempt(
proctored_exam_id, self.users[2].id, 'Test Code 3', True, False,
'asd')
proctored_exam_attempts = get_proctored_exam_results(
self.course_key, query_features)
assert len(proctored_exam_attempts) == 3
for proctored_exam_attempt in proctored_exam_attempts:
assert set(proctored_exam_attempt.keys()) == set(query_features)
def upload_proctored_exam_results_report(_xmodule_instance_args, _entry_id, course_id, _task_input, action_name):
"""
For a given `course_id`, generate a CSV file containing
information about proctored exam results, and store using a `ReportStore`.
"""
start_time = time()
start_date = datetime.now(UTC)
num_reports = 1
task_progress = TaskProgress(action_name, num_reports, start_time)
current_step = {'step': 'Calculating info about proctored exam results in a course'}
task_progress.update_task_state(extra_meta=current_step)
# Compute result table and format it
query_features = [
'course_id',
'provider',
'track',
'exam_name',
'username',
'email',
'attempt_code',
'allowed_time_limit_mins',
'is_sample_attempt',
'started_at',
'completed_at',
'status',
'review_status',
'Suspicious Count',
'Suspicious Comments',
'Rules Violation Count',
'Rules Violation Comments'
]
student_data = get_proctored_exam_results(course_id, query_features)
header, rows = format_dictlist(student_data, query_features)
task_progress.attempted = task_progress.succeeded = len(rows)
task_progress.skipped = task_progress.total - task_progress.attempted
rows.insert(0, header)
current_step = {'step': 'Uploading CSV'}
task_progress.update_task_state(extra_meta=current_step)
# Perform the upload
upload_csv_to_report_store(rows, 'proctored_exam_results_report', course_id, start_date)
return task_progress.update_task_state(extra_meta=current_step)
