Batch exporting and importing flobs for an sqlite database
After creating a new version of a database, it can be time consuming to re-populate flobs individually using the slobr app. dbflobr provides functionality to carry out this task automatically with minimal user input, and provides useful console output to summarize the results. Lets assume you have a database containing one or more tables with Blob columns.
Saving flobs from a database
Create a connection to your database and run the function dbflobr::save_all_flobs() providing the database connection and the file path you have chosen for storing the flobs. dbflobr will automatically use the table’s primary key as the file name for each saved flob. In this example, ‘DateVisit’ is the unique primary key
Flobs are stored in sub-directories named after the tables and columns they originated from. This preserves all of the information necessary to repopulate a new version of the database into the correct locations.
Importing flobs back into a database
After a new version of the database has been created, run the function dbflobr::import_all_flobs(), providing the connection to the new database and the file path to the directory in which all of your flobs are stored. dbflobr will repopulate the database using the file and directory names to import each flob to the correct cell.
Working with individual tables and columns
If you only want to export and import flobs from particular tables or columns you can use dbflobr::save_flobs() and dbflobr::import_flobs() respectively, providing the additional arguments ‘table_name’ and ‘column_name’ as needed.