"""add_price_to_test_parameter

Revision ID: 7e8b91c3d4a2
Revises: 475b2397161a
Create Date: 2026-09-26 01:10:00.000000+00:00

"""

from collections.abc import Sequence

import sqlalchemy as sa
from alembic import op

# revision identifiers, used by Alembic.
revision: str = "7e8b91c3d4a2"
down_revision: str | None = "475b2397161a"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None


def upgrade() -> None:
    op.add_column(
        "test_parameter",
        sa.Column(
            "price",
            sa.Numeric(precision=10, scale=2),
            nullable=True,
            comment="Individual price for this analyte if ordered separately",
        ),
    )


def downgrade() -> None:
    op.drop_column("test_parameter", "price")