Etlhelper

Latest version: v0.14.3

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

Scan your dependencies

Page 2 of 5

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

0.11.0

Not secure
This release adds the following features:

* The `on_error` parameter is added to `executemany` and the functions that call it (`load`, `copy_rows`, `copy_table_rows`). This allows a job to complete even if some rows fail (e.g. due to failed unique constraint). A user-provided function is called on the failed rows from each chunk of data once the chunk is complete. See [README](https://github.com/BritishGeologicalSurvey/etlhelper#handling-insert-errors) for details.
* The `chunk_size` is now a named parameter in all etl functions. Previously it was set by the global variable, `etlhelper.etl.CHUNKSIZE`. This makes it more accessible.

What's Changed
* Add Python 3.9 to CI checks by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/116
* Add on_error handling to executemany and related methods by ximenesuk and volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/115


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

0.10.0

Not secure
This release adds two new functions that make life easier by using autogenerated INSERT statements based on dictionary keys or namedtuple attributes.

+ `load` inserts data into the given table, generating the INSERT statement based on the input data. There is a recipe for [transforming and loading](https://github.com/BritishGeologicalSurvey/etlhelper#csv-load-script-template) data from a CSV file. `load` can also combined with [`iter_rows`](https://github.com/BritishGeologicalSurvey/etlhelper#combining-iter_rows-with-load) to insert the results of arbitrary SQL queries on the source connection into the destination connection.
+ `copy_table_rows` [copies the contents of a table](https://github.com/BritishGeologicalSurvey/etlhelper#copy-table-rows) from one connection to another.

What's Changed
* Update spatial ETL GeomFromText command by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/106
* Load function by volcan01010 in https://github.com/BritishGeologicalSurvey/etlhelper/pull/109


**Full Changelog**: https://github.com/BritishGeologicalSurvey/etlhelper/compare/v0.9.7...v0.10.0

Page 2 of 5

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.