rbind {SQLDataFrame} | R Documentation |
SQLDataFrame
objectsPerforms rbind on SQLDataFrame
objects.
## S4 method for signature 'SQLDataFrame' rbind(..., deparse.level = 1)
... |
One or more |
deparse.level |
See ‘?base::cbind’ for a description of this argument. |
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.
A SQLDataFrame
object.
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)