Package: dittodb
Check: examples
New result: ERROR
  Running examples in ‘dittodb-Ex.R’ failed
  The error most likely occurred in:
  
  > base::assign(".ptime", proc.time(), pos = "CheckExEnv")
  > ### Name: nycflights_sqlite
  > ### Title: An SQLite connection to a subset of nycflights13
  > ### Aliases: nycflights_sqlite
  > 
  > ### ** Examples
  > 
  > if (check_for_pkg("RSQLite", message)) {
  +   con <- nycflights_sqlite()
  + 
  +   DBI::dbGetQuery(con, "SELECT flight, tailnum, origin, dest FROM flights LIMIT 10")
  +   DBI::dbGetQuery(con, "SELECT faa, name, lat, lon, alt, tz FROM airports")
  + 
  +   DBI::dbDisconnect(con)
  + }
  Error in find_file(path) : 
    Couldn't find the file _home_hornik_tmp_CRAN_recheck_dittodb.Rcheck_dittodb_nycflights.sqlite/SELECT-c36080.R in any of the mock directories.
  Calls: <Anonymous> ... dbFetch -> dbFetch -> read_file -> source -> find_file
  Execution halted

Package: dittodb
Check: tests
New result: ERROR
    Running ‘spelling.R’ [0s/0s]
    Running ‘testthat.R’ [19s/20s]
  Running the tests in ‘tests/testthat.R’ failed.
  Complete output:
    > library(testthat)
    > test_check("dittodb")
    Loading required package: dittodb
    Loading required package: DBI
    There is no mock database being used.
    Saving _problems/test-dbi-sqlite-integration-8.R
    Saving _problems/test-dbi-sqlite-integration-17.R
    There is no mock database being used.
    There is no mock database being used.
    Saving _problems/test-dbplyr-integration-7.R
    There is no mock database being used.
    There is no mock database being used.
    Saving _problems/test-nycflights13-9.R
    Saving _problems/test-nycflights13-137.R
    There is no mock database being used.
    Tracing function "dbConnect" in package "RSQLite"
    Tracing function "dbConnect" in package "namespace:DBI"
    There is no mock database being used.
    Tracing function "dbConnect" in package "RSQLite"
    Tracing function "dbConnect" in package "namespace:DBI"
    There is no mock database being used.
    [ FAIL 5 | WARN 4 | SKIP 7 | PASS 199 ]
    
    ══ Skipped tests (7) ═══════════════════════════════════════════════════════════
    • Skipping tests that need functioning MariaDB. (1):
      'test-dbi-generic-integration.R:49:5'
    • Skipping tests that need functioning Postgres. (6):
      'test-dbi-generic-integration.R:49:5', 'test-dbi-generic-integration.R:49:5',
      'test-dbi-generic-integration.R:49:5', 'test-nycflights13.R:16:3',
      'test-nycflights13.R:57:3', 'test-nycflights13.R:97:3'
    
    ══ Failed tests ════════════════════════════════════════════════════════════════
    ── Failure ('test-dbi-sqlite-integration.R:5:3'): The fixture is what we expect ──
    Expected `dbListTables(con)` to be identical to `c("airlines", "airports", "flights", "planes", "weather")`.
    Differences:
    `actual`:                                                     
    `expected`: "airlines" "airports" "flights" "planes" "weather"
    
    ── Error ('test-dbi-sqlite-integration.R:10:3'): The fixture is what we expect ──
    Error in `find_file(path)`: Couldn't find the file _memory_/SELECT-f2090b.R in any of the mock directories.
    Backtrace:
         ▆
      1. ├─testthat::expect_identical(...) at test-dbi-sqlite-integration.R:10:3
      2. │ └─testthat::quasi_label(enquo(object), label)
      3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
      4. ├─DBI::dbGetQuery(con, "SELECT * FROM airlines LIMIT 2")
      5. └─DBI::dbGetQuery(con, "SELECT * FROM airlines LIMIT 2")
      6.   └─DBI (local) .local(conn, statement, ...)
      7.     ├─DBI::dbFetch(rs, n = n, ...)
      8.     └─dittodb::dbFetch(rs, n = n, ...)
      9.       ├─dittodb:::read_file(find_file(path))
     10.       │ └─base::source(file_path, keep.source = FALSE)
     11.       └─dittodb:::find_file(path)
    ── Error ('test-dbplyr-integration.R:7:1'): (code run outside of `test_that()`) ──
    Error in `find_file(path)`: Couldn't find the file _home_hornik_tmp_scratch_Rtmp6CAc8U_dbplyr_integration/dbListTables.R in any of the mock directories.
    Backtrace:
         ▆
      1. ├─base::suppressMessages(con <- nycflights13_create_sqlite(temp_path)) at test-dbplyr-integration.R:7:1
      2. │ └─base::withCallingHandlers(...)
      3. └─dittodb::nycflights13_create_sqlite(temp_path)
      4.   └─dittodb::nycflights13_create_sql(sqlite_con, schema = "", ...)
      5.     ├─DBI::dbListTables(con)
      6.     └─dittodb::dbListTables(con)
      7.       └─dittodb:::list_helper("dbListTables", conn, ...)
      8.         ├─dittodb:::read_file(find_file(path))
      9.         │ └─base::source(file_path, keep.source = FALSE)
     10.         └─dittodb:::find_file(path)
    ── Failure ('test-nycflights13.R:6:3'): nycflights sqlite can be created ───────
    Expected `dbListTables(con)` to be identical to `c("airlines", "airports", "flights", "planes", "weather")`.
    Differences:
    `actual`:                                                     
    `expected`: "airlines" "airports" "flights" "planes" "weather"
    
    ── Error ('test-nycflights13.R:137:3'): nycflights_db() test databes ───────────
    Error in `find_file(path)`: Couldn't find the file _home_hornik_tmp_CRAN_recheck_dittodb.Rcheck_dittodb_nycflights.sqlite/SELECT-4013df.R in any of the mock directories.
    Backtrace:
        ▆
     1. ├─DBI::dbGetQuery(con, "SELECT * FROM flights LIMIT 10;") at test-nycflights13.R:137:3
     2. └─DBI::dbGetQuery(con, "SELECT * FROM flights LIMIT 10;")
     3.   └─DBI (local) .local(conn, statement, ...)
     4.     ├─DBI::dbFetch(rs, n = n, ...)
     5.     └─dittodb::dbFetch(rs, n = n, ...)
     6.       ├─dittodb:::read_file(find_file(path))
     7.       │ └─base::source(file_path, keep.source = FALSE)
     8.       └─dittodb:::find_file(path)
    
    [ FAIL 5 | WARN 4 | SKIP 7 | PASS 199 ]
    Error:
    ! Test failures.
    Execution halted