UGS Water Chemistry Database Seeder

A db tool for seeding and updating the ugs water chemistry database.

Setup

1. Install oracle instant client >= 19.3.0.0.0
   1. Download the "Basic Light Package" from this page.
   2. Follow install directions at the bottom of the download page.
      • No need to mess with co-locating optional oracle config files such as tnsnames.ora.
   3. Follow ODBC installation instructions for windows.
2. Update ugssecrets.py based on the sample.
   1. To find the name of your instant client driver: import pyodbc;pyodbc.drivers().
3. execute scripts\createDB.sql or create a sql server database called UGSWaterChemistry
4. execute python -m ugsdbseeder create-tables <configuration> to create db tables.
5. see usage (python -m ugsdbseeder -h)

Usage

from the **/src** directory
execute python -m ugsdbseeder -h for usage.

Tests

from the parent project directory
tox