Running ‘testthat.R’
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(gsheet)
  > 
  > test_check("gsheet")
  ── 1. Error: Correct result on mtcars sheet (@test-gsheet2tbl.R#5)  ────────────
  SSL: no alternative certificate subject name matches target host name 'docs.google.com'
  Backtrace:
    1. base::suppressWarnings(a <- gsheet2tbl("docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo"))
    3. gsheet::gsheet2tbl("docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo")
    6. readr::read_csv(...)
    7. readr:::read_delimited(...)
    8. readr:::datasource_connection(file, skip, skip_empty_rows, comment)
    9. readr:::read_connection(path)
   11. base::open.connection(con, "rb")
  
  ── 2. Error: Works correctly with and with url containing sheetid = 850032961 (@
  SSL: no alternative certificate subject name matches target host name 'docs.google.com'
  Backtrace:
    1. base::suppressWarnings(a <- gsheet2tbl("https://docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo/edit#gid=850032961"))
    3. gsheet::gsheet2tbl("https://docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo/edit#gid=850032961")
    6. readr::read_csv(...)
    7. readr:::read_delimited(...)
    8. readr:::datasource_connection(file, skip, skip_empty_rows, comment)
    9. readr:::read_connection(path)
   11. base::open.connection(con, "rb")
  
  ── 3. Error: Correct result on corner cases sheet (@test-gsheet2tbl.R#15)  ─────
  SSL: no alternative certificate subject name matches target host name 'docs.google.com'
  Backtrace:
   1. gsheet::gsheet2tbl("https://docs.google.com/spreadsheets/d/1QNaOSRePfMRpdyR6DQfdO82pAq9RRrlJeK6DP3ZlMCg/edit?usp=sharing")
   4. readr::read_csv(...)
   5. readr:::read_delimited(...)
   6. readr:::datasource_connection(file, skip, skip_empty_rows, comment)
   7. readr:::read_connection(path)
   9. base::open.connection(con, "rb")
  
  ── 4. Error: Works correctly with and without sheet id (@test-gsheet2text.R#5)  
  SSL: no alternative certificate subject name matches target host name 'docs.google.com'
  Backtrace:
   1. gsheet::gsheet2text("docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo")
   2. httr::GET(address)
   3. httr:::request_perform(req, hu$handle$handle)
   5. httr:::request_fetch.write_memory(req$output, req$url, handle)
   6. curl::curl_fetch_memory(url, handle = handle)
  
  ── 5. Failure: Throws informative error when share by link is turned off (@test-
  `{ ... }` threw an error with unexpected message.
  Expected match: "Unable to retrieve document. Is 'share by link' enabled for this sheet?"
  Actual message: "SSL: no alternative certificate subject name matches target host name 'docs.google.com'"
  Backtrace:
    1. testthat::expect_error(...)
    6. gsheet::gsheet2text("https://docs.google.com/spreadsheets/d/1zMvLM_dWvIHeTFi8Sct9QMmrr7Roo2tav2SE4Wt7vBQ/edit")
    7. httr::GET(address)
    8. httr:::request_perform(req, hu$handle$handle)
   10. httr:::request_fetch.write_memory(req$output, req$url, handle)
   11. curl::curl_fetch_memory(url, handle = handle)
  
  ══ testthat results  ═══════════════════════════════════════════════════════════
  [ OK: 0 | SKIPPED: 0 | WARNINGS: 0 | FAILED: 5 ]
  1. Error: Correct result on mtcars sheet (@test-gsheet2tbl.R#5) 
  2. Error: Works correctly with and with url containing sheetid = 850032961 (@test-gsheet2tbl.R#10) 
  3. Error: Correct result on corner cases sheet (@test-gsheet2tbl.R#15) 
  4. Error: Works correctly with and without sheet id (@test-gsheet2text.R#5) 
  5. Failure: Throws informative error when share by link is turned off (@test-gsheet2text.R#11) 
  
  Error: testthat unit tests failed
  In addition: Warning message:
  In identical(x, TRUE) :
    closing unused connection 5 (https://docs.google.com/spreadsheets/export?id=1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo&format=csv&gid=850032961)
  Execution halted