DB: Database connector objects
In mbojan/db6: Interacting with Databases via R6-class Objects

Description Usage Format Methods Examples

Implementation of two R6 classes and their generators for creating database connector objects. Class "DBpub" implements all standard database interaction methods (as in package DBI) as public methods. Class "DBprv" is identical, but with these methods implemented as private methods.

1
2
3

DBpub

DBprv

R6 class generator objects

Implemented methods:

get_query(...): execute arbitrary SQL query, see dbGetQuery
list_tables(...): list tables in DB
list_fields(...): list fields of a table
send_query(...): send query
write_table(...): write a data frame to a DB table
read_table(...): read a DB table, return a data frame
has_tables(...): check if tables exist

z <- DBpub$new( DBI::dbConnect(RSQLite::SQLite(), dbname=":memory:") )
z$show()
z$list_tables()
z$write_table(name="mtcars", value=mtcars)
z$list_tables()
z$read_table("mtcars")
z$disconnect()
z$show()