def test_template_reader(mock_config, org_test_files_dir): mock_config.initialise() for fl in os.listdir(org_test_files_dir): shutil.copy( Path.cwd() / "tests" / "resources" / "org_templates" / fl, (Path(mock_config.PLATFORM_DOCS_DIR) / "input"), ) tmpl_file = Path(mock_config.PLATFORM_DOCS_DIR) / "input" / "dft1_tmp.xlsm" data = template_reader(tmpl_file) assert data["dft1_tmp.xlsm"]["data"]["10 - Benefits"]["X34"]["value"] == 1 assert (data["dft1_tmp.xlsm"]["data"]["10 - Benefits"]["X34"]["data_type"] == "NUMBER")
def test_template_reader(template) -> None: data = template_reader(template) assert _get_cell_data(template, data, "Summary", "B2")["data_type"] == "DATE" assert _get_cell_data(template, data, "Summary", "B3")["data_type"] == "TEXT" assert _get_cell_data(template, data, "Summary", "B4")["data_type"] == "NUMBER" assert _get_cell_data(template, data, "Summary", "B5")["data_type"] == "NUMBER" assert (_get_cell_data(template, data, "Summary", "B2")["value"] == "2019-10-20T00:00:00") assert (_get_cell_data(template, data, "Summary", "B3")["value"] == "This is a string") assert _get_cell_data(template, data, "Summary", "B4")["value"] == 2.2 assert _get_cell_data(template, data, "Summary", "B4")["value"] == 2.20 assert _get_cell_data(template, data, "Summary", "B4")["value"] != 2.21 assert _get_cell_data(template, data, "Summary", "B5")["value"] == 10 assert _get_cell_data(template, data, "Another Sheet", "K25")["value"] == "Float:" assert _get_cell_data(template, data, "Another Sheet", "K25")["data_type"] == "TEXT"
def test_template_reader(template): dataset = template_reader(template) assert (dataset["test_template.xlsx"]["data"]["Summary"]["B3"]["value"] == "This is a string")