Coverage for slidge/db/alembic/versions/4681a639c030_avatars_served_via_http.py: 70%

1"""avatars served via HTTP 

2 

3Revision ID: 4681a639c030 

4Revises: 211345c68f0b 

5Create Date: 2026-08-23 05:54:07.276008 

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 = "4681a639c030" 

16down_revision: str | None = "211345c68f0b" 

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

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

19 

20 

21def upgrade() -> None: 

22 with op.batch_alter_table("avatar", schema=None) as batch_op: 

23 batch_op.add_column(sa.Column("http_id", sa.String(), nullable=True)) 

24 batch_op.add_column(sa.Column("http_type", sa.String(), nullable=True)) 

25 batch_op.add_column(sa.Column("http_bytes", sa.Integer(), nullable=True)) 

26 batch_op.add_column(sa.Column("http_url", sa.String(), nullable=True)) 

27 batch_op.add_column(sa.Column("http_height", sa.Integer(), nullable=True)) 

28 batch_op.add_column(sa.Column("http_width", sa.Integer(), nullable=True)) 

29 

30 

31def downgrade() -> None: 

32 with op.batch_alter_table("avatar", schema=None) as batch_op: 

33 batch_op.drop_column("http_width") 

34 batch_op.drop_column("http_height") 

35 batch_op.drop_column("http_url") 

36 batch_op.drop_column("http_bytes") 

37 batch_op.drop_column("http_type") 

38 batch_op.drop_column("http_id")