from __future__ import annotations

from datetime import datetime
from typing import Literal, Optional
from uuid import UUID

from pydantic import BaseModel, ConfigDict, Field, field_validator

from .config import ALLOWED_CONNECTIONS, ALLOWED_TABLES


class CreateRun(BaseModel):
    model_config = ConfigDict(extra="forbid")

    run_id: UUID
    connection: str = Field(min_length=1, max_length=64)
    mode: Literal["full"]
    tables: list[str] = Field(min_length=1, max_length=16)

    @field_validator("connection")
    @classmethod
    def known_connection(cls, value: str) -> str:
        if value not in ALLOWED_CONNECTIONS:
            raise ValueError("connection is not allowed")
        return value

    @field_validator("tables")
    @classmethod
    def known_tables(cls, values: list[str]) -> list[str]:
        if len(values) != len(set(values)):
            raise ValueError("tables must be unique")
        if any(value not in ALLOWED_TABLES for value in values):
            raise ValueError("one or more tables are not allowed")
        return values


class TableSnapshot(BaseModel):
    name: str
    status: Literal["pending", "running", "completed", "failed"]
    rows_imported: Optional[int] = Field(default=None, ge=0)
    previous_rows: Optional[int] = Field(default=None, ge=0)
    started_at: Optional[datetime] = None
    finished_at: Optional[datetime] = None
    backup_table: Optional[str] = Field(default=None, pattern=r"^[a-z_][a-z0-9_]*$")
    error_message: Optional[str] = Field(default=None, max_length=1000)


class RunSnapshot(BaseModel):
    run_id: UUID
    status: Literal["pending", "queued", "running", "completed", "failed", "cancelled"]
    started_at: Optional[datetime] = None
    finished_at: Optional[datetime] = None
    error_message: Optional[str] = Field(default=None, max_length=1000)
    tables: list[TableSnapshot]


def utcnow() -> str:
    return datetime.utcnow().isoformat(timespec="seconds") + "Z"
