"""Add quote_status to standalone insurance models

Revision ID: a1b2c3d4e5f6
Revises: 211b37bc596b
Create Date: 2026-07-28 10:00:00.000000

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
import sqlmodel


# revision identifiers, used by Alembic.
revision: str = 'a1b2c3d4e5f6'
down_revision: Union[str, Sequence[str], None] = '211b37bc596b'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None

STANDALONE_TABLES = [
    'personalautoinsurance',
    'homeinsurance',
    'generalliability',
    'cyberliability',
    'professionalliability',
    'grouplife',
    'businessumbrella',
    'unifiedcommercial',
]


def upgrade() -> None:
    """Upgrade schema."""
    for table_name in STANDALONE_TABLES:
        op.add_column(
            table_name,
            sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False, server_default='Draft')
        )


def downgrade() -> None:
    """Downgrade schema."""
    for table_name in STANDALONE_TABLES:
        op.drop_column(table_name, 'quote_status')
