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
|
#!/usr/bin/env python3
import os
import sqlite3
db_path = "terminfinder_db.sqlite"
if not os.path.exists(db_path):
print(f"DB named {db_path} does not exist!")
exit(1)
con = sqlite3.connect(db_path)
cur = con.cursor()
def create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates):
select = cur.execute(
"SELECT meeting_id FROM meeting;")
meeting_ids = select.fetchall()
print(meeting_ids)
if meeting_id in (x[0] for x in meeting_ids):
print("meeting_id is already taken!")
else:
cur.execute(
"INSERT INTO meeting (meeting_id, title, description, possible_dates, participants) VALUES (?, ?, ?, ?, ?);",
(
meeting_id,
meeting_name,
meeting_description,
meeting_dates,
None,
),
)
cur.execute(
f"CREATE TABLE meeting_dates_{meeting_id}(date, confirming, declining, meeting_id, PRIMARY KEY (date) FOREIGN KEY (meeting_id) REFERENCES meeting(meeting_id))"
)
for date in meeting_dates.split(","):
cur.execute(
f"INSERT INTO meeting_dates_{meeting_id} (date, confirming, declining, meeting_id) VALUES (?, ?, ?, ?);",
(date, None, None, meeting_id),
)
con.commit()
meeting_id = "meet1"
meeting_name = "My first meeting"
meeting_description = "This is a test meeting description"
meeting_dates = "2026-01-01_12-00,2026-01-01_13-00,2026-01-02_14-00"
create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)
meeting_id = "meet2"
meeting_name = "My second meeting"
meeting_description = "This is a test meeting description"
meeting_dates = "2026-01-01_12-00,2026-01-01_13-00,2026-01-02_14-00"
create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)
|
