Develop a standard(ish?) set of DBI methods to run

[jonkeane]

If we match DBI's methods, we should be able to test each driver relatively simply. What's the minimal and appropriate set of DBI methods that we should cover to test and show compatibility with a new driver.

cf: https://cran.r-project.org/web/packages/DBI/vignettes/DBI-1.html

DBIDriver

These are probably mostly no-op

• driverName()
• dbListConnections(drv, ...)
• dbGetInfo(dbObj, ...)
• dbUnloadDriver(driverName)

DBIConnection

• dbConnect(drv, ...)
• dbDisconnect(conn, ...)
• dbSendQuery(conn, statement, ...)
• dbGetQuery(conn, statemnet, ...)
• dbGetException(conn, ...) (deprecated Deprecate dbListResults() r-dbi/DBI#58)
• dbGetInfo(dbObj, ...)
• dbListResults(conn, ...) (deprecated Deprecate dbGetException r-dbi/DBI#51)
• dbListTables(conn, ...)
• dbReadTable(conn, name, ...)
• dbWriteTable(conn, name, value, ...)
• dbRemoveTable(conn, name, ...)
• dbListFields(conn, name, ...)
• dbCommit(conn, ...) (optional)
• dbRollback(conn, ...) (optional)
• dbCallProc(conn, storedProc, ...) (optional, deprecated)

DBIResult

• fetch(res, n, ...)
• dbClearResult(res, ...)
• dbGetInfo(dbObj, ...)
• dbColumnInfo(res, ...)
• dbSetDataMappings(velds, ...) (optional)
• dbGetStatement(res, ...) (optional)
• dbGetRowsAffected(res, ...) (optional)
• dbHasCompleted(res, ...) (optional)
• dbGetRowCount(res, ...) (optional)