R Under development (unstable) (2024-01-26 r85832 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.

> library(testthat)
> options(dbms = "sql server")
> test_check("CohortAlgebra")
Loading required package: CohortAlgebra
Loading required package: DatabaseConnector

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 sql server *************
Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpqaOS6G\file1bbb04ef6710b/jdbcDrivers'` to C:\Users\CRAN\Documents/.Renviron and restarting R.
trying URL 'https://ohdsi.github.io/DatabaseConnectorJars/postgresqlV42.2.18.zip'
Content type 'application/zip' length 931791 bytes (909 KB)
==================================================
downloaded 909 KB

DatabaseConnector postgresql JDBC driver downloaded to 'D:\temp\RtmpqaOS6G\file1bbb04ef6710b/jdbcDrivers'.
Consider adding `DATABASECONNECTOR_JAR_FOLDER='D:\temp\RtmpqaOS6G\file1bbb04ef6710b/jdbcDrivers'` to C:\Users\CRAN\Documents/.Renviron and restarting R.
trying URL 'https://ohdsi.github.io/DatabaseConnectorJars/sqlServerV9.2.0.zip'
Content type 'application/zip' length 1262814 bytes (1.2 MB)
==================================================
downloaded 1.2 MB

DatabaseConnector sql server JDBC driver downloaded to 'D:\temp\RtmpqaOS6G\file1bbb04ef6710b/jdbcDrivers'.
[ FAIL 0 | WARN 0 | SKIP 9 | PASS 0 ]

══ Skipped tests (9) ═══════════════════════════════════════════════════════════
• skipCdmTests is TRUE (9): 'test-appendCohortTables.R:2:3',
  'test-copyCohorts.R:2:3', 'test-deleteCohort.R:2:3',
  'test-eraFyCohorts.R:2:3', 'test-intersectCohorts.R:2:3',
  'test-minusCohorts.R:2:3', 'test-reindexCohortsByDays.R:2:3',
  'test-removeOverlappingSubjects.R:2:3', 'test-unionCohorts.R:2:3'

[ FAIL 0 | WARN 0 | SKIP 9 | PASS 0 ]
Warning message:
The folder location 'D:\temp\RtmpqaOS6G\file1bbb04ef6710b/jdbcDrivers' does not exist. Attempting to create. 
> 
> proc.time()
   user  system elapsed 
   1.31    0.25    1.78