SQLServerResult-class: SQL Server Result classes

In RSQLServer: SQL Server R Database Interface (DBI) and 'dplyr' SQL Backend

Description

The SQLServerPreResult class extends the DBIResult class, the SQLServerResult class extends the SQLServerPreResult class, while the SQLServerUpdateResult class extends the SQLServerResult class. The SQLServerUpdateResult class is created by a call to dbSendStatement as the JDBC API does not return a ResultSet but rather an integer value for non-query statements. The dbGetRowsAffected called on SQLServerUpdateResult returns the value produced by the JDBC API. The SQLServerPreResult class wraps a JDBC PreparedStatement that has yet to be executed and is necessary for dbBind to function per the DBI spec (taking a DBIResult as an input and returning another as output). This contrasts to the JDBC interface where binding occurs on Statement classes and not on ResultSet classes.

Usage

## S4 method for signature 'SQLServerResult'
dbIsValid(dbObj)

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

## S4 method for signature 'SQLServerPreResult,numeric'
fetch(res, n = -1, ...)

## S4 method for signature 'SQLServerUpdateResult,numeric'
fetch(res, n = -1, ...)

## S4 method for signature 'SQLServerPreResult'
dbBind(res, params, ..., batch = FALSE)

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

## S4 method for signature 'SQLServerResult,numeric'
fetch(res, n = -1, block = 2048L, ...)

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

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

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

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

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

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

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

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

Arguments

batch

logical, indicates whether uploads (e.g., 'INSERT' or 'UPDATE') should be uploaded in batches, potentially much faster than by individual rows (the default). (Setting it here enabled binding the variables in batches, the actual batched upload is done in dbSendStatement or dbExecute.)

RSQLServer documentation built on June 20, 2017, 9:12 a.m.