From 67252d3e64d871c6dab21e4697d3d26f55bbc519 Mon Sep 17 00:00:00 2001 From: Niclas Dobbertin Date: Thu, 9 Jul 2026 23:06:00 +0200 Subject: init basic sqlite functions --- view_meeting.py | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 view_meeting.py (limited to 'view_meeting.py') diff --git a/view_meeting.py b/view_meeting.py new file mode 100644 index 0000000..00f6ae4 --- /dev/null +++ b/view_meeting.py @@ -0,0 +1,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) -- cgit v1.2.3