from queries.process_gsm import process_gsm_data
from queries.process_lte import process_lte_data
from queries.process_mal import process_mal_with_bts_name
from queries.process_mrbts import process_mrbts_data
from queries.process_trx import process_trx_with_bts_name
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)
    process_trx_with_bts_name(filepath)
    process_mrbts_data(filepath)
    process_mal_with_bts_name(filepath)

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