"""Render jobs (journal + queue), result files, webhook deliveries (TZ 2.2.9-2.2.10, 2.2.13)."""

from __future__ import annotations

from django.db import models
from django.utils import timezone

from snapfile.core.fields import UUIDv7Field
from snapfile.doctemplates.models import Template, TemplateVersion
from snapfile.integration.models import ApiKey
from snapfile.projects.models import Project

JOB_STATUSES = ("queued", "running", "succeeded", "failed", "canceled", "expired")


class QueueFields(models.Model):
    """Fields shared by every DB-backed queue table (TZ 2.1.6.1)."""

    queue = models.CharField(max_length=16)
    status = models.CharField(max_length=16, default="queued")
    priority = models.PositiveSmallIntegerField(default=5)
    available_at = models.DateTimeField(default=timezone.now)
    attempts = models.PositiveSmallIntegerField(default=0)
    max_attempts = models.PositiveSmallIntegerField(default=3)
    lease_owner = models.CharField(max_length=96, null=True, blank=True)
    lease_until = models.DateTimeField(null=True, blank=True)
    heartbeat_at = models.DateTimeField(null=True, blank=True)
    error_code = models.CharField(max_length=64, null=True, blank=True)
    error_message = models.TextField(null=True, blank=True)

    class Meta:
        abstract = True


class RenderJob(QueueFields):
    id = UUIDv7Field(primary_key=True)
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name="render_jobs")
    template = models.ForeignKey(Template, on_delete=models.CASCADE, related_name="render_jobs")
    template_version = models.ForeignKey(TemplateVersion, null=True, blank=True, on_delete=models.SET_NULL)
    api_key = models.ForeignKey(ApiKey, null=True, blank=True, on_delete=models.SET_NULL)
    initiator = models.JSONField(null=True, blank=True)
    kind = models.CharField(max_length=16, default="render")
    mode = models.CharField(max_length=8, default="async")
    cancel_requested = models.BooleanField(default=False)
    output = models.JSONField(default=dict)
    payload_ref = models.CharField(max_length=512, null=True, blank=True)
    payload = models.JSONField(null=True, blank=True)
    payload_hash = models.CharField(max_length=64)
    idempotency_key_hash = models.CharField(max_length=64, null=True, blank=True)
    request_fingerprint = models.CharField(max_length=64, null=True, blank=True)
    external_ref = models.CharField(max_length=255, null=True, blank=True)
    webhook_url = models.CharField(max_length=512, null=True, blank=True)
    cost_estimate = models.IntegerField(default=1)
    pages = models.IntegerField(null=True, blank=True)
    attempt_log = models.JSONField(null=True, blank=True)
    warnings = models.JSONField(null=True, blank=True)
    timings = models.JSONField(null=True, blank=True)
    engine_version = models.CharField(max_length=16)
    queued_at = models.DateTimeField(null=True, blank=True)
    started_at = models.DateTimeField(null=True, blank=True)
    finished_at = models.DateTimeField(null=True, blank=True)
    expires_at = models.DateTimeField(null=True, blank=True, db_index=True)
    created_at = models.DateTimeField(default=timezone.now)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "render_jobs"
        indexes = [
            models.Index(fields=["status", "queue", "priority", "available_at"], name="jobs_claim"),
            models.Index(fields=["status", "lease_until"], name="jobs_reaper"),
            models.Index(fields=["project", "id"], name="jobs_project_id"),
            models.Index(fields=["project", "external_ref"], name="jobs_external_ref"),
        ]
        constraints = [
            models.UniqueConstraint(fields=["project", "idempotency_key_hash"], name="jobs_idempotency"),
        ]


class RenderFile(models.Model):
    id = UUIDv7Field(primary_key=True)
    render_job = models.ForeignKey(RenderJob, on_delete=models.CASCADE, related_name="files")
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name="+")
    kind = models.CharField(max_length=8)
    sheet_index = models.IntegerField(null=True, blank=True)
    filename = models.CharField(max_length=255)
    path = models.CharField(max_length=512)
    disk = models.CharField(max_length=32, default="local")
    mime = models.CharField(max_length=64)
    size_bytes = models.BigIntegerField()
    sha256 = models.CharField(max_length=64)
    width_px = models.IntegerField(null=True, blank=True)
    height_px = models.IntegerField(null=True, blank=True)
    download_count = models.IntegerField(default=0)
    expires_at = models.DateTimeField(db_index=True)
    deleted_at = models.DateTimeField(null=True, blank=True)
    created_at = models.DateTimeField(default=timezone.now)

    class Meta:
        db_table = "render_files"
        ordering = ["sheet_index", "id"]


class WebhookDelivery(QueueFields):
    id = UUIDv7Field(primary_key=True)
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name="webhook_deliveries")
    event = models.CharField(max_length=64)
    event_id = models.CharField(max_length=64)
    url = models.CharField(max_length=512)
    payload = models.JSONField()
    response_code = models.PositiveSmallIntegerField(null=True, blank=True)
    response_snippet = models.CharField(max_length=512, null=True, blank=True)
    delivered_at = models.DateTimeField(null=True, blank=True)
    created_at = models.DateTimeField(default=timezone.now)

    class Meta:
        db_table = "webhook_deliveries"
        indexes = [
            models.Index(fields=["status", "queue", "priority", "available_at"], name="wh_claim"),
            models.Index(fields=["project", "id"], name="wh_project_id"),
        ]
