Learn R Programming
bigrquery (version 0.3.0)

DBI: DBI methods

Description

Implementations of pure virtual functions defined in the DBI package.

Usage

# S4 method for BigQueryDriver
show(object)
# S4 method for BigQueryDriver
dbConnect(drv, project, dataset, billing = project,
  ...)
# S4 method for BigQueryDriver
dbIsValid(dbObj, ...)
# S4 method for BigQueryDriver
dbGetInfo(dbObj, ...)
# S4 method for BigQueryConnection
show(object)
# S4 method for BigQueryConnection
dbIsValid(dbObj, ...)
# S4 method for BigQueryConnection
dbDisconnect(conn, ...)
# S4 method for BigQueryConnection,character
dbSendQuery(conn, statement, ...)
# S4 method for BigQueryConnection,character
dbQuoteString(conn, x, ...)
# S4 method for BigQueryConnection,character
dbQuoteIdentifier(conn, x, ...)
# S4 method for BigQueryConnection,character,data.frame
dbWriteTable(conn, name,
  value, overwrite = FALSE, append = FALSE, ..., row.names = NA)
# S4 method for BigQueryConnection,character
dbReadTable(conn, name, ...,
  row.names = NA)
# S4 method for BigQueryConnection
dbListTables(conn, ...)
# S4 method for BigQueryConnection,character
dbExistsTable(conn, name, ...)
# S4 method for BigQueryConnection,character
dbListFields(conn, name, ...)
# S4 method for BigQueryConnection,character
dbRemoveTable(conn, name, ...)
# S4 method for BigQueryConnection
dbGetInfo(dbObj, ...)
# S4 method for BigQueryConnection
dbBegin(conn, ...)
# S4 method for BigQueryConnection
dbCommit(conn, ...)
# S4 method for BigQueryConnection
dbRollback(conn, ...)
# S4 method for BigQueryResult
show(object)
# S4 method for BigQueryResult
dbIsValid(dbObj, ...)
# S4 method for BigQueryResult
dbClearResult(res, ...)
# S4 method for BigQueryResult
dbFetch(res, n = -1, ..., row.names = NA)
# S4 method for BigQueryResult
dbHasCompleted(res, ...)
# S4 method for BigQueryResult
dbGetStatement(res, ...)
# S4 method for BigQueryResult
dbColumnInfo(res, ...)
# S4 method for BigQueryResult
dbGetRowCount(res, ...)
# S4 method for BigQueryResult
dbGetRowsAffected(res, ...)
# S4 method for BigQueryResult
dbBind(res, params, ...)

Arguments

object

Any R object

drv

an object that inherits from , or a character string specifying the name of DBMS driver, e.g., "RSQLite", "RMySQL", "RPostgreSQL", or an existing object (in order to clone an existing connection).

project

project containing this table

dataset

dataset containing this table

billing

project ID to use for billing

...

authorization arguments needed by the DBMS instance; these typically include user, password, dbname, host, port, etc. For details see the appropriate DBIDriver.

dbObj

An object inheriting from , i.e. , , or a

conn

A object, as produced by dbConnect.

statement

a character vector of length 1 containing SQL.

x

A character vector to label as being escaped SQL.

name

A character string specifying a DBMS table name.

value

a data.frame (or coercible to data.frame).

overwrite

a logical specifying whether to overwrite an existing table or not. Its default is FALSE.

append

a logical specifying whether to append to an existing table in the DBMS. Its default is FALSE.

row.names

A logical specifying whether the row.names should be output to the output DBMS table; if TRUE, an extra field whose name will be whatever the R identifier "row.names" maps to the DBMS (see make.db.names). If NA will add rows names if they are characters, otherwise will ignore.

res

An object inheriting from .

n

maximum number of records to retrieve per fetch. Use n = -1 to retrieve all pending records. Some implementations may recognize other special values.

params

A list of bindings. Named values should be matched to named paramters (if supported by the DBI backend). Unnamed values will be matched by position. I don't recommend mixing named and unnamed values.