tests/testthat/test-odbc-drivers.R

In rstats-db/odbc: Connect to ODBC Compatible Databases (using the DBI Interface)

test_that("odbcListDrivers() returns available drivers", {
  skip_on_cran()
  skip_if_no_drivers()

  res <- odbcListDrivers()
  expect_identical(names(res), c("name", "attribute", "value"))
  expect_true(nrow(res) >= 1)
})

test_that("odbcListDrivers() keep and filter work", {
  skip_on_cran()
  skip_if_no_drivers()

  current_drivers <- odbcListDrivers()[["name"]]
  res <- odbcListDrivers(filter = current_drivers)
  expect_true(nrow(res) == 0)

  res <- odbcListDrivers(keep = current_drivers[[1]])
  expect_true(unique(res$name) == current_drivers[[1]])
})