1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
"""tracked actor queue scheduling fields"""
from __future__ import annotations
from alembic import op
import sqlalchemy as sa
from sqlalchemy import inspect
revision = "20260411_0006"
down_revision = "20260411_0005"
branch_labels = None
depends_on = None
def _column_names(table_name: str) -> set[str]:
return {column["name"] for column in inspect(op.get_bind()).get_columns(table_name)}
def upgrade() -> None:
columns = _column_names("tracked_actors")
if "discovery_state" not in columns:
op.add_column(
"tracked_actors",
sa.Column("discovery_state", sa.String(length=32), nullable=False, server_default="queued"),
)
if "queued_for_discovery_at" not in columns:
op.add_column("tracked_actors", sa.Column("queued_for_discovery_at", sa.DateTime(timezone=True), nullable=True))
if "next_poll_after" not in columns:
op.add_column("tracked_actors", sa.Column("next_poll_after", sa.DateTime(timezone=True), nullable=True))
if "last_claimed_at" not in columns:
op.add_column("tracked_actors", sa.Column("last_claimed_at", sa.DateTime(timezone=True), nullable=True))
if "poll_attempts" not in columns:
op.add_column(
"tracked_actors",
sa.Column("poll_attempts", sa.Integer(), nullable=False, server_default="0"),
)
op.execute(
sa.text(
"""
UPDATE tracked_actors
SET discovery_state = CASE
WHEN last_poll_status IS NOT NULL THEN last_poll_status
ELSE 'queued'
END
"""
)
)
op.execute(
sa.text(
"""
UPDATE tracked_actors
SET queued_for_discovery_at = COALESCE(queued_for_discovery_at, last_requested_at, last_polled_at, CURRENT_TIMESTAMP)
"""
)
)
op.execute(
sa.text(
"""
UPDATE tracked_actors
SET next_poll_after = COALESCE(next_poll_after, last_polled_at, CURRENT_TIMESTAMP)
"""
)
)
def downgrade() -> None:
columns = _column_names("tracked_actors")
if "poll_attempts" in columns:
op.drop_column("tracked_actors", "poll_attempts")
if "last_claimed_at" in columns:
op.drop_column("tracked_actors", "last_claimed_at")
if "next_poll_after" in columns:
op.drop_column("tracked_actors", "next_poll_after")
if "queued_for_discovery_at" in columns:
op.drop_column("tracked_actors", "queued_for_discovery_at")
if "discovery_state" in columns:
op.drop_column("tracked_actors", "discovery_state")
|
