SQLiteConnection-class {RSQLite}R Documentation

Class SQLiteConnection

Description

SQLite connection class.

Generators

The method dbConnect is the main generator.

Extends

Class "DBIConnection", directly. Class "SQLiteObject", directly. Class "DBIObject", by class "DBIConnection". Class "dbObjectId", by class "SQLiteObject".

Methods

coerce
signature(from = "SQLiteConnection", to = "SQLiteResult"): ...
dbCallProc
signature(conn = "SQLiteConnection"): ...
dbCommit
signature(conn = "SQLiteConnection"): ...
dbConnect
signature(drv = "SQLiteConnection"): ...
dbDisconnect
signature(conn = "SQLiteConnection"): ...
dbExistsTable
signature(conn = "SQLiteConnection", name = "character"): ...
dbGetException
signature(conn = "SQLiteConnection"): ...
dbGetInfo
signature(dbObj = "SQLiteConnection"): ...
dbGetQuery
signature(conn = "SQLiteConnection", statement = "character"): ...
dbListFields
signature(conn = "SQLiteConnection", name = "character"): ...
dbListResults
signature(conn = "SQLiteConnection"): ...
dbListTables
signature(conn = "SQLiteConnection"): ...
dbReadTable
signature(conn = "SQLiteConnection", name = "character"): ...
dbRemoveTable
signature(conn = "SQLiteConnection", name = "character"): ...
dbRollback
signature(conn = "SQLiteConnection"): ...
dbSendQuery
signature(conn = "SQLiteConnection", statement = "character"): ...
dbWriteTable
signature(conn = "SQLiteConnection", name = "character", value = "data.frame"): ...
summary
signature(object = "SQLiteConnection"): ...

Author(s)

R-SIG-DB

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

DBI classes: SQLiteObject-class SQLiteDriver-class SQLiteConnection-class SQLiteResult-class

Examples

drv <- dbDriver("SQLite")
tfile <- tempfile()
con <- dbConnect(drv, dbname = tfile)
dbDisconnect(con)
dbUnloadDriver(drv)

[Package RSQLite version 0.6-9 Index]