This PR updates the Programs Registry API so that the DB is seeded by either CSV/ SQL files. Props to @akebi for diligently preparing the files.
What did I do?
[x] Updated the documentation in the README
[x] Updated the models based on the observed mock data
[x] Ordered the packages in requirements.txt
[x] Wrote the seed_data script to seed the API DB
Why did I approach it this way?
Streamlining the seeding process for this DB would inform me better on implementing an Airflow DAG to connect an s3 bucket to the Programs Registry DB. Furthermore, the learnings so acquired would be beneficial for the commit_to_db task in DAG.
What does this PR do?
This PR updates the Programs Registry API so that the DB is seeded by either CSV/ SQL files. Props to @akebi for diligently preparing the files.
What did I do?
requirements.txt
seed_data
script to seed the API DBWhy did I approach it this way?
Streamlining the
seeding
process for this DB would inform me better on implementing an Airflow DAG to connect an s3 bucket to the Programs Registry DB. Furthermore, the learnings so acquired would be beneficial for thecommit_to_db
task in DAG.