diff options
| author | Niclas Dobbertin <niclas.dobbertin@mailbox.org> | 2026-07-10 11:51:09 +0200 |
|---|---|---|
| committer | Niclas Dobbertin <niclas.dobbertin@mailbox.org> | 2026-07-10 11:51:09 +0200 |
| commit | 5aa8e0d2dafadabbe3796f63741868a9b0d17a5c (patch) | |
| tree | 8f3177d3c2e8dbebd3b1ad04aa7b8fa6ff060c5c /create_meeting.py | |
| parent | c6c842b93c616a690546c6dd0a029f578ecf5769 (diff) | |
move into subdirs
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) |
