dbIsValid

0th

Percentile

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 a DBIResult
...
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

Aliases
  • dbIsValid
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)
Documentation reproduced from package DBI, version 0.5-1, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.