R/update_status_db.R
update_status_db.Rd
add a dataframe, optionally purging related obsolete records, to a SQLite database
update_status_db(
sqlite_filename,
tablename,
dropfield = NULL,
dropvalue,
newdf
)
character(1) filename of SQLite database; database must exist
character(1) name of table to operate on
character(1) or NULL, the field used to select records to delete
character(1) only used if dropfield
is not NULL, value used to
select records for deletion
data.frame conforming to the table in tablename
if such exists
Connects to db with flag SQLITE_RW and disconnects on exit.