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
100 stars 25 forks source link

Read LOBs as string/bytes instead of streaming #181

Closed volcan01010 closed 1 year ago

volcan01010 commented 1 year ago

Summary

This merge request updates the default behaviour of the oracledb driver so that LOB data are returned as native Python strings/bytes.

It includes updated documentation and a test to confirm the mechanism for switching between string/bytes and LOB return types. It also confirms that LOBs longer than 4000 characters are returned intact.

Closes #110

To test

Ideally, we would also run code from this branch against internal BGS spatial data scripts to confirm that they still work.