#!/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()

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"


def create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates):
    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()


create_meeting(meeting_id, meeting_name, meeting_description, meeting_dates)