OHDSI / ResultModelManager

RMM is an R package designed to handle common ohdsi results data management functions by providing a common API for data model migrations and definitions
https://ohdsi.github.io/ResultModelManager/
Apache License 2.0
3 stars 3 forks source link

Currently released version failing R check #35

Closed schuemie closed 1 year ago

schuemie commented 1 year ago

I see

> test_check("ResultModelManager")
Connecting using SQLite driver
trying URL 'https://***.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 '/Users/runner/.jdbcDrivers'.
Connecting using PostgreSQL driver

  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |==================                                                    |  25%
  |                                                                            
  |===================================                                   |  50%
  |                                                                            
  |====================================================                  |  75%Error in `source_file()`:
! In path: "/Users/runner/work/ResultModelManager/ResultModelManager/check/ResultModelManager.Rcheck/tests/testthat/setup.R"
Caused by error in `.createErrorReport()`:
! Error executing SQL:
org.postgresql.util.PSQLException: ERROR: syntax error at or near ".0275386"
  Position: 36
An error report has been created at  /Users/runner/work/ResultModelManager/ResultModelManager/check/ResultModelManager.Rcheck/tests/testthat/errorReportSql.txt
Backtrace:
     ▆
  1. └─testthat::test_check("ResultModelManager")
  2.   └─testthat::test_dir(...)
  3.     └─testthat:::test_files(...)
  4.       └─testthat:::test_files_serial(...)
  5.         └─testthat:::test_files_setup_state(...)
  6.           └─testthat::source_test_setup(".", env)
  7.             └─testthat::source_dir(path, "^setup.*\\.[rR]$", env = env, wrap = FALSE)
  8.               └─base::lapply(...)
  9.                 └─testthat (local) FUN(X[[i]], ...)
 10.                   └─testthat::source_file(path, env = env, chdir = chdir, wrap = wrap)
 11.                     ├─base::withCallingHandlers(...)
 12.                     └─base::eval(exprs, env)
 13.                       └─base::eval(exprs, env)
 14.                         └─DatabaseConnector::renderTranslateExecuteSql(...) at tests/testthat/setup.R:58:2
 15.                           └─DatabaseConnector::executeSql(...)
 16.                             └─base::tryCatch(...)
 17.                               └─base (local) tryCatchList(expr, classes, parentenv, handlers)
 18.                                 └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]])
 19.                                   └─value[[3L]](cond)
 20.                                     └─DatabaseConnector:::.createErrorReport(dbms, err$message, sqlStatement, errorReportFile)
 21.                                       └─rlang::abort(...)
Execution halted