blob: 92bf534b67e808bc59794ecf701386b8155169dc (
plain)
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
|
#!/usr/bin/env python3
import os
import sqlite3
from urllib.parse import parse_qs
query_string = os.environ.get("QUERY_STRING")
params = parse_qs(query_string)
db_path = "/var/local/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()
meeting_id = params["meeting_id"][0]
def extract_meeting(meeting_id):
# Data from meeting table
select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,))
result = select.fetchone()
if result is None:
return f"Meeting with id \"{meeting_id}\" does not exist"
meeting_data = {"meeting_id": meeting_id, "title": result[1],
"description": result[2],
"dates": result[3].split(",") if not result[3] is None else "",
"participants": result[4].split(",") if not result[4] is None else ""}
# Individual dates data
select = cur.execute(f"SELECT * FROM meeting_dates_{meeting_id};")
result = select.fetchall()
return meeting_data
meeting_data = extract_meeting(meeting_id)
print("Content-Type: text/plain")
print("")
print("This is master")
print(meeting_data)
|
