CDCgov / dibbs-query-connector

A FHIR client allowing public health agencies to query health care organizations directly or via a TEFCA QHIN
Creative Commons Zero v1.0 Universal
4 stars 0 forks source link

Write DB Creation script #85

Closed bamader closed 3 weeks ago

bamader commented 1 month ago

With all other pieces of functionality in place, we can finally write a script to create the DB once and for all. This bash script (or python, or whatever other DB creation language the dev who picks this up chooses) should be run after the flyway table creation migration is performed. It should pull down the whole eRSD as a FHIR bundle, then iterate through it and perform any and all necessary insertions. When a value set or group of data is finished, the sanity check function should be called to verify that all data was added, and any pieces that weren't properly inserted should be repeated at the end of the script.

linear[bot] commented 1 month ago

QUE-40 Write DB Creation script