gabriel / musehub public
0089_commit_metadata.py python
31 lines 1.1 KB
Raw
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