coercion: Coerce SQLiteDataset Objects to Other Classes

In dfdb: Access Data Tables in a SQLite Data Base as Pseudo-Dataframes

Description

Methods to coercise a SQLiteDataset object to a data frame, list, or matrix.

Usage

## S3 method for class 'SQLiteDataset'
as.data.frame(x, row.names, optional, ...)
## S3 method for class 'SQLiteDataset'
as.list(x, ...)
## S3 method for class 'SQLiteDataset'
as.matrix(x, ...)

Arguments

x	an SQLiteDataset object.
row.names	not used.
optional	not used.
...	not used.

Value

a data frame, list, or matrix containing the entire data set.

Author(s)

John Fox, [e-mail].

See Also

SQLiteDataset, as.data.frame, as.list, as.matrix

Examples

dr <- dbDriver("SQLite")
tfile <- tempfile()
con <- dbConnect(dr, dbname = tfile)
dbWriteTable(con, "USArrests", USArrests)
dbDisconnect(con)
Arrests <- SQLiteDataset("USArrests", database=tfile)
as.data.frame(Arrests)
as.list(Arrests)
as.matrix(Arrests)
close(Arrests)

dfdb documentation built on May 2, 2019, 4:58 p.m.