blob: 00f6ae4067253a90546580739043ee3723a00167 (
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
|
#!/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()
meeting_id = "meet1"
def extract_meeting(meeting_id):
select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,))
result = select.fetchall()
print(result)
select = cur.execute(f"SELECT * FROM meeting_dates_{meeting_id};")
result = select.fetchall()
print(result)
extract_meeting(meeting_id)
|
