40 lines
945 B
Python
40 lines
945 B
Python
"""capture reliability
|
|
|
|
Revision ID: f8c2d6e1a4b7
|
|
Revises: c9e2a7f4b1d8
|
|
Create Date: 2026-10-19 03:00:00.000000
|
|
|
|
"""
|
|
|
|
from collections.abc import Sequence
|
|
|
|
import sqlalchemy as sa
|
|
from alembic import op
|
|
|
|
revision: str = "f8c2d6e1a4b7"
|
|
down_revision: str | None = "c9e2a7f4b1d8"
|
|
branch_labels: str | Sequence[str] | None = None
|
|
depends_on: str | Sequence[str] | None = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.add_column(
|
|
"jobs", sa.Column("run_after", sa.DateTime(timezone=True), nullable=True)
|
|
)
|
|
op.execute(
|
|
"ALTER TABLE accounts "
|
|
"ADD COLUMN catchup_pts integer, "
|
|
"ADD COLUMN catchup_qts integer, "
|
|
"ADD COLUMN catchup_date integer"
|
|
)
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.execute(
|
|
"ALTER TABLE accounts "
|
|
"DROP COLUMN IF EXISTS catchup_pts, "
|
|
"DROP COLUMN IF EXISTS catchup_qts, "
|
|
"DROP COLUMN IF EXISTS catchup_date"
|
|
)
|
|
op.drop_column("jobs", "run_after")
|