SQLiteConnection-class: Class SQLiteConnection (and methods)

Description Usage Arguments See Also

Description

SQLiteConnection objects are created by passing SQLite() as first argument to DBI::dbConnect(). They are a superclass of the DBIConnection class. The "Usage" section lists the class methods overridden by RSQLite.

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
## S3 method for class 'SQLiteConnection'
format(x, ...)

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

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

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

## S4 method for signature 'SQLiteConnection,SQL'
dbQuoteIdentifier(conn, x, ...)

## S4 method for signature 'SQLiteConnection,SQL'
dbUnquoteIdentifier(conn, x, ...)

## S4 method for signature 'SQLiteConnection'
dbGetException(conn, ...)

## S4 method for signature 'SQLiteConnection,character'
dbSendQuery(conn, statement,
  params = NULL, ...)

## S4 method for signature 'SQLiteConnection'
sqlData(con, value,
  row.names = pkgconfig::get_config("RSQLite::row.names.query", FALSE), ...)

## S4 method for signature 'SQLiteConnection,character'
dbRemoveTable(conn, name, ...,
  temporary = FALSE, fail_if_missing = TRUE)

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

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

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

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

Arguments

temporary

If TRUE, only temporary tables are considered.

fail_if_missing

If FALSE, dbRemoveTable() succeeds if the table doesn't exist.

See Also

The corresponding generic functions DBI::dbSendQuery(), DBI::dbGetQuery(), DBI::dbSendStatement(), DBI::dbExecute(), DBI::dbExistsTable(), DBI::dbListTables(), DBI::dbListFields(), DBI::dbRemoveTable(), and DBI::sqlData().


RSQLite documentation built on May 7, 2018, 1:03 a.m.