getDBOption {rquery}

Get a database connection option.

Description

Note: we are moving away from global options to options in the DB handle.

Usage

getDBOption(db, optname, default, connection_options = list())

Arguments

db

database connection handle.

optname

character, single option name.

default

what to return if not set.

connection_options

name list of per connection options.

Value

option value

Examples

if(requireNamespace("DBI", quietly = TRUE) && requireNamespace("RSQLite", quietly = TRUE)) {
  my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  print(getDBOption(my_db, "use_DBI_dbExecute"))
  DBI::dbDisconnect(my_db)
}