R Under development (unstable) (2024-11-28 r87392 ucrt) -- "Unsuffered Consequences" Copyright (C) 2024 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://example-data.ohdsi.dev/GiBleed.zip' Content type 'application/zip' length 6754786 bytes (6.4 MB) ================================================== downloaded 6.4 MB Download completed! Creating CDM database D:\temp\2024_11_29_09_55_01_21719\Rtmpy0tFRz\file160145ee663b9/GiBleed_5.3.zip Note: method with signature 'DBIConnection#Id' chosen for function 'dbExistsTable', target signature 'duckdb_connection#Id'. "duckdb_connection#ANY" would also be valid Support for 'prefix' in write_schema is deprecated and will be removed in a future release. Please use the `writePrefix` argument in `cdmFromCon()` instead. This message is displayed once per session. i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [820ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [287ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [262ms] i Generating 3 cohorts i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [677ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [281ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [225ms] 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 [276ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [247ms] i Generating 2 cohorts i Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 [211ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [215ms] i Generating 2 cohorts i Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 [191ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [214ms] i Generating 2 cohorts i Generating 2 cohorts i Generating 2 cohorts i Generating 1 cohort i Generating cohort (1/1) - gibleed_default v Generating cohort (1/1) - gibleed_default [332ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_default_with_descendants v Generating cohort (1/1) - gibleed_default_with_descendants [329ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_all v Generating cohort (1/1) - gibleed_all [327ms] i Generating 1 cohort i Generating cohort (1/1) - gibleed_all v Generating cohort (1/1) - gibleed_all [303ms] i Generating 1 cohort i Generating cohort (1/1) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/1) - cerebral_venous_sinus_thrombosis_01 [229ms] Attaching package: 'clock' The following object is masked from 'package:CDMConnector': as_date i Generating 5 cohorts i Generating cohort (1/5) - gibleed_all v Generating cohort (1/5) - gibleed_all [322ms] i Generating cohort (2/5) - gibleed_default v Generating cohort (2/5) - gibleed_default [287ms] i Generating cohort (3/5) - gibleed_default_with_descendants v Generating cohort (3/5) - gibleed_default_with_descendants [295ms] i Generating cohort (4/5) - gibleed_all_end_10 v Generating cohort (4/5) - gibleed_all_end_10 [334ms] i Generating cohort (5/5) - gibleed_end_10 v Generating cohort (5/5) - gibleed_end_10 [321ms] Getting distinct count of concept relationship table 0.08 sec elapsed Getting count of different relationship IDs in concept relationship table 0.07 sec elapsed Getting join of concept and concept class computed to a temp table 0.1 sec elapsed Getting concept table collected into memory 0.02 sec elapsed Getting join of person and observation period collected into memory 0.07 sec elapsed Getting summary of observation period start and end dates by gender concept id 0.14 sec elapsed i Generating 2 cohorts i Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (1/2) - cerebral_venous_sinus_thrombosis_01 [210ms] i Generating cohort (2/2) - deep_vein_thrombosis_01 v Generating cohort (2/2) - deep_vein_thrombosis_01 [215ms] i Generating 3 cohorts i Generating cohort (1/3) - another_gibleed_male v Generating cohort (1/3) - another_gibleed_male [586ms] i Generating cohort (2/3) - another_cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - another_cerebral_venous_sinus_thrombosis_01 [206ms] i Generating cohort (3/3) - another_deep_vein_thrombosis_01 v Generating cohort (3/3) - another_deep_vein_thrombosis_01 [236ms] i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [577ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [203ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [251ms] i Generating 3 cohorts i Generating cohort (1/3) - gibleed_male v Generating cohort (1/3) - gibleed_male [642ms] i Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 v Generating cohort (2/3) - cerebral_venous_sinus_thrombosis_01 [187ms] i Generating cohort (3/3) - deep_vein_thrombosis_01 v Generating cohort (3/3) - deep_vein_thrombosis_01 [269ms] i `EUNOMIA_DATA_FOLDER` set to: 'D:\temp\2024_11_29_09_55_01_21719\Rtmpy0tFRz'. trying URL 'https://example-data.ohdsi.dev/GiBleed.zip' Content type 'application/zip' length 6754786 bytes (6.4 MB) ================================================== downloaded 6.4 MB Download completed! Creating CDM database D:\temp\2024_11_29_09_55_01_21719\Rtmpy0tFRz/GiBleed_5.3.zip Getting distinct count of concept relationship table 0.09 sec elapsed Getting count of different relationship IDs in concept relationship table 0.06 sec elapsed Getting join of concept and concept class computed to a temp table 0.1 sec elapsed Getting concept table collected into memory 0.01 sec elapsed Getting join of person and observation period collected into memory 0.04 sec elapsed Getting summary of observation period start and end dates by gender concept id 0.16 sec elapsed 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 20 | PASS 361 ] ══ Skipped tests (20) ══════════════════════════════════════════════════════════ • Capr cannot be loaded (1): 'test-04-db-generateConceptCohortSet.R:578:3' • On CRAN (8): 'test-04-db-generateConceptCohortSet.R:381:3', 'test-04-db-generateConceptCohortSet.R:399:3', 'test-04-db-generateConceptCohortSet.R:425:3', 'test-Eunomia.R:59:3', 'test-db-recordCohortAttrition.R:121:5', 'test-db-recordCohortAttrition.R:134:3', 'test-memory-issue.R:6:3', 'test-write_prefix_cohort_generation_snowflake.R:4:3' • TreatmentPatterns cannot be loaded (1): 'test-03-db-generateCohortSet.R:130:3' • arrow::write_parquet is failing (1): 'test-local_cdm.R:3:3' • eunomia_is_available("empty_cdm") is not TRUE (1): 'test-Eunomia.R:42:3' • failing test (2): 'test-07-db-dateadd.R:126:3', 'test-db-in_schema.R:27:5' • manual test (6): 'test-02-db-cdm.R:235:3', 'test-03-db-generateCohortSet.R:111:3', 'test-03-db-generateCohortSet.R:248:3', 'test-09-db-copy_cdm_to.R:62:3', 'test-Eunomia.R:2:3', 'test-db-write_schema_with_database.R:5:3' [ FAIL 0 | WARN 0 | SKIP 20 | PASS 361 ] > > > > > > proc.time() user system elapsed 344.07 33.65 329.10