"""Environment diagnostics (``manage.py snapfile_doctor``, ``/admin/v1/system``, ``/health/details``)."""

from __future__ import annotations

import importlib
import shutil
import sys
from typing import Any

import django
from django.conf import settings
from django.db import connection
from django.utils import timezone

from snapfile_render import ENGINE_VERSION


def _version(module: str) -> str | None:
    try:
        mod = importlib.import_module(module)
    except Exception:
        return None
    return str(getattr(mod, "__version__", getattr(mod, "VERSION", "?")))


def diagnostics() -> dict[str, Any]:
    from snapfile.core.models import SchedulerRun, WorkerHeartbeat
    from snapfile.jobs.models import RenderJob

    try:
        import reportlab.lib.rl_accel  # noqa: F401

        rl_accel = True
    except Exception:
        rl_accel = False
    try:
        import pypdfium2

        pdfium = str(pypdfium2.PDFIUM_INFO) if hasattr(pypdfium2, "PDFIUM_INFO") else _version("pypdfium2")
    except Exception:
        pdfium = None
    with connection.cursor() as cur:
        if connection.vendor == "postgresql":
            cur.execute("SELECT version()")
        else:
            cur.execute("SELECT VERSION()")
        db_version = cur.fetchone()[0]
    now = timezone.now()
    queue = {}
    for q in ("render-high", "render"):
        qs = RenderJob.objects.filter(status="queued", queue=q)
        oldest = qs.order_by("available_at").values_list("available_at", flat=True).first()
        queue[q] = {"depth": qs.count(), "oldest_seconds": int((now - oldest).total_seconds()) if oldest else 0}
    var = settings.SNAPFILE_VAR_DIR
    var.mkdir(parents=True, exist_ok=True)
    disk = shutil.disk_usage(var)
    return {
        "app": {"engine_version": ENGINE_VERSION, "python": sys.version.split()[0], "django": django.get_version()},
        "libraries": {
            "reportlab": _version("reportlab"),
            "rl_accel": rl_accel,
            "pypdfium2": _version("pypdfium2"),
            "pdfium": pdfium,
            "Pillow": _version("PIL"),
            "fontTools": _version("fontTools"),
            "ninja": _version("ninja"),
            "jsonschema": _version("jsonschema"),
        },
        "database": {
            "vendor": connection.vendor,
            "version": db_version,
            "skip_locked": bool(connection.features.has_select_for_update_skip_locked),
        },
        "queue": {"mode": settings.SNAPFILE_QUEUE_MODE, "queues": queue},
        "scheduler": [
            {
                "task": r.task,
                "last_finished_at": r.last_finished_at.isoformat() if r.last_finished_at else None,
                "status": r.last_status,
            }
            for r in SchedulerRun.objects.all()
        ],
        "workers": [
            {"owner": w.owner, "mode": w.mode, "last_seen_at": w.last_seen_at.isoformat(), "jobs_done": w.jobs_done}
            for w in WorkerHeartbeat.objects.order_by("-last_seen_at")[:20]
        ],
        "storage": {"var_dir": str(var), "free_mb": disk.free // (1024 * 1024)},
        "frontend": {"dist": str(settings.FRONTEND_DIST), "present": (settings.FRONTEND_DIST / "index.html").exists()},
    }
