write_flob: Write flob

In dbflobr: Read and Write Files to SQLite Databases

Write flob

Description

Write a flob to a SQLite database.

Usage

write_flob(flob, column_name, table_name, key, conn, exists = NA)

Arguments

flob	A flob.
column_name	A string of the name of the BLOB column.
table_name	A string of the name of the existing table.
key	A data.frame whose columns and values are used to filter the table to a single row (this in combination with the column_name argument are used to target a single cell within the table to modify).
conn	A SQLite connection object.
exists	A logical scalar specifying whether the column must (TRUE) or mustn't (FALSE) already exist or whether it doesn't matter (NA). IF FALSE, a new BLOB column is created.

Value

An invisible copy of flob.

Examples

flob <- flobr::flob_obj
conn <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(conn, "Table1", data.frame(IntColumn = c(1L, 2L)))
DBI::dbReadTable(conn, "Table1")
key <- data.frame(IntColumn = 2L)
write_flob(flob, "BlobColumn", "Table1", key, conn, exists = FALSE)
DBI::dbReadTable(conn, "Table1")
DBI::dbDisconnect(conn)

dbflobr documentation built on Aug. 20, 2022, 1:06 a.m.