sqlutils icon indicating copy to clipboard operation
sqlutils copied to clipboard

Switch to modern DBI usage

Open hadley opened this issue 10 years ago • 1 comments

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)

hadley avatar Jul 01 '15 15:07 hadley

Similarly

sqlexec.SQLiteConnection <- function(connection, sql, ...) {
  DBI::dbGetQuery(connection, sql, ...)
}

hadley avatar Jul 01 '15 15:07 hadley