So I thought that this project was dead. Yesterday a surprise development resurrected it from the ashes. DOH provided data dump (instead of a public API) for COVID 19 cases. The data is now dumped daily in Google Drive. It’s not the method I prefer, however, most of the enterprise apps we develop and support use this method so I am well experienced here.
This change impacted the app in two major ways: first, I need to create a CSV upload facility and completely discard the data pull from their previous API. Second, the schema and lookup values changed so I have to modify the part where it aggregates the data. This is the most tedious part, to be honest. I scrapped all previous data and I re-evaluated how I plot charts.
I have also scrapped some of the features as the data no longer supports them. For example, the previous data includes foreigner and OFW cases. It seems those are now gone. I will update the app in case this changes.
I am now 80% done. Most left are testing. Hopefully, I can get something shipped by end of the week. Stay tuned!