Project for converting MIDA MySQL DB data to registry ingest files

Run the db_fetch_and_transform.sh script which extracts, analyzes and converts all necessary data. There is an execution flag --with-db that determines whether the MIDA DB should be accessed or existing extracts should be reused. Be aware that MySQL access parameters are hard coded in the extraction scripts (scripts/1_db_extraction) and might require change and that the python-mysql-connector needs to be available.

# Connects MIDA db using host localhost, port 3307, database 'midadb', user/password 'root'
./db_fetch_and_transform.sh --with-db

# Does not extract data from DB, but uses pre-extracted data committed to this repo under `data/1_db`
./db_fetch_and_transform.sh