from __future__ import annotations

import pytest

from opensquilla.session.models import AgentTaskRecord, AgentTaskStatus, SessionNode, SessionStatus
from opensquilla.session.storage import SessionStorage


@pytest.mark.asyncio
async def test_agent_task_ledger_marks_active_tasks_abandoned_after_restart(tmp_path) -> None:
    db_path = tmp_path / "sessions.db"
    key = "agent:main:webchat:restart-ledger"

    storage = SessionStorage(str(db_path))
    await storage.connect()
    try:
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="queued-task",
                session_key=key,
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.QUEUED,
                created_at=100,
                updated_at=100,
            )
        )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="running-task",
                session_key=key,
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.RUNNING,
                created_at=110,
                updated_at=120,
                started_at=120,
            )
        )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="done-task",
                session_key=key,
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.SUCCEEDED,
                created_at=130,
                updated_at=140,
                started_at=135,
                finished_at=140,
            )
        )
    finally:
        await storage.close()

    restarted = SessionStorage(str(db_path))
    await restarted.connect()
    try:
        rows = await restarted.list_agent_tasks(session_key=key)
    finally:
        await restarted.close()

    by_id = {row.task_id: row for row in rows}
    assert by_id["queued-task"].status == AgentTaskStatus.ABANDONED
    assert by_id["queued-task"].terminal_reason == "process_restart"
    assert by_id["queued-task"].finished_at is not None
    assert by_id["running-task"].status == AgentTaskStatus.ABANDONED
    assert by_id["running-task"].terminal_reason == "process_restart"
    assert by_id["running-task"].finished_at is not None
    assert by_id["done-task"].status == AgentTaskStatus.SUCCEEDED
    assert by_id["done-task"].terminal_reason is None


@pytest.mark.asyncio
async def test_list_agent_tasks_for_sessions_groups_visible_session_tasks(tmp_path) -> None:
    storage = SessionStorage(str(tmp_path / "sessions.db"))
    await storage.connect()
    try:
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="one-old",
                session_key="agent:main:webchat:one",
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.SUCCEEDED,
                created_at=100,
                updated_at=100,
            )
        )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="one-new",
                session_key="agent:main:webchat:one",
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.RUNNING,
                created_at=200,
                updated_at=200,
            )
        )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="two-task",
                session_key="agent:main:webchat:two",
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.QUEUED,
                created_at=150,
                updated_at=150,
            )
        )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="hidden-task",
                session_key="agent:main:webchat:hidden",
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.QUEUED,
                created_at=50,
                updated_at=50,
            )
        )

        grouped = await storage.list_agent_tasks_for_sessions(
            ["agent:main:webchat:one", "agent:main:webchat:two"],
            limit_per_session=1,
        )
    finally:
        await storage.close()

    assert set(grouped) == {"agent:main:webchat:one", "agent:main:webchat:two"}
    assert [row.task_id for row in grouped["agent:main:webchat:one"]] == ["one-new"]
    assert [row.task_id for row in grouped["agent:main:webchat:two"]] == ["two-task"]


@pytest.mark.asyncio
async def test_list_sessions_keeps_active_task_session_before_limit(tmp_path) -> None:
    storage = SessionStorage(str(tmp_path / "sessions.db"))
    await storage.connect()
    old_key = "agent:main:webchat:old-running"
    try:
        await storage.upsert_session(
            SessionNode(
                session_key=old_key,
                session_id="old-session",
                agent_id="main",
                created_at=1,
                updated_at=1,
                started_at=1,
                status=SessionStatus.RUNNING,
            )
        )
        for index in range(200):
            await storage.upsert_session(
                SessionNode(
                    session_key=f"agent:main:webchat:new-{index:03d}",
                    session_id=f"new-session-{index:03d}",
                    agent_id="main",
                    created_at=1000 + index,
                    updated_at=1000 + index,
                    started_at=1000 + index,
                    ended_at=2000 + index,
                    status=SessionStatus.DONE,
                )
            )
        await storage.create_agent_task(
            AgentTaskRecord(
                task_id="task-running",
                session_key=old_key,
                source_kind="webui",
                queue_mode="followup",
                run_kind="web_turn",
                status=AgentTaskStatus.RUNNING,
                created_at=9999,
                updated_at=9999,
                started_at=9999,
            )
        )

        rows = await storage.list_sessions(limit=200)
    finally:
        await storage.close()

    keys = [row.session_key for row in rows]
    assert old_key in keys
    assert keys[0] == old_key