Sql-metadata

Latest version: v2.11.0

Safety actively analyzes 630052 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 4 of 6

1.9.0

* Bump pytest from 6.0.1 to 6.0.2 62
* Bump coverage from 5.2.1 to 5.3 61
* build(deps-dev): bump pytest from 6.0.2 to 6.1.0 64
* `get_query_tables` doesn't respect table names with dashes in their name 60
* get_query_columns: improve handling of queries with "IS NULL" conditions 65
* build(deps-dev): bump pytest from 6.1.0 to 6.1.1 66
* build(deps): bump sqlparse from 0.3.1 to 0.4.0 67

1.8.0

* 38 `bug` - Ignoring Multiple FROM tables when they prefixed by DATASET (reported by rubensmussicury)
* 52 `bug` - Incorrect column names when table aliases are used (reported by akku1506 and fixed in 58)
* 55 `dependencies` - Bump coverage from 5.2 to 5.2.1 (by dependabot[bot])
* 56 `dependencies` - Bump pytest from 5.4.3 to 6.0.0 (by dependabot[bot])
* 57 `dependencies` - Bump pytest from 6.0.0 to 6.0.1 (by dependabot[bot])

1.7.1

sql
SELECT s.cust_id,count(s.cust_id) FROM SH.sales s GROUP BY s.cust_id


This query was giving `s.cust_id` as a table name instead of `SH.sales`. This is now fixed by 54.

1.7.0

* 45 - `get_query_tables`: Add support for `database.schema.table` notation (thanks to dylanhogg)
* 46 - installed dependabot that keeps dependencies up to date
* removed TravisCI integration
* automated PyPI publish on new release creation

1.6.0

* 30 - Improved handling of table aliases
* 39 - Support Python 3.x only
* 41 - handling of newlines in queries fixed (as reported in 37)
* 34 - Support for valid syntax for OUTER JOIN

The following bugs were solved by updating `sqlparse` dependency in 40:

* 31 - CTE makes get_query_tables() case-sensitive for SELECT
* 32 - CTE breaks INSERT INTO ... SELECT and DELETE FROM
* 33 - Add support for ALTER TABLE ... APPEND

1.5.0

* 29 - get_query_tables: fix handling of "SELECT x ORDER BY y" queries
* use [Semantic Versioning](https://semver.org/)

Page 4 of 6

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.