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’.