Changes in version 0.6.2 (2025-10-02) Bug Fixes: 1. Resolved issue with migration status check failing on packages using a table prefix (e.g. cohort generator) Changes in version 0.6.1 (2025-09-25) Bug Fixes: 1. Removed use of dbGetQuery call in pooled connection handler, requiring support for DatabaseConnector 7 Changes in version 0.6.0 (2025-09-18) Changes: 1. Added experimental wrapper functions for python based upload of csv files 2. Breaking change - public use of finalize from R6 classes causes deprecation warning in use of R6 package. Package maintainers should replace this with class to closeConnection which is in use or has been added to all classes. Note - due to CRAN this package cannot release without making this change. Bug Fixes: 1. Fixed big in type check issue in ResultExportManager 2. Fixed bad deletion of existing primary key rows. Also improved efficiency of delete by using a join Changes in version 0.5.11 (2024-09-19) Changes: 1. Refactor of tests to accommodate cran Changes in version 0.5.10 (2024-08-21) Changes: 1. Using readr column types to work around issues with inconsistent type conversion between DBI and JDBC drivers. Bug fixes: 1. Resolved issue where failed queries were being aborted inside the wrong connection in PooledConnectionHandler 2. Refactored pooled connection handler to better ensure checkout connections are returned Changes in version 0.5.9 (2024-07-21) Changes: 1. More tidy cleanup of PooledConnectionHandlers to prevent leaked connections. Changes: 1. Changes made to make package CRAN compliant 2. PooledConnectionHandler now uses withr::defer to automatically returned pooled connections returned with getConnection Changes in version 0.5.8 Bug fixes: 1. Fixed bug in uploads where empty tables are used to determine uploads (and can fail) Changes in version 0.5.7 Bug fixes: 1. Added type conversion checking on upload of data where columns are characters but interpreted as numeric from reading inserted data Changes in version 0.5.6 Changes: 1. For PooledConnectionHandler, added check to see if java stack size is set on unix systems before connecting stop overflow errors on rconnect platforms. Note that this solution will fail if RJava is called before the connection Changes in version 0.5.5 Bug Fixes: 1. Removal of comment in DataMigrationManager sql that caused translation error for spark/databricks platforms 2. The "optional" column in the model specification is now fully optional (when not present, all columns are assumed to be required) Changes in version 0.5.4 Changes: 1. Use of jdbc connection is default in pooled connection class Changes in version 0.5.3 Changes: 1. Tests for PooledConnection classes Bug Fixes: 1. Use of RPostgres updated. 2. Use of dbplyr::in_schema for using dplyr::tbl in ConnectionHandlers Changes in version 0.5.2 Changes: 1. Allow PooledConnectionHandler classes to use DBI connections to bypass use of JDBC on systems where it may not be supported. Bug Fixes: 1. Fixed issue in platform specific migrations where SqlRender sometimes fails to add attribute when calling loadRenderTranslateSql Changes in version 0.5.1 Bug fixes: 1. Fixed issue with uploads results from removal of emptyIsNa property which is no longer used/required Changes in version 0.5.0 Changes: 1. Added utility function grantTablePermissions to make it easier to grant select, delete, insert and update permissions for users on results database setups 2. Added ResultExportManager class and utility to support standardized validation routines for exported data 3. Allow packages to have an internal migration table prefix separate from the user defined one e.g my_study_sccs_migration 4. emptyIsNa field is no longer required in specifications 5. Purge all data supported in upload functionality (requiring user input) Bug fixes: 1. generateSqlSchema No longer requires primary key field to be lower case in results spec files, is now case-insensitive 2. connectionHandlers now check sql string attribute to see if query needs translating, avoiding potential for errors caused by double translation Changes in version 0.4.0 Changes: 1. removed spuriously added createResultsDataModel function 2. added QueryNamespace R6 class that allows users to define a table specification and then complete queries without always having to specify table names 3. Added createQueryNamespace helper function to allow a variety of convenient ways to create query namespaces 4. Added loadResultsDataModelSpecifications that loads results specs from a csv file and checks that the columns are correct 5. Added some vignettes on usage of package features Changes in version 0.3.0 Changes: 1. Added support for validating results model schema data.frames 2. Added function to generate sql for creating schemas from specification data frames 3. Added unzip folder function 4. Added robust upload function for directories of csv files conforming to model specifications 5. Added vignette to describe creating results schemas and uploading data sets Changes in version 0.2.0 Changes: 1. 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. 2. 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 in version 0.1.1 Changes: 1. Added snakeCaseToCamelCase parameter to public in connectionHandlers so it can be defined once if required 2. Added schema generator function that creates sql from csv files with table defs Changes in version 0.1.0 Initial version