"""Core-owned durable Forms submission records."""
from __future__ import annotations

from datetime import datetime
from typing import Optional
from uuid import UUID as PyUUID

from sqlalchemy import DateTime, ForeignKey, Index, String, Text
from sqlalchemy.dialects.postgresql import JSONB, UUID
from sqlalchemy.orm import Mapped, mapped_column
from sqlalchemy.sql import func

from src.core.database import Base


class FormSubmissionRecord(Base):
    __tablename__ = "form_submissions"
    __table_args__ = (
        Index("ix_form_submissions_project_form_persisted", "project_id", "form_key", "persisted_at"),
    )

    submission_id: Mapped[str] = mapped_column(String(64), primary_key=True)
    project_id: Mapped[PyUUID] = mapped_column(
        UUID(as_uuid=True), ForeignKey("projects.id", ondelete="CASCADE"), nullable=False
    )
    form_key: Mapped[str] = mapped_column(String(64), nullable=False)
    values_json: Mapped[dict] = mapped_column(JSONB, nullable=False)
    accepted_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), nullable=False)
    persisted_at: Mapped[datetime] = mapped_column(
        DateTime(timezone=True), nullable=False, server_default=func.now()
    )
    status: Mapped[str] = mapped_column(String(32), nullable=False, server_default="accepted")
    client_identity: Mapped[Optional[str]] = mapped_column(Text, nullable=True)