Package Instance

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "url": "http://public2.vulnerablecode.io/api/packages/12916?format=api",
    "purl": "pkg:pypi/sqlalchemy@0.9.0",
    "type": "pypi",
    "namespace": "",
    "name": "sqlalchemy",
    "version": "0.9.0",
    "qualifiers": {},
    "subpath": "",
    "is_vulnerable": true,
    "next_non_vulnerable_version": "1.2.18",
    "latest_non_vulnerable_version": "1.3.0b3",
    "affected_by_vulnerabilities": [
        {
            "url": "http://public2.vulnerablecode.io/api/vulnerabilities/35320?format=api",
            "vulnerability_id": "VCID-kbkh-bf1z-3kb4",
            "summary": "SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.",
            "references": [
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html"
                },
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html"
                },
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html"
                },
                {
                    "reference_url": "https://access.redhat.com/errata/RHSA-2019:0981",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://access.redhat.com/errata/RHSA-2019:0981"
                },
                {
                    "reference_url": "https://access.redhat.com/errata/RHSA-2019:0984",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://access.redhat.com/errata/RHSA-2019:0984"
                },
                {
                    "reference_url": "https://github.com/advisories/GHSA-38fc-9xqv-7f7q",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/advisories/GHSA-38fc-9xqv-7f7q"
                },
                {
                    "reference_url": "https://github.com/no-security/sqlalchemy_test",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/no-security/sqlalchemy_test"
                },
                {
                    "reference_url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy/issues/4510",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4510"
                },
                {
                    "reference_url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html"
                },
                {
                    "reference_url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html"
                },
                {
                    "reference_url": "https://www.oracle.com/security-alerts/cpujan2021.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://www.oracle.com/security-alerts/cpujan2021.html"
                },
                {
                    "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7548",
                    "reference_id": "CVE-2019-7548",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7548"
                }
            ],
            "fixed_packages": [
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/12995?format=api",
                    "purl": "pkg:pypi/sqlalchemy@1.2.18",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.18"
                },
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/57824?format=api",
                    "purl": "pkg:pypi/sqlalchemy@1.2.19",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.19"
                }
            ],
            "aliases": [
                "CVE-2019-7548",
                "GHSA-38fc-9xqv-7f7q",
                "PYSEC-2019-124"
            ],
            "risk_score": null,
            "exploitability": null,
            "weighted_severity": null,
            "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-kbkh-bf1z-3kb4"
        },
        {
            "url": "http://public2.vulnerablecode.io/api/vulnerabilities/35324?format=api",
            "vulnerability_id": "VCID-tt22-7cuc-gkfc",
            "summary": "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.",
            "references": [
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html"
                },
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html"
                },
                {
                    "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html"
                },
                {
                    "reference_url": "https://access.redhat.com/errata/RHSA-2019:0981",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://access.redhat.com/errata/RHSA-2019:0981"
                },
                {
                    "reference_url": "https://access.redhat.com/errata/RHSA-2019:0984",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://access.redhat.com/errata/RHSA-2019:0984"
                },
                {
                    "reference_url": "https://github.com/advisories/GHSA-887w-45rq-vxgf",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/advisories/GHSA-887w-45rq-vxgf"
                },
                {
                    "reference_url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-123.yaml",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-123.yaml"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481"
                },
                {
                    "reference_url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html"
                },
                {
                    "reference_url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html"
                },
                {
                    "reference_url": "https://www.oracle.com/security-alerts/cpujan2021.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://www.oracle.com/security-alerts/cpujan2021.html"
                },
                {
                    "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7164",
                    "reference_id": "CVE-2019-7164",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7164"
                }
            ],
            "fixed_packages": [
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/12995?format=api",
                    "purl": "pkg:pypi/sqlalchemy@1.2.18",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.18"
                },
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/57825?format=api",
                    "purl": "pkg:pypi/sqlalchemy@1.3.0b3",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.3.0b3"
                }
            ],
            "aliases": [
                "CVE-2019-7164",
                "GHSA-887w-45rq-vxgf",
                "PYSEC-2019-123"
            ],
            "risk_score": null,
            "exploitability": null,
            "weighted_severity": null,
            "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-tt22-7cuc-gkfc"
        }
    ],
    "fixing_vulnerabilities": [],
    "risk_score": null,
    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.9.0"
}