Write a Named List of Data Frames to a SQLite Database
# S3 method for list rws_write( x, exists = TRUE, delete = FALSE, replace = FALSE, meta = TRUE, log = TRUE, commit = TRUE, strict = TRUE, x_name = substitute(x), silent = getOption("rws.silent", FALSE), conn, all = TRUE, unique = TRUE, ... )
A named list of data frames.
A flag specifying whether the table(s) must already exist.
A flag specifying whether to delete existing rows before inserting data. If meta = TRUE the meta data is deleted.
meta = TRUE
A flag specifying whether to replace any existing rows whose inclusion would violate unique or primary key constraints.
A flag specifying whether to preserve meta data.
A flag specifying whether to log the table operations.
A flag specifying whether to commit the operations (calling with commit = FALSE can be useful for checking data).
A flag specifying whether to error if x has extraneous columns or if exists = TRUE extraneous data frames.
A string of the name of the object.
A flag specifying whether to suppress messages and warnings.
A SQLiteConnection to a database.
A flag specifying whether all the existing tables in the data base must be represented.
A flag specifying whether each table must represented by no more than one data frame.
Not used.
Other rws_write: rws_write.data.frame(), rws_write.environment(), rws_write()
rws_write.data.frame()
rws_write.environment()
rws_write()
conn <- rws_connect() rws_list_tables(conn) rws_write(list(somedata = rws_data, anothertable = rws_data), exists = FALSE, conn = conn) rws_list_tables(conn) rws_disconnect(conn)
Run the code above in your browser using DataLab