"""widen secrets.notes from 140 to 255 chars

Revision ID: 0002_notes_widen
Revises: 0001_initial
Create Date: 2026-10-03

Downgrade truncates nothing but re-narrows the column; it fails if any row
holds more than 140 chars.
"""

from collections.abc import Sequence

import sqlalchemy as sa

from alembic import op

revision: str = "0002_notes_widen"
down_revision: str | None = "0001_initial"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    op.alter_column(
        "secrets",
        "notes",
        existing_type=sa.String(140),
        type_=sa.String(255),
        existing_nullable=True,
    )


def downgrade() -> None:
    op.alter_column(
        "secrets",
        "notes",
        existing_type=sa.String(255),
        type_=sa.String(140),
        existing_nullable=True,
    )