#!/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 = params["meeting_id"][0]


def extract_meeting(meeting_id):
    # Data from meeting table
    select = cur.execute(f"SELECT * FROM meeting WHERE meeting_id = ?;", (meeting_id,))
    result = select.fetchone()
    if result is None:
        return f"Meeting with id \"{meeting_id}\" does not exist"
    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)