dbGetInfo-methods {RSQLite} | R Documentation |
These methods are straight-forward implementations of the corresponding generic functions.
SQLiteResult
.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
SQLite
,
dbDriver
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbListTables
,
dbReadTable
.
data(USArrests) drv <- dbDriver("SQLite") con <- dbConnect(drv, dbname=":memory:") dbWriteTable(con, "t1", USArrests) dbWriteTable(con, "t2", USArrests) dbListTables(con) rs <- dbSendQuery(con, "select * from t1 where UrbanPop >= 80") dbGetStatement(rs) dbHasCompleted(rs) info <- dbGetInfo(rs) names(info) info$fields fetch(rs, n=2) dbHasCompleted(rs) info <- dbGetInfo(rs) info$fields dbClearResult(rs) names(dbGetInfo(drv)) # DBIConnection info names(dbGetInfo(con)) dbDisconnect(con)