"""Rename legacy merge_strategy values to canonical names.

  state_overlay    → overlay
  state_weave      → weave
  state_rebase     → replay
  domain_selective → selective

Revision ID: 0070
Revises: 0069
"""
from __future__ import annotations

from alembic import op

revision = "0070"
down_revision = "0069"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.execute("""
        UPDATE musehub_proposals
        SET merge_strategy = CASE merge_strategy
            WHEN 'state_overlay'    THEN 'overlay'
            WHEN 'state_weave'      THEN 'weave'
            WHEN 'state_rebase'     THEN 'replay'
            WHEN 'domain_selective' THEN 'selective'
            ELSE merge_strategy
        END
        WHERE merge_strategy IN ('state_overlay', 'state_weave', 'state_rebase', 'domain_selective')
    """)


def downgrade() -> None:
    op.execute("""
        UPDATE musehub_proposals
        SET merge_strategy = CASE merge_strategy
            WHEN 'overlay'   THEN 'state_overlay'
            WHEN 'weave'     THEN 'state_weave'
            WHEN 'replay'    THEN 'state_rebase'
            WHEN 'selective' THEN 'domain_selective'
            ELSE merge_strategy
        END
        WHERE merge_strategy IN ('overlay', 'weave', 'replay', 'selective')
    """)