diff options
| author | T-Aji <tolujbd2@gmail.com> | 2024-08-22 10:48:54 +0100 |
|---|---|---|
| committer | T-Aji <tolujbd2@gmail.com> | 2024-08-22 10:48:54 +0100 |
| commit | 548b8678e4d5f725e086f0e4eb115c9aa11b55be (patch) | |
| tree | 77f601383429851e2e3da490bb2d42420509be05 /tests/test_fact_sales_order.py | |
| parent | c5338ebb198a79604e36d65de39e28baf54f0ecd (diff) | |
| download | de-project-bentley-548b8678e4d5f725e086f0e4eb115c9aa11b55be.tar.gz de-project-bentley-548b8678e4d5f725e086f0e4eb115c9aa11b55be.zip | |
passing tests create_dim_design and create_dim_staff
Diffstat (limited to 'tests/test_fact_sales_order.py')
| -rw-r--r-- | tests/test_fact_sales_order.py | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/tests/test_fact_sales_order.py b/tests/test_fact_sales_order.py new file mode 100644 index 0000000..13196d5 --- /dev/null +++ b/tests/test_fact_sales_order.py @@ -0,0 +1,40 @@ +from src.fact_sales_order import create_dim_design, create_dim_staff +import pandas as pd + +class TestCreateDimDesign: + def test_dim_design_returns_dataframe(self): + d = {"test": ["Hello", "Bye"], "design_id": ["Hello", "Bye"], "design_name": ["Hello", "Bye"], + "file_name": ["Hello", "Bye"], "file_location": ["Hello", "Bye"], "Hello": ["Hello", "Bye"]} + test_df = {"design": pd.DataFrame(data=d)} + result = create_dim_design(test_df) + assert isinstance(result, pd.DataFrame) + + def test_dim_design_returns_correct_columns_and_values(self): + d = {"test": ["Hello", "Bye"], "design_id": ["Hello", "Bye"], "design_name": ["Hello", "Bye"], + "file_name": ["Hello", "Bye"], "file_location": ["Hello", "Bye"], "Hello": ["Hello", "Bye"]} + test_df = {"design": pd.DataFrame(data=d)} + result = create_dim_design(test_df) + d2 = {"design_id": ["Hello", "Bye"], "design_name": ["Hello", "Bye"], "file_name": ["Hello", "Bye"], + "file_location": ["Hello", "Bye"]} + expected_df = pd.DataFrame(data=d2) + expected_result = expected_df.copy() + assert result.equals(expected_result) + +class TestCreateDimStaff: + def test_dim_staff_returns_dataframe(self): + d = {"staff_id": ["Hello", "Bye"], "first_name": ["Hello", "Bye"], "last_name": ["Hello", "Bye"], "department_id": ["Hello", "Bye"]} + d2 = {"department_name": ["Hello", "Bye"], "location": ["Hello", "Bye"], "email_address": ["Hello", "Bye"], "department_id": ["Hello", "Bye"]} + test_df = {"staff": pd.DataFrame(data=d), "department": pd.DataFrame(data=d2)} + result = create_dim_staff(test_df) + assert isinstance(result, pd.DataFrame) + + def test_dim_staff_returns_correct_columns_and_values(self): + d = {"staff_id": ["Hello", "Bye"], "first_name": ["Hello", "Bye"], "last_name": ["Hello", "Bye"], "department_id": ["Hello", "Bye"]} + d2 = {"department_name": ["Hello", "Bye"], "location": ["Hello", "Bye"], "email_address": ["Hello", "Bye"], "department_id": ["Hello", "Bye"]} + test_df = {"staff": pd.DataFrame(data=d), "department": pd.DataFrame(data=d2)} + result = create_dim_staff(test_df) + expected_d = {"staff_id": ["Hello", "Bye"], "first_name": ["Hello", "Bye"], "last_name": ["Hello", "Bye"], "department_name": ["Hello", "Bye"], "location": ["Hello", "Bye"], "email_address": ["Hello", "Bye"]} + expected_df = pd.DataFrame(data=expected_d) + expected_result = expected_df.copy() + assert result.equals(expected_result) +
\ No newline at end of file |
