SQLiteConnection-class {RSQLite}

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

## S4 method for signature 'SQLiteConnection'
dbAppendTable(conn, name, value, ..., row.names = NULL)

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

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

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

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

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

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

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

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

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

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

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

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

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

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