/
update_db.py
53 lines (43 loc) · 1.36 KB
/
update_db.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
import gspread
from sqlalchemy.orm import sessionmaker
from models import SacramentMeeting, OtherMeetings, Hymnbook
from utils import get_credentials, db_connect, create_tables
def get_db_session():
engine = db_connect()
create_tables(engine)
Session = sessionmaker(bind=engine)
session = Session()
return session
def main():
session = get_db_session()
credentials = get_credentials()
gc = gspread.authorize(credentials)
workbook = gc.open("Hymn Singing Responses")
wks_sacrament = workbook.worksheet("Sacrament Meeting")
wks_other = workbook.worksheet("Other Meetings")
wks_hymns = workbook.worksheet("Hymns")
# foo = wks_sacrament.get_all_values()
# print(foo[44])
# dates = wks_sacrament.col_values(2)
# print(dates)
hymnal = wks_hymns.get_all_values()
for hymn in hymnal:
if not hymn[0].isdigit():
continue
session.add(Hymnbook(
hymn_number=hymn[0],
hymn_name=hymn[1],
scriptures=hymn[2],
text_author=hymn[3],
music_composer=hymn[4],
tempo_low=hymn[5],
tempo_high=hymn[6],
singing_descriptor=hymn[7],
meter=hymn[8],
tune=hymn[9]
)
)
# print(hymn)
print(len(session.query(Hymnbook).all()))
if __name__ == "__main__":
main()