gabriel / musehub public
0046_proposal_domain_summaries_and_agent_meta.py python
51 lines 2.5 KB
Raw
sha256:3ff9c9863a9891bdcde71b4a43228f66d0493e38b7cc1d09fe9eb7de774046b2 feat: add repair-commit wire endpoint (API parity with repa… Opus 4.8 minor ⚠ breaking 1 day ago
1 """Add domain summary columns and agent provenance columns to proposals + review enhancements (issue #37 Phase 1b)
2
3 Revision ID: 0046
4 Revises: 0045
5 """
6 from __future__ import annotations
7
8 import sqlalchemy as sa
9 from alembic import op
10 from sqlalchemy.dialects.postgresql import ARRAY, JSONB
11
12 revision: str = "0046"
13 down_revision: str = "0045"
14 branch_labels = None
15 depends_on = None
16
17
18 def upgrade() -> None:
19 # MIDI domain summary columns
20 op.add_column("musehub_proposals", sa.Column("midi_tracks_changed", sa.Integer, nullable=False, server_default="0"))
21 op.add_column("musehub_proposals", sa.Column("midi_notes_delta", sa.Integer, nullable=False, server_default="0"))
22 op.add_column("musehub_proposals", sa.Column("harmonic_tension_delta", sa.Float, nullable=True))
23
24 # Payment domain summary columns
25 op.add_column("musehub_proposals", sa.Column("payment_claim_count", sa.Integer, nullable=False, server_default="0"))
26 op.add_column("musehub_proposals", sa.Column("payment_ledger_delta_nano", sa.BigInteger, nullable=False, server_default="0"))
27 op.add_column("musehub_proposals", sa.Column("payment_avax_address", sa.String(255), nullable=True))
28
29 # Agent provenance columns
30 op.add_column("musehub_proposals", sa.Column("agent_model", sa.String(255), nullable=True))
31 op.add_column("musehub_proposals", sa.Column("agent_spawned_by", sa.String(255), nullable=True))
32
33 # Review dimensional fields
34 op.add_column("musehub_proposal_reviews", sa.Column("reviewed_domains", ARRAY(sa.Text), nullable=False, server_default="{}"))
35 op.add_column("musehub_proposal_reviews", sa.Column("domain_risk_acknowledged", JSONB, nullable=False, server_default="{}"))
36 op.add_column("musehub_proposal_reviews", sa.Column("suggested_merge_strategy", sa.String(50), nullable=True))
37
38
39 def downgrade() -> None:
40 op.drop_column("musehub_proposal_reviews", "suggested_merge_strategy")
41 op.drop_column("musehub_proposal_reviews", "domain_risk_acknowledged")
42 op.drop_column("musehub_proposal_reviews", "reviewed_domains")
43
44 op.drop_column("musehub_proposals", "agent_spawned_by")
45 op.drop_column("musehub_proposals", "agent_model")
46 op.drop_column("musehub_proposals", "payment_avax_address")
47 op.drop_column("musehub_proposals", "payment_ledger_delta_nano")
48 op.drop_column("musehub_proposals", "payment_claim_count")
49 op.drop_column("musehub_proposals", "harmonic_tension_delta")
50 op.drop_column("musehub_proposals", "midi_notes_delta")
51 op.drop_column("musehub_proposals", "midi_tracks_changed")
File History 1 commit
sha256:3ff9c9863a9891bdcde71b4a43228f66d0493e38b7cc1d09fe9eb7de774046b2 feat: add repair-commit wire endpoint (API parity with repa… Opus 4.8 minor ⚠ 1 day ago