1 files changed, 80 insertions, 0 deletions
diff --git a/alembic/versions/20260411_0006_actor_queue_scheduling.py b/alembic/versions/20260411_0006_actor_queue_scheduling.py
new file mode 100644
index 0000000..a4fb9c1
--- /dev/null
+++ b/alembic/versions/20260411_0006_actor_queue_scheduling.py
@@ -0,0 +1,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")