BritishGeologicalSurvey / etlhelper

ETL Helper is a Python ETL library to simplify data transfer into and out of databases.
https://britishgeologicalsurvey.github.io/etlhelper/
GNU Lesser General Public License v3.0
105 stars 25 forks source link

Add list and tuple row factories #136

Closed volcan01010 closed 1 year ago

volcan01010 commented 1 year ago

Description

This merge request adds list and tuple row factories and updates the documentation. It closes #132.

These changes mean that ETL Helper can export data in the main Python built-in collection types. Adding the list_row_factory provides a mutable container for use with MS-SQL, which cannot use dictionaries. Adding tuple gives an option with minimal processing overhead, although I haven't done any testing to see how much difference it makes.

To test