1 files changed, 35 insertions, 23 deletions
diff --git a/create_meeting.py b/create_meeting.py
index 396e19c..d07172c 100644
--- a/create_meeting.py
+++ b/create_meeting.py
@@ -12,33 +12,45 @@ if not os.path.exists(db_path):
 con = sqlite3.connect(db_path)
 cur = con.cursor()
 
-meeting_id = "meet1"
-meeting_name = "My first meeting"
-meeting_description = "This is a test meeting description"
-meeting_dates = "2026-01-01_12-00,2026-01-01_13-00,2026-01-02_14-00"
-
 
 def create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates):
-    cur.execute(
-        "INSERT INTO meeting (meeting_id, title, description, possible_dates, participants) VALUES (?, ?, ?, ?, ?);",
-        (
-            meeting_id,
-            meeting_name,
-            meeting_description,
-            meeting_dates,
-            None,
-        ),
-    )
-    cur.execute(
-        f"CREATE TABLE meeting_dates_{meeting_id}(date, confirming, declining, meeting_id, PRIMARY KEY (date) FOREIGN KEY (meeting_id) REFERENCES meeting(meeting_id))"
-    )
-
-    for date in meeting_dates.split(","):
+    select = cur.execute(
+        "SELECT meeting_id FROM meeting;")
+    meeting_ids = select.fetchall()
+    print(meeting_ids)
+    if meeting_id in (x[0] for x in meeting_ids):
+        print("meeting_id is already taken!")
+    else:
+        cur.execute(
+            "INSERT INTO meeting (meeting_id, title, description, possible_dates, participants) VALUES (?, ?, ?, ?, ?);",
+            (
+                meeting_id,
+                meeting_name,
+                meeting_description,
+                meeting_dates,
+                None,
+            ),
+        )
         cur.execute(
-            f"INSERT INTO meeting_dates_{meeting_id} (date, confirming, declining, meeting_id) VALUES (?, ?, ?, ?);",
-            (date, None, None, meeting_id),
+            f"CREATE TABLE meeting_dates_{meeting_id}(date, confirming, declining, meeting_id, PRIMARY KEY (date) FOREIGN KEY (meeting_id) REFERENCES meeting(meeting_id))"
         )
-    con.commit()
+
+        for date in meeting_dates.split(","):
+            cur.execute(
+                f"INSERT INTO meeting_dates_{meeting_id} (date, confirming, declining, meeting_id) VALUES (?, ?, ?, ?);",
+                (date, None, None, meeting_id),
+            )
+        con.commit()
 
 
+meeting_id = "meet1"
+meeting_name = "My first meeting"
+meeting_description = "This is a test meeting description"
+meeting_dates = "2026-01-01_12-00,2026-01-01_13-00,2026-01-02_14-00"
+create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)
+
+meeting_id = "meet2"
+meeting_name = "My second meeting"
+meeting_description = "This is a test meeting description"
+meeting_dates = "2026-01-01_12-00,2026-01-01_13-00,2026-01-02_14-00"
 create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)