Learn R Programming

RSQLite (version 2.1.1)

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