rocker (version 0.3.1)

validateCon: Check if an earlier opened connection is still open.

Description

Check if an earlier opened connection is still open.

Usage

validateCon(db, statement = NULL, onLostNull = FALSE, ...)

Value

TRUE or FALSE

Arguments

db

rocker object

statement

Optional SQL statement. If not set default validateQuery will be used.

onLostNull

TRUE or FALSE. If connection lost, set .con to NULL

...

Not used yet

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(), setupSQLite(), unloadDriver(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupSQLite(db)
rocker::connect(db)
rocker::validateCon(db)
rocker::disconnect(db)
rocker::unloadDriver(db)