-
Notifications
You must be signed in to change notification settings - Fork 0
/
teamleaders.py
36 lines (27 loc) · 1.07 KB
/
teamleaders.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
from google_sheet_client import client
from expiringdict import ExpiringDict
cache = ExpiringDict(max_len=100, max_age_seconds=5 * 60)
DEFAULT_TEAMLEADER = ["Михаил Кирьянов", "m.kiryanov@kodland.team"]
def get_team_leaders():
if cache.get("teachers"):
return cache["teachers"]
spreadsheet_id = '1UqmI_st-d6ukUSB0TqeM5TDNQkOlAYSQ7aOaFZXrxiY'
worksheet = 'Тлы'
sheet = client.open_by_key(spreadsheet_id).worksheet(worksheet)
teachers = sheet.get_all_records()
teamleaders = [
# Миша выставлен дефолтным
DEFAULT_TEAMLEADER,
]
print(teachers)
for t in teachers:
if t.get("ID") and t.get("Корп. почта"):
teamleaders.append([t["ID"], t["Корп. почта"]])
cache["teachers"] = teamleaders
return cache["teachers"]
def get_team_leaders_dict():
if cache.get("teachers_dict"):
return cache["teachers_dict"]
teamleaders = get_team_leaders()
cache["teachers_dict"] = {x[0]: x[1] for x in teamleaders}
return cache["teachers_dict"]