"""seed deezer songwhip client

Adds the Deezer fan-collect client (paused) so it can be enabled from the
dashboard. Idempotent — no-ops if the row already exists.

Revision ID: d9e3f1a7c2b4
Revises: c8d2f4a6b1e9
Create Date: 2026-06-29 12:00:00.000000+00:00

"""

from collections.abc import Sequence

from alembic import op

# revision identifiers, used by Alembic.
revision: str = "d9e3f1a7c2b4"
down_revision: str | Sequence[str] | None = "c8d2f4a6b1e9"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    op.execute("""
        INSERT INTO dsp_client (dsp_id, name, display_name, status, nominal_rps) VALUES
            ('deezer', 'deezer_songwhip', 'Deezer: Songwhip', 'paused', 10)
        ON CONFLICT (name) DO NOTHING
    """)


def downgrade() -> None:
    op.execute("DELETE FROM dsp_client WHERE name = 'deezer_songwhip'")