Geen omschrijving

b664ca1203a4_add_dark_mode.py 883B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. """Add dark mode
  2. Revision ID: b664ca1203a4
  3. Revises: 2df770a4989c
  4. Create Date: 2022-03-06 18:00:46.251407
  5. """
  6. import sqlalchemy as sa
  7. from alembic import op
  8. from app.alembic.alembic_utils import _table_has_column
  9. # revision identifiers, used by Alembic.
  10. revision = 'b664ca1203a4'
  11. down_revision = '2df770a4989c'
  12. branch_labels = None
  13. depends_on = None
  14. def upgrade():
  15. if not _table_has_column('user', 'in_dark_mode'):
  16. op.add_column('user',
  17. sa.Column('in_dark_mode', sa.Boolean)
  18. )
  19. t_ua = sa.Table(
  20. 'user',
  21. sa.MetaData(),
  22. sa.Column('id', sa.Integer, primary_key=True),
  23. sa.Column('in_dark_mode', sa.Boolean)
  24. )
  25. conn = op.get_bind()
  26. conn.execute(t_ua.update().values(
  27. in_dark_mode=False
  28. ))
  29. pass
  30. def downgrade():
  31. pass