setupSQLite: Setup database driver and define connection parameters for...

In rocker: Database Interface Class

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"), ...)

Arguments

db	rocker object
dbname	Database name
protect	Parameters to be hidden
...	Optional, additional suitable parameters passed to DBI::dbConnect()

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

Examples

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

rocker documentation built on Aug. 21, 2022, 1:06 a.m.