R Under development (unstable) (2025-10-27 r88972 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)
> options(dbms = "sqlite")
> runTestsOnEunomia <- TRUE
> if (runTestsOnEunomia) {
+   test_check("FeatureExtraction")
+ }
Loading required package: FeatureExtraction
Loading required package: DatabaseConnector
Loading required package: Andromeda
Loading required package: dplyr

Attaching package: 'dplyr'

The following object is masked from 'package:testthat':

    matches

The following objects are masked from 'package:stats':

    filter, lag

The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union

************* Testing on sqlite *************

attempting to download GiBleed
trying URL 'https://raw.githubusercontent.com/OHDSI/EunomiaDatasets/main/datasets/GiBleed/GiBleed_5.3.zip'
Content type 'application/zip' length 6861852 bytes (6.5 MB)
==================================================
downloaded 6.5 MB

attempting to extract and load: D:\temp\2025_10_28_10_35_17_5618\RtmpsNKXvF/GiBleed_5.3.zip to: D:\temp\2025_10_28_10_35_17_5618\RtmpsNKXvF/GiBleed_5.3.sqlite
Connecting using SQLite driver
Executing SQL took 0.0277 secs
Cohorts created in table main.cohort
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.955 secs
Constructing features on server
Fetching data from server
Fetching data took 0.801 secs
# CovariateData object

Cohorts of interest IDs: 1, 2

Inherits from Andromeda:
# Andromeda object
# Physical location:  D:\temp\2025_10_28_10_35_17_5618\RtmpsNKXvF\file717c22174efd.duckdb

Tables:
$analysisRef (analysisId, analysisName, domainId, startDay, endDay, isBinary, missingMeansZero)
$covariateRef (covariateId, covariateName, analysisId, conceptId)
$covariates (cohortDefinitionId, covariateId, covariateValue, rowId)
Constructing features on server
Fetching data from server
Fetching data took 0.688 secs
Constructing features on server
Fetching data from server
Fetching data took 0.966 secs
Constructing features on server
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.695 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.66 secs
Constructing features on server
Fetching data from server
Fetching data took 0.673 secs
Constructing features on server
Fetching data from server
Fetching data took 0.709 secs
Constructing features on server
Fetching data from server
Fetching data took 0.546 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.833 secs
Constructing features on server
Fetching data from server
Fetching data took 0.822 secs
Aggregating covariates took 1.4 secs
Constructing features on server
Fetching data from server
Fetching data took 0.537 secs
Constructing features on server
Fetching data from server
Fetching data took 0.666 secs
Constructing features on server
Fetching data from server
Fetching data took 0.659 secs
Constructing features on server
Fetching data from server
Fetching data took 0.678 secs
Constructing features on server
Fetching data from server
Fetching data took 0.662 secs
Constructing features on server
Fetching data from server
Fetching data took 0.697 secs
Constructing features on server
Fetching data from server
Fetching data took 0.773 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.964 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.955 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.681 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.751 secs
Tidying covariates took 0.562 secs
Removing 1 redundant covariates
Removing 1 infrequent covariates
Normalizing covariates
Tidying covariates took 2.16 secs
Sending temp tables to server
Constructing features on server
Fetching data from server
Fetching data took 0.766 secs
Removing 0 redundant covariate ID - time ID combinations
Removing 0 infrequent covariates
Normalizing covariates
Tidying covariates took 2.53 secs
Removing 1 redundant covariates
Tidying covariates took 1.72 secs
Removing 1 redundant covariates
Tidying covariates took 1.94 secs
Removing 1 redundant covariates
Tidying covariates took 1.63 secs
Removing 1 redundant covariates
Tidying covariates took 1.57 secs
Removing 1 redundant covariates
Tidying covariates took 1.56 secs
Removing 1 redundant covariates
Tidying covariates took 1.56 secs
Removing 1 redundant covariates
Tidying covariates took 1.55 secs
Removing 1 redundant covariates
Tidying covariates took 1.64 secs
Removing 1 redundant covariates
Tidying covariates took 1.64 secs
Removing 1 redundant covariates
Tidying covariates took 1.62 secs
[ FAIL 0 | WARN 7 | SKIP 83 | PASS 131 ]

