-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathstatic_tables.py
77 lines (69 loc) · 2.93 KB
/
static_tables.py
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
from sheets import sheet_reader
from utils import colors_to_list, make_banner, make_table, write_csv
SHEET_ID = "1fKXpwXhKlLLG-kjh8udQIH9poNLs7kAzSnXndZ1Le4Y"
CSV_DB_PATH = 'csv_db'
# Struct read ranges
ST_RANGES = {
"area": "A1:H428", "chamber": "A1:C410", "role": "A1:F410",
"coalition": "A1:D45", "party": "A1:F79",
"profession": "A1:B119", "contest": "A1:G410"
# "past-membership": "A1:G1",
}
make_banner("Getting static tables data")
# AREA
area_data = sheet_reader(SHEET_ID, f"Table area!{ST_RANGES['area']}")
area_header = area_data[0].keys()
write_csv(make_table(area_header, area_data), f"{CSV_DB_PATH}/area")
for area in area_data:
del area["area_id"]
# CHAMBER
chamber_data = sheet_reader(SHEET_ID, f"Table chamber!{ST_RANGES['chamber']}")
chamber_header = chamber_data[0].keys()
write_csv(make_table(chamber_header, chamber_data), f"{CSV_DB_PATH}/chamber")
for chamber in chamber_data:
del chamber["chamber_id"]
# ROLE
role_data = sheet_reader(SHEET_ID, f"Table role!{ST_RANGES['role']}")
role_header = role_data[0].keys()
write_csv(make_table(role_header, role_data), f"{CSV_DB_PATH}/role")
for role in role_data:
del role["role_id"]
# COALITION
coalition_data = sheet_reader(SHEET_ID,
f"Table coalition!{ST_RANGES['coalition']}")
coalition_header = coalition_data[0].keys()
write_csv(make_table(coalition_header, coalition_data),
f"{CSV_DB_PATH}/coalition")
coalition_data = colors_to_list(coalition_data)
for coalition in coalition_data:
del coalition["coalition_id"]
coalitions_catalogue = sheet_reader(SHEET_ID, "Table coalition!B2:B45",
as_list=True)
# PARTY
party_data = sheet_reader(SHEET_ID, f"Table party!{ST_RANGES['party']}")
party_header = party_data[0].keys()
write_csv(make_table(party_header, party_data), f"{CSV_DB_PATH}/party")
party_data = colors_to_list(party_data)
for party in party_data:
del party["party_id"]
parties = sheet_reader(SHEET_ID, "Table party!C2:C79", as_list=True)
# CONTEST
contest_data = sheet_reader(SHEET_ID, f"Table contest!{ST_RANGES['contest']}")
contest_header = contest_data[0].keys()
write_csv(make_table(contest_header, contest_data), f"{CSV_DB_PATH}/contest")
for contest in contest_data:
del contest["contest_id"]
contest_chambers = sheet_reader(SHEET_ID, "Table contest!C2:C410",
as_list=True)
# PROFESSION
profession_range = f"Catalogue profession!{ST_RANGES['profession']}"
profession_data = sheet_reader(SHEET_ID, profession_range)
profession_header = profession_data[0].keys()
write_csv(make_table(profession_header, profession_data),
f"{CSV_DB_PATH}/profession")
for profession in profession_data:
del profession["profession_id"]
professions_catalogue = sheet_reader(SHEET_ID, "Catalogue profession!B2:B119",
as_list=True)
# URL types Catalogue
url_types = sheet_reader(SHEET_ID, "Catalogue url_types!B2:B23", as_list=True)