diff options
Diffstat (limited to 'view_meeting.py')
| -rw-r--r-- | view_meeting.py | 37 |
1 files changed, 0 insertions, 37 deletions
diff --git a/view_meeting.py b/view_meeting.py deleted file mode 100644 index 5ec8dd0..0000000 --- a/view_meeting.py +++ /dev/null @@ -1,37 +0,0 @@ -#!/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): - # Data from meeting table - select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,)) - result = select.fetchone() - 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() - print(result) - - return meeting_data - - -meeting_data = extract_meeting(meeting_id) -print(meeting_data) |
