Learn R Programming
adbi (version 0.1.2)

AdbiResult-class: Class AdbiResult (and methods)

Description

AdbiResult objects are created by DBI::dbSendQuery() or DBI::dbSendStatement(), and encapsulate the result of an SQL statement (either SELECT or not). They are a superclass of the DBI::DBIResult class. The "Usage" section lists the class methods overridden by adbi.

Usage

# S4 method for AdbiResult
dbBindArrow(res, params, ...)
# S4 method for AdbiResult
dbBind(res, params, ...)
# S4 method for AdbiResult
dbClearResult(res, ...)
# S4 method for AdbiResult
dbColumnInfo(res, ...)
# S4 method for AdbiResult
dbGetRowCount(res, ...)
# S4 method for AdbiResult
dbGetRowsAffected(res, ...)
# S4 method for AdbiResult
dbGetStatement(res, ...)
# S4 method for AdbiResult
dbHasCompleted(res, ...)
# S4 method for AdbiResult
dbIsValid(dbObj, ...)
# S4 method for AdbiResult
show(object)

Arguments

res

An object inheriting from DBI::DBIResult.

params

For dbBind(), a list of values, named or unnamed, or a data frame, with one element/column per query parameter. For dbBindArrow(), values as a nanoarrow stream, with one column per query parameter.

...

Other arguments passed on to methods.

dbObj

An object inheriting from DBI::DBIObject, i.e. DBI::DBIDriver, DBI::DBIConnection, or a DBI::DBIResult

object

Any R object

See Also

The corresponding generic functions DBI::dbFetch(), DBI::dbClearResult(), DBI::dbBind(), DBI::dbColumnInfo(), DBI::dbGetRowsAffected(), DBI::dbGetRowCount(), DBI::dbHasCompleted(), and DBI::dbGetStatement().