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

1"""Add 'occupant_id' column to Participant 

2 

3Revision ID: b7a06a86416a 

4Revises: 86d980dbb426 

5Create Date: 2025-12-14 21:39:45.025086 

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 = "b7a06a86416a" 

16down_revision: str | None = "86d980dbb426" 

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

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

19 

20 

21def upgrade() -> None: 

22 op.execute("DELETE FROM participant") 

23 # ### commands auto generated by Alembic - please adjust! ### 

24 with op.batch_alter_table("participant", schema=None) as batch_op: 

25 batch_op.add_column(sa.Column("occupant_id", sa.String(), nullable=False)) 

26 # ### end Alembic commands ### 

27 

28 

29def downgrade() -> None: 

30 # ### commands auto generated by Alembic - please adjust! ### 

31 with op.batch_alter_table("participant", schema=None) as batch_op: 

32 batch_op.drop_column("occupant_id") 

33 # ### end Alembic commands ###