"""Nombre de badges par bénévole

Revision ID: 0027_volunteer_badge_count
Revises: 0026_badge_editor_v2
Create Date: 2026-10-27

`volunteer.badge_count` : nombre d'exemplaires de son badge imprimés sur les
planches (`POST .../badges/generate`), 1 par défaut — les bénévoles existants
gardent un seul badge.
"""

from collections.abc import Sequence

import sqlalchemy as sa
from alembic import op

revision: str = "0027_volunteer_badge_count"
down_revision: str | None = "0026_badge_editor_v2"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    op.add_column(
        "volunteer",
        sa.Column("badge_count", sa.Integer(), nullable=False, server_default="1"),
    )
    op.create_check_constraint(
        "ck_volunteer_badge_count_positive", "volunteer", "badge_count >= 1"
    )


def downgrade() -> None:
    op.drop_constraint("ck_volunteer_badge_count_positive", "volunteer", type_="check")
    op.drop_column("volunteer", "badge_count")