Create a Database and Return an Object that Stores the Connection — rpwf_connect_db • rpwf

Create or connect to a SQLite db. Access the connection with object$con.

Usage

rpwf_connect_db(dbname, board, ...)

Arguments

dbname: path to the database, passed to RSQLite::SQLite().
board: a {pins} board object.
...: arguments passed to DBI::dbConnect()

Value

A new rpwf_connect_db() object.

Examples

board <- pins::board_temp()
tmp_dir <- tempdir()
db_con <- rpwf_connect_db(paste(tmp_dir, "db.SQLite", sep = "/"), board)
db_con$con
#> <SQLiteConnection>
#>   Path: /tmp/RtmpeFWTsg/db.SQLite
#>   Extensions: TRUE
db_con$board
#> Pin board <pins_board_folder>
#> Path: '/tmp/RtmpeFWTsg/pins-24b4431a9c16'
#> Cache size: 0