gabriel / musehub public
0064_drop_stream_rejections.py python
42 lines 1.5 KB
Raw
sha256:20b27796ed512236119feef48b4577a8fd9ded05a15267dd4e6da23604ad1f1a docs: update Suggested Ownership Split table to reflect ful… Sonnet 5 27 days ago
1 """Drop musehub_stream_rejections — dead MWP-era table.
2
3 The streaming wire protocol (MWP) has been removed. The rejection audit
4 table it wrote to has never had any production traffic — no inserts, no
5 reads. Drop it cleanly.
6
7 Revision ID: 0064
8 Revises: 0063
9 """
10 from __future__ import annotations
11
12 from alembic import op
13
14
15 revision: str = "0064"
16 down_revision: str = "0063"
17 branch_labels = None
18 depends_on = None
19
20
21 def upgrade() -> None:
22 op.drop_index("ix_stream_rejections_identity", table_name="musehub_stream_rejections")
23 op.drop_index("ix_stream_rejections_repo", table_name="musehub_stream_rejections")
24 op.drop_table("musehub_stream_rejections")
25
26
27 def downgrade() -> None:
28 import sqlalchemy as sa
29
30 op.create_table(
31 "musehub_stream_rejections",
32 sa.Column("rejection_id", sa.String(128), nullable=False),
33 sa.Column("repo_id", sa.String(128), nullable=False),
34 sa.Column("identity_id", sa.String(128), nullable=True),
35 sa.Column("reason", sa.String(32), nullable=False),
36 sa.Column("detail", sa.Text(), nullable=False),
37 sa.Column("rejected_at", sa.DateTime(timezone=True), nullable=False),
38 sa.ForeignKeyConstraint(["repo_id"], ["musehub_repos.repo_id"], ondelete="CASCADE"),
39 sa.PrimaryKeyConstraint("rejection_id"),
40 )
41 op.create_index("ix_stream_rejections_repo", "musehub_stream_rejections", ["repo_id"], unique=False)
42 op.create_index("ix_stream_rejections_identity", "musehub_stream_rejections", ["identity_id"], unique=False)
File History 3 commits
sha256:20b27796ed512236119feef48b4577a8fd9ded05a15267dd4e6da23604ad1f1a docs: update Suggested Ownership Split table to reflect ful… Sonnet 5 27 days ago
sha256:8ea2f75226d5834770ccaddbaa6efda1cc337446fd481bb385de8bec4555ae79 docs: Section 9 CI pipeline — confirm job queue is idempote… Sonnet 5 27 days ago
sha256:80e1a60a39562f6e616aaafbb27487f03abbec7d8ffc6164302b7a0c0bfc63ee docs: check off Section 0 items verified in inventory doc, … Sonnet 5 27 days ago