Running ‘testthat.R’ [33s/84s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(readwritesqlite)
  > 
  > test_check("readwritesqlite")
  [ FAIL 89 | WARN 86 | SKIP 0 | PASS 171 ]
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error (test-db.R:56:3): table_info ──────────────────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-db.R:56:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-describe.R:9:3): describe with scalars works ────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-describe.R:9:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-describe.R:26:3): describe with vector works ────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-describe.R:26:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-describe.R:43:3): describe errors if extra ──────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-describe.R:43:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-describe.R:53:3): describe replace works ────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-describe.R:53:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-describe.R:84:3): describe two works ────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-describe.R:84:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-drop.R:7:3): rws_drop_table works ───────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-drop.R:7:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-drop.R:19:3): rws_rename_table informative errors ───────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-drop.R:19:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-drop.R:34:3): rws_rename_table multiple tables ──────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-drop.R:34:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-drop.R:55:3): rws_drop_table primary key deferred ───────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-drop.R:55:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-init.R:32:3): init makes table ──────────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-init.R:32:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local2, conn = conn, exists = NA)
    5. └─readwritesqlite:::rws_write.data.frame(local2, conn = conn, exists = NA)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-log.R:24:3): rws_write data.frame logs commands ─────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(local, conn = conn) at test-log.R:24:2
    2. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::write_data(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-log.R:56:3): rws_write list logs commands ───────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(y["local"], exists = FALSE, conn = conn) at test-log.R:56:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-log.R:88:3): log replace rows UNIQUE constraints ────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-log.R:88:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:49:3): meta handles logical ──────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:49:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:72:3): meta handles all classes ──────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:72:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:88:3): meta errors if meta and then no meta ──────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:88:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:104:3): meta errors if no meta and then meta ─────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:104:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:120:3): meta errors if inconsistent meta ─────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:120:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:136:3): fix meta inconsistent by deleting ────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:136:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:160:3): meta reads logical ───────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:160:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:183:3): meta reads all classes ───────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:183:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:225:3): meta = FALSE same as just writing ────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:225:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(...)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:270:3): meta logical logical different types ─────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:270:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:304:3): meta Date different types ────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:304:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:341:3): meta POSIXct different types ─────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:341:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:381:3): meta hms different types ─────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:381:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:422:3): meta hms preserves decimal ───────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:422:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:458:3): meta units different types ───────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:458:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:501:3): meta sfc different types ─────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:501:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:553:3): meta factor different types ──────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:553:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:588:3): meta factor 11 level ─────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:588:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:615:3): meta ordered different types ─────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:615:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:691:3): meta factor rearrange levels ─────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:691:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:730:3): meta factor add levels ───────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:730:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:771:3): meta ordered add and rearrange levels ────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:771:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:819:3): meta TRUE then FALSE then read with TRUE ─────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-meta.R:819:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-meta.R:866:3): meta strips trailing spaces proj ─────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-meta.R:866:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-pool.R:10:3): sf data frames with single geometry passed back ───
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-pool.R:10:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-query.R:23:3): rws_get_sqlite_query works with meta = TRUE and logical ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-query.R:23:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-query.R:49:3): rws_get_sqlite_query works with meta = TRUE and logical ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-query.R:49:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-query.R:69:3): rws_get_sqlite_query teases apart two ────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-query.R:69:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-read.R:62:3): rws_read with meta = FALSE  ───────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-read.R:62:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:7:3): rws_rename_table works ───────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:7:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:19:3): rws_rename_table informative errors ─────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:19:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:40:3): rws_rename_table multiple tables ────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:40:2
    2. └─readwritesqlite:::rws_write.list(...)
    3.   └─base::mapply(...)
    4.     └─readwritesqlite (local) `<fn>`(...)
    5.       └─readwritesqlite:::create_table(...)
    6.         └─readwritesqlite:::log_command(...)
    7.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           └─DBI::dbAppendTable(conn, .log_table_name, data)
    9.             ├─methods::callNextMethod()
   10.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   11.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   13.                 ├─DBI::dbSendStatement(conn, statement, ...)
   14.                 └─DBI::dbSendStatement(conn, statement, ...)
   15.                   ├─DBI::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   17.                     └─RSQLite (local) .local(conn, statement, ...)
   18.                       ├─DBI::dbBind(rs, params)
   19.                       └─RSQLite::dbBind(rs, params)
   20.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   21.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:61:3): rws_rename_table primary key ────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-rename.R:61:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:79:3): rws_rename_column works ─────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:79:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::create_table(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:98:3): rws_rename_column renames own column ────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:98:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::create_table(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:115:3): rws_rename_column informative errors ───────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:115:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::create_table(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:130:3): rws_rename_column can't overwrite existing column ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(...) at test-rename.R:130:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::create_table(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-rename.R:150:3): rws_rename_column primary key ──────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-rename.R:150:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-utils.R:11:3): rws_table_names ──────────────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn) at test-utils.R:11:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::create_table(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-validate.R:32:3): rws_write.data.frame checks missing values ────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-validate.R:32:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-validate.R:51:3): rws_write.data.frame checks primary key on input values ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-validate.R:51:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:43:3): rws_write.data.frame writes to existing table ────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:43:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:62:3): rws_write.data.frame creates table ───────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:62:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = FALSE, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:74:3): rws_write.data.frame handling of case ────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:74:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:97:3): rws_write.data.frame deals with " quoted table names ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:97:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:113:3): rws_write.data.frame deals with [ quoted table names ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:113:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:129:3): rws_write.data.frame deals with backtick quoted table names ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:129:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:141:3): rws_write.data.frame corrects column order ──────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:141:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:165:3): rws_write.data.frame warns for extra columns ────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_warning(...) at test-write.R:165:2
    2. │ └─testthat:::quasi_capture(enquo(object), label, capture_warnings)
    3. │   ├─testthat (local) .capture(...)
    4. │   │ └─base::withCallingHandlers(...)
    5. │   └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
    6. ├─readwritesqlite::rws_write(local, conn = conn, strict = FALSE)
    7. └─readwritesqlite:::rws_write.data.frame(local, conn = conn, strict = FALSE)
    8.   └─readwritesqlite:::write_sqlite_data(...)
    9.     └─readwritesqlite:::write_data(...)
   10.       └─readwritesqlite:::log_command(...)
   11.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   12.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   13.           ├─methods::callNextMethod()
   14.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   15.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   17.               ├─DBI::dbSendStatement(conn, statement, ...)
   18.               └─DBI::dbSendStatement(conn, statement, ...)
   19.                 ├─DBI::dbSendQuery(conn, statement, ...)
   20.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   21.                   └─RSQLite (local) .local(conn, statement, ...)
   22.                     ├─DBI::dbBind(rs, params)
   23.                     └─RSQLite::dbBind(rs, params)
   24.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   25.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:181:3): rws_write.data.frame is case insensitive ────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:181:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:189:3): rws_write.data.frame deals with quoted column names ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:189:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn, exists = FALSE)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn, exists = FALSE)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:212:3): rws_write.data.frame can delete ─────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(local, conn = conn) at test-write.R:212:2
    2. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::write_data(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:224:3): rws_write.data.frame can not commit ─────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─readwritesqlite::rws_write(local, commit = FALSE, conn = conn) at test-write.R:224:2
    2. └─readwritesqlite:::rws_write.data.frame(...)
    3.   └─readwritesqlite:::write_sqlite_data(...)
    4.     └─readwritesqlite:::write_data(...)
    5.       └─readwritesqlite:::log_command(...)
    6.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
    7.         └─DBI::dbAppendTable(conn, .log_table_name, data)
    8.           ├─methods::callNextMethod()
    9.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   10.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   11.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   12.               ├─DBI::dbSendStatement(conn, statement, ...)
   13.               └─DBI::dbSendStatement(conn, statement, ...)
   14.                 ├─DBI::dbSendQuery(conn, statement, ...)
   15.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   16.                   └─RSQLite (local) .local(conn, statement, ...)
   17.                     ├─DBI::dbBind(rs, params)
   18.                     └─RSQLite::dbBind(rs, params)
   19.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   20.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:265:3): rws_write writes list with 1 data frame ─────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(y, conn = conn), "local") at test-write.R:265:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(y, conn = conn)
    5. └─readwritesqlite:::rws_write.list(y, conn = conn)
    6.   └─base::mapply(...)
    7.     └─readwritesqlite (local) `<fn>`(...)
    8.       └─readwritesqlite:::write_data(...)
    9.         └─readwritesqlite:::log_command(...)
   10.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   12.             ├─methods::callNextMethod()
   13.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   14.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.                 ├─DBI::dbSendStatement(conn, statement, ...)
   17.                 └─DBI::dbSendStatement(conn, statement, ...)
   18.                   ├─DBI::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   20.                     └─RSQLite (local) .local(conn, statement, ...)
   21.                       ├─DBI::dbBind(rs, params)
   22.                       └─RSQLite::dbBind(rs, params)
   23.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   24.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:278:3): rws_write writes list with 2 data frame ─────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:278:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(y, conn = conn)
    5. └─readwritesqlite:::rws_write.list(y, conn = conn)
    6.   └─base::mapply(...)
    7.     └─readwritesqlite (local) `<fn>`(...)
    8.       └─readwritesqlite:::write_data(...)
    9.         └─readwritesqlite:::log_command(...)
   10.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   12.             ├─methods::callNextMethod()
   13.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   14.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.                 ├─DBI::dbSendStatement(conn, statement, ...)
   17.                 └─DBI::dbSendStatement(conn, statement, ...)
   18.                   ├─DBI::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   20.                     └─RSQLite (local) .local(conn, statement, ...)
   21.                       ├─DBI::dbBind(rs, params)
   22.                       └─RSQLite::dbBind(rs, params)
   23.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   24.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:292:3): rws_write writes list with 2 identically named data frames ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:292:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(y, conn = conn, unique = FALSE)
    5. └─readwritesqlite:::rws_write.list(y, conn = conn, unique = FALSE)
    6.   └─base::mapply(...)
    7.     └─readwritesqlite (local) `<fn>`(...)
    8.       └─readwritesqlite:::write_data(...)
    9.         └─readwritesqlite:::log_command(...)
   10.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   12.             ├─methods::callNextMethod()
   13.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   14.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.                 ├─DBI::dbSendStatement(conn, statement, ...)
   17.                 └─DBI::dbSendStatement(conn, statement, ...)
   18.                   ├─DBI::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   20.                     └─RSQLite (local) .local(conn, statement, ...)
   21.                       ├─DBI::dbBind(rs, params)
   22.                       └─RSQLite::dbBind(rs, params)
   23.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   24.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:335:3): rws_write errors if strict = TRUE and exists = TRUE and extra data frames ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_warning(...) at test-write.R:335:2
    2. │ └─testthat:::quasi_capture(enquo(object), label, capture_warnings)
    3. │   ├─testthat (local) .capture(...)
    4. │   │ └─base::withCallingHandlers(...)
    5. │   └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
    6. ├─readwritesqlite::rws_write(y, strict = FALSE, conn = conn)
    7. └─readwritesqlite:::rws_write.list(y, strict = FALSE, conn = conn)
    8.   └─base::mapply(...)
    9.     └─readwritesqlite (local) `<fn>`(...)
   10.       └─readwritesqlite:::write_data(...)
   11.         └─readwritesqlite:::log_command(...)
   12.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   13.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   14.             ├─methods::callNextMethod()
   15.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   16.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   17.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   18.                 ├─DBI::dbSendStatement(conn, statement, ...)
   19.                 └─DBI::dbSendStatement(conn, statement, ...)
   20.                   ├─DBI::dbSendQuery(conn, statement, ...)
   21.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   22.                     └─RSQLite (local) .local(conn, statement, ...)
   23.                       ├─DBI::dbBind(rs, params)
   24.                       └─RSQLite::dbBind(rs, params)
   25.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   26.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:348:3): rws_write writes environment ────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:348:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(environment(), conn = conn, exists = FALSE)
    5. └─readwritesqlite:::rws_write.environment(...)
    6.   ├─readwritesqlite::rws_write(...)
    7.   └─readwritesqlite:::rws_write.list(...)
    8.     └─base::mapply(...)
    9.       └─readwritesqlite (local) `<fn>`(...)
   10.         └─readwritesqlite:::create_table(...)
   11.           └─readwritesqlite:::log_command(...)
   12.             ├─DBI::dbAppendTable(conn, .log_table_name, data)
   13.             └─DBI::dbAppendTable(conn, .log_table_name, data)
   14.               ├─methods::callNextMethod()
   15.               └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   16.                 ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   17.                 └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   18.                   ├─DBI::dbSendStatement(conn, statement, ...)
   19.                   └─DBI::dbSendStatement(conn, statement, ...)
   20.                     ├─DBI::dbSendQuery(conn, statement, ...)
   21.                     └─RSQLite::dbSendQuery(conn, statement, ...)
   22.                       └─RSQLite (local) .local(conn, statement, ...)
   23.                         ├─DBI::dbBind(rs, params)
   24.                         └─RSQLite::dbBind(rs, params)
   25.                           └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   26.                             └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:359:3): rws_write not commits ───────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:359:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(...)
    5. └─readwritesqlite:::rws_write.list(...)
    6.   └─base::mapply(...)
    7.     └─readwritesqlite (local) `<fn>`(...)
    8.       └─readwritesqlite:::create_table(...)
    9.         └─readwritesqlite:::log_command(...)
   10.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   12.             ├─methods::callNextMethod()
   13.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   14.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.                 ├─DBI::dbSendStatement(conn, statement, ...)
   17.                 └─DBI::dbSendStatement(conn, statement, ...)
   18.                   ├─DBI::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   20.                     └─RSQLite (local) .local(conn, statement, ...)
   21.                       ├─DBI::dbBind(rs, params)
   22.                       └─RSQLite::dbBind(rs, params)
   23.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   24.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:376:3): replace rows PRIMARY KEY constraints ────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:376:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:410:3): replace rows UNIQUE constraints in unique key ───
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:410:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:446:3): replace rows with FOREIGN key ───────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:446:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:474:3): foreign keys switched on one data frame at a time ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:474:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(y$local, x_name = "local", conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(...)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:491:3): foreign keys switched off for two data frame ────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:491:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(y, conn = conn)
    5. └─readwritesqlite:::rws_write.list(y, conn = conn)
    6.   └─base::mapply(...)
    7.     └─readwritesqlite (local) `<fn>`(...)
    8.       └─readwritesqlite:::write_data(...)
    9.         └─readwritesqlite:::log_command(...)
   10.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   12.             ├─methods::callNextMethod()
   13.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   14.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   16.                 ├─DBI::dbSendStatement(conn, statement, ...)
   17.                 └─DBI::dbSendStatement(conn, statement, ...)
   18.                   ├─DBI::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   20.                     └─RSQLite (local) .local(conn, statement, ...)
   21.                       ├─DBI::dbBind(rs, params)
   22.                       └─RSQLite::dbBind(rs, params)
   23.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   24.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Failure (test-write.R:509:3): foreign keys pick up foreign key violation for two data frames ──
  `rws_write(y, conn = conn)` threw an error with unexpected message.
  Expected match: "FOREIGN KEY constraint failed"
  Actual message: "CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND\n    CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND\n    NRowLog >= 0"
  Backtrace:
       ▆
    1. ├─testthat::expect_error(rws_write(y, conn = conn), "FOREIGN KEY constraint failed") at test-write.R:509:2
    2. │ └─testthat:::quasi_capture(...)
    3. │   ├─testthat (local) .capture(...)
    4. │   │ └─base::withCallingHandlers(...)
    5. │   └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
    6. ├─readwritesqlite::rws_write(y, conn = conn)
    7. └─readwritesqlite:::rws_write.list(y, conn = conn)
    8.   └─base::mapply(...)
    9.     └─readwritesqlite (local) `<fn>`(...)
   10.       └─readwritesqlite:::write_data(...)
   11.         └─readwritesqlite:::log_command(...)
   12.           ├─DBI::dbAppendTable(conn, .log_table_name, data)
   13.           └─DBI::dbAppendTable(conn, .log_table_name, data)
   14.             ├─methods::callNextMethod()
   15.             └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   16.               ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   17.               └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   18.                 ├─DBI::dbSendStatement(conn, statement, ...)
   19.                 └─DBI::dbSendStatement(conn, statement, ...)
   20.                   ├─DBI::dbSendQuery(conn, statement, ...)
   21.                   └─RSQLite::dbSendQuery(conn, statement, ...)
   22.                     └─RSQLite (local) .local(conn, statement, ...)
   23.                       ├─DBI::dbBind(rs, params)
   24.                       └─RSQLite::dbBind(rs, params)
   25.                         └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   26.                           └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:532:3): strict environment with extra data frame and extra column ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_warning(...) at test-write.R:532:2
    2. │ └─testthat:::quasi_capture(enquo(object), label, capture_warnings)
    3. │   ├─testthat (local) .capture(...)
    4. │   │ └─base::withCallingHandlers(...)
    5. │   └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
    6. ├─readwritesqlite::rws_write(env, strict = FALSE, conn = conn)
    7. └─readwritesqlite:::rws_write.environment(...)
    8.   ├─readwritesqlite::rws_write(...)
    9.   └─readwritesqlite:::rws_write.list(...)
   10.     └─base::mapply(...)
   11.       └─readwritesqlite (local) `<fn>`(...)
   12.         └─readwritesqlite:::write_data(...)
   13.           └─readwritesqlite:::log_command(...)
   14.             ├─DBI::dbAppendTable(conn, .log_table_name, data)
   15.             └─DBI::dbAppendTable(conn, .log_table_name, data)
   16.               ├─methods::callNextMethod()
   17.               └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   18.                 ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   19.                 └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   20.                   ├─DBI::dbSendStatement(conn, statement, ...)
   21.                   └─DBI::dbSendStatement(conn, statement, ...)
   22.                     ├─DBI::dbSendQuery(conn, statement, ...)
   23.                     └─RSQLite::dbSendQuery(conn, statement, ...)
   24.                       └─RSQLite (local) .local(conn, statement, ...)
   25.                         ├─DBI::dbBind(rs, params)
   26.                         └─RSQLite::dbBind(rs, params)
   27.                           └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   28.                             └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:552:3): sf data frames with single geometry passed back ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:552:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:584:3): sf data frames with two geometries and correct one passed back ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:584:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:611:3): sf can change sf_column ─────────────────────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(rws_write(local, conn = conn), "local") at test-write.R:611:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::write_data(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:634:3): sf data frames with two geometries and lots of other stuff and correct one passed back ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:634:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:664:3): initialized even with no rows of data ───────────
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:664:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:694:3): initialized meta with no rows of data and not overwritten unless delete = TRUE ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:694:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:724:3): initialized with no rows of data and no metadata and not overwritten unless delete = TRUE ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:724:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:753:3): initialized with no rows of data and no metadata and not overwritten unless delete = TRUE ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:753:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  ── Error (test-write.R:780:3): meta then inconsistent data then error meta but delete reset ──
  <Rcpp::exception/C++Error/error/condition>
  Error: CHECK constraint failed: DATETIME(DateTimeUTCLog) IS DateTimeUTCLog AND
      CommandLog IN ('CREATE', 'UPDATE', 'DELETE', 'INSERT', 'DROP') AND
      NRowLog >= 0
  Backtrace:
       ▆
    1. ├─testthat::expect_identical(...) at test-write.R:780:2
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─readwritesqlite::rws_write(local, exists = NA, conn = conn)
    5. └─readwritesqlite:::rws_write.data.frame(local, exists = NA, conn = conn)
    6.   └─readwritesqlite:::write_sqlite_data(...)
    7.     └─readwritesqlite:::create_table(...)
    8.       └─readwritesqlite:::log_command(...)
    9.         ├─DBI::dbAppendTable(conn, .log_table_name, data)
   10.         └─DBI::dbAppendTable(conn, .log_table_name, data)
   11.           ├─methods::callNextMethod()
   12.           └─DBI (local) .nextMethod(conn = conn, name = name, value = value)
   13.             ├─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   14.             └─DBI::dbExecute(conn, query, params = unname(as.list(value)))
   15.               ├─DBI::dbSendStatement(conn, statement, ...)
   16.               └─DBI::dbSendStatement(conn, statement, ...)
   17.                 ├─DBI::dbSendQuery(conn, statement, ...)
   18.                 └─RSQLite::dbSendQuery(conn, statement, ...)
   19.                   └─RSQLite (local) .local(conn, statement, ...)
   20.                     ├─DBI::dbBind(rs, params)
   21.                     └─RSQLite::dbBind(rs, params)
   22.                       └─RSQLite:::db_bind(res, as.list(params), ..., allow_named_superset = FALSE)
   23.                         └─RSQLite:::result_bind(res@ptr, params)
  
  [ FAIL 89 | WARN 86 | SKIP 0 | PASS 171 ]
  Error: Test failures
  Execution halted