Rename flob
s from a SQLite database and save to directory.
save_all_flobs(
table_name = NULL,
conn,
dir = ".",
sep = "_-_",
sub = FALSE,
replace = FALSE,
geometry = FALSE
)
A vector of character strings indicating names of tables to save flobs from. By default all tables are included.
A SQLite connection object.
A string of the path to the directory to save the files in.
A string of the separator used to construct file names from values.
A logical scalar specifying whether to save all existing files in a subdirectory of the same name (sub = TRUE) or all possible files in a subdirectory of the same name (sub = NA) or not nest files within a subdirectory (sub = FALSE).
A flag specifying whether to replace existing files. If sub = TRUE (or sub = NA) and replace = TRUE then all existing files within a subdirectory are deleted.
A flag specifying whether to search columns named geometry for flobs.
An invisible named list of named vectors of the file names and new file names saved.
flob <- flobr::flob_obj
conn <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbGetQuery(conn, "CREATE TABLE Table1 (IntColumn INTEGER PRIMARY KEY NOT NULL)")
#> Warning: SQL statements must be issued with dbExecute() or dbSendStatement() instead of dbGetQuery() or dbSendQuery().
#> data frame with 0 columns and 0 rows
DBI::dbWriteTable(conn, "Table1", data.frame(IntColumn = c(1L, 2L)), append = TRUE)
key <- data.frame(IntColumn = 2L)
write_flob(flob, "BlobColumn", "Table1", key, conn, exists = FALSE)
dir <- tempdir()
save_all_flobs(conn = conn, dir = dir)
#> Table name: 'Table1'
#> Column name: 'BlobColumn'
#> Saving files to '/var/folders/24/8k48jl6d249_n_qfxwsl6xvm0000gn/T//RtmpNCRB0r/Table1/BlobColumn'
#> ✖ Row 1: no file found
#> ✔ Row 2: file flobr.pdf renamed to 2.pdf
#>
DBI::dbDisconnect(conn)