0089_commit_metadata.py
python
sha256:89c7a8268be75aeb33144acf863ad3ebefe7fd3bdfd679faa768199fd789b376
merge: REST wire wave — #296 #297 #298 #299 (Tier A review …
Opus 5.5
minor
⚠ breaking
1 day ago
| 1 | """musehub_commits.commit_metadata: keep each pushed commit's ``metadata`` (musehub#297) |
| 2 | |
| 3 | Push ingest used to discard the commit record's ``metadata`` mapping, so a fetch served ``metadata: {}`` for every commit. |
| 4 | |
| 5 | Revision ID: 0089 |
| 6 | Revises: 0088 |
| 7 | |
| 8 | Additive and nullable (no default rewrite, no lock beyond the brief ADD COLUMN catalog update): the previous image never reads it, so redeploying it |
| 9 | remains a valid rollback. |
| 10 | """ |
| 11 | from __future__ import annotations |
| 12 | |
| 13 | import sqlalchemy as sa |
| 14 | from alembic import op |
| 15 | from sqlalchemy.dialects.postgresql import JSONB |
| 16 | |
| 17 | revision: str = "0089" |
| 18 | down_revision: str = "0088" |
| 19 | branch_labels = None |
| 20 | depends_on = None |
| 21 | |
| 22 | |
| 23 | def upgrade() -> None: |
| 24 | # ADD COLUMN takes an ACCESS EXCLUSIVE lock: fail fast (and retry the deploy) rather than queue every musehub_commits read |
| 25 | # behind a long-running transaction such as a cold intel ingest (review F2). |
| 26 | op.execute("SET LOCAL lock_timeout = '5s'") |
| 27 | op.add_column("musehub_commits", sa.Column("commit_metadata", JSONB(), nullable=True)) |
| 28 | |
| 29 | |
| 30 | def downgrade() -> None: |
| 31 | op.drop_column("musehub_commits", "commit_metadata") |
File History
3 commits
sha256:89c7a8268be75aeb33144acf863ad3ebefe7fd3bdfd679faa768199fd789b376
merge: REST wire wave — #296 #297 #298 #299 (Tier A review …
Opus 5.5
minor
⚠
1 day ago
sha256:0425c7ed0698f5efc5b053148f82fd8764d6895fa27e9dd6e331d55786914085
fix(wire): review of #296-#299 — trim have instead of refus…
Opus 5.5
patch
1 day ago
sha256:bcf1d3c0486f7022d47cd24eed38fad1b1c50879b58cfe173231d76f0c9a1432
feat(wire): keep each pushed commit's metadata — commit_met…
Opus 5.5
minor
⚠
1 day ago