from queries.process_gsm import process_gsm_data
from queries.process_lte import process_lte_data
from queries.process_wcdma import process_wcdma_data
from utils.convert_to_excel import convert_dfs
from utils.utils_vars import UtilsVars


def process_all_tech_db(filepath: str):
    UtilsVars.all_db_dfs.clear()
    process_gsm_data(filepath)
    process_wcdma_data(filepath)
    process_lte_data(filepath)

    UtilsVars.final_all_database = convert_dfs(
        UtilsVars.all_db_dfs, ["GSM", "WCDMA", "LTE_FDD", "LTE_TDD"]
    )