Metadata-Version: 2.1
Name: etlhelper
Version: 1.0.2
Summary: etlhelper is Python ETL library to simplify data transfer into and out of databases.
Author-email: BGS Informatics <enquiries@bgs.ac.uk>
License: LGPL-3.0 license
Project-URL: Source Code, https://github.com/BritishGeologicalSurvey/etlhelper
Project-URL: Documentation, https://britishgeologicalsurvey.github.io/etlhelper/
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Information Technology
Classifier: Intended Audience :: Science/Research
Classifier: License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Topic :: Database
Classifier: Topic :: Scientific/Engineering :: GIS
Requires-Python: >=3.9
Description-Content-Type: text/markdown
License-File: LICENSE
Provides-Extra: oracle
Requires-Dist: oracledb; extra == "oracle"
Requires-Dist: cffi; extra == "oracle"
Provides-Extra: mssql
Requires-Dist: pyodbc; extra == "mssql"
Provides-Extra: postgres
Requires-Dist: psycopg2-binary; extra == "postgres"
Provides-Extra: all
Requires-Dist: oracledb; extra == "all"
Requires-Dist: cffi; extra == "all"
Requires-Dist: pyodbc; extra == "all"
Requires-Dist: psycopg2-binary; extra == "all"
Provides-Extra: dev
Requires-Dist: flake8; extra == "dev"
Requires-Dist: ipdb; extra == "dev"
Requires-Dist: ipython; extra == "dev"
Requires-Dist: pytest; extra == "dev"
Requires-Dist: pytest-cov; extra == "dev"
Provides-Extra: pkg
Requires-Dist: build; extra == "pkg"
Requires-Dist: twine; extra == "pkg"

# etlhelper

> etlhelper is a Python ETL library to simplify data transfer into and out of databases.

ETL Helper makes it easy to run SQL queries via Python and return the
results.
It takes care of cursor management, importing drivers and formatting connection strings,
while providing memory-efficient functions to read, write and transform data.
This reduces the amount of boilerplate code required to manipulate data within relational
databases with Python.

---

+ **Documentation**: https://britishgeologicalsurvey.github.io/etlhelper/
+ **Source code**: https://github.com/BritishGeologicalSurvey/etlhelper

---

## Installation

ETL Helper is available on PyPI.

```bash
pip install etlhelper
```

Database driver packages are not included by default and should be specified in square brackets.
Options are `oracle` (installs [oracledb](https://pypi.org/project/oracledb/)), `mssql` (installs [pyodbc](https://pypi.org/project/pyodbc/)) and `postgres` (installs [psycopg2](https://pypi.org/project/psycopg2/)).
Multiple values can be separated by commas.

```bash
pip install etlhelper[oracle,postgres]
```

See the individual database driver configuration pages for any OS-level dependencies.


## Development

ETL Helper was created by and is maintained by British Geological Survey Informatics.

+ John A Stevenson ([volcan01010](https://github.com/volcan01010))
+ Jo Walsh ([metazool](https://github.com/metazool))
+ Declan Valters ([dvalters](https://github.com/dvalters))
+ Colin Blackburn ([ximenesuk](https://github.com/ximenesuk))
+ Daniel Sutton ([kerberpolis](https://github.com/kerberpolis))
+ Leo Rudczenko ([leorudczenko](https://github.com/leorudczenko))

See [CONTRIBUTING.md](CONTRIBUTING.md) for details on how to contribute.

## Licence

ETL Helper is distributed under the [LGPL v3.0 licence](LICENSE).
Copyright: © BGS / UKRI 2019
