def downgrade()

in src/dispatch/database/revisions/tenant/versions/2022-09-09_4452426c6905.py [0:0]

• 64 lines of code
• 1 McCabe index (conditional complexity)

def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, "case", type_="foreignkey")
    op.drop_constraint(None, "case", type_="foreignkey")
    op.drop_constraint(None, "case", type_="foreignkey")
    op.drop_column("case", "case_priority_id")
    op.drop_column("case", "case_severity_id")
    op.drop_column("case", "case_type_id")
    op.create_table(
        "assoc_case_case_severity",
        sa.Column("case_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("case_severity_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("created_at", postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
        sa.Column("id", sa.INTEGER(), autoincrement=True, nullable=False),
        sa.ForeignKeyConstraint(
            ["case_id"],
            ["case.id"],
            name="assoc_case_case_severity_case_id_fkey",
            ondelete="CASCADE",
        ),
        sa.ForeignKeyConstraint(
            ["case_severity_id"],
            ["case_severity.id"],
            name="assoc_case_case_severity_case_severity_id_fkey",
            ondelete="CASCADE",
        ),
        sa.PrimaryKeyConstraint("id", name="assoc_case_case_severity_pkey"),
    )
    op.create_table(
        "assoc_case_case_priority",
        sa.Column("case_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("case_priority_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("created_at", postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
        sa.Column("id", sa.INTEGER(), autoincrement=True, nullable=False),
        sa.ForeignKeyConstraint(
            ["case_id"],
            ["case.id"],
            name="assoc_case_case_priority_case_id_fkey",
            ondelete="CASCADE",
        ),
        sa.ForeignKeyConstraint(
            ["case_priority_id"],
            ["case_priority.id"],
            name="assoc_case_case_priority_case_priority_id_fkey",
            ondelete="CASCADE",
        ),
        sa.PrimaryKeyConstraint("id", name="assoc_case_case_priority_pkey"),
    )
    op.create_table(
        "assoc_case_case_type",
        sa.Column("case_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("case_type_id", sa.INTEGER(), autoincrement=False, nullable=False),
        sa.Column("created_at", postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
        sa.Column("id", sa.INTEGER(), autoincrement=True, nullable=False),
        sa.ForeignKeyConstraint(
            ["case_id"], ["case.id"], name="assoc_case_case_type_case_id_fkey", ondelete="CASCADE"
        ),
        sa.ForeignKeyConstraint(
            ["case_type_id"],
            ["case_type.id"],
            name="assoc_case_case_type_case_type_id_fkey",
            ondelete="CASCADE",
        ),
        sa.PrimaryKeyConstraint("id", name="assoc_case_case_type_pkey"),
    )