def it_should_ignore_the_deleted_record(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user_deleted(connection, SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, UNIQUE_ID, STUDENT_ID) # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: LMSUser = query(connection, "SELECT EdFiStudentId from lms.LMSUser") assert len(LMSUser) == 1 assert LMSUser[0]["EdFiStudentId"] is None
def it_should_return_no_exceptions(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user(connection, SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, UNIQUE_ID, STUDENT_ID) # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: exceptions = query( connection, "SELECT SourceSystemIdentifier FROM lmsx.exceptions_LMSUser") assert len(exceptions) == 0
def it_should_run_successfully(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user(connection, "sis_id_1", "*****@*****.**", SOURCE_SYSTEM) insert_lms_user(connection, "sis_id_2", "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, "not_matching_sis_id_1") insert_edfi_student(connection, "not_matching_sis_id_2") # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: LMSUser = query(connection, "SELECT EdFiStudentId from lms.LMSUser") assert len(LMSUser) == 2 assert LMSUser[0]["EdFiStudentId"] is None assert LMSUser[1]["EdFiStudentId"] is None
def it_should_return_exceptions(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user(connection, SIS_ID_1, "*****@*****.**", SOURCE_SYSTEM) insert_lms_user(connection, SIS_ID_2, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, "not_matching_sis_id_1") insert_edfi_student(connection, "not_matching_sis_id_2") # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: exceptions = query( connection, "SELECT SourceSystemIdentifier FROM lmsx.exceptions_LMSUser") assert len(exceptions) == 2 assert exceptions[0]["SourceSystemIdentifier"] == SIS_ID_1 assert exceptions[1]["SourceSystemIdentifier"] == SIS_ID_2
def it_should_return_one_exception(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user(connection, SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, UNIQUE_ID, STUDENT_ID) insert_lms_user(connection, NOT_MATCHING_SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, "also_not_matching_unique_id") # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: exceptions = query( connection, "SELECT SourceSystemIdentifier FROM lmsx.exceptions_LMSUser") assert len(exceptions) == 1 assert exceptions[0][ "SourceSystemIdentifier"] == NOT_MATCHING_SIS_ID
def it_should_run_successfully(test_db_config: MssqlServerConfig): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_lms_user(connection, SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, UNIQUE_ID, STUDENT_ID) insert_lms_user(connection, NOT_MATCHING_SIS_ID, "*****@*****.**", SOURCE_SYSTEM) insert_edfi_student(connection, "also_not_matching_unique_id") # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: LMSUser = query( connection, "SELECT EdFiStudentId, SourceSystemIdentifier from lms.LMSUser", ) assert len(LMSUser) == 2 assert LMSUser[0]["SourceSystemIdentifier"] == SIS_ID assert LMSUser[0]["EdFiStudentId"] == STUDENT_ID assert LMSUser[1]["SourceSystemIdentifier"] == NOT_MATCHING_SIS_ID assert LMSUser[1]["EdFiStudentId"] is None
def it_should_create_missing_submissions_for_associated_students( test_db_config: MssqlServerConfig, source_system: str): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_descriptor( connection, descriptor_namespace_for(source_system), ASSIGNMENT_CATEGORY ) insert_lmsx_assignmentcategory_descriptor(connection, 1) insert_descriptor( connection, descriptor_namespace_for(source_system), source_system ) insert_lmsx_sourcesystem_descriptor(connection, 2) insert_descriptor( connection, submission_descriptor_namespace_for(source_system), ASSIGNMENT_SUBMISSION_STATUS_MISSING, ) insert_lmsx_assignmentsubmissionstatus_descriptor(connection, 3) insert_descriptor( connection, submission_descriptor_namespace_for(source_system), ASSIGNMENT_SUBMISSION_STATUS_UPCOMING, ) insert_lmsx_assignmentsubmissionstatus_descriptor(connection, 4) insert_lms_section(connection, SIS_SECTION_ID, source_system) insert_edfi_section(connection, SIS_SECTION_ID) connection.execute( """UPDATE LMS.LMSSECTION SET EdFiSectionId = (SELECT TOP 1 ID FROM EDFI.SECTION)""" ) insert_lms_assignment( connection, ASSIGNMENT_SOURCE_SYSTEM_IDENTIFIER, source_system, 1, ASSIGNMENT_CATEGORY ) insert_lms_user(connection, USER_SIS_ID, USER_TEST_EMAIL, source_system) insert_edfi_student(connection, USER_SIS_ID) connection.execute( """UPDATE LMS.LMSUSER SET EdFiStudentId = (SELECT TOP 1 ID FROM EDFI.Student)""" ) insert_edfi_section_association( connection, SIS_SECTION_ID, USER_SIS_ID ) # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: LMSAssignmentSubmission = query( connection, "SELECT * from [lmsx].[AssignmentSubmission]" ) # We are only creating records for Schoology if (source_system == SOURCE_SYSTEM.SCHOOLOGY): assert len(LMSAssignmentSubmission) == 1 else: assert len(LMSAssignmentSubmission) == 0
def it_should_insert_the_submissions_successfully( test_db_config: MssqlServerConfig, source_system: str ): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_descriptor( connection, descriptor_namespace_for(source_system), ASSIGNMENT_CATEGORY ) insert_lmsx_assignmentcategory_descriptor(connection, 1) insert_descriptor( connection, descriptor_namespace_for(source_system), source_system ) insert_lmsx_sourcesystem_descriptor(connection, 2) insert_descriptor( connection, submission_descriptor_namespace_for(source_system), ASSIGNMENT_SUBMISSION_STATUS, ) insert_lmsx_assignmentsubmissionstatus_descriptor(connection, 3) insert_lms_section(connection, SIS_SECTION_ID, source_system) insert_edfi_section(connection, SIS_SECTION_ID) connection.execute( """UPDATE LMS.LMSSECTION SET EdFiSectionId = (SELECT TOP 1 ID FROM EDFI.SECTION)""" ) assignment_id = insert_lms_assignment( connection, ASSIGNMENT_SOURCE_SYSTEM_IDENTIFIER, source_system, 1, ASSIGNMENT_CATEGORY, ) insert_lms_user(connection, USER_SIS_ID, USER_TEST_EMAIL, source_system) insert_edfi_student(connection, USER_SIS_ID) connection.execute( """UPDATE LMS.LMSUSER SET EdFiStudentId = (SELECT TOP 1 ID FROM EDFI.Student)""" ) insert_lms_assignment_submissions( connection, SUBMISSION_TEST_LMS_IDENTIFIER, SUBMISSION_TEST_IDENTIFIER, assignment_id, 1, ASSIGNMENT_SUBMISSION_STATUS, source_system, False, ) # act run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: LMSAssignmentSubmission = query( connection, "SELECT * from [lmsx].[AssignmentSubmission]" ) assert len(LMSAssignmentSubmission) == 1 assert ( LMSAssignmentSubmission[0]["AssignmentSubmissionIdentifier"] == SUBMISSION_TEST_IDENTIFIER )
def it_should_return_zero( test_db_config: MssqlServerConfig ): # arrange with MSSqlConnection(test_db_config).pyodbc_conn() as connection: insert_descriptor( connection, descriptor_namespace_for(SOURCE_SYSTEM), ASSIGNMENT_CATEGORY ) insert_lmsx_assignmentcategory_descriptor(connection, 1) insert_descriptor( connection, descriptor_namespace_for(SOURCE_SYSTEM), SOURCE_SYSTEM ) insert_lmsx_sourcesystem_descriptor(connection, 2) insert_descriptor( connection, submission_descriptor_namespace_for(SOURCE_SYSTEM), ASSIGNMENT_SUBMISSION_STATUS, ) insert_lmsx_assignmentsubmissionstatus_descriptor(connection, 3) insert_lms_section(connection, SIS_SECTION_ID, SOURCE_SYSTEM) insert_edfi_section(connection, SIS_SECTION_ID) connection.execute( """UPDATE LMS.LMSSECTION SET EdFiSectionId = (SELECT TOP 1 ID FROM EDFI.SECTION)""" ) assignment_id = insert_lms_assignment( connection, ASSIGNMENT_SOURCE_SYSTEM_IDENTIFIER, SOURCE_SYSTEM, 1, ASSIGNMENT_CATEGORY, ) insert_lms_user(connection, USER_SIS_ID, USER_TEST_EMAIL, SOURCE_SYSTEM) insert_edfi_student(connection, USER_SIS_ID) connection.execute( """UPDATE LMS.LMSUSER SET EdFiStudentId = (SELECT TOP 1 ID FROM EDFI.Student)""" ) insert_lms_assignment_submissions( connection, SUBMISSION_TEST_LMS_IDENTIFIER, SUBMISSION_TEST_IDENTIFIER, assignment_id, 1, ASSIGNMENT_SUBMISSION_STATUS, SOURCE_SYSTEM, False, ) # act result = None run_harmonizer(test_db_config) # assert with MSSqlConnection(test_db_config).pyodbc_conn() as connection: result = query(connection, QUERY_FOR_ASSIGNMENT_SUBMISSION_EXCEPTIONS) result[0]['count'] == 0