DBI: DBI methods

Description Usage Arguments

Description

Implementations of pure virtual functions defined in the 'DBI' package.

Usage

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
## S4 method for signature 'HDFqlDriver'
show(object)

## S4 method for signature 'HDFqlDriver'
dbConnect(
  drv,
  db,
  ...,
  bigint = c("integer64", "integer", "numeric", "character")
)

## S4 method for signature 'HDFqlDriver'
dbUnloadDriver(drv, ...)

## S4 method for signature 'HDFqlDriver,ANY'
dbDataType(dbObj, obj, ...)

## S4 method for signature 'HDFqlDriver,list'
dbDataType(dbObj, obj, ...)

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

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

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

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

## S4 method for signature 'HDFqlConnection'
dbDisconnect(conn, ...)

## S4 method for signature 'HDFqlConnection,character'
dbSendQuery(conn, statement, ...)

## S4 method for signature 'HDFqlConnection,character'
dbSendStatement(conn, statement, ...)

## S4 method for signature 'HDFqlConnection,ANY'
dbDataType(dbObj, obj, ...)

## S4 method for signature 'HDFqlConnection,character'
dbQuoteString(conn, x, ...)

## S4 method for signature 'HDFqlConnection,character'
dbQuoteIdentifier(conn, x, ...)

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

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

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

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

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

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

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

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

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

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

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

## S4 method for signature 'HDFqlConnection,character,data.frame'
dbWriteTable(conn, name, value, overwrite = FALSE, append = FALSE, ...)

## S4 method for signature 'HDFqlConnection,character'
dbReadTable(conn, name, ...)

## S4 method for signature 'HDFqlConnection'
dbListTables(conn, ...)

## S4 method for signature 'HDFqlConnection,character'
dbExistsTable(conn, name, ...)

## S4 method for signature 'HDFqlConnection,character'
dbListFields(conn, name, ...)

## S4 method for signature 'HDFqlConnection,character'
dbRemoveTable(conn, name, ...)

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

## S4 method for signature 'HDFqlConnection'
dbBegin(conn, ...)

## S4 method for signature 'HDFqlConnection'
dbCommit(conn, ...)

## S4 method for signature 'HDFqlConnection'
dbRollback(conn, ...)

Arguments

object

Any R object

drv

an object that inherits from DBIDriver, or an existing DBIConnection object (in order to clone an existing connection).

...

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

dbObj

A object inheriting from DBIDriver or DBIConnection

obj

An R object whose SQL type we want to determine.

conn

A DBIConnection object, as returned by dbConnect().

statement

a character string containing SQL.

x

A character vector to quote as string.

res

An object inheriting from DBIResult.

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.

params

A list of bindings, named or unnamed.

name

A character string specifying the unquoted DBMS table name, or the result of a call to dbQuoteIdentifier().

value

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

overwrite

Allow overwriting the destination table. Cannot be 'TRUE' if 'append' is also 'TRUE'.

append

Allow appending to the destination table. Cannot be 'TRUE' if 'overwrite' is also 'TRUE'.


mkoohafkan/RHDFql documentation built on April 16, 2020, 10:50 p.m.