══ Skipped tests (83) ══════════════════════════════════════════════════════════
• On CRAN (27): 'test-Aggregation.R:6:3', 'test-CompareCohorts.R:41:3',
  'test-CovariateData.R:55:3', 'test-CovariateData.R:99:3',
  'test-CovariateData.R:160:3', 'test-CovariateData.R:174:3',
  'test-CovariateData.R:193:3', 'test-GetCohortBasedCovariates.R:515:3',
  'test-GetCohortBasedCovariates.R:526:3',
  'test-GetCohortBasedCovariates.R:537:3',
  'test-GetCohortBasedCovariates.R:548:3',
  'test-GetCohortBasedCovariates.R:559:3',
  'test-GetCohortBasedCovariates.R:570:3',
  'test-GetCohortBasedCovariates.R:581:3',
  'test-GetCohortBasedCovariates.R:592:3', 'test-GetCovariates.R:63:3',
  'test-GetCovariates.R:87:3', 'test-GetCovariates.R:100:3',
  'test-GetCovariates.R:113:3',
  'test-GetCovariatesFromCohortAttributes.R:30:3',
  'test-GetCovariatesFromCohortAttributes.R:51:3',
  'test-GetCovariatesFromCohortAttributes.R:79:3',
  'test-GetCovariatesTemporalSequence.R:83:3',
  'test-GetDefaultCovariates.R:6:3', 'test-HelperFunctions.R:31:3',
  'test-Table1.R:85:3', 'test-Table1.R:146:3'
• dbms == "oracle" is not TRUE (14): 'test-GetCohortBasedCovariates.R:822:3',
  'test-GetCohortBasedCovariates.R:834:3',
  'test-GetCohortBasedCovariates.R:846:3',
  'test-GetCohortBasedCovariates.R:858:3',
  'test-GetCohortBasedCovariates.R:870:3',
  'test-GetCohortBasedCovariates.R:882:3',
  'test-GetCohortBasedCovariates.R:894:3',
  'test-GetCohortBasedCovariates.R:906:3',
  'test-GetCohortBasedCovariates.R:918:3', 'test-query-no-fail.R:162:3',
  'test-query-no-fail.R:344:3', 'test-query-no-fail.R:450:3',
  'test-query-no-fail.R:558:3', 'test-spot-checks.R:204:3'
• dbms == "postgresql" is not TRUE (14):
  'test-GetCohortBasedCovariates.R:604:3',
  'test-GetCohortBasedCovariates.R:616:3',
  'test-GetCohortBasedCovariates.R:628:3',
  'test-GetCohortBasedCovariates.R:640:3',
  'test-GetCohortBasedCovariates.R:652:3',
  'test-GetCohortBasedCovariates.R:664:3',
  'test-GetCohortBasedCovariates.R:676:3',
  'test-GetCohortBasedCovariates.R:688:3',
  'test-GetCohortBasedCovariates.R:700:3', 'test-query-no-fail.R:146:3',
  'test-query-no-fail.R:328:3', 'test-query-no-fail.R:434:3',
  'test-query-no-fail.R:542:3', 'test-spot-checks.R:190:3'
• dbms == "redshift" is not TRUE (14): 'test-GetCohortBasedCovariates.R:931:3',
  'test-GetCohortBasedCovariates.R:943:3',
  'test-GetCohortBasedCovariates.R:955:3',
  'test-GetCohortBasedCovariates.R:967:3',
  'test-GetCohortBasedCovariates.R:979:3',
  'test-GetCohortBasedCovariates.R:991:3',
  'test-GetCohortBasedCovariates.R:1003:3',
  'test-GetCohortBasedCovariates.R:1015:3',
  'test-GetCohortBasedCovariates.R:1027:3', 'test-query-no-fail.R:170:3',
  'test-query-no-fail.R:352:3', 'test-query-no-fail.R:458:3',
  'test-query-no-fail.R:566:3', 'test-spot-checks.R:211:3'
• dbms == "sql server" is not TRUE (14):
  'test-GetCohortBasedCovariates.R:713:3',
  'test-GetCohortBasedCovariates.R:725:3',
  'test-GetCohortBasedCovariates.R:737:3',
  'test-GetCohortBasedCovariates.R:749:3',
  'test-GetCohortBasedCovariates.R:761:3',
  'test-GetCohortBasedCovariates.R:773:3',
  'test-GetCohortBasedCovariates.R:785:3',
  'test-GetCohortBasedCovariates.R:797:3',
  'test-GetCohortBasedCovariates.R:809:3', 'test-query-no-fail.R:154:3',
  'test-query-no-fail.R:336:3', 'test-query-no-fail.R:442:3',
  'test-query-no-fail.R:550:3', 'test-spot-checks.R:197:3'

[ FAIL 0 | WARN 7 | SKIP 83 | PASS 131 ]
Executing SQL took 0.00861 secs
> 
> proc.time()
   user  system elapsed 
 395.70   15.84  396.53