diff options
| author | Niclas Dobbertin <niclas.dobbertin@mailbox.org> | 2026-07-10 11:51:09 +0200 |
|---|---|---|
| committer | Niclas Dobbertin <niclas.dobbertin@mailbox.org> | 2026-07-10 11:51:09 +0200 |
| commit | 5aa8e0d2dafadabbe3796f63741868a9b0d17a5c (patch) | |
| tree | 8f3177d3c2e8dbebd3b1ad04aa7b8fa6ff060c5c /view_meeting.py | |
| parent | c6c842b93c616a690546c6dd0a029f578ecf5769 (diff) | |
move into subdirs
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) |
