duckdb_result-class: DuckDB Result Set

Description

Methods for accessing result sets for queries on DuckDB connections. Implements DBIResult.

Usage

duckdb_fetch_arrow(res, chunk_size = 1e+06)
duckdb_fetch_record_batch(res, chunk_size = 1e+06)
# S4 method for duckdb_result
dbBind(res, params, ...)
# S4 method for duckdb_result
dbClearResult(res, ...)
# S4 method for duckdb_result
dbColumnInfo(res, ...)
# S4 method for duckdb_result
dbFetch(res, n = -1, ...)
# S4 method for duckdb_result
dbGetInfo(dbObj, ...)
# S4 method for duckdb_result
dbGetRowCount(res, ...)
# S4 method for duckdb_result
dbGetRowsAffected(res, ...)
# S4 method for duckdb_result
dbGetStatement(res, ...)
# S4 method for duckdb_result
dbHasCompleted(res, ...)
# S4 method for duckdb_result
dbIsValid(dbObj, ...)
# S4 method for duckdb_result
show(object)

Arguments

res: Query result to be converted to a Record Batch Reader
chunk_size: The chunk size
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.
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.
dbObj: An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult
object: Any R object