"""Storage ingest archive path mode (preserve folders vs flatten).

Revision ID: 081
Revises: 080
"""

from typing import Sequence, Union

import sqlalchemy as sa
from alembic import op

revision: str = "081"
down_revision: Union[str, None] = "080"
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column(
        "storage_ingest_jobs",
        sa.Column(
            "archive_path_mode",
            sa.String(length=32),
            server_default="preserve_folders",
            nullable=False,
        ),
    )


def downgrade() -> None:
    op.drop_column("storage_ingest_jobs", "archive_path_mode")