Indexdigest

Latest version: v1.6.0

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

Scan your dependencies

Page 2 of 2

1.2.0

* 36 [linters] - Suggest InnoDB over MyISAM
* 128 [linters] - `data-too-old`: check columns with non-timestamp types, but with "time" in their names
* 129 [bug] - `data_too_old` - handle incorrect or missing timestamp values
* 130 [bug] - Ignore views
* 131 [enhancement] - Treat `forum_creation_temp` as temporary table
* 132 [bug] - Handle tables names with dashes
* 137 [bug] - `get_boundary_times` | handle tables with dashes
* 138 [bug] - `select_star` | queries with comments should be handled as well
* 140 [bug] - `high_offset_selects` | insert queries should be skipped by this check

1.1.0

* 28 [linters] - Check timestamp columns if they contain old data
* 54 [command line tool] - Process selected checks when `--checks` / `--skip-checks` option is provided
* 55 [command line tool] - Process only selected tables when `--tables` / `--skip-tables` option is provided
* 94 [linters] - Report primary keys with a generic "id" name
* 106 [bug] - `get_table_schema`: cast to str
* 107 [enhancement] - Do not add partitions in schema returned by the database helper
* 109 [enhancement] - Improve `get_used_tables_from_queries` handling of table aliases
* 112 [bug] - Fix `Database error 1146 - Cannot get columns list for table`
* 114 [performance] - get_boundary_times: add `memoize`
* 115 [bug] - `check_data_not_updated_recently` / `check_data_too_old` - cast timestamps to str
* 116 [internals] - cli: `extract get_reports()` function and improve syslog reporter tests coverage
* 118 [linters] - Avoid high offsets in queries
* 119 [internals] - Update dependencies
* 120 [enhancement] - `data_too_old` / `data_not_updated_recently` - report timestamp column name and table size

1.0.0

* 73 [linters] - Consider adding checks from `sqlcheck`
* 84 [linters] - Consider adding checks from `SchemaCrawler`
* 85 [bug] - tests: do not assume the version, silly me...
* 86 [internals] - Cache table schema
* 87 [formatters] - syslog: emit `appname` field
* 89 [linters] - Report empty tables
* 90 [internals] - `add_linter` helper script
* 92 [linters] - Report select queries with `*`
* 93 [linters] - Report queries with `HAVING` clause
* 95 [bug] - `empty_tables`: use `EXPLAIN SELECT count(*)` to estimate rows count
* 97 [internals] - `get_query_tables`: improve SQL queries parsing
* 98 [enhancement] - Gracefully handle complex queries that can't be parsed
* 100 [internals] - `sql_metadata` | use a new Python package extracted from index-digest
* 101 [internals] - Use `sql_metadata==1.0.2`
* 104 [enhancement] - `not_used_tables`: report rows count, table size and its schema

0.2.0

* 34 [linters] - Check for missing primary or unique keys
* 35 [formatters] - Support more formatters
* 68 [formatters] - Add YAML results formatter
* 70 [linters] - Report `INSERT IGNORE` queries
* 72 [formatters] - Add `syslog` results reporter
* 74 [linters] - Report tables with just a single column
* 75 [linters] - Report tables with "test" word in a name
* 77 [internals] - travis: make build matrix a bit smaller (and faster)

0.1.0

* 1 [TravisCI] - Set up Travis tests
* 2 [linters] - Report not used indices
* 3 [undefined] - Generate score for queries based on their indices usage
* 4 [linters] - Detect redundant indices
* 5 [linters] - Report indices and data size for each table
* 6 [linters] - Report not used columns and tables
* 8 [internals] - Introduce Database class abstracting MySQL access
* 16 [linters] - redundant_indices - show table schema and table / indices size in the context
* 19 [linters] - Reports queries that do not use indices
* 20 [linters] - Report queries that use filesort or temporary file
* 25 [internals] - Improve SQL parsing
* 26 [linters] - Report full table scan (by gbenson-wikia)
* 27 [linters] - Warn on queries which contain wildcards not at the end of LIKE clauses (by gbenson-wikia)
* 30 [TravisCI] - Test on TravisCI using MySQL 5.7
* 32 [linters] - Report text columns that use non-utf collation
* 44 [bug] - queries_not_using_index: handle no matching row in const table
* 48 [bug] - Conflicting indexes shouldn't result in a suggestion to remove both... (by reedy)
* 49 [bug] - Unique vs PK... Not necessarily redundant due to unique constraint (by reedy)
* 57 [internals] - Cache database meta-data
* 60 [MySQL 8] - Run Travis tests using MySQL 5.5, 5.6, 5.7 and 8.0
* 61 [MySQL 8] - Support MySQL 8.0
* 63 [internals] - Suppress MySQL warnings when EXPLAIN is run
* 66 [enhancement] - Add support for MariaDB
* 69 [internals] - Publish to PyPI

Page 2 of 2

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.