From 5aa8e0d2dafadabbe3796f63741868a9b0d17a5c Mon Sep 17 00:00:00 2001 From: Niclas Dobbertin Date: Fri, 10 Jul 2026 11:51:09 +0200 Subject: move into subdirs --- cgi/init_sqlite.py | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 cgi/init_sqlite.py (limited to 'cgi/init_sqlite.py') diff --git a/cgi/init_sqlite.py b/cgi/init_sqlite.py new file mode 100644 index 0000000..acc6153 --- /dev/null +++ b/cgi/init_sqlite.py @@ -0,0 +1,17 @@ +#!/usr/bin/env python3 + +import os +import sqlite3 + +db_path = "terminfinder_db.sqlite" + +if os.path.exists(db_path): + print(f"DB named {db_path} already exists") + exit(1) + +con = sqlite3.connect(db_path) +cur = con.cursor() + +cur.execute( + "CREATE TABLE meeting(meeting_id, title, description, possible_dates, participants, PRIMARY KEY (meeting_id))" +) -- cgit v1.2.3