"""gateway persist: face, id, reports, voice metadata

Revision ID: d4e5f6a7b8c9
Revises: a1b2c3d4e5f6
Create Date: 2026-10-27

Blobs (PDFs, encrypted ID images) stay on disk; only metadata is stored.
Platform User/Company IDs are string refs with no cross-schema FKs.

Note: interview_sessions migration removed — table is legacy (sessions HTTP
gone); do not recreate via alembic. Existing DB rows may remain.
"""

from __future__ import annotations

from typing import Sequence, Union

import sqlalchemy as sa
from alembic import op

revision: str = "d4e5f6a7b8c9"
down_revision: Union[str, Sequence[str], None] = "a1b2c3d4e5f6"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.create_table(
        "face_verification_audits",
        sa.Column("audit_id", sa.String(128), primary_key=True),
        sa.Column("interview_id", sa.String(128), nullable=False),
        sa.Column("candidate_id", sa.String(128), nullable=True),
        sa.Column("status", sa.String(32), nullable=False),
        sa.Column("verified", sa.Boolean(), nullable=False, server_default=sa.false()),
        sa.Column(
            "identity_matched", sa.Boolean(), nullable=False, server_default=sa.false()
        ),
        sa.Column(
            "liveness_passed", sa.Boolean(), nullable=False, server_default=sa.false()
        ),
        sa.Column("match_score", sa.Float(), nullable=True),
        sa.Column("distance", sa.Float(), nullable=True),
        sa.Column("threshold", sa.Float(), nullable=True),
        sa.Column("liveness_score", sa.Float(), nullable=True),
        sa.Column("model", sa.String(128), nullable=True),
        sa.Column("detector", sa.String(128), nullable=True),
        sa.Column("attempt", sa.Integer(), nullable=False, server_default="1"),
        sa.Column("face_count", sa.Integer(), nullable=True),
        sa.Column("frame_count", sa.Integer(), nullable=False, server_default="0"),
        sa.Column("registered_image_sha256", sa.String(128), nullable=True),
        sa.Column("live_image_sha256s", sa.JSON(), nullable=False),
        sa.Column("error_code", sa.String(128), nullable=True),
        sa.Column("warnings", sa.JSON(), nullable=False),
        sa.Column("created_at", sa.String(64), nullable=False),
        sa.Column("expires_at", sa.String(64), nullable=True),
    )
    op.create_index(
        "ix_face_verification_audits_interview_id",
        "face_verification_audits",
        ["interview_id"],
    )
    op.create_index(
        "ix_face_verification_audits_candidate_id",
        "face_verification_audits",
        ["candidate_id"],
    )

    op.create_table(
        "id_verifications",
        sa.Column("verification_id", sa.String(128), primary_key=True),
        sa.Column("interview_id", sa.String(128), nullable=True),
        sa.Column("candidate_id", sa.String(128), nullable=True),
        sa.Column("verification_status", sa.String(64), nullable=False),
        sa.Column("verified", sa.Boolean(), nullable=False, server_default=sa.false()),
        sa.Column(
            "consent_given", sa.Boolean(), nullable=False, server_default=sa.false()
        ),
        sa.Column("consent_id", sa.String(128), nullable=True),
        sa.Column("consent_version", sa.String(64), nullable=True),
        sa.Column("consent_timestamp", sa.String(64), nullable=True),
        sa.Column("extracted_name", sa.String(512), nullable=True),
        sa.Column("extracted_id_number_masked", sa.String(128), nullable=True),
        sa.Column("document_type", sa.String(128), nullable=True),
        sa.Column("match_score", sa.Float(), nullable=True),
        sa.Column("identity_matched", sa.Boolean(), nullable=True),
        sa.Column("liveness_passed", sa.Boolean(), nullable=True),
        sa.Column("expiry_valid", sa.Boolean(), nullable=True),
        sa.Column("authenticity_passed", sa.Boolean(), nullable=True),
        sa.Column("name_matched", sa.Boolean(), nullable=True),
        sa.Column("encrypted_storage_id", sa.String(256), nullable=True),
        sa.Column("id_image_sha256", sa.String(128), nullable=True),
        sa.Column("attempt", sa.Integer(), nullable=False, server_default="1"),
        sa.Column("error_code", sa.String(128), nullable=True),
        sa.Column("warnings", sa.JSON(), nullable=False),
        sa.Column("checks", sa.JSON(), nullable=False),
        sa.Column("created_at", sa.String(64), nullable=False),
        sa.Column("verified_at", sa.String(64), nullable=True),
        sa.Column("expires_at", sa.String(64), nullable=True),
    )
    op.create_index("ix_id_verifications_interview_id", "id_verifications", ["interview_id"])
    op.create_index("ix_id_verifications_candidate_id", "id_verifications", ["candidate_id"])

    op.create_table(
        "evaluation_reports",
        sa.Column("report_id", sa.String(64), primary_key=True),
        sa.Column("interview_id", sa.String(128), nullable=True),
        sa.Column("storage_path", sa.Text(), nullable=False),
        sa.Column("summary_markdown", sa.Text(), nullable=True),
        sa.Column("candidate_name", sa.String(512), nullable=True),
        sa.Column("role_title", sa.String(512), nullable=True),
        sa.Column("company_name", sa.String(512), nullable=True),
        sa.Column("created_at", sa.DateTime(timezone=True), nullable=False),
        sa.Column("meta", sa.JSON(), nullable=False),
    )
    op.create_index(
        "ix_evaluation_reports_interview_id", "evaluation_reports", ["interview_id"]
    )

    op.create_table(
        "voice_profiles",
        sa.Column("voice_id", sa.String(128), primary_key=True),
        sa.Column("company_id", sa.String(128), nullable=False),
        sa.Column("voice_name", sa.String(512), nullable=False),
        sa.Column("tts_model", sa.String(128), nullable=False),
        sa.Column("mode", sa.String(32), nullable=False),
        sa.Column("openai_voice_id", sa.String(256), nullable=True),
        sa.Column("builtin_voice", sa.String(64), nullable=True),
        sa.Column("consent_id", sa.String(128), nullable=True),
        sa.Column("sample_sha256", sa.String(128), nullable=True),
        sa.Column("created_at", sa.String(64), nullable=False),
        sa.Column("meta", sa.JSON(), nullable=False),
    )
    op.create_index("ix_voice_profiles_company_id", "voice_profiles", ["company_id"])


def downgrade() -> None:
    op.drop_index("ix_voice_profiles_company_id", table_name="voice_profiles")
    op.drop_table("voice_profiles")
    op.drop_index("ix_evaluation_reports_interview_id", table_name="evaluation_reports")
    op.drop_table("evaluation_reports")
    op.drop_index("ix_id_verifications_candidate_id", table_name="id_verifications")
    op.drop_index("ix_id_verifications_interview_id", table_name="id_verifications")
    op.drop_table("id_verifications")
    op.drop_index(
        "ix_face_verification_audits_candidate_id", table_name="face_verification_audits"
    )
    op.drop_index(
        "ix_face_verification_audits_interview_id", table_name="face_verification_audits"
    )
    op.drop_table("face_verification_audits")
