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 --- add_participant.py | 57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 add_participant.py (limited to 'add_participant.py') diff --git a/add_participant.py b/add_participant.py new file mode 100644 index 0000000..da79fab --- /dev/null +++ b/add_participant.py @@ -0,0 +1,57 @@ +#!/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" +part_name = "niklas" +data = [ + ("2026-01-01_12-00", True), + ("2026-01-01_13-00", False), + ("2026-01-02_14-00", True), +] + + +def add_participant(meeting_id, part_name, data): + for datum in data: + if datum[1]: + select = cur.execute( + f"SELECT confirming FROM meeting_dates_{meeting_id} WHERE date = ?;", + (datum[0],), + ) + result = select.fetchone() + new_confirming = result[0] + "," + part_name + cur.execute( + f"UPDATE meeting_dates_{meeting_id} SET confirming = ? WHERE date = ?;", + ( + new_confirming, + datum[0], + ), + ) + else: + select = cur.execute( + f"SELECT declining FROM meeting_dates_{meeting_id} WHERE date = ?;", + (datum[0],), + ) + result = select.fetchone() + new_declining = result[0] + "," + part_name + cur.execute( + f"UPDATE meeting_dates_{meeting_id} SET declining = ? WHERE date = ?;", + ( + new_declining, + datum[0], + ), + ) + con.commit() + + +add_participant(meeting_id, part_name, data) -- cgit v1.2.3