CRAN Package Check Results for Package RSQL

Last updated on 2020-12-04 00:48:33 CET.

Flavor Version Tinstall Tcheck Ttotal Status Flags
r-devel-linux-x86_64-debian-clang 0.1.4 6.26 41.64 47.90 OK
r-devel-linux-x86_64-debian-gcc 0.1.4 4.97 33.21 38.18 OK
r-devel-linux-x86_64-fedora-clang 0.1.4 61.60 NOTE
r-devel-linux-x86_64-fedora-gcc 0.1.4 55.39 NOTE
r-devel-windows-ix86+x86_64 0.1.4 9.00 57.00 66.00 OK
r-patched-linux-x86_64 0.1.4 5.67 40.05 45.72 OK
r-patched-solaris-x86 0.1.4 78.40 NOTE
r-release-linux-x86_64 0.1.4 4.65 39.65 44.30 OK
r-release-macos-x86_64 0.1.4 NOTE
r-release-windows-ix86+x86_64 0.1.4 8.00 43.00 51.00 OK
r-oldrel-macos-x86_64 0.1.4 ERROR
r-oldrel-windows-ix86+x86_64 0.1.4 8.00 54.00 62.00 ERROR

Check Details

Version: 0.1.4
Check: dependencies in R code
Result: NOTE
    Namespaces in Imports field not imported from:
     ‘RSQLite’ ‘knitr’
     All declared Imports should be used.
Flavors: r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-patched-solaris-x86, r-release-macos-x86_64, r-oldrel-macos-x86_64

Version: 0.1.4
Check: tests
Result: ERROR
     Running ‘testthat.R’ [3s/3s]
    Running the tests in ‘tests/testthat.R’ failed.
    Last 13 lines of output:
     ══ testthat results ═══════════════════════════════════════════════════════════
     Warning (test_sql_lib.R:86:5): sql_lib insert and delete test
     Warning (test_sql_lib.R:89:5): sql_lib insert and delete test
     Warning (test_sql_lib.R:107:5): sql_lib select, insert and delete with dataframe
     Warning (test_sql_lib.R:113:5): sql_lib select, insert and delete with dataframe
     ERROR (test_sql_lib.R:138:5): sql_lib select, insert, update and delete with dataframe and stuffed apostrophe
     Warning (test_sql_lib.R:179:5): sql_lib select with where clause
     Warning (test_sql_lib.R:199:5): retrieveInsert
     Warning (test_sql_lib.R:221:5): retrieveInsert
    
     [ FAIL 1 | WARN 7 | SKIP 0 | PASS 20 ]
     Finalizing object and disconnecting
     Finalizing object and disconnecting
     Error: Test failures
     Execution halted
Flavor: r-oldrel-macos-x86_64

Version: 0.1.4
Check: tests
Result: ERROR
     Running 'testthat.R' [4s]
    Running the tests in 'tests/testthat.R' failed.
    Complete output:
     > library(testthat)
     > library(DBI)
     > library(RSQLite)
     > library(RSQL)
     > library(lgr)
     > library(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
    
     >
     > log.levels <- lgr::get_log_levels()
     >
     > lgr$set_threshold(log.levels["debug"])
     >
     >
     >
     > test_check("RSQL")
     -- Warning (test_sql_lib.R:86:5): sql_lib insert and delete test ---------------
     Closing open result set, pending rows
    
     -- Warning (test_sql_lib.R:89:5): sql_lib insert and delete test ---------------
     Closing open result set, pending rows
    
     -- Warning (test_sql_lib.R:107:5): sql_lib select, insert and delete with datafr
     Closing open result set, pending rows
    
     -- Warning (test_sql_lib.R:113:5): sql_lib select, insert and delete with datafr
     Closing open result set, pending rows
    
     -- ERROR (test_sql_lib.R:138:5): sql_lib select, insert, update and delete with
     Error: 'nchar()' requires a character vector
     Backtrace:
     x
     1. \-rsql$gen_update("mtcars", values = update_values, where_values = where_values_df) test_sql_lib.R:138:4
     2. \-RSQL:::sql_gen_update(...)
     3. \-RSQL::stuff_df_quoted(text.df = values.df)
     4. \-base::sapply(text.df[i, ], FUN = rm_quotes)
     5. \-base::lapply(X = X, FUN = FUN, ...)
     6. \-RSQL:::FUN(X[[i]], ...)
     7. \-base::substr(text, nchar(text), nchar(text))
    
     -- Warning (test_sql_lib.R:179:5): sql_lib select with where clause ------------
     Closing open result set, pending rows
    
     -- Warning (test_sql_lib.R:199:5): retrieveInsert ------------------------------
     Closing open result set, pending rows
    
     Finalizing object and disconnecting
     -- Warning (test_sql_lib.R:221:5): retrieveInsert ------------------------------
     Closing open result set, pending rows
    
     == testthat results ===========================================================
     Warning (test_sql_lib.R:86:5): sql_lib insert and delete test
     Warning (test_sql_lib.R:89:5): sql_lib insert and delete test
     Warning (test_sql_lib.R:107:5): sql_lib select, insert and delete with dataframe
     Warning (test_sql_lib.R:113:5): sql_lib select, insert and delete with dataframe
     ERROR (test_sql_lib.R:138:5): sql_lib select, insert, update and delete with dataframe and stuffed apostrophe
     Warning (test_sql_lib.R:179:5): sql_lib select with where clause
     Warning (test_sql_lib.R:199:5): retrieveInsert
     Warning (test_sql_lib.R:221:5): retrieveInsert
    
     [ FAIL 1 | WARN 7 | SKIP 0 | PASS 20 ]
     Error: Test failures
     Execution halted
     Finalizing object and disconnecting
Flavor: r-oldrel-windows-ix86+x86_64