COVID-19
Taking data and inserting into Postgres Database for future use.
- Download and install Postgres
- Use data application (such as DataGrip) to connect to Postgres locally
- Create a config.yaml as follows and fill in values:
host: <host>
username: <username>
port: <port>
databaseName: <name>- Run provided scripts to create tables
- Run insertion scripts to load existing data
- Have Postgres running locally
- Navigate to directory of repo and run
go run corona.goto pull new data - (Data usually gets updated 25-30 minutes on API call)
- Set up the CoronaAPI
- Location data is stored in the
infotable data_idlinks to the id in the data table for specific data records
- As of v0.9, cleanup is performed within the API itself so manual cleanup is at own discretion
- In case there is duplicate data, simply run the
table_cleanup.sqlfile against the database - Based on time_ran column, which is automated on insert inside of go
- Portal is a work in progress, but after running the CoronaAPI, simply use a local server (such as in atom) to view the basic line graph