duckdb_result-class: DuckDB Result Set

In duckdb: DBI Package for the DuckDB Database Management System

Description

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

Usage

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

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

duckdb_fetch_arrow(
  res,
  stream = FALSE,
  vector_per_chunk = 1,
  return_table = FALSE
)

duckdb_fetch_record_batch(res, approx_batch_size = 1)

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

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

## S4 method for signature 'duckdb_result'
dbGetInfo(dbObj, ...)

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

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

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

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

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

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

Arguments

object	Any R object
res	Query result to be converted to an Arrow Table
...	Other arguments passed on to methods.
stream	If we are streaming the query result or returning it all at once
vector_per_chunk	If streaming, how many vectors per chunk we should emit
return_table	If we return results as a list of RecordBatches or an Arrow Table
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
params	A list of bindings, named or unnamed.

duckdb documentation built on Nov. 22, 2021, 5:07 p.m.