R Under development (unstable) (2025-09-14 r88831 ucrt) -- "Unsuffered Consequences" Copyright (C) 2025 The R Foundation for Statistical Computing Platform: x86_64-w64-mingw32/x64 R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > library(testthat) > library(ResultModelManager) Loading required package: R6 Loading required package: DatabaseConnector > > test_check("ResultModelManager") Connecting using SQLite driver trying URL 'https://jdbc.postgresql.org/download/postgresql-42.7.3.jar' Content type 'application/java-archive' length 1089312 bytes (1.0 MB) ================================================== downloaded 1.0 MB DatabaseConnector postgresql JDBC driver downloaded to 'D:\temp\2025_09_15_22_55_17_32430\RtmpQ98bOU\filec5585bd356f7'. Connecting using SQLite driver | | | 0% | |=================================== | 50% | |======================================================================| 100% Executing SQL took 0.014 secs Connecting using SQLite driver Closing database connection Connecting using SQLite driver Closing database connection Connecting using SQLite driver Closing database connection | | | 0% | |======================================================================| 100% Executing SQL took 0.00418 secs Connecting using SQLite driver | | | 0% | |=================================== | 50% | |======================================================================| 100% Executing SQL took 0.00518 secs Using DatabaseConnector jdbc driver. Initializing pooled connection Connecting using SQLite driver Initializing pooled connection Connecting using SQLite driver Initializing pooled connection Connecting using SQLite driver | | | 0% | |======================================================================| 100% Executing SQL took 0.00429 secs Migrator using SQL files in ResultModelManager Connecting using SQLite driver Creating migrations table Executing SQL took 0.00547 secs Migrations table created Executing migration: Migration_1-example.sql Executing SQL took 0.00385 secs Saving migration: Migration_1-example.sql Executing SQL took 0.00364 secs Migration complete Migration_1-example.sql Executing migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00538 secs Saving migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00346 secs Migration complete Migration_2-MultiPlatformExample.sql Closing database connection Connecting using SQLite driver Migrator using SQL files in ResultModelManager Connecting using SQLite driver Closing database connection Migrator using SQL files in directory structure Connecting using SQLite driver Creating migrations table Executing SQL took 0.00364 secs Migrations table created Executing migration: Migration_1-example.sql Executing SQL took 0.00569 secs Saving migration: Migration_1-example.sql Executing SQL took 0.00483 secs Migration complete Migration_1-example.sql Executing migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00713 secs Saving migration: Migration_2-MultiPlatformExample.sql Executing SQL took 0.00376 secs Migration complete Migration_2-MultiPlatformExample.sql Closing database connection Connecting using SQLite driver Migrator using SQL files in directory structure Column databaseId in table foo in results folder foo.zip is of type character, but was expecting bigint. Attempting to convert. Column charField in table foo in results folder foo.zip is of type numeric, but was expecting varchar. Attempting to convert. Column dateField in table foo in results folder foo.zip is of type character, but was expecting date. Attempting to convert. Connecting using SQLite driver | | | 0% | |============ | 17% | |======================= | 33% | |=================================== | 50% | |=============================================== | 67% | |========================================================== | 83% | |======================================================================| 100% Executing SQL took 0.00621 secs Inserting data took 0.0153 secs Executing SQL took 0.0035 secs Inserting data took 0.0447 secs Executing SQL took 0.00288 secs Inserting data took 0.00989 secs Executing SQL took 0.00302 secs Using DatabaseConnector jdbc driver. Connecting using SQLite driver Using DatabaseConnector jdbc driver. Initializing pooled connection Connecting using SQLite driver Connecting using SQLite driver Executing SQL took 0.00367 secs Executing SQL took 0.00292 secs Closing database connection null/na primary keys found duplicate primary keys found Connecting using SQLite driver Inserting data took 0.0579 secs Connecting using SQLite driver | | | 0% | |============ | 17% | |======================= | 33% | |=================================== | 50% | |=============================================== | 67% | |========================================================== | 83% | |======================================================================| 100% Executing SQL took 0.0103 secs Connecting using SQLite driver [ FAIL 2 | WARN 0 | SKIP 16 | PASS 135 ] ══ Skipped tests (16) ══════════════════════════════════════════════════════════ • On CRAN (7): 'test-DataMigrationManager.R:70:3', 'test-DataMigrationManager.R:92:3', 'test-PyFunctions.R:2:3', 'test-PyFunctions.R:39:3', 'test-PyFunctions.R:112:3', 'test-PyFunctions.R:167:3', 'test-QueryNamespace.R:63:3' • results db not available (9): 'test-DataModel.R:18:3', 'test-DataModel.R:56:3', 'test-DataModel.R:145:3', 'test-DataModel.R:200:3', 'test-DataModel.R:239:3', 'test-DataModelFunctions.R:93:3', 'test-PooledConnection.R:34:3', 'test-ResultExportManager.R:131:3', 'test-Utils.R:15:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-DataModelFunctions.R:230:3'): Delete primary key rows function SQLITE ── `result` (`actual`) not identical to `keptRows` (`expected`). `names(actual)`: "id" "id_2" `names(expected)`: "ID" "ID_2" `actual$id` is a double vector (5, 7) `expected$id` is absent `actual$id_2` is a double vector (6, 8) `expected$id_2` is absent `actual$ID` is absent `expected$ID` is a double vector (5, 7) `actual$ID_2` is absent `expected$ID_2` is a double vector (6, 8) ── Failure ('test-ResultExportManager.R:70:3'): exportDataFrame method exports data frame correctly ── `exportManager$exportDataFrame(df2, "table1", append = TRUE)` did not throw the expected error. [ FAIL 2 | WARN 0 | SKIP 16 | PASS 135 ] Error: Test failures In addition: Warning message: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead Execution halted Warning messages: 1: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead 2: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead 3: In .subset2(e, "finalize")() : Due to changes in the R6 package, this method is deprecated and will be removed in a future version. Please use closeConnection instead