from queries.process_atoll_db import process_data_for_atoll
from queries.process_gsm import combined_gsm_database, gsm_analaysis
from queries.process_invunit import process_invunit_data
from queries.process_lte import lte_fdd_analaysis, lte_tdd_analaysis, process_lte_data
from queries.process_mrbts import process_mrbts_data
from queries.process_nice_db import process_data_for_nice
from queries.process_site_db import site_db
from queries.process_wcdma import process_wcdma_data, wcdma_analaysis
from utils.convert_to_excel import convert_database_dfs, convert_dfs
from utils.utils_vars import UtilsVars


def clear_all_dbs():
    UtilsVars.all_db_dfs.clear()
    UtilsVars.all_db_dfs_names.clear()
    UtilsVars.gsm_dfs.clear()
    UtilsVars.wcdma_dfs.clear()
    UtilsVars.lte_dfs.clear()
    UtilsVars.atoll_dfs.clear()
    UtilsVars.final_atoll_database = None


def all_dbs(filepath: str):
    clear_all_dbs()
    combined_gsm_database(filepath)
    process_wcdma_data(filepath)
    process_lte_data(filepath),
    process_mrbts_data(filepath)
    process_invunit_data(filepath)


def process_all_tech_db(filepath: str):
    all_dbs(filepath)
    site_db()

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


def process_all_tech_db_with_stats(
    filepath: str,
    #    region_list: list
):
    all_dbs(filepath)
    site_db()
    gsm_analaysis(filepath)
    wcdma_analaysis(
        filepath,
        # region_list
    )
    lte_fdd_analaysis(filepath)
    lte_tdd_analaysis(filepath)
    UtilsVars.final_all_database = convert_database_dfs(
        UtilsVars.all_db_dfs,
        [
            "GSM",
            "MAL",
            "TRX",
            "WCDMA",
            "LTE_FDD",
            "LTE_TDD",
            "MRBTS",
            "INVUNIT",
            "SITE",
        ],
    )


def process_atoll_db(filepath: str):
    clear_all_dbs()
    process_data_for_atoll(filepath)


def process_nice_db(filepath: str):
    clear_all_dbs()
    process_data_for_nice(filepath)