Class SQLiteConnection (and methods)

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
dbAppendTable(conn, name, value, ..., row.names = NULL)

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

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

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

# S4 method for SQLiteConnection
dbGetInfo(dbObj, ...)

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

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

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

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

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

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

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

# S4 method for SQLiteConnection
show(object)

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

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