add tracking participants and prevent duplicates

1 files changed, 55 insertions, 34 deletions

diff --git a/add_participant.py b/add_participant.py
index da79fab..948b4c6 100644
--- a/add_participant.py
+++ b/add_participant.py
@@ -12,6 +12,53 @@ if not os.path.exists(db_path):
 con = sqlite3.connect(db_path)
 cur = con.cursor()
 
+
+
+def add_participant(meeting_id, part_name, data):
+    select = cur.execute(
+        "SELECT participants FROM meeting WHERE meeting_id = ?;", (meeting_id,)
+    )
+    participants = select.fetchone()[0]
+    print(participants)
+    if part_name in participants.split(","):
+        print("Participant name already taken!")
+    else:
+        cur.execute(
+            "UPDATE meeting SET participants = ? WHERE meeting_id = ?;",
+            (participants + "," + part_name, meeting_id),
+        )
+        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()
+
+
 meeting_id = "meet1"
 part_name = "niklas"
 data = [
@@ -19,39 +66,13 @@ data = [
     ("2026-01-01_13-00", False),
     ("2026-01-02_14-00", True),
 ]
+add_participant(meeting_id, part_name, data)
 
-
-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()
-
-
+meeting_id = "meet1"
+part_name = "philip"
+data = [
+    ("2026-01-01_12-00", False),
+    ("2026-01-01_13-00", True),
+    ("2026-01-02_14-00", True),
+]
 add_participant(meeting_id, part_name, data)