bhaden94 / covid19-tracker-v2-api Goto Github PK

Currently I calculate days difference on the frontend. I want to move this to the backend. The route needs to handle all states/countries in one GET.

There can also be a choice of how many days difference to get. For example we could get the difference in the last day for each state/country or we could get the difference in the last 7 days for each state/country.

One option: this would move all calculation to the BE which would be nice and fast

• parameters sent to backend: State/Country object, days difference, property name(maybe, will start by just doing active)
  • State/Country object: This would come in as a LinkedHashMap(to keep order) that would look like this

    • {
         alabama: 'Alabama',
         alaska: 'Alaska',
         arizona: 'Arizona',
         etc...
      }

    • We could then build a map where the key is state/country name and the value is the difference

      • {
           Alabama: 1200,
           Alaska: 1000,
           Arizona: -500
        }

Another easier option: This would keep calculations on the FE, but the network data should still be pretty small.

• Return the most recent DB entry and the one that is daysDifference away

I have scheduled tasks that run to populate our DB with the new data daily. This may pose a problem with Heroku's free tier since it will sleep after 30 minutes of inactivity. Maybe there is another site I can use or maybe Heroku has a way to set up scheduled tasks.

In the source repo the recovered and active cases are no longer reported.

I need to calculate these now instead of relying on the numbers to be there.

https: //github .com/CSSEGISandData /COVID-19/issues/3773

https://github.com/bhaden94/spacex-app/blob/master/README.md

See this repo for example readme

During scheduled update time everyday I would like to perform some data validation on what is currently in the DB.

Often times there is data from the past that gets updated and I currently have no way of going back and including that data unless I clear the DB and restart the BE to populate it again with all the data.

2 ways to do this.

1. Get all docs form DB and write custom aggregation Java code.
2. Create a custom MongoDB aggregation query and run that
   • https://www.devglan.com/spring-boot/spring-data-mongodb-queries
   • https://docs.mongodb.com/manual/aggregation/

Also add github action and turn on wait for CI pipeline to finish in Heroku.

Transition statUtilities.tsx and Totals.tsx on the FE to use BE for totals data.

Take in rate name and state/country name as parameters.

Find the average of that rate on the respective state/country. If no state/country given then find average of rate on all.

example return for incident_rate:

{
  "incident_rate": 1107.56
}

The bar chart needs data like this:

[
    {
        rate: 'Incident Rate',
        state_country: 0,
        us_world: 2568
    },
    {
        rate: 'Mortality Rate',
        state_country: 0,
        us_world: 2.14,
    }
]

This issue needs to handle both the rates component and the bar chart. There may need to be a few different endpoints made for it.

https://learn.microsoft.com/en-us/azure/developer/java/migration/migrate-spring-boot-to-azure-spring-apps

• Upgrade Spring boot and Gradle
• Create spring app in Azure after credits show in account
• Deploy application (Procfile has the current command used)
• Configure environment variables
• Expose application
• Update API URI in frontend environment variables
• Modify GitHub Actions to push to Azure with any new changes

Currently:

• congo (brazzaville)
• congo (kinshasa)

Should be:

• congo brazzaville
• congo kinshasa