You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Aug 14, 2020. It is now read-only.
Precisamos dividir o endpoint do Datasus em alguns outros endpoints e fazer algumas alterações no Model:
Por favor, submetam 1 PR POR ISSUE!!
Alterações no model: Precisamos adicionar os seguintes campos no model:
- city varchar(100)
- codUf integer
- codMun integer
- codHealthRegion integer
- nameHealthRegion varchar(150)
- epiWeek integer
- population integer
- recoveredNew integer
- accompanyingNew integer
Endpoint 1: /datasus/graphs/last30days (SQL Query: SELECT date, totalcases, totaldeaths FROM DataSus WHERE region = 'Brasil' ORDER BY date DESC LIMIT 30)
Endpoint 2: /datasus/graphs/regions (SQL Query: SELECT date, region, SUM(totalcases) FROM DataSus WHERE date = (SELECT MAX(date) FROM DataSus) AND city = '' AND codmun IS NULL GROUP BY date, region)
Endpoint 3: /datasus/graphs/total_cases (SQL Query: SELECT date, region, totalcases, totaldeaths from DataSus WHERE date = (SELECT MAX(date) FROM DataSus) AND coduf = 76)
Endpoint 4: /datasus/regions (SQL Query: SELECT id, region, state, city, coduf, codmun, population, totalcases, totaldeaths, date FROM DataSus WHERE date = (SELECT MAX(date) FROM Datasus))
The text was updated successfully, but these errors were encountered:
Precisamos dividir o endpoint do Datasus em alguns outros endpoints e fazer algumas alterações no Model:
Por favor, submetam 1 PR POR ISSUE!!
Alterações no model: Precisamos adicionar os seguintes campos no model:
-
city varchar(100)
-
codUf integer
-
codMun integer
-
codHealthRegion integer
-
nameHealthRegion varchar(150)
-
epiWeek integer
-
population integer
-
recoveredNew integer
-
accompanyingNew integer
Endpoint 1:
/datasus/graphs/last30days
(SQL Query:SELECT date, totalcases, totaldeaths FROM DataSus WHERE region = 'Brasil' ORDER BY date DESC LIMIT 30
)Endpoint 2:
/datasus/graphs/regions
(SQL Query:SELECT date, region, SUM(totalcases) FROM DataSus WHERE date = (SELECT MAX(date) FROM DataSus) AND city = '' AND codmun IS NULL GROUP BY date, region
)Endpoint 3:
/datasus/graphs/total_cases
(SQL Query:SELECT date, region, totalcases, totaldeaths from DataSus WHERE date = (SELECT MAX(date) FROM DataSus) AND coduf = 76
)Endpoint 4:
/datasus/regions
(SQL Query:SELECT id, region, state, city, coduf, codmun, population, totalcases, totaldeaths, date FROM DataSus WHERE date = (SELECT MAX(date) FROM Datasus)
)The text was updated successfully, but these errors were encountered: