Aucune description

a3eb60654ec4_add_cases_status.py 706B

1234567891011121314151617181920212223242526272829303132333435
  1. """Add cases status
  2. Revision ID: a3eb60654ec4
  3. Revises: 3204e9116233
  4. Create Date: 2022-11-10 07:52:22.502834
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. from sqlalchemy import Integer
  9. from sqlalchemy import text
  10. from app.alembic.alembic_utils import _table_has_column
  11. # revision identifiers, used by Alembic.
  12. revision = 'a3eb60654ec4'
  13. down_revision = '3204e9116233'
  14. branch_labels = None
  15. depends_on = None
  16. def upgrade():
  17. if not _table_has_column('cases', 'status_id'):
  18. op.add_column('cases',
  19. sa.Column('status_id', Integer, server_default=text("0"),
  20. nullable=False)
  21. )
  22. pass
  23. def downgrade():
  24. pass