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



def add_participant(meeting_id, part_name, data):
    select = cur.execute(
        "SELECT participants FROM meeting WHERE meeting_id = ?;", (meeting_id,)
    )
    participants = select.fetchone()[0]
    print(participants)
    if part_name in participants.split(","):
        print("Participant name already taken!")
    else:
        cur.execute(
            "UPDATE meeting SET participants = ? WHERE meeting_id = ?;",
            (participants + "," + part_name, meeting_id),
        )
        for datum in data:
            if datum[1]:
                select = cur.execute(
                    f"SELECT confirming FROM meeting_dates_{meeting_id} WHERE date = ?;",
                    (datum[0],),
                )
                result = select.fetchone()
                new_confirming = result[0] + "," + part_name
                cur.execute(
                    f"UPDATE meeting_dates_{meeting_id} SET confirming = ? WHERE date = ?;",
                    (
                        new_confirming,
                        datum[0],
                    ),
                )
            else:
                select = cur.execute(
                    f"SELECT declining FROM meeting_dates_{meeting_id} WHERE date = ?;",
                    (datum[0],),
                )
                result = select.fetchone()
                new_declining = result[0] + "," + part_name
                cur.execute(
                    f"UPDATE meeting_dates_{meeting_id} SET declining = ? WHERE date = ?;",
                    (
                        new_declining,
                        datum[0],
                    ),
                )
        con.commit()


meeting_id = "meet1"
part_name = "niklas"
data = [
    ("2026-01-01_12-00", True),
    ("2026-01-01_13-00", False),
    ("2026-01-02_14-00", True),
]
add_participant(meeting_id, part_name, data)

meeting_id = "meet1"
part_name = "philip"
data = [
    ("2026-01-01_12-00", False),
    ("2026-01-01_13-00", True),
    ("2026-01-02_14-00", True),
]
add_participant(meeting_id, part_name, data)