gabriel / musehub public
0033_symbol_intel_blast_index.py python
31 lines 810 B
Raw
sha256:1dd27e6d5c24550177b01b0a171e8375c07cf046b549e7683364706b6522d3bc docs(#139): mark all 11 checklist items resolved, document … Sonnet 5 12 days ago
1 """Add (repo_id, blast DESC) index on musehub_symbol_intel for blast-leader card query.
2
3 The DISTINCT ON (repo_id) ORDER BY repo_id, blast DESC query used by
4 enrich_repo_cards() needs this index to avoid a sequential scan when
5 fetching the top blast symbol per repo across a batch of repo IDs.
6
7 Revision ID: 0033
8 Revises: 0032
9 """
10 from __future__ import annotations
11
12 from alembic import op
13 import sqlalchemy as sa
14
15 revision = "0033"
16 down_revision = "0032"
17 branch_labels = None
18 depends_on = None
19
20
21 def upgrade() -> None:
22 op.create_index(
23 "ix_symbol_intel_repo_blast",
24 "musehub_symbol_intel",
25 ["repo_id", sa.text("blast DESC NULLS LAST")],
26 if_not_exists=True,
27 )
28
29
30 def downgrade() -> None:
31 op.drop_index("ix_symbol_intel_repo_blast", table_name="musehub_symbol_intel")
File History 2 commits
sha256:1dd27e6d5c24550177b01b0a171e8375c07cf046b549e7683364706b6522d3bc docs(#139): mark all 11 checklist items resolved, document … Sonnet 5 12 days ago
sha256:649011bedd713e22f7dca4c4be94bdefbf3b10950d9fc80235928d0b0b823be8 docs: track issue #139 (two-column app-shell refactor) plan… Sonnet 5 12 days ago