init basic sqlite functions

1 files changed, 43 insertions, 0 deletions

diff --git a/create_meeting.py b/create_meeting.py
new file mode 100644
index 0000000..489067d
--- /dev/null
+++ b/create_meeting.py
@@ -0,0 +1,43 @@
+#!/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"
+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) VALUES (?, ?, ?, ?);",
+        (
+            meeting_id,
+            meeting_name,
+            meeting_description,
+            meeting_dates,
+        ),
+    )
+    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(","):
+        cur.execute(
+            f"INSERT INTO meeting_dates_{meeting_id} (date, confirming, declining, meeting_id) VALUES (?, ?, ?, ?);",
+            (date, "", "", meeting_id),
+        )
+    con.commit()
+
+
+create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)