init basic sqlite functions

1 files changed, 57 insertions, 0 deletions

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)