bvandeusenandClaude Opus 5.5
79655fd19f
CI & Build / Python lint (push) Successful in 2s
CI & Build / Plugin hooks (push) Successful in 13s
CI & Build / TypeScript typecheck (push) Successful in 59s
CI & Build / integration (push) Successful in 1m32s
CI & Build / Python tests (push) Successful in 2m33s
CI & Build / Build & push image (push) Successful in 26s
Record, milestone, phase and plan citations go from every migration header; the "end before start" fix (0043) and the suppressed-count column (0095) state the condition they prevent rather than the incident. 0053 and 0055 pointed at design specs under docs/superpowers that are not in the repo; those pointers are removed. Kept: alembic's generated "Create Date:" headers (template metadata, not rationale), 0121's ARM_BORN justification beside the constant, and 0051's illustrative "update task 42" format example. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
48 lines
1.3 KiB
Python
48 lines
1.3 KiB
Python
"""conversations.last_curator_run_at — tracks scheduler progress per-conversation
|
|
|
|
Revision ID: 0048
|
|
Revises: 0047
|
|
Create Date: 2026-05-22
|
|
|
|
Part of the conversation+curator architecture. The
|
|
scheduler runs every 15 minutes and processes any journal conversation
|
|
with messages newer than its `last_curator_run_at` timestamp. NULL
|
|
means "never run; process all of today on first sweep."
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
|
|
revision = "0048"
|
|
down_revision = "0047"
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.add_column(
|
|
"conversations",
|
|
sa.Column(
|
|
"last_curator_run_at",
|
|
sa.DateTime(timezone=True),
|
|
nullable=True,
|
|
),
|
|
)
|
|
# Indexed because the scheduler's selection query is
|
|
# WHERE conversation_type='journal' AND (last_curator_run_at IS NULL OR ...)
|
|
# which benefits from a partial index narrowed to journal rows.
|
|
op.create_index(
|
|
"ix_conversations_journal_last_curator",
|
|
"conversations",
|
|
["last_curator_run_at"],
|
|
postgresql_where=sa.text("conversation_type = 'journal'"),
|
|
)
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.drop_index(
|
|
"ix_conversations_journal_last_curator",
|
|
table_name="conversations",
|
|
)
|
|
op.drop_column("conversations", "last_curator_run_at")
|