rws_write.list: Write a Named List of Data Frames to a SQLite Database

In readwritesqlite: Enhanced Reading and Writing for 'SQLite' Databases

Write a Named List of Data Frames to a SQLite Database

Description

Write a Named List of Data Frames to a SQLite Database

Usage

## S3 method for class '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,
  ...
)

Arguments

x	A named list of data frames.
exists	A flag specifying whether the table(s) must already exist.
delete	A flag specifying whether to delete existing rows before inserting data. If meta = TRUE the meta data is deleted.
replace	A flag specifying whether to replace any existing rows whose inclusion would violate unique or primary key constraints.
meta	A flag specifying whether to preserve meta data.
log	A flag specifying whether to log the table operations.
commit	A flag specifying whether to commit the operations (calling with commit = FALSE can be useful for checking data).
strict	A flag specifying whether to error if x has extraneous columns or if exists = TRUE extraneous data frames.
x_name	A string of the name of the object.
silent	A flag specifying whether to suppress messages and warnings.
conn	A SQLiteConnection to a database.
all	A flag specifying whether all the existing tables in the data base must be represented.
unique	A flag specifying whether each table must represented by no more than one data frame.
...	Not used.

See Also

Other rws_write: rws_write.data.frame(), rws_write.environment(), rws_write()

Examples

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)

readwritesqlite documentation built on Oct. 17, 2022, 1:06 a.m.