File size: 1,896 Bytes
ccb28f5 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
import os
import pandas as pd
import pytest
from queries.process_all_db import (
all_dbs,
process_all_tech_db,
process_all_tech_db_with_stats,
)
from utils.utils_vars import UtilsVars
class TestProcessAllDB:
def setup_method(self):
UtilsVars.all_db_dfs = []
UtilsVars.final_all_database = None
def test_all_dbs(self):
filepath = r"C:\Users\David\Documents\PROJECTS\2023\PROJET 2023\DUMP\DUMP\NOVEMBRE\20241127_21145_27112024_Dump.xml.gz.xlsb"
all_dbs(filepath)
assert len(UtilsVars.all_db_dfs) == 7
assert isinstance(UtilsVars.all_db_dfs[0], pd.DataFrame)
def test_process_all_tech_db(self):
filepath = r"C:\Users\David\Documents\PROJECTS\2023\PROJET 2023\DUMP\DUMP\NOVEMBRE\20241127_21145_27112024_Dump.xml.gz.xlsb"
process_all_tech_db(filepath)
assert UtilsVars.final_all_database is not None
def test_process_all_tech_db_with_stats(self):
filepath = r"C:\Users\David\Documents\PROJECTS\2023\PROJET 2023\DUMP\DUMP\NOVEMBRE\20241127_21145_27112024_Dump.xml.gz.xlsb"
process_all_tech_db_with_stats(filepath)
assert UtilsVars.final_all_database is not None
# def test_all_dbs_empty_file(self):
# filepath = r"C:\Users\HP\Desktop\LTE\PROJET 2023\DUMP\2024\SEPTEMBRE\empty.xlsb"
# all_dbs(filepath)
# assert len(UtilsVars.all_db_dfs) == 0
# def test_process_all_tech_db_empty_file(self):
# filepath = r"C:\Users\HP\Desktop\LTE\PROJET 2023\DUMP\2024\SEPTEMBRE\empty.xlsb"
# process_all_tech_db(filepath)
# assert UtilsVars.final_all_database is None
# def test_process_all_tech_db_with_stats_empty_file(self):
# filepath = r"C:\Users\HP\Desktop\LTE\PROJET 2023\DUMP\2024\SEPTEMBRE\empty.xlsb"
# process_all_tech_db_with_stats(filepath)
# assert UtilsVars.final_all_database is None
|