gabriel / musehub public
0032_symbol_vitals_coupling_count.py python
30 lines 772 B
Raw
sha256:009b5a222314f47640a58d75ce5a1f428f1624cf0b51384dfcdfbdfab3cc42a4 feat: migration idempotency, file attribution DAG walk, mpa… Sonnet 4.6 minor ⚠ breaking 9 days ago
1 """Add coupling_count to musehub_symbol_vitals.
2
3 Pre-computed at push time: the number of distinct symbols this symbol
4 co-changes with. Enables the symbol list page to show a coupling score
5 per row without any aggregation at request time.
6
7 Revision ID: 0032
8 Revises: 0031
9 """
10 from __future__ import annotations
11
12 from alembic import op
13 import sqlalchemy as sa
14
15 revision = "0032"
16 down_revision = "0031"
17 branch_labels = None
18 depends_on = None
19
20
21 def upgrade() -> None:
22 op.add_column(
23 "musehub_symbol_vitals",
24 sa.Column("coupling_count", sa.Integer, nullable=False, server_default="0"),
25 )
26
27
28 def downgrade() -> None:
29 from sqlalchemy import text
30 op.execute(text("ALTER TABLE IF EXISTS musehub_symbol_vitals DROP COLUMN IF EXISTS coupling_count"))
File History 1 commit
sha256:009b5a222314f47640a58d75ce5a1f428f1624cf0b51384dfcdfbdfab3cc42a4 feat: migration idempotency, file attribution DAG walk, mpa… Sonnet 4.6 minor 9 days ago