"""cascade product conversion cleanup with units

Revision ID: 9fa42b6c31e7
Revises: 8ed7e92275d5
"""
from alembic import op

revision = "9fa42b6c31e7"
down_revision = "8ed7e92275d5"
branch_labels = None
depends_on = None

def upgrade():
    op.drop_constraint("product_unit_conversions_unit_id_fkey", "product_unit_conversions", type_="foreignkey")
    op.create_foreign_key("product_unit_conversions_unit_id_fkey", "product_unit_conversions", "units", ["unit_id"], ["id"], ondelete="CASCADE")

def downgrade():
    op.drop_constraint("product_unit_conversions_unit_id_fkey", "product_unit_conversions", type_="foreignkey")
    op.create_foreign_key("product_unit_conversions_unit_id_fkey", "product_unit_conversions", "units", ["unit_id"], ["id"], ondelete="RESTRICT")