diff options
Diffstat (limited to 'create_meeting.py')
| -rw-r--r-- | create_meeting.py | 56 |
1 files changed, 0 insertions, 56 deletions
diff --git a/create_meeting.py b/create_meeting.py deleted file mode 100644 index d07172c..0000000 --- a/create_meeting.py +++ /dev/null @@ -1,56 +0,0 @@ -#!/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() - - -def create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates): - 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"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, 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) |