extract-methods: Extract and Assignement Methods

In jrnold/DBIExtras: Misc DBI related functions

Description

Extract and Assignement Methods

Examples

## Not run:
library(RSQLite)
data(iris)
tmpdb <- tempfile()
drv <- dbDriver("SQLite")
con <- dbConnect(drv, tmpdb)

## No tables currently defined
dbListTables(con)
## Create table iris
con[["iris"]] <- iris
dbListTables(con)
## Read table
con[["iris"]]
## Delete Table
con[["iris"]] <- NULL
dbListTables(con)

## $ can also be used to read/write/delete tables
con$iris <- iris
con$iris
con$iris <- NULL
dbListTables(con)

jrnold/DBIExtras documentation built on May 19, 2019, 11:55 p.m.