import db

from .ensure_ia_chat_schema import ensure_ia_chat_schema


def create_ia_conversation(slug: str, screen_id: int) -> int:
    """ "+ Nouvelle conversation" (voir static/game/js/ia/ia-chat.js) : créée
    IMMÉDIATEMENT, vide — visible tout de suite dans la colonne, pas
    besoin d'attendre un premier message."""
    ensure_ia_chat_schema(slug)
    conn = db.connect(slug)
    conn.execute("INSERT INTO _ia_conversations (screen_id) VALUES (?)", (screen_id,))
    conversation_id = int(conn.execute("SELECT last_insert_rowid() AS id").fetchone()["id"])
    conn.commit()
    conn.close()
    return conversation_id