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

## S4 method for signature 'OsqueryDriver'
dbConnect(drv, host = NULL, keyfile = NULL,
  osquery_remote_path = NULL, ...)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Arguments

object

Any R object

drv

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

host

NULL (default) if using osqueryi locally; an ssh server string of the form [user@]hostname[:@port]

keyfile

NULL (default) if using osqueryi locally; path to private key file. Must be in OpenSSH format (see details)

osquery_remote_path

if connecting to a remote system and osqueryi is not on the PATH for the ssh connection, provide it here. Ignored if using locally.

...

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().

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.


hrbrmstr/osqueryr documentation built on May 31, 2019, 12:10 p.m.