Etlhelper

Latest version: v0.14.3

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

Scan your dependencies

Page 1 of 4

0.14.3

This is a minor release, with the main purpose of adding a deprecation warning to inform users that ETL Helper will soon move to version 1. This will include breaking changes. Users are advised to *pin the version* of their dependencies.

Other changes include swapping the CI system from Travis CI to GitHub Actions, documentation updates and minor tweaks to module importing and the reporting of SQLite column type.


Merge requests merged
* GitHub actions by leorudczenko in https://github.com/BritishGeologicalSurvey/etlhelper/pull/162
* Update README.md by rbroth in https://github.com/BritishGeologicalSurvey/etlhelper/pull/156
* 159 add deprecation warning by leorudczenko in https://github.com/BritishGeologicalSurvey/etlhelper/pull/165
* Add row_factories import to __init__ by leorudczenko in https://github.com/BritishGeologicalSurvey/etlhelper/pull/173
* Change column type to lowercase by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/178
* Docs fix by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/179
* * Update pip to fix psycopg2 install by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/180

New Contributors
* rbroth made their first contribution in https://github.com/BritishGeologicalSurvey/etlhelper/pull/156

**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.14.2...v0.14.3

0.14.2

This is a minor release to allow schema-qualified table names e.g. `schema.table` in the `validate_identifiers()` and to apply the validation to table names passed to the `copy_table_rows()` function.

What's Changed
* Allow schema-qualified names in validate_identifier by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/141
* Validate table name in copy_table_rows by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/142

**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.14.1...v0.14.2

0.14.1

This release is a minor fix to allow the test suite to pass in Python 3.6.

What's Changed
* Py36 fix by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/138


**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.14.0...v0.14.1

0.14.0

This release adds the following new features:

+ The `generate_insert_sql` function (used by `load`) validates the table and column names used. As these are user-provided they were a potential route for SQL injection attacks. An `ETLHelperBadIdentifierError` is raised on bad input.
+ The `abort_etlhelper_threads()` function has been added. When called, this raises an `ETLHelperAbort` exception at the end of the current chunk. It can be used to cancel jobs that are running in threads, such as in GUI applications. See [README.md](https://github.com/BritishGeologicalSurvey/etlhelper#aborting-running-jobs).
+ `list_row_factory` and `tuple_row_factory` have been added. Data can now be exported as all of the main Python container types e.g. namedtuple, dictionary, list and tuple. Lists are mutable so are convenient to use with transform functions. Tuples are fast to create and access. See [README.md](https://github.com/BritishGeologicalSurvey/etlhelper#row-factories)

Pull requests merged

* Validate table identifiers by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/134
* Repo tweaks by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/135
* Add list and tuple row factories by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/136
* Abort function by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/137


**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/V0.13.0...v0.14.0

0.13.0

Not secure
This release adds the `table_info()` function that provides basic metadata about the columns in a table. It is useful when browsing data and when auto-generating SQL queries.

What's Changed

* Make information on column types accessible by ximenesuk and volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/128

**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.12.2...v0.13.0

0.12.2

Not secure
Minor release that extends the range of exceptions raised by the database drivers that are caught and handled by ETL Helper.

What's Changed
* Catch base classes for driver exceptions by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/123


**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.12.1...v0.12.2

Page 1 of 4

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.