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>
49 lines
1.5 KiB
Python
49 lines
1.5 KiB
Python
"""add note.description and note.consolidated_at
|
|
|
|
Revision ID: 0044
|
|
Revises: 0043
|
|
Create Date: 2026-05-13
|
|
|
|
Adds two columns to the ``notes`` table to support the task-as-durable-record
|
|
design:
|
|
|
|
- ``description``: user-stated goal / initial context. Meaningful when
|
|
``is_task=true``; left NULL on knowledge notes.
|
|
- ``consolidated_at``: timestamp of the most recent auto-summary pass. NULL
|
|
until the first consolidation runs.
|
|
|
|
Backfill: for existing tasks we copy ``body`` into ``description`` so the
|
|
user's original goal text is preserved when ``body`` is later overwritten by
|
|
the auto-summary pipeline. The brief duplication window between
|
|
``body`` and ``description`` is harmless and resolves on the first
|
|
consolidation pass.
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
|
|
|
|
revision = "0044"
|
|
down_revision = "0043"
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.add_column("notes", sa.Column("description", sa.Text(), nullable=True))
|
|
op.add_column(
|
|
"notes",
|
|
sa.Column("consolidated_at", sa.DateTime(timezone=True), nullable=True),
|
|
)
|
|
# is_task is a Python property (status IS NOT NULL); there's no DB column
|
|
# of that name. Backfill description from body for everything that
|
|
# qualifies as a task at the model layer.
|
|
op.execute(
|
|
"UPDATE notes SET description = body "
|
|
"WHERE status IS NOT NULL AND body IS NOT NULL"
|
|
)
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.drop_column("notes", "consolidated_at")
|
|
op.drop_column("notes", "description")
|