The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.
Changes:
Changes:
Bug fixes:
Resolved issue where failed queries were being aborted inside the wrong connection in PooledConnectionHandler
Refactored pooled connection handler to better ensure checkout connections are returned
Changes:
Changes:
Changes made to make package CRAN compliant
PooledConnectionHandler
now uses withr::defer to
automatically returned pooled connections returned with
getConnection
Bug fixes:
Bug fixes:
Changes:
Bug Fixes: 1. Removal of comment in DataMigrationManager sql that caused translation error for spark/databricks platforms
Changes:
Changes:
Bug Fixes:
Use of RPostgres updated.
Use of dbplyr::in_schema for using dplyr::tbl in ConnectionHandlers
Changes:
PooledConnectionHandler
classes to use DBI
connections to bypass use of JDBC on systems where it may not be
supported.Bug Fixes:
loadRenderTranslateSql
Bug fixes:
emptyIsNa
property which is no longer used/requiredChanges: 1. Added utility function grantTablePermissions
to make it easier to grant select, delete, insert and update permissions
for users on results database setups
Added ResultExportManager
class and utility to
support standardized validation routines for exported data
Allow packages to have an internal migration table prefix
separate from the user defined one e.g
my_study_sccs_migration
emptyIsNa
field is no longer required in
specifications
Purge all data supported in upload functionality (requiring user input)
Bug fixes:
generateSqlSchema
No longer requires primary key
field to be lower case in results spec files, is now
case-insensitive
connectionHandlers now check sql string attribute to see if query needs translating, avoiding potential for errors caused by double translation
Changes:
removed spuriously added createResultsDataModel
function
added QueryNamespace
R6 class that allows users to
define a table specification and then complete queries without always
having to specify table names
Added createQueryNamespace
helper function to allow
a variety of convenient ways to create query namespaces
Added loadResultsDataModelSpecifications
that loads
results specs from a csv file and checks that the columns are
correct
Added some vignettes on usage of package features
Changes:
Added support for validating results model schema data.frames
Added function to generate sql for creating schemas from specification data frames
Added unzip folder function
Added robust upload function for directories of csv files conforming to model specifications
Added vignette to describe creating results schemas and uploading data sets
Changes:
Fixed support for newer versions of DatabaseConnector that have
altered interface - this will mean this package now depends on
DatabaseConnector version 6.0.0 and above. However, queryDb
compatibility means that no code that uses these classes will need to be
altered.
Added support for ConnectionHandler
to load tables
with dbplyr/dplyr
tbl
interface (i.e. lazy
loading). This means that dplyr
style queries should be
supported natively in Pooled and non-pooled connections.
Changes: 1. Added snakeCaseToCamelCase parameter to public in connectionHandlers so it can be defined once if required
Initial version
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.