lastDBdate: Returns the most recent date present in the database table.
In claudia-codeco/AlertTools: utility functions for the Alerta Dengue System

Description Usage Arguments Value Examples

Useful to check if the database is up-to-date.

1	lastDBdate(tab, cities, cid10 = "A90", stations, datasource = con)

`tab`	table in the database. Either (sinan, clima_wu, tweet, historico, historico_mrj).
`cities`	vector of geocodes.
`cid10`	relevant for sinan, tweeter or historico. Codes are: dengue "A90", chik "A92.0", zika "A92.8".
`stations`	vector with wu stations. Ex. c("SGBL", "SBRL")
`datasource`

vector with two elements: data.max = most recent date in the collection of cities or stations; se = corresponding epidemiological week.

cidades <- getCidades(regional = "Sete Lagoas", uf = "Minas Gerais")
lastDBdate(tab = "tweet", cities = cidades$municipio_geocodigo, cid10 = "A90")
lastDBdate(tab = "sinan", cities = cidades$municipio_geocodigo, cid10 = "A92.8")
lastDBdate(tab = "clima_wu", stations = "SBAF", datasource=con)  
lastDBdate(tab = "clima_wu", cities = cidades$municipio_geocodigo, datasource=con)