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
## S4 method for signature 'KazamDriver'
show(object)

## S4 method for signature 'KazamDriver'
dbConnect(drv, ...)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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.

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.


rstats-db/RKazam documentation built on May 29, 2018, 10:11 a.m.