"""Editor sessions issued by the client service (TZ 2.2.12, 2.9.3)."""

from __future__ import annotations

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

from snapfile.core.fields import UUIDv7Field
from snapfile.integration.models import ApiKey
from snapfile.projects.models import Project

ROLES = ("viewer", "editor", "admin")


class EditSession(models.Model):
    id = UUIDv7Field(primary_key=True)
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name="edit_sessions")
    api_key = models.ForeignKey(ApiKey, null=True, blank=True, on_delete=models.SET_NULL)
    actor_type = models.CharField(max_length=16, default="user")
    handoff_token_hash = models.CharField(max_length=64, unique=True)
    handoff_expires_at = models.DateTimeField()
    handoff_used_at = models.DateTimeField(null=True, blank=True)
    external_user_id = models.CharField(max_length=191)
    external_user_name = models.CharField(max_length=255)
    external_user_email = models.CharField(max_length=255, null=True, blank=True)
    external_user_meta = models.JSONField(null=True, blank=True)
    role = models.CharField(max_length=16)
    template_scope = models.JSONField(null=True, blank=True)
    open_target = models.JSONField(null=True, blank=True)
    permissions = models.JSONField(null=True, blank=True)
    locale = models.CharField(max_length=8, null=True, blank=True)
    return_url = models.CharField(max_length=512, null=True, blank=True)
    client_session_ref = models.CharField(max_length=255, null=True, blank=True)
    refresh_token_hash = models.CharField(max_length=64, null=True, blank=True)
    # Previous (rotated-out) refresh token: presenting it again after the grace window revokes the session.
    refresh_prev_hash = models.CharField(max_length=64, null=True, blank=True, db_index=True)
    refresh_rotated_at = models.DateTimeField(null=True, blank=True)
    expires_at = models.DateTimeField()
    last_seen_at = models.DateTimeField(null=True, blank=True)
    last_introspected_at = models.DateTimeField(null=True, blank=True)
    revoked_at = models.DateTimeField(null=True, blank=True)
    ip_issued = models.CharField(max_length=45, null=True, blank=True)
    ip_last = models.CharField(max_length=45, null=True, blank=True)
    created_at = models.DateTimeField(default=timezone.now)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "edit_sessions"
        indexes = [models.Index(fields=["project", "external_user_id"], name="sessions_project_user")]
