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