| setupSQLite {rocker} | R Documentation |
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 |
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)