dbIsValid
From DBI v0.5-1
by Kirill Müller
Is this DBMS object still valid?
This generic tests whether a database object is still valid (i.e. it hasn't been disconnected or cleared).
Usage
dbIsValid(dbObj, ...)Arguments
- dbObj
- An object inheriting from
DBIObject, i.e.DBIDriver,DBIConnection, or aDBIResult - ...
- Other arguments to methods.
Value
-
a logical of length 1
See Also
Other DBIDriver generics: DBIDriver-class,
dbConnect, dbDataType,
dbDriver, dbGetInfo,
dbListConnections
Other DBIConnection generics: DBIConnection-class,
dbDataType, dbDisconnect,
dbExecute, dbExistsTable,
dbGetException, dbGetInfo,
dbGetQuery, dbListFields,
dbListResults, dbListTables,
dbReadTable, dbRemoveTable,
dbSendQuery, dbSendStatement
Other DBIResult generics: DBIResult-class,
SQL, dbBind,
dbClearResult, dbColumnInfo,
dbFetch, dbGetInfo,
dbGetRowCount,
dbGetRowsAffected,
dbGetStatement,
dbHasCompleted
Examples
library(DBI)
dbIsValid(RSQLite::SQLite())
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbIsValid(con)
rs <- dbSendQuery(con, "SELECT 1")
dbIsValid(rs)
dbClearResult(rs)
dbIsValid(rs)
dbDisconnect(con)
dbIsValid(con)
Community examples
Looks like there are no examples yet.