How to use Room Persistence Library with pre-populated database?

by

This is how I solved it, and how you can ship your application with a pre-populated database (up to Room v. alpha5)

  • put your SQLite DB database_name.db into the assets/databases folder

  • take the files from this repo and put them in a package called i.e. sqlAsset

  • in your AppDatabase class, modify your Room’s DB creation code accordingly:

    Room.databaseBuilder(context.getApplicationContext(), 
                     AppDatabase.class, 
                     "database_name.db")
.openHelperFactory(new AssetSQLiteOpenHelperFactory())
.allowMainThreadQueries()
.build();

Note that you have to use "database_name.db" and not getDatabasePath() or other methods: it just needs the name of the file.

More Related Contents:

  1. How to populate Android Room database table on first run?
  2. How insert image in room persistence library?
  3. Need a bit of assistance [closed]
  4. How to add multiple edit text and spinner data into SQLite database?
  5. CursorOutofBoundsException Index -1 requested with size of 0
  6. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  7. Save data in a SQLite database with the original format and view those data again with that form format
  8. Ship an application with a database
  9. Retrieve database or any other file from the Internal Storage using run-as
  10. How to access data/data folder in Android device?
  11. View contents of database file in Android Studio
  12. Recommended way / order to read data from a webservice, parse that data and insert it in a SQLite db
  13. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  14. How to perform an SQLite query within an Android application?
  15. Room Persistence: Error:Entities and Pojos must have a usable public constructor
  16. Android room persistent library – TypeConverter error of error: Cannot figure out how to save field to database”
  17. Android: column ‘_id’ does not exist
  18. How can I insert image in a sqlite database
  19. Room – LiveData observer does not trigger when database is updated
  20. How to store and retrieve a byte array (image data) to and from a SQLite database?
  21. Android room persistent library – how to insert class that has a List object field
  22. SQLite returned an error code of 14
  23. How to store sqlite database directly on sdcard
  24. Attempt to reopen an already-closed object sqlitedatabase
  25. How to save enum field in the database room?
  26. Room : LiveData from Dao will trigger Observer.onChanged on every Update, even if the LiveData value has no change
  27. How to convert milliseconds to date in SQLite
  28. How to check database on not rooted android device
  29. How to make primary key as autoincrement for Room Persistence lib
  30. Backup Room database

Leave a Comment