sqlutils
sqlutils copied to clipboard
Switch to modern DBI usage
i.e.
require(DBI)
sqlfile <- paste(system.file(package='sqlutils'), '/db/students.db', sep='')
m <- dbDriver(RSQLite::SQLite())
conn <- dbConnect(m, dbname=sqlfile)
q1 <- execQuery('StudentSummary', connection=conn)
Similarly
sqlexec.SQLiteConnection <- function(connection, sql, ...) {
DBI::dbGetQuery(connection, sql, ...)
}