"""scraping_logs: track per-company progress for long runs

Revision ID: 0004
Revises: 0003
Create Date: 2026-04-17

Adds progress_current / progress_total (units = companies). The UI renders
progress_current / NULLIF(progress_total, 0) as a percentage so the admin can
see how far along a long backfill is, and whether it's still making progress.
"""
from alembic import op


revision = "0004"
down_revision = "0003"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.execute(
        "ALTER TABLE scraping_logs "
        "ADD COLUMN progress_current INT NOT NULL DEFAULT 0, "
        "ADD COLUMN progress_total INT NOT NULL DEFAULT 0"
    )


def downgrade() -> None:
    op.execute("ALTER TABLE scraping_logs DROP COLUMN progress_current, DROP COLUMN progress_total")