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.11.4 Index]