from queries.process_gsm import combined_gsm_database
from queries.process_lte import process_lte_data
from queries.process_mrbts import process_mrbts_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()
    combined_gsm_database(filepath)  # for gsm,mal,trx
    process_wcdma_data(filepath)
    process_lte_data(filepath),  # for LTE_FDD, LTE_TDD
    process_mrbts_data(filepath)

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