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]