Etlhelper

Latest version: v1.0.1

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

Scan your dependencies

Page 2 of 5

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

0.12.1

Not secure
Updated `load` for case where `rows` is an empty generator.

What's Changed
* Add test for empty generator by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/122


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

0.12.0

Not secure
This release makes the following minor improvements:

+ `executemany`, `load`, `copy_rows` and `copy_table_rows` return counts of the number of rows that
were processed and that failed
+ `setup_oracle_client` fails gracefully when cx_Oracle is not installed
+ `load` no longer crashes on being passed an empty list
+ ETLHelperConnectionError reports DbParams instead of connection string, to avoid password appearing in logs
+ Improved test coverage and documentation for `generate_insert_sql` function

What's Changed
* Change summary quote to _into and out of_ by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/117
* Make setup.py description match README by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/118
* Load improvements by volcan01010 and ximenesuk in https://github.com/BritishGeologicalSurvey/etlhelper/pull/121


**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.11.0...v0.12.0

Page 2 of 5

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.