DomoResult: Domo Result Methods

In shunsambongi/domo: DBI for DOMO

Domo Result Methods

Description

Implementations of pure virtual functions defined in the DBI package for DomoResult objects.

Usage

## S4 method for signature 'DomoResult'
show(object)

## S4 method for signature 'DomoResult'
dbIsValid(dbObj, ...)

## S4 method for signature 'DomoResult'
dbBind(res, params, ...)

## S4 method for signature 'DomoResult'
dbFetch(res, n = -1, ...)

## S4 method for signature 'DomoResult'
dbGetRowCount(res, ...)

## S4 method for signature 'DomoResult'
dbGetRowsAffected(res, ...)

## S4 method for signature 'DomoResult'
dbGetStatement(res, ...)

## S4 method for signature 'DomoResult'
dbColumnInfo(res, ...)

## S4 method for signature 'DomoResult'
dbClearResult(res, ...)

## S4 method for signature 'DomoResult'
dbHasCompleted(res, ...)

Arguments

object	Any R object
dbObj	An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult
...	Other arguments to methods.
res	An object inheriting from DBIResult.
params	A list of bindings, named or unnamed.
n	maximum number of records to retrieve per fetch. Use n = -1 or n = Inf to retrieve all pending records. Some implementations may recognize other special values.

Examples

## Not run: 
library(DBI)
con <- dbConnect(domo::domo())
dataset_id <- "77194824-a5c1-11ea-9600-0116159276e2"
res <- dbSendQuery(con, "SELECT mpg FROM mtcars WHERE mpg > ?", dataset_id)
dbBind(res, list(20))
dbHasCompleted(res)
dbGetRowCount(res)

dbFetch(res, n = 1)
dbHasCompleted(res)
dbGetRowCount(res)

dbFetch(res)
dbHasCompleted(res)
dbGetRowCount(res)

dbClearResult(res)
dbDisconnect(con)

## End(Not run)

shunsambongi/domo documentation built on Aug. 19, 2022, 12:47 a.m.