Learn R Programming

DBI (version 1.2.2)

DBIObject-class: DBIObject class

Description

Base class for all other DBI classes (e.g., drivers, connections). This is a virtual Class: No objects may be created from it.

Arguments

Implementation notes

An implementation MUST provide methods for the following generics:

  • dbGetInfo().

It MAY also provide methods for:

  • summary(). Print a concise description of the object. The default method invokes dbGetInfo(dbObj) and prints the name-value pairs one per line. Individual implementations may tailor this appropriately.

Details

More generally, the DBI defines a very small set of classes and generics that allows users and applications access DBMS with a common interface. The virtual classes are DBIDriver that individual drivers extend, DBIConnection that represent instances of DBMS connections, and DBIResult that represent the result of a DBMS statement. These three classes extend the basic class of DBIObject, which serves as the root or parent of the class hierarchy.

See Also

Other DBI classes: DBIConnection-class, DBIConnector-class, DBIDriver-class, DBIResult-class, DBIResultArrow-class

Examples

Run this code
if (FALSE) { # requireNamespace("RSQLite", quietly = TRUE)
drv <- RSQLite::SQLite()
con <- dbConnect(drv)

rs <- dbSendQuery(con, "SELECT 1")
is(drv, "DBIObject")   ## True
is(con, "DBIObject")   ## True
is(rs, "DBIObject")

dbClearResult(rs)
dbDisconnect(con)
}

Run the code above in your browser using DataLab