Learn R Programming
RSQLite (version 2.1.4)

SQLiteConnection-class: Class SQLiteConnection (and methods)

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

# S3 method for SQLiteConnection
format(x, ...)
# S4 method for SQLiteConnection
show(object)
# S4 method for SQLiteConnection
dbIsValid(dbObj, ...)
# S4 method for SQLiteConnection,character
dbQuoteIdentifier(conn, x, ...)
# S4 method for SQLiteConnection,SQL
dbQuoteIdentifier(conn, x, ...)
# S4 method for SQLiteConnection,SQL
dbUnquoteIdentifier(conn, x, ...)
# S4 method for SQLiteConnection
dbGetException(conn, ...)
# S4 method for SQLiteConnection,character
dbSendQuery(conn, statement,
  params = NULL, ...)
# S4 method for SQLiteConnection
sqlData(con, value,
  row.names = pkgconfig::get_config("RSQLite::row.names.query", FALSE),
  ...)
# S4 method for SQLiteConnection,character
dbRemoveTable(conn, name, ...,
  temporary = FALSE, fail_if_missing = TRUE)
# S4 method for SQLiteConnection,character
dbExistsTable(conn, name, ...)
# S4 method for SQLiteConnection
dbListTables(conn, ...)
# S4 method for SQLiteConnection,character
dbListFields(conn, name, ...)
# S4 method for 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().