"""a bundle pepper per account, so a node cannot test passphrase guesses

Revision ID: c3d4e5f6a7b9
Revises: b2c3d4e5f6a8
"""

from collections.abc import Sequence

import sqlalchemy as sa
from alembic import op

revision: str = "c3d4e5f6a7b9"
down_revision: str | Sequence[str] | None = "b2c3d4e5f6a8"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    with op.batch_alter_table("users") as batch:
        batch.add_column(sa.Column("bundle_pepper", sa.String(128), nullable=True))
        batch.add_column(sa.Column("bundle_pepper_version", sa.Integer(), nullable=False,
                                   server_default="1"))


def downgrade() -> None:
    with op.batch_alter_table("users") as batch:
        batch.drop_column("bundle_pepper_version")
        batch.drop_column("bundle_pepper")