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()
