"""replace docuseal columns with placements_json

Revision ID: g002_placements
Revises: g001_signing
Create Date: 2026-03-07
"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects.postgresql import JSON

# revision identifiers
revision = "g002_placements"
down_revision = "g001_signing"
branch_labels = None
depends_on = None


def upgrade():
    op.drop_column("signing_requests", "docuseal_template_id")
    op.drop_column("signing_requests", "docuseal_submission_id")
    op.drop_column("signing_requests", "docuseal_slug")
    op.add_column(
        "signing_requests",
        sa.Column("placements_json", JSON, nullable=True),
    )


def downgrade():
    op.drop_column("signing_requests", "placements_json")
    op.add_column(
        "signing_requests",
        sa.Column("docuseal_template_id", sa.Integer, nullable=True),
    )
    op.add_column(
        "signing_requests",
        sa.Column("docuseal_submission_id", sa.Integer, nullable=True),
    )
    op.add_column(
        "signing_requests",
        sa.Column("docuseal_slug", sa.String(255), nullable=True),
    )