"""Infrastructure tables (TZ 2.2.11, 2.2.13): admin user, locks, rate counters, audit, scheduler state."""

from __future__ import annotations

from typing import Any

from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
from django.db import models
from django.utils import timezone

from .fields import UUIDv7Field


class AdminUserManager(BaseUserManager["AdminUser"]):
    def get_or_create_superadmin(self, login: str) -> AdminUser:
        user, _ = self.get_or_create(login=login)
        if user.has_usable_password():
            user.set_unusable_password()
            user.save(update_fields=["password"])
        return user


class AdminUser(AbstractBaseUser):
    """The single super-admin row (synced from .env). Password is never stored (TZ 2.9.4)."""

    id = UUIDv7Field(primary_key=True)
    login = models.CharField(max_length=150, unique=True)
    created_at = models.DateTimeField(default=timezone.now)

    USERNAME_FIELD = "login"
    REQUIRED_FIELDS: list[str] = []
    objects = AdminUserManager()

    class Meta:
        db_table = "snapfile_admin_user"

    is_staff = True
    is_superuser = True
    is_active = True

    def has_perm(self, perm: str, obj: Any = None) -> bool:
        return True

    def has_module_perms(self, app_label: str) -> bool:
        return True

    def get_session_auth_hash(self) -> str:
        # Changing the password hash in .env invalidates all admin sessions.
        from django.conf import settings

        from .crypto import derive_key, hmac_hex

        return hmac_hex(derive_key("admin-session"), f"{self.login}:{settings.SUPERADMIN_PASSWORD_HASH}")


class AppLock(models.Model):
    name = models.CharField(max_length=191, primary_key=True)
    owner = models.CharField(max_length=96)
    lease_until = models.DateTimeField()
    acquired_at = models.DateTimeField(default=timezone.now)

    class Meta:
        db_table = "app_locks"


class RateCounter(models.Model):
    bucket = models.CharField(max_length=191, primary_key=True)
    count = models.PositiveIntegerField(default=0)
    expires_at = models.DateTimeField(db_index=True)

    class Meta:
        db_table = "rate_counters"


class AuditLog(models.Model):
    id = UUIDv7Field(primary_key=True)
    project_id = models.UUIDField(null=True, blank=True)
    actor_type = models.CharField(max_length=16)
    actor_id = models.CharField(max_length=191, null=True, blank=True, db_index=True)
    actor_name = models.CharField(max_length=255, null=True, blank=True)
    actor_meta = models.JSONField(null=True, blank=True)
    action = models.CharField(max_length=64)
    subject_type = models.CharField(max_length=32, null=True, blank=True)
    subject_id = models.UUIDField(null=True, blank=True)
    changes = models.JSONField(null=True, blank=True)
    ip = models.CharField(max_length=45, null=True, blank=True)
    user_agent = models.CharField(max_length=255, null=True, blank=True)
    request_id = models.CharField(max_length=64, null=True, blank=True)
    created_at = models.DateTimeField(default=timezone.now)

    class Meta:
        db_table = "audit_log"
        indexes = [
            models.Index(fields=["project_id", "created_at"], name="audit_project_time"),
            models.Index(fields=["subject_type", "subject_id"], name="audit_subject"),
        ]


class SchedulerRun(models.Model):
    task = models.CharField(max_length=64, primary_key=True)
    last_started_at = models.DateTimeField(null=True)
    last_finished_at = models.DateTimeField(null=True)
    last_status = models.CharField(max_length=16, null=True)
    last_duration_ms = models.PositiveIntegerField(null=True)
    last_error = models.TextField(null=True)

    class Meta:
        db_table = "scheduler_runs"


class WorkerHeartbeat(models.Model):
    owner = models.CharField(max_length=96, primary_key=True)
    host = models.CharField(max_length=128)
    pid = models.PositiveIntegerField()
    mode = models.CharField(max_length=16)
    queues = models.CharField(max_length=128)
    started_at = models.DateTimeField()
    last_seen_at = models.DateTimeField()
    jobs_done = models.PositiveIntegerField(default=0)
    rss_mb = models.PositiveIntegerField(null=True)

    class Meta:
        db_table = "worker_heartbeats"
