rbind {SQLDataFrame}R Documentation

rbind of SQLDataFrame objects

Description

Performs rbind on SQLDataFrame objects.

Usage

## S4 method for signature 'SQLDataFrame'
rbind(..., deparse.level = 1)

Arguments

...

One or more SQLDataFrame objects. These can be given as named arguments.

deparse.level

See ‘?base::cbind’ for a description of this argument.

Details

rbind supports aggregation of SQLDataFrame objects. For representation of SQLite tables, same or different connections are supported. For representation of MySQL tables, at least one SQLDataFrame must have write permission.

Value

A SQLDataFrame object.

Examples

test.db1 <- system.file("extdata/test.db", package = "SQLDataFrame")
test.db2 <- system.file("extdata/test1.db", package = "SQLDataFrame")
con1 <- DBI::dbConnect(DBI::dbDriver("SQLite"), dbname = test.db1)
con2 <- DBI::dbConnect(DBI::dbDriver("SQLite"), dbname = test.db2)
obj1 <- SQLDataFrame(conn = con1,
                     dbtable = "state",
                     dbkey = c("region", "population"))
obj2 <- SQLDataFrame(conn = con2,
                     dbtable = "state1",
                     dbkey = c("region", "population"))
obj1_sub <- obj1[1:10, 2:3]
obj2_sub <- obj2[8:15,2:3]

## rbind
res_rbind <- rbind(obj1_sub, obj2_sub)
res_rbind
dim(res_rbind)

[Package SQLDataFrame version 1.8.0 Index]