Coverage for slidge/db/alembic/versions/7d21996a1605_add_mam_timestamp_index.py: 91%

1"""add mam timestamp index 

2 

3Revision ID: 7d21996a1605 

4Revises: f213312053f2 

5Create Date: 2026-09-17 22:26:51.578872 

6 

7""" 

8 

9from collections.abc import Sequence 

10 

11from alembic import op 

12 

13# revision identifiers, used by Alembic. 

14revision: str = "7d21996a1605" 

15down_revision: str | None = "f213312053f2" 

16branch_labels: str | Sequence[str] | None = None 

17depends_on: str | Sequence[str] | None = None 

18 

19 

20def upgrade() -> None: 

21 with op.batch_alter_table("mam", schema=None) as batch_op: 

22 batch_op.create_index( 

23 "ix_mam_room_id_timestamp", ["room_id", "timestamp"], unique=False 

24 ) 

25 

26 

27def downgrade() -> None: 

28 raise RuntimeError("downgrades are not supported")