rocker (version 0.3.1)

setupSQLite: Setup database driver and define connection parameters for SQLite using RSQLite package. Wrapper for setupDriver() function.

Description

Setup database driver and define connection parameters for SQLite using RSQLite package. Wrapper for setupDriver() function.

Usage

setupSQLite(db, dbname = ":memory:", protect = c("password", "user"), ...)

Value

Invisible self

Arguments

db

rocker object

dbname

Database name

protect

Parameters to be hidden

...

Optional, additional suitable parameters passed to DBI::dbConnect()

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(), setupDriver(), setupMariaDB(), setupPostgreSQL(), unloadDriver(), validateCon(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupSQLite(
  db,
  dbname = ":memory:"
)
rocker::unloadDriver(db)