Source code for thoth.storages.data.alembic.versions.a7442899ef28_add_indexes_needed_for_revsolver

"""Add indexes needed for revsolver

Revision ID: a7442899ef28
Revises: ecb0ca258835
Create Date: 2020-04-21 19:19:43.848258+00:00

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "a7442899ef28"
down_revision = "ecb0ca258835"
branch_labels = None
depends_on = None


[docs]def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_index("depends_on_entity_id_idx", "depends_on", ["entity_id"], unique=False) op.create_index( "python_package_version_environment_idx", "python_package_version", ["os_name", "os_version", "python_version"], unique=False, ) op.create_index( "python_package_version_entity_package_name_idx", "python_package_version_entity", ["package_name"], unique=False, )
# ### end Alembic commands ###
[docs]def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_index("python_package_version_entity_package_name_idx", table_name="python_package_version_entity") op.drop_index("python_package_version_environment_idx", table_name="python_package_version") op.drop_index("depends_on_entity_id_idx", table_name="depends_on")
# ### end Alembic commands ###