def it_should_have_temporary_sync_table_unchanged(test_db_after_sync): EXPECTED_SYNC_DATA_AFTER_SYNC = SYNC_DATA with test_db_after_sync.connect() as con: expected_sync_assignments_df = prep_expected_sync_df( DataFrame(EXPECTED_SYNC_DATA_AFTER_SYNC, columns=COLUMNS).astype("string"), IDENTITY_COLUMNS, ) sync_assignments_from_db_df = prep_from_sync_db_df( read_sql_query("SELECT * from Sync_Assignments", con).astype("string"), IDENTITY_COLUMNS, ) assert expected_sync_assignments_df.to_csv( ) == sync_assignments_from_db_df.to_csv()
def it_should_have_courses_table_with_updated_row_and_added_new_row( test_db_after_sync, ): EXPECTED_COURSE_DATA_AFTER_SYNC = [ UNCHANGED_COURSE, OMITTED_FROM_SYNC_COURSE, CHANGED_COURSE_AFTER, NEW_COURSE, ] with test_db_after_sync.connect() as con: expected_courses_df = prep_expected_sync_df( DataFrame(EXPECTED_COURSE_DATA_AFTER_SYNC, columns=COLUMNS).astype("string"), IDENTITY_COLUMNS, ) courses_from_db_df = prep_from_sync_db_df( read_sql_query("SELECT * from Courses", con).astype("string"), IDENTITY_COLUMNS, ) assert expected_courses_df.to_csv() == courses_from_db_df.to_csv()
def it_should_have_submissions_table_with_updated_row_and_added_new_row( test_db_after_sync, ): EXPECTED_SUBMISSIONS_DATA_AFTER_SYNC = [ UNCHANGED_SUBMISSION, CHANGED_SUBMISSION_AFTER, NEW_SUBMISSION, ] with test_db_after_sync.connect() as con: expected_submissions_df = prep_expected_sync_df( DataFrame(EXPECTED_SUBMISSIONS_DATA_AFTER_SYNC, columns=COLUMNS).astype( "string" ), IDENTITY_COLUMNS, ) submissions_from_db_df = prep_from_sync_db_df( read_sql_query("SELECT * from StudentSubmissions", con).astype("string"), IDENTITY_COLUMNS, ) assert expected_submissions_df.to_csv() == submissions_from_db_df.to_csv()
def it_should_have_temporary_unmatched_table_with_correct_intermediate_rows( test_db_after_sync, ): EXPECTED_UNMATCHED_DATA_AFTER_SYNC = [ CHANGED_ASSIGNMENT_BEFORE, CHANGED_ASSIGNMENT_AFTER, OMITTED_FROM_SYNC_ASSIGNMENT, NEW_ASSIGNMENT, ] with test_db_after_sync.connect() as con: expected_unmatched_df = prep_expected_sync_df( DataFrame(EXPECTED_UNMATCHED_DATA_AFTER_SYNC, columns=COLUMNS).astype("string"), IDENTITY_COLUMNS, ) unmatched_from_db_df = prep_from_sync_db_df( read_sql_query("SELECT * from Unmatched_Assignments", con).astype("string"), IDENTITY_COLUMNS, ) assert expected_unmatched_df.to_csv( ) == unmatched_from_db_df.to_csv()