Connections to Database Management Systems which automatically disconnect. In particular connections which are created with DBI::dbConnect() and closed with DBI::dbDisconnect().

with_db_connection(con, code)

local_db_connection(con, .local_envir = parent.frame())

## Arguments

con For with_db_connection() a named list with the connection(s) to create. For local_db_connection() the code to create a single connection, which is then returned. [any] Code to execute in the temporary environment [environment] The environment to use for scoping.

## Value

[any] The results of the evaluation of the code argument.

withr for examples

## Examples

db <- tempfile()
with_db_connection(
list(con = DBI::dbConnect(RSQLite::SQLite(), db)), {
DBI::dbWriteTable(con, "mtcars", mtcars)
#> 6 18.1   6  225 105 2.76 3.460 20.22  1  0    3    1unlink(db)