def it_should_match_the_record(test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db insert_user(connection, "U123456", SOURCE_SYSTEM, 1) insert_user(connection, "U123456", "FirstLMS", 2) insert_section(connection, "B098765", SOURCE_SYSTEM, 1) insert_section(connection, "F098765", "FirstLMS", 2) insert_user_section_association(connection, "UB123456", SOURCE_SYSTEM, 1, 1, 1) insert_user_section_association(connection, "UF123456", SOURCE_SYSTEM, 2, 2, 2) insert_record(connection, "B123456", SOURCE_SYSTEM, 1, 1, 1) insert_record(connection, "F234567", "FirstLMS", 2, 2, 2) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged LMSUserAttendanceEvent = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.lmsuserattendanceevent order by sourcesystemidentifier" ).fetchall() assert len(LMSUserAttendanceEvent) == 2 assert [SOURCE_SYSTEM, "FirstLMS" ] == [x["sourcesystem"] for x in LMSUserAttendanceEvent] assert ["B123456", "F234567"] == [ x["sourcesystemidentifier"] for x in LMSUserAttendanceEvent ] assert [None, None] == [x["deletedat"] for x in LMSUserAttendanceEvent]
def it_should_match_the_record(test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db section_identifier_1 = 13 insert_section(connection, "B098765", SOURCE_SYSTEM, section_identifier_1) section_identifier_2 = 14 insert_section(connection, "B109876", SOURCE_SYSTEM, section_identifier_2) insert_assignment(connection, "B123456", SOURCE_SYSTEM, 11, section_identifier_1) insert_assignment(connection, "B234567", SOURCE_SYSTEM, 12, section_identifier_2) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged Assignment = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.assignment order by sourcesystemidentifier" ).fetchall() assert len(Assignment) == 2 assert [SOURCE_SYSTEM, SOURCE_SYSTEM] == [x["sourcesystem"] for x in Assignment] assert ["B123456", "B234567" ] == [x["sourcesystemidentifier"] for x in Assignment] assert [None, None] == [x["deletedat"] for x in Assignment]
def it_should_soft_delete_the_record( test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db # arrange - note csv file has only B123456 user_identifier = 13 insert_user(connection, "U123456", SOURCE_SYSTEM, user_identifier) section_identifier = 14 insert_section(connection, "S098765", SOURCE_SYSTEM, section_identifier) assignment_identifier = 15 insert_assignment(connection, "B098765", SOURCE_SYSTEM, assignment_identifier, section_identifier) insert_record(connection, "B123456", SOURCE_SYSTEM, assignment_identifier, user_identifier) insert_record(connection, "B234567", SOURCE_SYSTEM, assignment_identifier, user_identifier) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - B234567 has been soft deleted AssignmentSubmission = connection.execute( "select sourcesystemidentifier from lms.assignmentsubmission where deletedat is not null" ).fetchall() assert len(AssignmentSubmission) == 1 assert AssignmentSubmission[0]["sourcesystemidentifier"] == "B234567"
def it_should_match_the_record( test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings] ): adapter, connection, settings = test_pgsql_db user_identifier = 10 insert_user(connection, "U123456", SOURCE_SYSTEM, user_identifier) section_identifier_1 = 11 insert_section(connection, "B098765", SOURCE_SYSTEM, section_identifier_1) section_identifier_2 = 12 insert_section(connection, "B109876", SOURCE_SYSTEM, section_identifier_2) insert_user_section_association(connection, "B123456", SOURCE_SYSTEM, 11, user_identifier, section_identifier_1) insert_user_section_association(connection, "B234567", SOURCE_SYSTEM, 12, user_identifier, section_identifier_2) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged LMSUserLMSSectionAssociation = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.lmsuserlmssectionassociation order by sourcesystemidentifier" ).fetchall() assert len(LMSUserLMSSectionAssociation) == 2 assert [SOURCE_SYSTEM, SOURCE_SYSTEM] == [ x["sourcesystem"] for x in LMSUserLMSSectionAssociation ] assert ["B123456", "B234567"] == [ x["sourcesystemidentifier"] for x in LMSUserLMSSectionAssociation ] assert [None, None] == [x["deletedat"] for x in LMSUserLMSSectionAssociation]
def it_should_match_the_record(test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db insert_user(connection, "U123456", SOURCE_SYSTEM, 1) insert_section(connection, "B098765", SOURCE_SYSTEM, 1) insert_section(connection, "B109876", SOURCE_SYSTEM, 2) insert_record(connection, "B123456", SOURCE_SYSTEM, 1, 1) insert_record(connection, "B234567", SOURCE_SYSTEM, 2, 1) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged LMSSectionActivity = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.lmssectionactivity order by sourcesystemidentifier" ).fetchall() assert len(LMSSectionActivity) == 2 assert [SOURCE_SYSTEM, SOURCE_SYSTEM ] == [x["sourcesystem"] for x in LMSSectionActivity] assert ["B123456", "B234567" ] == [x["sourcesystemidentifier"] for x in LMSSectionActivity] assert [None, None] == [x["deletedat"] for x in LMSSectionActivity]
def it_should_soft_delete_the_record( test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db # arrange - note csv file has only B123456 insert_section(connection, "B123456", SOURCE_SYSTEM, 99988) insert_section(connection, "B234567", SOURCE_SYSTEM, 99989) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - B234567 has been soft deleted LMSSection = connection.execute( "select sourcesystemidentifier from lms.lmssection where deletedat is not null" ).fetchall() assert len(LMSSection) == 1 assert LMSSection[0]["sourcesystemidentifier"] == "B234567"
def it_should_match_the_record(test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db user_identifier = 11 insert_user(connection, "U123456", SOURCE_SYSTEM, user_identifier) user_identifier = 12 insert_user(connection, "U123456", "FirstLMS", user_identifier) section_identifier = 13 insert_section(connection, "S098765", SOURCE_SYSTEM, section_identifier) section_identifier = 14 insert_section(connection, "S098765", "FirstLMS", section_identifier) assignment_identifier_1 = 15 insert_assignment(connection, "B098765", SOURCE_SYSTEM, assignment_identifier_1, section_identifier) assignment_identifier_2 = 16 insert_assignment(connection, "F098765", SOURCE_SYSTEM, assignment_identifier_2, section_identifier) insert_record(connection, "B123456", SOURCE_SYSTEM, assignment_identifier_1, user_identifier) insert_record(connection, "F234567", "FirstLMS", assignment_identifier_2, user_identifier) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged AssignmentSubmission = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.assignmentsubmission order by sourcesystemidentifier" ).fetchall() assert len(AssignmentSubmission) == 2 assert [SOURCE_SYSTEM, "FirstLMS" ] == [x["sourcesystem"] for x in AssignmentSubmission] assert ["B123456", "F234567"] == [ x["sourcesystemidentifier"] for x in AssignmentSubmission ] assert [None, None] == [x["deletedat"] for x in AssignmentSubmission]
def it_should_match_the_record(test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db # arrange - note csv file has only B123456 from BestLMS insert_section(connection, "B123456", SOURCE_SYSTEM, 99998) insert_section(connection, "F234567", "FirstLMS", 99999) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - records are unchanged LMSSection = connection.execute( "select sourcesystem, sourcesystemidentifier, deletedat from lms.lmssection order by sourcesystemidentifier" ).fetchall() assert len(LMSSection) == 2 assert [SOURCE_SYSTEM, "FirstLMS"] == [x["sourcesystem"] for x in LMSSection] assert ["B123456", "F234567" ] == [x["sourcesystemidentifier"] for x in LMSSection] assert [None, None] == [x["deletedat"] for x in LMSSection]
def it_should_soft_delete_the_record( test_pgsql_db: Tuple[SqlLmsOperations, Connection, ConnectionSettings]): adapter, connection, settings = test_pgsql_db # arrange - note csv file has only B123456 insert_user(connection, "U123456", SOURCE_SYSTEM, 1) insert_section(connection, "B098765", SOURCE_SYSTEM, 1) insert_user_section_association(connection, "UB123456", SOURCE_SYSTEM, 1, 1, 1) insert_record(connection, "B123456", SOURCE_SYSTEM, 1, 1, 1) insert_record(connection, "B234567", SOURCE_SYSTEM, 1, 1, 1) # act run_loader(main_arguments(adapter, CSV_PATH, settings)) # assert - B234567 has been soft deleted LMSUserAttendanceEvent = connection.execute( "select sourcesystemidentifier from lms.lmsuserattendanceevent where deletedat is not null" ).fetchall() assert len(LMSUserAttendanceEvent) == 1 assert LMSUserAttendanceEvent[0]["sourcesystemidentifier"] == "B234567"