Source code for thoth.storages.data.alembic.versions.6389973bd8b6_remove_package_analyzer

"""Remove package-analyzer

Revision ID: 6389973bd8b6
Revises: 84588707e6ba
Create Date: 2020-09-14 08:31:09.089734+00:00

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = "6389973bd8b6"
down_revision = "84588707e6ba"
branch_labels = None
depends_on = None


[docs]def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_table("investigated") op.drop_table("investigated_file") op.drop_table("package_analyzer_run")
# ### end Alembic commands ###
[docs]def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "investigated_file", sa.Column("package_analyzer_run_id", sa.INTEGER(), autoincrement=False, nullable=False), sa.Column("python_file_digest_id", sa.INTEGER(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint( ["package_analyzer_run_id"], ["package_analyzer_run.id"], name="investigated_file_package_analyzer_run_id_fkey", ondelete="CASCADE", ), sa.ForeignKeyConstraint( ["python_file_digest_id"], ["python_file_digest.id"], name="investigated_file_python_file_digest_id_fkey", ondelete="CASCADE", ), ) op.create_table( "package_analyzer_run", sa.Column( "id", sa.INTEGER(), server_default=sa.text("nextval('package_analyzer_run_id_seq'::regclass)"), autoincrement=True, nullable=False, ), sa.Column("package_analyzer_name", sa.TEXT(), autoincrement=False, nullable=True), sa.Column("package_analyzer_version", sa.TEXT(), autoincrement=False, nullable=True), sa.Column("package_analysis_document_id", sa.TEXT(), autoincrement=False, nullable=False), sa.Column("datetime", postgresql.TIMESTAMP(), autoincrement=False, nullable=False), sa.Column("debug", sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column("package_analyzer_error", sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column("duration", sa.INTEGER(), autoincrement=False, nullable=True), sa.Column("input_python_package_version_entity_id", sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint( ["input_python_package_version_entity_id"], ["python_package_version_entity.id"], name="package_analyzer_run_input_python_package_version_entity_i_fkey", ondelete="CASCADE", ), sa.PrimaryKeyConstraint("id", name="package_analyzer_run_pkey"), postgresql_ignore_search_path=False, ) op.create_table( "investigated", sa.Column("package_analyzer_run_id", sa.INTEGER(), autoincrement=False, nullable=False), sa.Column("python_artifact_id", sa.INTEGER(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint( ["package_analyzer_run_id"], ["package_analyzer_run.id"], name="investigated_package_analyzer_run_id_fkey", ondelete="CASCADE", ), sa.ForeignKeyConstraint( ["python_artifact_id"], ["python_artifact.id"], name="investigated_python_artifact_id_fkey", ondelete="CASCADE", ), )
# ### end Alembic commands ###