Package functions fail gracefully in case database is offline.
Performance improvements to long2wide
.
A connection to the database is only established when specific functions are called that require a database connection.
make_date
can now also convert year-month strings of the form 'YYYYMNN' or 'YYYY-MNN' to R Date's.
tryCatch
, and, if it fails,
ugatsdb_reconnect
is called and the query is sent again. Significant speed improvement to the expand_date
function.
Additional security: before each call, the database connection is checked using DBI::dbIsValid
(inside tryCatch
). If the connection is not valid, ugatsdb_reconnect
is called before executing the query.
Fixed a bug in transpose_wide
when data contains both numeric and categorical data (next to the date variable in the first column). In that case a list of two transposed datasets, one with the numeric data and the other with the categorical data, is returned.
The default date formatting for transpose_wide
was changed from an American MM/DD/YYYY date to a British DD/MM/YYYY date, which is also the Ugandan convention of recording dates.
Small changes and additions to the documentation. Notably, the package overview page is now called 'ugatsdb-package', with an alias 'ugatsdb'.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.