Backup Room database

by

This doesn’t answer the original question

How can I properly re-open room db after I close it?

However, moving everything to the original database file is what you want to do, then you don’t have to close the database in the first place. You can instead force a checkpoint using the wal_checkpoint pragma.

Query the following statement against the database. We use raw queries here as pragma is not yet supported by Room (it will trigger a UNKNOWN query type error). Have this query inside of your DAO:

@RawQuery
int checkpoint(SupportSQLiteQuery supportSQLiteQuery);

And then when you call the checkpoint method, use the query then:

myDAO.checkpoint(new SimpleSQLiteQuery("pragma wal_checkpoint(full)"));

This link may shed some light on what wal_checkpoint does.

More Related Contents:

  1. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. Android SQLite Example [closed]
  4. Android Room: Insert relation entities using Room
  5. Room Persistence: Error:Entities and Pojos must have a usable public constructor
  6. Room – LiveData observer does not trigger when database is updated
  7. How can I represent a “many to many” relation with Android Room when column names are same?
  8. Return type for Android Room joins
  9. How insert image in room persistence library?
  10. DB File in Assets Folder. Will it be Updated?
  11. SQLiteOpenHelper – creating database on SD card
  12. How to combine two live data one after the other?
  13. how to bulk insert in sqlite in android
  14. How to add multiple edit text and spinner data into SQLite database?
  15. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  16. What is AndroidX?
  17. Location of sqlite database on the device
  18. Android column ‘_id’ does not exist?
  19. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  20. Deleting Row in SQLite in Android
  21. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  22. Android sqlite how to check if a record exists
  23. Android room persistent library – TypeConverter error of error: Cannot figure out how to save field to database”
  24. How can I insert image in a sqlite database
  25. Android Jetpack Navigation, BottomNavigationView with Youtube or Instagram like proper back navigation (fragment back stack)?
  26. What is The use of moveToFirst () in SQLite Cursors
  27. ViewModelProviders is deprecated in 1.1.0
  28. SQLite android column not found
  29. How I can retrieve current fragment in NavHostFragment?
  30. SQlite – Android – Foreign key syntax

Leave a Comment