Write to a SQLite Database
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,
...
)
The object to write.
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.
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.
Not used.
An invisible character vector of the name(s) of the table(s).
Other rws_write:
rws_write.data.frame()
,
rws_write.environment()
,
rws_write.list()
conn <- rws_connect()
rws_write(rws_data, exists = FALSE, conn = conn)
rws_disconnect(conn)