def upgrade()

in migrations/versions/da6767746e76_add_more_db_indexes.py [0:0]

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

def upgrade():
    op.create_index(
        op.f("ix_column_metadata_exists"), "column_metadata", ["exists"], unique=False
    )
    op.create_index(
        op.f("ix_column_metadata_name"), "column_metadata", ["name"], unique=False
    )
    op.create_index(
        op.f("ix_column_metadata_table_id"),
        "column_metadata",
        ["table_id"],
        unique=False,
    )
    op.create_index(
        "ix_column_metadata_table_id_exists",
        "column_metadata",
        ["table_id", "exists"],
        unique=False,
    )
    op.create_index(
        "ix_column_metadata_table_id_name_exists",
        "column_metadata",
        ["table_id", "exists", "name"],
        unique=False,
    )
    op.create_index(
        "ix_column_metadata_table_id_pkey",
        "column_metadata",
        ["table_id", "id"],
        unique=False,
    )
    op.create_index(
        op.f("ix_table_metadata_data_source_id"),
        "table_metadata",
        ["data_source_id"],
        unique=False,
    )
    op.create_index(
        "ix_table_metadata_data_source_id_exists",
        "table_metadata",
        ["data_source_id", "exists"],
        unique=False,
    )
    op.create_index(
        "ix_table_metadata_data_source_id_name_exists",
        "table_metadata",
        ["data_source_id", "exists", "name"],
        unique=False,
    )
    op.create_index(
        op.f("ix_table_metadata_exists"), "table_metadata", ["exists"], unique=False
    )
    op.create_index(
        op.f("ix_table_metadata_name"), "table_metadata", ["name"], unique=False
    )
    op.create_index(
        op.f("ix_table_metadata_sample_updated_at"),
        "table_metadata",
        ["sample_updated_at"],
        unique=False,
    )