Coverage for slidge/db/alembic/versions/b597d84d17dc_more_muc_room_renaming.py: 86%

1"""more muc→room renaming 

2 

3Revision ID: b597d84d17dc 

4Revises: 5dd33faac9e0 

5Create Date: 2026-10-25 07:59:53.729177 

6 

7""" 

8 

9from collections.abc import Sequence 

10 

11import sqlalchemy as sa 

12from alembic import op 

13 

14# revision identifiers, used by Alembic. 

15revision: str = "b597d84d17dc" 

16down_revision: str | None = "5dd33faac9e0" 

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

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

19 

20 

21def upgrade() -> None: 

22 if op.get_bind().dialect.name == "postgresql": 

23 op.execute("ALTER TYPE muctype RENAME TO roomtype") 

24 

25 with op.batch_alter_table("room", schema=None) as batch_op: 

26 batch_op.alter_column( 

27 "muc_type", 

28 new_column_name="type", 

29 existing_type=sa.Enum( 

30 "GROUP", "CHANNEL", "CHANNEL_NON_ANONYMOUS", name="muctype" 

31 ), 

32 existing_nullable=False, 

33 ) 

34 

35 

36def downgrade() -> None: 

37 raise RuntimeError("downgrades are not supported")