Write extracted contents to local database — cas_write_db_contents

If some IDs are already present in the database, only the new ones are appended: IDs are expected to be unique.

Usage

cas_write_db_contents_data(
  contents_df,
  overwrite = FALSE,
  db_connection = NULL,
  disconnect_db = FALSE,
  quiet = FALSE,
  check_previous = TRUE,
  ...
)

Arguments

overwrite: Logical, defaults to FALSE. If TRUE, checks if matching data are previously held in the table and overwrites them. This should be used with caution, as it may overwrite completely the selected table.
db_connection: Defaults to NULL. If NULL, uses local SQLite database. If given, must be a connection object or a list with relevant connection settings (see example).
disconnect_db: Defaults to TRUE. If FALSE, leaves the connection to database open.
quiet: Defaults to FALSE. If set to TRUE, messages on number of lines added are not shown.
check_previous: Defaults to TRUE. If set to FALSE, the given input is stored in the database without checking if the same id had already been stored.
...: Passed to cas_get_db_file().

Value

Invisibly returns only new rows added.

Details

Check for consistency in database columns: if new columns do not match previous columns, it throws an error.