2024060210_stop_cascade_template_deletion_to_slot_8fee990845df.py 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. """stop cascade template deletion to slot
  2. Revision ID: 8fee990845df
  3. Revises: eabd3ad5aaf8
  4. Create Date: 2024-06-02 17:10:22.363720
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = "8fee990845df"
  10. down_revision = "eabd3ad5aaf8"
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. # ### commands auto generated by Alembic - please adjust! ###
  15. op.drop_constraint("slots_template_id_fkey_v2", "slots", type_="foreignkey")
  16. op.create_foreign_key(
  17. "slots_template_id_fkey_v3",
  18. "slots",
  19. "slot_templates",
  20. ["template_id"],
  21. ["id"],
  22. ondelete="SET NULL",
  23. )
  24. # ### end Alembic commands ###
  25. def downgrade():
  26. # ### commands auto generated by Alembic - please adjust! ###
  27. op.drop_constraint("slots_template_id_fkey_v3", "slots", type_="foreignkey")
  28. op.create_foreign_key(
  29. "slots_template_id_fkey_v2",
  30. "slots",
  31. "slot_templates",
  32. ["template_id"],
  33. ["id"],
  34. ondelete="CASCADE",
  35. )
  36. # ### end Alembic commands ###