move into subdirs

1 files changed, 45 insertions, 0 deletions

diff --git a/cgi/view_meeting.py b/cgi/view_meeting.py
new file mode 100644
index 0000000..69ae1e3
--- /dev/null
+++ b/cgi/view_meeting.py
@@ -0,0 +1,45 @@
+#!/usr/bin/env python3
+
+
+import os
+import sqlite3
+from urllib.parse import parse_qs
+
+query_string = os.environ.get("QUERY_STRING")
+params = parse_qs(query_string)
+
+
+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"
+
+
+def extract_meeting(meeting_id):
+    # Data from meeting table
+    select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,))
+    result = select.fetchone()
+    meeting_data = {"meeting_id": meeting_id, "title": result[1],
+                    "description": result[2],
+                    "dates": result[3].split(",") if not result[3] is None else "",
+                    "participants": result[4].split(",") if not result[4] is None else ""}
+
+    # Individual dates data
+    select = cur.execute(f"SELECT * FROM meeting_dates_{meeting_id};")
+    result = select.fetchall()
+
+    return meeting_data
+
+
+meeting_data = extract_meeting(meeting_id)
+
+print("Content-Type: text/plain")
+print("")
+print()
+print(meeting_data)