def downgrade()

in src/dispatch/database/revisions/tenant/versions/2022-10-27_01aa49ca0470.py [0:0]

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

def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        "suppression_rule",
        sa.Column("search_vector", postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "suppression_rule", sa.Column("name", sa.VARCHAR(), autoincrement=False, nullable=True)
    )
    op.add_column(
        "suppression_rule",
        sa.Column("description", sa.VARCHAR(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "suppression_rule",
        sa.Column("creator_id", sa.INTEGER(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "suppression_rule",
        sa.Column(
            "expression",
            postgresql.JSON(astext_type=sa.Text()),
            autoincrement=False,
            nullable=False,
        ),
    )
    op.create_foreign_key(
        "suppression_rule_creator_id_fkey",
        "suppression_rule",
        "dispatch_user",
        ["creator_id"],
        ["id"],
        referent_schema="dispatch_core",
    )
    op.create_index(
        "suppression_rule_search_vector_idx", "suppression_rule", ["search_vector"], unique=False
    )
    op.create_unique_constraint(
        "suppression_rule_name_project_id_key", "suppression_rule", ["name", "project_id"]
    )
    op.add_column(
        "plugin_instance",
        sa.Column(
            "configuration",
            postgresql.JSON(astext_type=sa.Text()),
            autoincrement=False,
            nullable=True,
        ),
    )
    op.add_column(
        "duplication_rule",
        sa.Column("search_vector", postgresql.TSVECTOR(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "duplication_rule", sa.Column("name", sa.VARCHAR(), autoincrement=False, nullable=True)
    )
    op.add_column(
        "duplication_rule",
        sa.Column("description", sa.VARCHAR(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "duplication_rule",
        sa.Column("creator_id", sa.INTEGER(), autoincrement=False, nullable=True),
    )
    op.add_column(
        "duplication_rule",
        sa.Column(
            "expression",
            postgresql.JSON(astext_type=sa.Text()),
            autoincrement=False,
            nullable=False,
        ),
    )
    op.create_foreign_key(
        "duplication_rule_creator_id_fkey",
        "duplication_rule",
        "dispatch_user",
        ["creator_id"],
        ["id"],
        referent_schema="dispatch_core",
    )
    op.create_index(
        "duplication_rule_search_vector_idx", "duplication_rule", ["search_vector"], unique=False
    )
    op.create_unique_constraint(
        "duplication_rule_name_project_id_key", "duplication_rule", ["name", "project_id"]
    )
    op.drop_column("duplication_rule", "window")
    op.drop_table("assoc_signal_instance_tags")
    op.drop_table("signal_instance")
    op.drop_index("signal_search_vector_idx", table_name="signal", postgresql_using="gin")
    op.drop_table("signal")
    op.drop_table("assoc_suppression_rule_tags")
    op.drop_table("assoc_duplication_rule_tag_types")