tests/testthat/test-postgres.R

In ropensci/nodbi: 'NoSQL' Database Connector

test_that("Source", {
  skip_if_no_postgres()
  skip_on_cran()

  # creating database connection has
  # unique parameters, see README.Rmd
  dbSrcKey <- function() {
    testKey <- createKey()
    testSrc <- src_postgres()
    return(list(testKey = testKey, testSrc = testSrc))
  }

  # test database set up
  tmp <- dbSrcKey()
  expect_is(tmp$testSrc, "docdb_src")
  expect_is(tmp$testSrc, "src_postgres")
  expect_output(suppressWarnings(print(tmp$testSrc)), "src: PostgreSQL")
  RPostgres::dbDisconnect(tmp$testSrc$con)
  rm(tmp)

  # run generic (database independent) tests
  source("core-nodbi.R", local = TRUE)

})