File size: 2,241 Bytes
9cd5e21
fbf7879
a9f4212
fbf7879
bb3e08f
9a4ad92
424caf8
fbf7879
1b27434
57fe85f
 
 
50b11f5
57fe85f
ccb28f5
 
 
 
50b11f5
 
 
 
 
 
fbf7879
57fe85f
fbf7879
bb3e08f
a9f4212
57fe85f
fbf7879
 
 
424caf8
fbf7879
1b27434
fbf7879
424caf8
 
 
 
 
 
 
 
 
 
 
fbf7879
 
 
ccb28f5
 
 
 
fbf7879
424caf8
fbf7879
ccb28f5
 
 
 
fbf7879
 
1b27434
bb3e08f
424caf8
 
 
 
 
 
 
 
 
 
 
57fe85f
50b11f5
 
 
 
9cd5e21
9a4ad92
 
 
 
 
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
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)