{"url":"http://public2.vulnerablecode.io/api/packages/12937?format=json","purl":"pkg:pypi/sqlalchemy@1.0.5","type":"pypi","namespace":"","name":"sqlalchemy","version":"1.0.5","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=json","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=json","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=json","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=json","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=json","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=json","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@1.0.5"}