R Under development (unstable) (2026-03-07 r89568 ucrt) -- "Unsuffered Consequences" Copyright (C) 2026 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. > # This file is part of the standard setup for testthat. > # It is recommended that you do not modify it. > # > # Where should you do additional test configuration? > # Learn more about the roles of various files in: > # * https://r-pkgs.org/tests.html > # * https://testthat.r-lib.org/reference/test_package.html#special-files > > library(testthat) > library(CDMConnector) > > test_check("CDMConnector") trying URL 'https://cdmconnectordata.blob.core.windows.net/cdmconnector-example-data/GiBleed_5.3.zip' Content type 'application/zip' length 6754786 bytes (6.4 MB) ================================================== downloaded 6.4 MB Download completed! Creating CDM database D:\temp\2026_03_08_14_20_17_15763\Rtmp614i3L\file10bc02d5b3ed8/GiBleed_5.3.zip Connecting using DuckDB driver i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [650ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [172ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [172ms] i Generating 3 cohorts i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [490ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [162ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [165ms] i Generating 3 cohorts i Generating 2 cohorts i Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 [180ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [165ms] i Generating 1 cohort i Generating cohort (1/1) - deep_vein_thrombosis_01 v Generating cohort (1/1) - deep_vein_thrombosis_01 [182ms] i Generating 1 cohort i Generating cohort (1/1) - deep_vein_thrombosis_01 v Generating cohort (1/1) - deep_vein_thrombosis_01 [166ms] i Generating 2 cohorts i Generating 2 cohorts i Generating 2 cohorts i Generating 1 cohort i Generating cohort (1/1) - viral_sinusitus v Generating cohort (1/1) - viral_sinusitus [458ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_default v Generating cohort (1/1) - gibleed_default [235ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_default_with_descendants v Generating cohort (1/1) - gibleed_default_with_descendants [257ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_all v Generating cohort (1/1) - gibleed_all [233ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_all v Generating cohort (1/1) - gibleed_all [233ms] Creating a new cdm Uploading table person (1 rows) - [1/3] Uploading table observation_period (1 rows) - [2/3] Uploading table vocabulary (125 rows) - [3/3] Creating a new cdm Uploading table person (1 rows) - [1/3] Creating a new cdm Uploading table person (2694 rows) - [1/35] Uploading table observation_period (5343 rows) - [2/35] Uploading table visit_occurrence (1037 rows) - [3/35] Uploading table visit_detail (0 rows) - [4/35] Uploading table condition_occurrence (65332 rows) - [5/35] Uploading table drug_exposure (67707 rows) - [6/35] Uploading table procedure_occurrence (37409 rows) - [7/35] Uploading table device_exposure (0 rows) - [8/35] Uploading table measurement (44053 rows) - [9/35] Uploading table observation (1477 rows) - [10/35] Uploading table death (0 rows) - [11/35] Uploading table note (0 rows) - [12/35] Uploading table note_nlp (0 rows) - [13/35] Uploading table specimen (0 rows) - [14/35] Uploading table fact_relationship (0 rows) - [15/35] Uploading table location (0 rows) - [16/35] Uploading table care_site (0 rows) - [17/35] Uploading table provider (0 rows) - [18/35] Uploading table payer_plan_period (0 rows) - [19/35] Uploading table cost (0 rows) - [20/35] Uploading table drug_era (52508 rows) - [21/35] Uploading table dose_era (0 rows) - [22/35] Uploading table condition_era (65719 rows) - [23/35] Uploading table metadata (0 rows) - [24/35] Uploading table cdm_source (1 rows) - [25/35] Uploading table concept (444 rows) - [26/35] Uploading table vocabulary (125 rows) - [27/35] Uploading table domain (45 rows) - [28/35] Uploading table concept_class (0 rows) - [29/35] Uploading table concept_relationship (8 rows) - [30/35] Uploading table relationship (480 rows) - [31/35] Uploading table concept_synonym (1064 rows) - [32/35] Uploading table concept_ancestor (65690 rows) - [33/35] Uploading table source_to_concept_map (0 rows) - [34/35] Uploading table drug_strength (0 rows) - [35/35] Creating a new cdm Uploading table person (2694 rows) - [1/35] Uploading table observation_period (5343 rows) - [2/35] Uploading table visit_occurrence (1037 rows) - [3/35] Uploading table visit_detail (0 rows) - [4/35] Uploading table condition_occurrence (65332 rows) - [5/35] Uploading table drug_exposure (67707 rows) - [6/35] Uploading table procedure_occurrence (37409 rows) - [7/35] Uploading table device_exposure (0 rows) - [8/35] Uploading table measurement (44053 rows) - [9/35] Uploading table observation (1477 rows) - [10/35] Uploading table death (0 rows) - [11/35] Uploading table note (0 rows) - [12/35] Uploading table note_nlp (0 rows) - [13/35] Uploading table specimen (0 rows) - [14/35] Uploading table fact_relationship (0 rows) - [15/35] Uploading table location (0 rows) - [16/35] Uploading table care_site (0 rows) - [17/35] Uploading table provider (0 rows) - [18/35] Uploading table payer_plan_period (0 rows) - [19/35] Uploading table cost (0 rows) - [20/35] Uploading table drug_era (52508 rows) - [21/35] Uploading table dose_era (0 rows) - [22/35] Uploading table condition_era (65719 rows) - [23/35] Uploading table metadata (0 rows) - [24/35] Uploading table cdm_source (1 rows) - [25/35] Uploading table concept (444 rows) - [26/35] Uploading table vocabulary (125 rows) - [27/35] Uploading table domain (45 rows) - [28/35] Uploading table concept_class (0 rows) - [29/35] Uploading table concept_relationship (8 rows) - [30/35] Uploading table relationship (480 rows) - [31/35] Uploading table concept_synonym (1064 rows) - [32/35] Uploading table concept_ancestor (65690 rows) - [33/35] Uploading table source_to_concept_map (0 rows) - [34/35] Uploading table drug_strength (0 rows) - [35/35] i Generating 5 cohorts i Generating cohort (1/5) - gibleed_all v Generating cohort (1/5) - gibleed_all [235ms] i Generating cohort (2/5) - gibleed_default v Generating cohort (2/5) - gibleed_default [235ms] i Generating cohort (3/5) - gibleed_default_with_descendants v Generating cohort (3/5) - gibleed_default_with_descendants [246ms] i Generating cohort (4/5) - gibleed_all_end_10 v Generating cohort (4/5) - gibleed_all_end_10 [260ms] i Generating cohort (5/5) - gibleed_end_10 v Generating cohort (5/5) - gibleed_end_10 [262ms] Getting distinct count of concept relationship table Getting count of different relationship IDs in concept relationship table Getting join of concept and concept class computed to a temp table Getting concept table collected into memory Getting join of person and observation period collected into memory Getting summary of observation period start and end dates by gender concept id Note: method with signature 'DBIConnection#Id' chosen for function 'dbExistsTable', target signature 'duckdb_connection#Id'. "duckdb_connection#ANY" would also be valid i Generating 2 cohorts i Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 [180ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [165ms] i Generating 3 cohorts i Generating cohort (1/3) - another_gibleed_male v Generating cohort (1/3) - another_gibleed_male [466ms] i Generating cohort (2/3) - another_cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - another_cerebral_venous_sinus_thrombosis_01 [151ms] i Generating cohort (3/3) - another_deep_vein_thrombosis_01 v Generating cohort (3/3) - another_deep_vein_thrombosis_01 [161ms] i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [491ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [162ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [154ms] i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [668ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [147ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [163ms] i `EUNOMIA_DATA_FOLDER` set to: 'D:\temp\2026_03_08_14_20_17_15763\Rtmp614i3L'. trying URL 'https://cdmconnectordata.blob.core.windows.net/cdmconnector-example-data/GiBleed_5.3.zip' Content type 'application/zip' length 6754786 bytes (6.4 MB) ================================================== downloaded 6.4 MB Download completed! Creating CDM database D:\temp\2026_03_08_14_20_17_15763\Rtmp614i3L/GiBleed_5.3.zip Getting distinct count of concept relationship table Getting count of different relationship IDs in concept relationship table Getting join of concept and concept class computed to a temp table Getting concept table collected into memory Getting join of person and observation period collected into memory Getting summary of observation period start and end dates by gender concept id i Generating 1 cohort i Generating cohort (1/1) - gibleed_all v Generating cohort (1/1) - gibleed_all [249ms] Creating a new cdm Uploading table person (2694 rows) - [1/2] Uploading table observation_period (5343 rows) - [2/2] i Generating 1 cohort i Generating cohort (1/1) - gibleed_male v Generating cohort (1/1) - gibleed_male [460ms] Note: method with signature 'DBIConnection#Id' chosen for function 'dbExistsTable', target signature 'duckdb_connection#Id'. "duckdb_connection#ANY" would also be valid [ FAIL 0 | WARN 0 | SKIP 60 | PASS 418 ] ══ Skipped tests (60) ══════════════════════════════════════════════════════════ • "postgres" %in% dbToTest is not TRUE (1): 'test-02-db-cdm.R:297:3' • "snowflake" %in% dbToTest is not TRUE (1): 'test-cdmDisconnect.R:5:3' • "sqlserver" %in% dbToTest is not TRUE (1): 'test-02-db-cdm.R:330:3' • On CRAN (46): 'test-04-db-generateConceptCohortSet.R:399:3', 'test-04-db-generateConceptCohortSet.R:415:3', 'test-04-db-generateConceptCohortSet.R:439:3', 'test-04-db-generateConceptCohortSet.R:507:3', 'test-04-db-generateConceptCohortSet.R:568:3', 'test-04-db-generateConceptCohortSet.R:616:3', 'test-07-db-dateadd.R:327:3', 'test-16-db-dbSource.R:85:3', 'test-Eunomia.R:41:3', 'test-Eunomia.R:63:3', 'test-buildEraTables.R:4:1', 'test-cdm-extra.R:5:1', 'test-cdmDisconnect.R:59:3', 'test-cdmFromCohortSet-extra.R:4:1', 'test-cdmFromCohortSet.R:2:1', 'test-circe-builders-extra.R:4:1', 'test-circe-domains.R:5:1', 'test-circe-extra.R:4:1', 'test-cohdSimilarConcepts.R:2:1', 'test-cohort-reconnect.R:5:1', 'test-compute-extra.R:4:1', 'test-copyCdmTo-extra.R:4:1', 'test-dag_cache-extra.R:4:1', 'test-dag_cache.R:5:1', 'test-dateadd-extra.R:4:1', 'test-db-recordCohortAttrition.R:121:5', 'test-db-recordCohortAttrition.R:134:3', 'test-dbSource-extra.R:4:1', 'test-execution_graph-extra.R:4:1', 'test-generateCohortSet-extra.R:5:1', 'test-generateCohortSet2-db.R:1:1', 'test-generateCohortSet2-extra.R:8:1', 'test-generateCohortSet2-postgres.R:7:3', 'test-generateCohortSet2-postgres.R:62:3', 'test-generateConceptCohortSet-extra.R:4:1', 'test-local-generateCohortSet.R:8:3', 'test-memory-issue.R:6:3', 'test-misc-extra.R:4:1', 'test-optimizer-extra.R:4:1', 'test-sqlrender-extra.R:4:1', 'test-sqlrender.R:6:1', 'test-summariseQuantile-extra.R:4:1', 'test-translate-lightweight.R:6:1', 'test-translate_lightweight-extra.R:5:1', 'test-utils-extra.R:4:1', 'test-write_prefix_cohort_generation_snowflake.R:4:3' • dateadd requires magrittr pipe (%>%); direct mutate() and native pipe (|>) not supported (1): 'test-07-db-dateadd.R:126:3' • failing test (1): 'test-db-in_schema.R:34:5' • manual test (7): 'test-02-db-cdm.R:237:3', 'test-03-db-generateCohortSet.R:115:3', 'test-03-db-generateCohortSet.R:250:3', 'test-09-db-copy_cdm_to.R:60:3', 'test-Eunomia.R:2:3', 'test-db-in_schema.R:46:3', 'test-db-write_schema_with_database.R:5:3' • {Capr} is not installed (1): 'test-04-db-generateConceptCohortSet.R:593:3' • {TreatmentPatterns} is not installed (1): 'test-03-db-generateCohortSet.R:133:3' [ FAIL 0 | WARN 0 | SKIP 60 | PASS 418 ] > > > > > > proc.time() user system elapsed 231.12 19.89 213.54