Нет описания

e33dd011fb87_resolution_status_in_alerts.py 755B

12345678910111213141516171819202122232425262728293031
  1. """resolution status in alerts
  2. Revision ID: e33dd011fb87
  3. Revises: 00b43bc4e8ac
  4. Create Date: 2023-07-03 13:28:08.882759
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. from app.alembic.alembic_utils import _table_has_column
  9. # revision identifiers, used by Alembic.
  10. revision = 'e33dd011fb87'
  11. down_revision = '00b43bc4e8ac'
  12. branch_labels = None
  13. depends_on = None
  14. def upgrade():
  15. if not _table_has_column('alerts', 'alert_resolution_status_id'):
  16. op.add_column('alerts', sa.Column('alert_resolution_status_id', sa.Integer(), nullable=True))
  17. op.create_foreign_key(None, 'alerts', 'alert_resolution_status',
  18. ['alert_resolution_status_id'], ['resolution_status_id'])
  19. pass
  20. def downgrade():
  21. pass