gabriel / musehub public
0011_coupling_indexes.py python
34 lines 788 B
Raw
sha256:c2e5cf2d754ed2fe9a94e879d41ad12ff221d2ac4ac7b45247fcb981c76858bf docs: Section 8 database/migrations/backups — verified live… Sonnet 5 24 days ago
1 """coupling: add co_changes + file_a indexes to musehub_intel_coupling
2
3 Revision ID: 0011
4 Revises: 0010
5 """
6
7 from __future__ import annotations
8
9 from typing import Union
10
11 from alembic import op
12
13 revision: str = "0011"
14 down_revision: Union[str, None] = "0010"
15 branch_labels = None
16 depends_on = None
17
18
19 def upgrade() -> None:
20 op.create_index(
21 "ix_intel_coupling_repo_co",
22 "musehub_intel_coupling",
23 ["repo_id", "co_changes"],
24 )
25 op.create_index(
26 "ix_intel_coupling_repo_file_a",
27 "musehub_intel_coupling",
28 ["repo_id", "file_a"],
29 )
30
31
32 def downgrade() -> None:
33 op.drop_index("ix_intel_coupling_repo_file_a", table_name="musehub_intel_coupling")
34 op.drop_index("ix_intel_coupling_repo_co", table_name="musehub_intel_coupling")
File History 2 commits
sha256:c2e5cf2d754ed2fe9a94e879d41ad12ff221d2ac4ac7b45247fcb981c76858bf docs: Section 8 database/migrations/backups — verified live… Sonnet 5 24 days ago
sha256:80e1a60a39562f6e616aaafbb27487f03abbec7d8ffc6164302b7a0c0bfc63ee docs: check off Section 0 items verified in inventory doc, … Sonnet 5 24 days ago