motherduck

*

*

tests

  Running ‘testthat.R’ [26s/37s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview
  > # * https://testthat.r-lib.org/articles/special-files.html
  > 
  > library(testthat)
  > library(motherduck)
  > library(DBI)
  > library(openxlsx)
  > 
  > test_check("motherduck")
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 0
  * # Tables in this catalog & schema you have access to: 0
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Created new schema "test_schema"
  > Current role: `duckdb`
  
  -- Status: ---------------------------------------------------------------------
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "test_schema"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 0
  * # Tables in this catalog & schema you have access to: 0
  > Current role: `duckdb`
  > Current role: `duckdb`
  > Current role: `duckdb`
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 1
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 1
  * # Tables in this catalog & schema you have access to: 1
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 1
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 1
  * # Tables in this catalog & schema you have access to: 1
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 1
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 1
  * # Tables in this catalog & schema you have access to: 1
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 3
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 3
  * # Tables in this catalog & schema you have access to: 3
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 3
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 3
  * # Tables in this catalog & schema you have access to: 3
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  Note: method with signature 'DBIConnection#Id' chosen for function 'dbExistsTable',
   target signature 'duckdb_connection#Id'.
   "duckdb_connection#ANY" would also be valid
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 0
  * # Tables in this catalog & schema you have access to: 0
  
  -- Action Report: 
  * Deleted "delete_table" from "[database_name]" in "main"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 0
  * # Tables in this catalog & schema you have access to: 0
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Created new schema "test_schema"
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 1
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 1
  * # Tables in this catalog & schema you have access to: 0
  
  -- Action Report: --
  
  * Deleted "test_schema" schema and 1 tables
  
  -- Status: ---------------------------------------------------------------------
  
  -- Connection Status Report: --
  
  ! You are not connected to MotherDuck
  
  -- User Report: --
  
  * User Name: "duckdb"
  * Role: "duckdb"
  
  -- Catalog Report: --
  
  * Current Database: "memory"
  * Current Schema: "main"
  * # Total Catalogs you have access to: 3
  * # Total Tables you have access to: 0
  * # Total Shares you have access to: 0
  * # Tables in this catalog you have access to: 0
  * # Tables in this catalog & schema you have access to: 0
  
  -- Action Report: --
  
  * Deleted "test_schema" schema and 1 tables
  
  -- Action Report: --
  
  v Inserted into existing database "memory"
  v Using existing schema "main"
  v Overwrite existing table "mtcars_csv"
  Saving _problems/test-motherduck-405.R
  [ FAIL 1 | WARN 0 | SKIP 1 | PASS 22 ]
  
  ══ Skipped tests (1) ═══════════════════════════════════════════════════════════
  • empty test (1): 'test-motherduck.R:259:3'
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-motherduck.R:405:7'): read_excel / successfully reads a excel and copies table to database ──
  <purrr_error_indexed/rlang_error/error/condition>
  Error in `purrr::map(ext_lst$valid_ext, function(x) DBI::dbExecute(.con, glue::glue("LOAD {x};")))`: i In index: 1.
  Caused by error in `duckdb_result()`:
  ! Invalid Error: Invalid Input Error: Initialization function "excel_duckdb_cpp_init" from file "/data/gannet/ripley/.local/share/R/duckdb/extensions/v1.4.4/linux_amd64/excel.duckdb_extension" threw an exception: "Missing DB manager"
  i Context: rapi_execute
  i Error type: INVALID
  
  [ FAIL 1 | WARN 0 | SKIP 1 | PASS 22 ]
  Error:
  ! Test failures.
  Execution halted

*

*

*

*

*

*

*

*

*

*

*