def test_canvas_course_scores_fixture(self, app):
results = queries.get_all_enrollments_in_advisee_canvas_sites()
assert len(results) > 0
assert {
'canvas_course_id': 7654321,
'canvas_course_term': 'Fall 2017',
'uid': '9000100',
'canvas_user_id': 9000100,
'current_score': 84,
'last_activity_at': 1535275620,
'sis_enrollment_status': 'E',
} in results
def merge_memberships_into_site_map(site_map):
# Collect the bCourses enrollments of interest.
canvas_enrollments = queries.get_all_enrollments_in_advisee_canvas_sites()
for key, group in groupby(canvas_enrollments, key=operator.itemgetter('canvas_course_id')):
canvas_site_id = key
enrollments = list(group)
sis_term_id = berkeley.sis_term_id_for_name(enrollments[0].get('canvas_course_term'))
site = site_map.get(sis_term_id, {}).get(canvas_site_id)
if site:
site['enrollments'] = enrollments
else:
app.logger.warn(f'Did not find canvas_course_id {canvas_site_id} in site map for term {sis_term_id}')
return site_map
def test_override_fixture(self, app):
mr = MockRows(
io.StringIO(
'course_id,uid,canvas_user_id,current_score,last_activity_at,sis_enrollment_status\n1,2,3,4,5,F'
))
with register_mock(queries.get_all_enrollments_in_advisee_canvas_sites,
mr):
data = queries.get_all_enrollments_in_advisee_canvas_sites()
assert len(data) == 1
assert {
'course_id': 1,
'uid': '2',
'canvas_user_id': 3,
'current_score': 4,
'last_activity_at': 5,
'sis_enrollment_status': 'F',
} == data[0]