From 67252d3e64d871c6dab21e4697d3d26f55bbc519 Mon Sep 17 00:00:00 2001 From: Niclas Dobbertin Date: Thu, 9 Jul 2026 23:06:00 +0200 Subject: init basic sqlite functions --- init_sqlite.py | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 init_sqlite.py (limited to 'init_sqlite.py') diff --git a/init_sqlite.py b/init_sqlite.py new file mode 100644 index 0000000..acc6153 --- /dev/null +++ b/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