From 5aa8e0d2dafadabbe3796f63741868a9b0d17a5c Mon Sep 17 00:00:00 2001 From: Niclas Dobbertin Date: Fri, 10 Jul 2026 11:51:09 +0200 Subject: move into subdirs --- view_meeting.py | 37 ------------------------------------- 1 file changed, 37 deletions(-) delete mode 100644 view_meeting.py (limited to 'view_meeting.py') 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) -- cgit v1.2.3