Source code for thoth.storages.data.alembic.versions.9168881dd125_initial_schema

"""Initial schema

Revision ID: 9168881dd125
Revises:
Create Date: 2019-09-19 11:56:44.670642+00:00

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

# revision identifiers, used by Alembic.
revision = "9168881dd125"
down_revision = None
branch_labels = None
depends_on = None


[docs]def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "cve", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("advisory", sa.String(length=16384), nullable=True), sa.Column("cve_name", sa.String(length=256), nullable=True), sa.Column("cve_id", sa.String(length=256), nullable=True), sa.Column("version_range", sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint("id"), ) op.create_table( "deb_dependency", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_name", sa.String(length=256), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "deb_package_version", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_name", sa.String(length=256), nullable=False), sa.Column("package_version", sa.String(length=256), nullable=False), sa.Column("epoch", sa.String(length=256), nullable=True), sa.Column("arch", sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint("id"), ) op.create_table( "ecosystem_solver", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("ecosystem", sa.String(length=256), nullable=False), sa.Column("solver_name", sa.String(length=256), nullable=False), sa.Column("solver_version", sa.String(length=16), nullable=False), sa.Column("os_name", sa.String(length=128), nullable=False), sa.Column("os_version", sa.String(length=8), nullable=False), sa.Column("python_version", sa.String(length=8), nullable=False), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("ecosystem", "solver_name", "solver_version", "os_name", "os_version", "python_version"), ) op.create_index( "ecosystem_solver_idx", "ecosystem_solver", ["ecosystem", "solver_name", "solver_version", "os_name", "os_version", "python_version"], unique=True, ) op.create_table( "hardware_information", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("cpu_vendor", sa.Integer(), nullable=True), sa.Column("cpu_model", sa.Integer(), nullable=True), sa.Column("cpu_cores", sa.Integer(), nullable=True), sa.Column("cpu_model_name", sa.String(length=256), nullable=True), sa.Column("cpu_family", sa.Integer(), nullable=True), sa.Column("cpu_physical_cpus", sa.Integer(), nullable=True), sa.Column("gpu_model_name", sa.String(length=256), nullable=True), sa.Column("gpu_vendor", sa.String(length=256), nullable=True), sa.Column("gpu_cores", sa.Integer(), nullable=True), sa.Column("gpu_memory_size", sa.Integer(), nullable=True), sa.Column("ram_size", sa.Integer(), nullable=True), sa.Column("is_user", sa.Boolean(), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "python_artifact", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("artifact_hash_sha256", sa.String(length=256), nullable=False), sa.Column("artifact_name", sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint("id"), ) op.create_table( "python_file_digest", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("sha256", sa.String(length=256), nullable=False), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("sha256"), ) op.create_index("sha256_idx", "python_file_digest", ["sha256"], unique=True) op.create_table( "python_package_index", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("url", sa.String(length=256), nullable=False), sa.Column("warehouse_api_url", sa.String(length=256), nullable=True), sa.Column("verify_ssl", sa.Boolean(), nullable=False), sa.Column("enabled", sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("url"), ) op.create_index("url_idx", "python_package_index", ["url"], unique=True) op.create_table( "python_software_stack", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column( "software_stack_type", postgresql.ENUM("USER", "INSPECTION", "ADVISED", name="software_stack_type"), nullable=True, ), sa.Column("performance_score", sa.Float(), nullable=True), sa.Column("overall_score", sa.Float(), nullable=True), sa.PrimaryKeyConstraint("id"), ) op.create_table( "rpm_package_version", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_name", sa.String(length=256), nullable=False), sa.Column("package_version", sa.String(length=256), nullable=False), sa.Column("release", sa.String(length=256), nullable=True), sa.Column("epoch", sa.String(length=256), nullable=True), sa.Column("arch", sa.String(length=256), nullable=True), sa.Column("src", sa.Boolean(), nullable=True), sa.Column("package_identifier", sa.String(length=256), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "rpm_requirement", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("rpm_requirement_name", sa.String(length=256), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "software_environment", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("environment_name", sa.String(length=256), nullable=True), sa.Column("python_version", sa.String(length=256), nullable=True), sa.Column("image_name", sa.String(length=256), nullable=True), sa.Column("image_sha", sa.String(length=256), nullable=True), sa.Column("os_name", sa.String(length=256), nullable=True), sa.Column("os_version", sa.String(length=256), nullable=True), sa.Column("cuda_version", sa.String(length=256), nullable=True), sa.Column("environment_type", postgresql.ENUM("RUNTIME", "BUILDTIME", name="environment_type"), nullable=False), sa.Column("is_user", sa.Boolean(), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "versioned_symbol", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("library_name", sa.String(length=256), nullable=False), sa.Column("symbol", sa.String(length=256), nullable=False), sa.PrimaryKeyConstraint("id"), ) op.create_table( "adviser_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("adviser_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("adviser_version", sa.String(length=256), nullable=False), sa.Column("adviser_name", sa.String(length=256), nullable=False), sa.Column("count", sa.Integer(), nullable=True), sa.Column("limit", sa.Integer(), nullable=True), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("debug", sa.Boolean(), nullable=False), sa.Column("limit_latest_versions", sa.Integer(), nullable=False), sa.Column("adviser_error", sa.Boolean(), nullable=False), sa.Column( "recommendation_type", postgresql.ENUM("STABLE", "TESTING", "LATEST", name="recommendation_type"), nullable=False, ), sa.Column("requirements_format", postgresql.ENUM("PIPENV", name="requirements_format"), nullable=False), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("advised_configuration_changes", sa.Boolean(), nullable=False), sa.Column("additional_stack_info", sa.Boolean(), nullable=False), sa.Column("user_run_software_environment_id", sa.Integer(), nullable=True), sa.Column("user_build_software_environment_id", sa.Integer(), nullable=True), sa.Column("user_software_stack_id", sa.Integer(), nullable=True), sa.Column("hardware_information_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["hardware_information_id"], ["hardware_information.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint( ["user_build_software_environment_id"], ["software_environment.id"], ondelete="CASCADE" ), sa.ForeignKeyConstraint(["user_run_software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["user_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_table( "deb_depends", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("version_range", sa.String(length=256), nullable=False), sa.Column("deb_dependency_id", sa.Integer(), nullable=False), sa.Column("deb_package_version_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["deb_dependency_id"], ["deb_dependency.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["deb_package_version_id"], ["deb_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "deb_dependency_id", "deb_package_version_id"), ) op.create_table( "deb_pre_depends", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("deb_dependency_id", sa.Integer(), nullable=False), sa.Column("deb_package_version_id", sa.Integer(), nullable=False), sa.Column("version_range", sa.String(length=256), nullable=True), sa.ForeignKeyConstraint(["deb_dependency_id"], ["deb_dependency.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["deb_package_version_id"], ["deb_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "deb_dependency_id", "deb_package_version_id"), ) op.create_table( "deb_replaces", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("deb_dependency_id", sa.Integer(), nullable=False), sa.Column("deb_package_version_id", sa.Integer(), nullable=False), sa.Column("version_range", sa.String(length=256), nullable=False), sa.ForeignKeyConstraint(["deb_dependency_id"], ["deb_dependency.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["deb_package_version_id"], ["deb_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "deb_dependency_id", "deb_package_version_id"), ) op.create_table( "dependency_monkey_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("dependency_monkey_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("dependency_monkey_name", sa.String(length=256), nullable=False), sa.Column("dependency_monkey_version", sa.String(length=256), nullable=False), sa.Column("seed", sa.Integer(), nullable=True), sa.Column("decision", sa.String(length=64), nullable=False), sa.Column("count", sa.Integer(), nullable=True), sa.Column("limit_latest_versions", sa.Integer(), nullable=True), sa.Column("debug", sa.Boolean(), nullable=True), sa.Column("dependency_monkey_error", sa.Boolean(), nullable=True), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("run_software_environment_id", sa.Integer(), nullable=True), sa.Column("build_software_environment_id", sa.Integer(), nullable=True), sa.Column("run_hardware_information_id", sa.Integer(), nullable=True), sa.Column("build_hardware_information_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["build_hardware_information_id"], ["hardware_information.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["build_software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["run_hardware_information_id"], ["hardware_information.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["run_software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_table( "has_symbol", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("software_environment_id", sa.Integer(), nullable=False), sa.Column("versioned_symbol_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["versioned_symbol_id"], ["versioned_symbol.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "software_environment_id", "versioned_symbol_id"), ) op.create_table( "included_file", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("file", sa.String(length=256), nullable=False), sa.Column("python_file_digest_id", sa.Integer(), nullable=False), sa.Column("python_artifact_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["python_artifact_id"], ["python_artifact.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_file_digest_id"], ["python_file_digest.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_file_digest_id", "python_artifact_id"), ) op.create_table( "package_extract_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_extract_name", sa.String(length=256), nullable=False), sa.Column("package_extract_version", sa.String(length=256), nullable=False), sa.Column("analysis_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("environment_type", postgresql.ENUM("RUNTIME", "BUILDTIME", name="environment_type"), nullable=False), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("debug", sa.Boolean(), nullable=False), sa.Column("package_extract_error", sa.Boolean(), nullable=False), sa.Column("image_tag", sa.String(length=256), nullable=False), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("os_name", sa.String(length=256), nullable=False), sa.Column("os_id", sa.String(length=256), nullable=False), sa.Column("os_version_id", sa.String(length=256), nullable=False), sa.Column("software_environment_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_table( "provenance_checker_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("provenance_checker_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("provenance_checker_version", sa.String(length=256), nullable=False), sa.Column("provenance_checker_name", sa.String(length=256), nullable=False), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("debug", sa.Boolean(), nullable=False), sa.Column("provenance_checker_error", sa.Boolean(), nullable=False), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("user_software_stack_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["user_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "user_software_stack_id"), ) op.create_table( "python_package_requirement", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("name", sa.String(length=256), nullable=False), sa.Column("version_range", sa.String(length=256), nullable=False), sa.Column("develop", sa.Boolean(), nullable=False), sa.Column("python_package_index_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["python_package_index_id"], ["python_package_index.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_table( "python_package_version_entity", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_name", sa.String(length=256), nullable=False), sa.Column("package_version", sa.String(length=256), nullable=True), sa.Column("python_package_index_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["python_package_index_id"], ["python_package_index.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("id"), sa.UniqueConstraint("package_name", "package_version", "python_package_index_id"), ) op.create_index( "python_package_version_entity_idx", "python_package_version_entity", ["package_name", "package_version", "python_package_index_id"], unique=True, ) op.create_table( "requires_symbol", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_artifact_id", sa.Integer(), nullable=False), sa.Column("versioned_symbol_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["python_artifact_id"], ["python_artifact.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["versioned_symbol_id"], ["versioned_symbol.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_artifact_id", "versioned_symbol_id"), ) op.create_table( "rpm_requires", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("rpm_package_version_id", sa.Integer(), nullable=False), sa.Column("rpm_requirement_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["rpm_package_version_id"], ["rpm_package_version.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["rpm_requirement_id"], ["rpm_requirement.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "rpm_package_version_id", "rpm_requirement_id"), ) op.create_table( "advised", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("adviser_run_id", sa.Integer(), nullable=True), sa.Column("python_software_stack_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["adviser_run_id"], ["adviser_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), ) op.create_table( "detected_symbol", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_extract_run_id", sa.Integer(), nullable=False), sa.Column("versioned_symbol_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_extract_run_id"], ["package_extract_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["versioned_symbol_id"], ["versioned_symbol.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "package_extract_run_id", "versioned_symbol_id"), ) op.create_table( "found_deb", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("deb_package_version_id", sa.Integer(), nullable=False), sa.Column("package_extract_run_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["deb_package_version_id"], ["deb_package_version.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["package_extract_run_id"], ["package_extract_run.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "deb_package_version_id", "package_extract_run_id"), ) op.create_table( "found_python_file", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("file", sa.String(length=256), nullable=False), sa.Column("python_file_digest_id", sa.Integer(), nullable=False), sa.Column("package_extract_run_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_extract_run_id"], ["package_extract_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_file_digest_id"], ["python_file_digest.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_file_digest_id", "package_extract_run_id"), ) op.create_table( "found_rpm", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("rpm_package_version_id", sa.Integer(), nullable=False), sa.Column("package_extract_run_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_extract_run_id"], ["package_extract_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["rpm_package_version_id"], ["rpm_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "rpm_package_version_id", "package_extract_run_id"), ) op.create_table( "has_vulnerability", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_package_version_entity_id", sa.Integer(), nullable=False), sa.Column("cve_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["cve_id"], ["cve.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint( ["python_package_version_entity_id"], ["python_package_version_entity.id"], ondelete="CASCADE" ), sa.PrimaryKeyConstraint("id", "python_package_version_entity_id", "cve_id"), ) op.create_table( "inspection_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("inspection_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=True), sa.Column("amun_version", sa.String(length=256), nullable=True), sa.Column("build_requests_cpu", sa.Float(), nullable=True), sa.Column("build_requests_memory", sa.Float(), nullable=True), sa.Column("run_requests_cpu", sa.Float(), nullable=True), sa.Column("run_requests_memory", sa.Float(), nullable=True), sa.Column( "inspection_sync_state", postgresql.ENUM("PENDING", "SYNCED", name="inspection_sync_state"), nullable=False ), sa.Column("build_hardware_information_id", sa.Integer(), nullable=True), sa.Column("run_hardware_information_id", sa.Integer(), nullable=True), sa.Column("build_software_environment_id", sa.Integer(), nullable=True), sa.Column("run_software_environment_id", sa.Integer(), nullable=True), sa.Column("dependency_monkey_run_id", sa.Integer(), nullable=True), sa.Column("inspection_software_stack_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["build_hardware_information_id"], ["hardware_information.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["build_software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["dependency_monkey_run_id"], ["dependency_monkey_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["inspection_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["run_hardware_information_id"], ["hardware_information.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["run_software_environment_id"], ["software_environment.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("inspection_document_id"), ) op.create_table( "package_analyzer_run", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_analyzer_name", sa.String(length=256), nullable=True), sa.Column("package_analyzer_version", sa.String(length=256), nullable=True), sa.Column("package_analysis_document_id", sa.String(length=256), nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("debug", sa.Boolean(), nullable=False), sa.Column("package_analyzer_error", sa.Boolean(), nullable=False), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("input_python_package_version_entity_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ["input_python_package_version_entity_id"], ["python_package_version_entity.id"], ondelete="CASCADE" ), sa.PrimaryKeyConstraint("id"), ) op.create_table( "python_dependency_monkey_requirements", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_package_requirement_id", sa.Integer(), nullable=False), sa.Column("dependency_monkey_run_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["dependency_monkey_run_id"], ["dependency_monkey_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint( ["python_package_requirement_id"], ["python_package_requirement.id"], ondelete="CASCADE" ), sa.PrimaryKeyConstraint("id", "python_package_requirement_id", "dependency_monkey_run_id"), ) op.create_table( "python_package_version", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_name", sa.String(length=256), nullable=False), sa.Column("package_version", sa.String(length=256), nullable=False), sa.Column("os_name", sa.String(length=256), nullable=True), sa.Column("os_version", sa.String(length=256), nullable=True), sa.Column("python_version", sa.String(length=256), nullable=True), sa.Column("entity_id", sa.Integer(), nullable=False), sa.Column("python_package_index_id", sa.Integer(), nullable=True), sa.ForeignKeyConstraint(["entity_id"], ["python_package_version_entity.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_package_index_id"], ["python_package_index.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint( "package_name", "package_version", "python_package_index_id", "os_name", "os_version", "python_version" ), ) op.create_index( "python_package_version_idx", "python_package_version", ["package_name", "package_version", "python_package_index_id"], unique=False, ) op.create_index( "python_package_version_index_idx_10", "python_package_version", ["package_name", "package_version", "python_package_index_id", "python_package_index_id"], unique=False, ) op.create_index( "python_package_version_index_idx_11", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_name"], unique=False, ) op.create_index( "python_package_version_index_idx_12", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_version"], unique=False, ) op.create_index( "python_package_version_index_idx_13", "python_package_version", ["package_name", "package_version", "python_package_index_id", "python_version"], unique=False, ) op.create_index( "python_package_version_index_idx_20", "python_package_version", ["package_name", "package_version", "python_package_index_id", "python_package_index_id", "os_name"], unique=False, ) op.create_index( "python_package_version_index_idx_21", "python_package_version", ["package_name", "package_version", "python_package_index_id", "python_package_index_id", "os_version"], unique=False, ) op.create_index( "python_package_version_index_idx_22", "python_package_version", ["package_name", "package_version", "python_package_index_id", "python_package_index_id", "python_version"], unique=False, ) op.create_index( "python_package_version_index_idx_23", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_name", "os_version"], unique=False, ) op.create_index( "python_package_version_index_idx_24", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_name", "python_version"], unique=False, ) op.create_index( "python_package_version_index_idx_25", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_version", "python_version"], unique=False, ) op.create_index( "python_package_version_index_idx_30", "python_package_version", [ "package_name", "package_version", "python_package_index_id", "python_package_index_id", "os_name", "os_version", ], unique=False, ) op.create_index( "python_package_version_index_idx_31", "python_package_version", [ "package_name", "package_version", "python_package_index_id", "python_package_index_id", "os_name", "python_version", ], unique=False, ) op.create_index( "python_package_version_index_idx_32", "python_package_version", [ "package_name", "package_version", "python_package_index_id", "python_package_index_id", "os_version", "python_version", ], unique=False, ) op.create_index( "python_package_version_index_idx_33", "python_package_version", ["package_name", "package_version", "python_package_index_id", "os_name", "os_version", "python_version"], unique=False, ) op.create_table( "python_requirements", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_package_requirement_id", sa.Integer(), nullable=False), sa.Column("python_software_stack_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ["python_package_requirement_id"], ["python_package_requirement.id"], ondelete="CASCADE" ), sa.ForeignKeyConstraint(["python_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_package_requirement_id", "python_software_stack_id"), ) op.create_table( "depends_on", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("entity_id", sa.Integer(), nullable=False), sa.Column("version_id", sa.Integer(), nullable=False), sa.Column("version_range", sa.String(length=128), nullable=True), sa.ForeignKeyConstraint(["entity_id"], ["python_package_version_entity.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["version_id"], ["python_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "entity_id", "version_id"), sa.UniqueConstraint("entity_id", "version_id", "version_range"), ) op.create_index("depends_on_idx", "depends_on", ["entity_id", "version_id", "version_range"], unique=False) op.create_index( "depends_on_version_range_idx", "depends_on", ["entity_id", "version_id", "version_range"], unique=False ) op.create_table( "has_artifact", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_package_version_id", sa.Integer(), nullable=False), sa.Column("python_artifact_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["python_artifact_id"], ["python_artifact.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_package_version_id"], ["python_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_package_version_id", "python_artifact_id"), ) op.create_table( "identified", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_extract_run_id", sa.Integer(), nullable=False), sa.Column("python_package_version_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_extract_run_id"], ["package_extract_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_package_version_id"], ["python_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "package_extract_run_id", "python_package_version_id"), ) op.create_table( "investigated", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_analyzer_run_id", sa.Integer(), nullable=False), sa.Column("python_artifact_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_analyzer_run_id"], ["package_analyzer_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_artifact_id"], ["python_artifact.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "package_analyzer_run_id", "python_artifact_id"), ) op.create_table( "investigated_file", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("package_analyzer_run_id", sa.Integer(), nullable=False), sa.Column("python_file_digest_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["package_analyzer_run_id"], ["package_analyzer_run.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_file_digest_id"], ["python_file_digest.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "package_analyzer_run_id", "python_file_digest_id"), ) op.create_table( "pi_conv1d", sa.Column("framework", sa.String(length=256), nullable=True), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("version", sa.String(length=256), nullable=False), sa.Column("overall_score", sa.Float(), nullable=True), sa.Column("exit_code", sa.Integer(), nullable=False), sa.Column("ru_utime", sa.Float(), nullable=False), sa.Column("ru_stime", sa.Float(), nullable=False), sa.Column("ru_maxrss", sa.Integer(), nullable=False), sa.Column("ru_ixrss", sa.Integer(), nullable=False), sa.Column("ru_idrss", sa.Integer(), nullable=False), sa.Column("ru_isrss", sa.Integer(), nullable=False), sa.Column("ru_minflt", sa.Integer(), nullable=False), sa.Column("ru_majflt", sa.Integer(), nullable=False), sa.Column("ru_nswap", sa.Integer(), nullable=False), sa.Column("ru_inblock", sa.Integer(), nullable=False), sa.Column("ru_oublock", sa.Integer(), nullable=False), sa.Column("ru_msgsnd", sa.Integer(), nullable=False), sa.Column("ru_msgrcv", sa.Integer(), nullable=False), sa.Column("ru_nsignals", sa.Integer(), nullable=False), sa.Column("ru_nvcsw", sa.Integer(), nullable=False), sa.Column("ru_nivcsw", sa.Integer(), nullable=False), sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("inspection_run_id", sa.Integer(), nullable=False), sa.Column("device", sa.String(length=256), nullable=False), sa.Column("dtype", sa.String(length=256), nullable=False), sa.Column("reps", sa.Integer(), nullable=False), sa.Column("data_format", sa.String(length=256), nullable=False), sa.Column("batch", sa.Integer(), nullable=False), sa.Column("input_width", sa.Integer(), nullable=False), sa.Column("input_channels", sa.Integer(), nullable=False), sa.Column("filter_width", sa.Integer(), nullable=False), sa.Column("output_channels", sa.Integer(), nullable=False), sa.Column("strides", sa.Integer(), nullable=False), sa.Column("padding", sa.String(length=256), nullable=False), sa.Column("elapsed", sa.Float(), nullable=False), sa.Column("rate", sa.Float(), nullable=False), sa.ForeignKeyConstraint( ["inspection_run_id"], ["inspection_run.id"], ), sa.PrimaryKeyConstraint("id"), ) op.create_table( "pi_conv2d", sa.Column("framework", sa.String(length=256), nullable=True), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("version", sa.String(length=256), nullable=False), sa.Column("overall_score", sa.Float(), nullable=True), sa.Column("exit_code", sa.Integer(), nullable=False), sa.Column("ru_utime", sa.Float(), nullable=False), sa.Column("ru_stime", sa.Float(), nullable=False), sa.Column("ru_maxrss", sa.Integer(), nullable=False), sa.Column("ru_ixrss", sa.Integer(), nullable=False), sa.Column("ru_idrss", sa.Integer(), nullable=False), sa.Column("ru_isrss", sa.Integer(), nullable=False), sa.Column("ru_minflt", sa.Integer(), nullable=False), sa.Column("ru_majflt", sa.Integer(), nullable=False), sa.Column("ru_nswap", sa.Integer(), nullable=False), sa.Column("ru_inblock", sa.Integer(), nullable=False), sa.Column("ru_oublock", sa.Integer(), nullable=False), sa.Column("ru_msgsnd", sa.Integer(), nullable=False), sa.Column("ru_msgrcv", sa.Integer(), nullable=False), sa.Column("ru_nsignals", sa.Integer(), nullable=False), sa.Column("ru_nvcsw", sa.Integer(), nullable=False), sa.Column("ru_nivcsw", sa.Integer(), nullable=False), sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("inspection_run_id", sa.Integer(), nullable=False), sa.Column("device", sa.String(length=256), nullable=False), sa.Column("dtype", sa.String(length=256), nullable=False), sa.Column("reps", sa.Integer(), nullable=False), sa.Column("data_format", sa.String(length=256), nullable=False), sa.Column("batch", sa.Integer(), nullable=False), sa.Column("input_height", sa.Integer(), nullable=False), sa.Column("input_width", sa.Integer(), nullable=False), sa.Column("input_channels", sa.Integer(), nullable=False), sa.Column("filter_height", sa.Integer(), nullable=False), sa.Column("filter_width", sa.Integer(), nullable=False), sa.Column("output_channels", sa.Integer(), nullable=False), sa.Column("strides", sa.Integer(), nullable=False), sa.Column("padding", sa.String(length=256), nullable=False), sa.Column("elapsed", sa.Float(), nullable=False), sa.Column("rate", sa.Float(), nullable=False), sa.ForeignKeyConstraint( ["inspection_run_id"], ["inspection_run.id"], ), sa.PrimaryKeyConstraint("id"), ) op.create_table( "pi_matmul", sa.Column("framework", sa.String(length=256), nullable=True), sa.Column("origin", sa.String(length=256), nullable=True), sa.Column("version", sa.String(length=256), nullable=False), sa.Column("overall_score", sa.Float(), nullable=True), sa.Column("exit_code", sa.Integer(), nullable=False), sa.Column("ru_utime", sa.Float(), nullable=False), sa.Column("ru_stime", sa.Float(), nullable=False), sa.Column("ru_maxrss", sa.Integer(), nullable=False), sa.Column("ru_ixrss", sa.Integer(), nullable=False), sa.Column("ru_idrss", sa.Integer(), nullable=False), sa.Column("ru_isrss", sa.Integer(), nullable=False), sa.Column("ru_minflt", sa.Integer(), nullable=False), sa.Column("ru_majflt", sa.Integer(), nullable=False), sa.Column("ru_nswap", sa.Integer(), nullable=False), sa.Column("ru_inblock", sa.Integer(), nullable=False), sa.Column("ru_oublock", sa.Integer(), nullable=False), sa.Column("ru_msgsnd", sa.Integer(), nullable=False), sa.Column("ru_msgrcv", sa.Integer(), nullable=False), sa.Column("ru_nsignals", sa.Integer(), nullable=False), sa.Column("ru_nvcsw", sa.Integer(), nullable=False), sa.Column("ru_nivcsw", sa.Integer(), nullable=False), sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("inspection_run_id", sa.Integer(), nullable=False), sa.Column("device", sa.String(length=256), nullable=False), sa.Column("matrix_size", sa.Integer(), nullable=False), sa.Column("dtype", sa.String(length=256), nullable=False), sa.Column("reps", sa.Integer(), nullable=False), sa.Column("elapsed", sa.Float(), nullable=False), sa.Column("rate", sa.Float(), nullable=False), sa.ForeignKeyConstraint( ["inspection_run_id"], ["inspection_run.id"], ), sa.PrimaryKeyConstraint("id"), ) op.create_table( "python_requirements_lock", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("python_package_version_id", sa.Integer(), nullable=False), sa.Column("python_software_stack_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["python_package_version_id"], ["python_package_version.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["python_software_stack_id"], ["python_software_stack.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "python_package_version_id", "python_software_stack_id"), ) op.create_table( "solved", sa.Column("id", sa.Integer(), autoincrement=True, nullable=False), sa.Column("datetime", sa.DateTime(), nullable=False), sa.Column("document_id", sa.String(length=128), nullable=False), sa.Column("duration", sa.Integer(), nullable=True), sa.Column("error", sa.Boolean(), nullable=False), sa.Column("error_unparseable", sa.Boolean(), nullable=False), sa.Column("error_unsolvable", sa.Boolean(), nullable=False), sa.Column("is_provided", sa.Boolean(), nullable=True), sa.Column("ecosystem_solver_id", sa.Integer(), nullable=False), sa.Column("version_id", sa.Integer(), nullable=False), sa.ForeignKeyConstraint(["ecosystem_solver_id"], ["ecosystem_solver.id"], ondelete="CASCADE"), sa.ForeignKeyConstraint(["version_id"], ["python_package_version.id"], ondelete="CASCADE"), sa.PrimaryKeyConstraint("id", "ecosystem_solver_id", "version_id"), ) op.create_index("solver_document_id_idx", "solved", ["document_id"], unique=False)
# ### end Alembic commands ###
[docs]def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_index("solver_document_id_idx", table_name="solved") op.drop_table("solved") op.drop_table("python_requirements_lock") op.drop_table("pi_matmul") op.drop_table("pi_conv2d") op.drop_table("pi_conv1d") op.drop_table("investigated_file") op.drop_table("investigated") op.drop_table("identified") op.drop_table("has_artifact") op.drop_index("depends_on_version_range_idx", table_name="depends_on") op.drop_index("depends_on_idx", table_name="depends_on") op.drop_table("depends_on") op.drop_table("python_requirements") op.drop_index("python_package_version_index_idx_33", table_name="python_package_version") op.drop_index("python_package_version_index_idx_32", table_name="python_package_version") op.drop_index("python_package_version_index_idx_31", table_name="python_package_version") op.drop_index("python_package_version_index_idx_30", table_name="python_package_version") op.drop_index("python_package_version_index_idx_25", table_name="python_package_version") op.drop_index("python_package_version_index_idx_24", table_name="python_package_version") op.drop_index("python_package_version_index_idx_23", table_name="python_package_version") op.drop_index("python_package_version_index_idx_22", table_name="python_package_version") op.drop_index("python_package_version_index_idx_21", table_name="python_package_version") op.drop_index("python_package_version_index_idx_20", table_name="python_package_version") op.drop_index("python_package_version_index_idx_13", table_name="python_package_version") op.drop_index("python_package_version_index_idx_12", table_name="python_package_version") op.drop_index("python_package_version_index_idx_11", table_name="python_package_version") op.drop_index("python_package_version_index_idx_10", table_name="python_package_version") op.drop_index("python_package_version_idx", table_name="python_package_version") op.drop_table("python_package_version") op.drop_table("python_dependency_monkey_requirements") op.drop_table("package_analyzer_run") op.drop_table("inspection_run") op.drop_table("has_vulnerability") op.drop_table("found_rpm") op.drop_table("found_python_file") op.drop_table("found_deb") op.drop_table("detected_symbol") op.drop_table("advised") op.drop_table("rpm_requires") op.drop_table("requires_symbol") op.drop_index("python_package_version_entity_idx", table_name="python_package_version_entity") op.drop_table("python_package_version_entity") op.drop_table("python_package_requirement") op.drop_table("provenance_checker_run") op.drop_table("package_extract_run") op.drop_table("included_file") op.drop_table("has_symbol") op.drop_table("dependency_monkey_run") op.drop_table("deb_replaces") op.drop_table("deb_pre_depends") op.drop_table("deb_depends") op.drop_table("adviser_run") op.drop_table("versioned_symbol") op.drop_table("software_environment") op.drop_table("rpm_requirement") op.drop_table("rpm_package_version") op.drop_table("python_software_stack") op.drop_index("url_idx", table_name="python_package_index") op.drop_table("python_package_index") op.drop_index("sha256_idx", table_name="python_file_digest") op.drop_table("python_file_digest") op.drop_table("python_artifact") op.drop_table("hardware_information") op.drop_index("ecosystem_solver_idx", table_name="ecosystem_solver") op.drop_table("ecosystem_solver") op.drop_table("deb_package_version") op.drop_table("deb_dependency") op.drop_table("cve")
# ### end Alembic commands ###