yotover (version 0.3.5)

yotov_db: The local Yotov database

Description

Returns a connection to the local yotov database. This is a DBI-compliant duckdb database connection. When using dplyr-based workflows, one typically accesses tables with yotov_data(), but this function lets the user interact with the database directly via SQL.

Usage

yotov_db(dbdir = yotov_path())

Arguments

dbdir

The location of the database on disk. Defaults to yotovdb under rappdirs::user_data_dir(), or the environment variable yotov_DB_DIR.

Examples

# NOT RUN {
if (yotov_status()) {
  DBI::dbListTables(yotov_db())

  ch1_application1 <- DBI::dbReadTable(yotov_db(), "ch1_application1")

  DBI::dbGetQuery(
    yotov_db(),
    "SELECT * FROM ch1_application1"
  )
}
# }