saveSQLDataFrame: Save SQLDataFrame object as a new database table.

In Liubuntu/SQLDataFrame: Representation of database tables in DataFrame metaphor.

Description

The function to save SQLDataFrame object as a database table with a supplied path to database.

Usage

saveSQLDataFrame(x, dbname = tempfile(fileext = ".db"),
  dbtable = deparse(substitute(x)), overwrite = FALSE, ...)

Arguments

x	The SQLDataFrame object to be saved.
dbname	A character string of the file path of to be saved database file.
dbtable	A character string for the to be saved database table name. Default is the name of the input SQLDataFrame.
overwrite	Whether to overwrite the dbtable if already exists. Default is FALSE.
...	other parameters passed to methods.

Examples

dbname <- system.file("extdata/test.db", package = "SQLDataFrame")
obj <- SQLDataFrame(dbname = dbname, dbtable = "state", dbkey = "state")
obj1 <- obj[1:10, 2:3]
obj1 <- saveSQLDataFrame(obj1, dbtable = "obj_subset")
dbname(obj1)
dbtable(obj1)

Liubuntu/SQLDataFrame documentation built on May 17, 2019, 7:43 a.m.