"""add_production_report_to_qa_verification_methods

Revision ID: eb65482c06bf
Revises: 61fcd0203836
Create Date: 2026-10-16 14:58:09.877227

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = 'eb65482c06bf'
down_revision: Union[str, None] = '61fcd0203836'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    conn = op.get_bind()
    conn.execute(sa.text("""
        INSERT INTO qa_verification_method_master (id, code, label, sort_order, is_active, created_at, updated_at)
        SELECT gen_random_uuid(), 'PRODUCTION_REPORT', 'Production Report', 6, TRUE, NOW(), NOW()
        WHERE NOT EXISTS (
            SELECT 1 FROM qa_verification_method_master WHERE code = 'PRODUCTION_REPORT'
        );
    """))


def downgrade() -> None:
    conn = op.get_bind()
    conn.execute(sa.text("""
        DELETE FROM qa_verification_method_master WHERE code = 'PRODUCTION_REPORT';
    """))