setupDriver {rocker}

Setup database driver and define connection parameters.

Description

Setup database driver and define connection parameters.

Usage

setupDriver(db, drv, protect = c("password", "user"), ...)

Arguments

db

rocker object

drv

Driver object from suitable package e.g. RPostgres::Postgres(), RMariaDB::MariaDB() and RSQLite::SQLite()

protect

Parameters to be hidden

...

Suitable parameters passed to DBI::dbConnect() e.g. host, port, dbname, user and password

Value

Invisible self

See Also

Other rocker-S3-functions: appendTable(), begin(), canConnect(), clearResult(), columnInfo(), commit(), connect(), createTable(), disconnect(), execute(), existsTable(), fetch(), getInfoCon(), getInfoDrv(), getInfoRes(), getQuery(), getRowCount(), getRowsAffected(), getStatement(), hasCompleted(), isValidCon(), isValidDrv(), isValidRes(), listFields(), listObjects(), listTables(), readTable(), removeTable(), rocker-README, rocker-S3-functions, rocker-package, rollback(), sendQuery(), sendStatement(), setupMariaDB(), setupPostgreSQL(), setupSQLite(), unloadDriver(), validateCon(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupDriver(
  db,
  drv = RSQLite::SQLite(),
  dbname = ":memory:"
)
rocker::unloadDriver(db)