justalk / covid19ph-api Goto Github PK

The parameter are query parameter. They can be chain as the example under :

http://13.250.29.32:5000/cases?limit=1&age_lower=20&status=RECOVERED

• The live version has a limit of 1000 cases showing by default. The limit can be change to higher value by setting the value parameter.
• The sort_key and sort_order has to be use together for working.
• The parameters can be mixed together for mixing your particular query.
• The datas are updated every week.
• Some datas fields can be empty because the datas from DOH are let with empty field.

The cron has been set in the crontab with this setting :

crontab -e
0 0 * * * curl http://0.0.0.0:5000/cron/cases

1. Download the notice PDF from DOH : http://bit.ly/DataDropPH
2. Parse the file for finding the link of the google drive where the datas are uploaded
3. Download the csv file with the data
4. Fill up the database used by the API

1. The api first check what is the parameter send and if it's a valid parameter (libs)
2. The api then build the filter that gonna be use by mongodb (services)
3. The api then return the result (dbs)

1. Cloning the repository

git cloning https://github.com/JustalK/COVID19PH-API.git

2. Install all the dependencies

npm install

3. Create an environnement file and fill up the information missing depending of your system

NODE_ENV=production

API_NAME=COVID19-PH
HOST=localhost
PORT=5000

CASES_LIMIT_GETTER=1000

DB_NAME=
DB_URI_DATA=
DB_URI_LOG=
DB_USER_DATA=
DB_PASS_DATA=
DB_HOST_LOG=
DB_PORT_LOG=
DB_NAME_LOG=
DB_USER_LOG=
DB_PASS_LOG=

• NODE_ENV: The type of the environnement file
• API_NAME: The name of the API
• HOST: The host of the API
• PORT: The port of the API
• CASES_LIMIT_GETTER: The limit of cases that can be fetch without params
• DB_NAME: The name of the database
• DB_URI_DATA: The url of the database
• DB_URI_LOG: The url of the log of the database
• DB_USER_DATA: The user of the database
• DB_PASS_DATA: The pass of the database

4. Create a google credential secret file form the developer file :

{
  "type": "service_account",
  "project_id": "",
  "private_key_id": "",
  "private_key": "",
  "client_email": "",
  "client_id": "",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": ""
}

For not sending the key to everyone, I am using the secrethub, so the file is not present inside the repository.

5. Activate on the google console the google drive API