From dec672b22381b5f9fd3d51f8233cc69f12964fd2 Mon Sep 17 00:00:00 2001 From: Niclas Dobbertin Date: Thu, 9 Jul 2026 23:31:45 +0200 Subject: add tracking participants and prevent duplicates --- view_meeting.py | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) (limited to 'view_meeting.py') diff --git a/view_meeting.py b/view_meeting.py index 00f6ae4..5ec8dd0 100644 --- a/view_meeting.py +++ b/view_meeting.py @@ -17,12 +17,21 @@ 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.fetchall() - print(result) + 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 + -extract_meeting(meeting_id) +meeting_data = extract_meeting(meeting_id) +print(meeting_data) -- cgit v1.2.3