"""rename proposal number column (previously pr_number) to proposal_number, rename musehub_pr_labels to musehub_proposal_labels

Revision ID: 0028
Revises: 0027
Create Date: 2026-04-06
"""

from alembic import op

revision = "0028"
down_revision = "0027"
branch_labels = None
depends_on = None


def upgrade() -> None:
    # Drop index referencing pr_number first, then rename the column
    op.drop_index("ix_musehub_proposals_repo_number", table_name="musehub_proposals")
    op.alter_column("musehub_proposals", "pr_number", new_column_name="proposal_number")
    op.create_index(
        "ix_musehub_proposals_repo_number",
        "musehub_proposals",
        ["repo_id", "proposal_number"],
    )

    # Rename musehub_pr_labels → musehub_proposal_labels
    op.rename_table("musehub_pr_labels", "musehub_proposal_labels")

    # Rename the label_id index on the table
    op.drop_index("ix_musehub_pr_labels_label_id", table_name="musehub_proposal_labels")
    op.create_index(
        "ix_musehub_proposal_labels_label_id",
        "musehub_proposal_labels",
        ["label_id"],
    )


def downgrade() -> None:
    op.drop_index("ix_musehub_proposal_labels_label_id", table_name="musehub_proposal_labels")
    op.create_index(
        "ix_musehub_pr_labels_label_id",
        "musehub_proposal_labels",
        ["label_id"],
    )
    op.rename_table("musehub_proposal_labels", "musehub_pr_labels")

    # Rename column first, then recreate index referencing the old column name
    op.alter_column("musehub_proposals", "proposal_number", new_column_name="pr_number")
    op.drop_index("ix_musehub_proposals_repo_number", table_name="musehub_proposals")
    op.create_index(
        "ix_musehub_proposals_repo_number",
        "musehub_proposals",
        ["repo_id", "pr_number"],
    )