RoomAsset

General

Category
Free
Tag
Database
License
Apache License, Version 2.0
Min SDK
15 (Android 4.0.3–4.0.4 Ice Cream Sandwich)
Registered
Nov 7, 2017
Favorites
4
Link
https://github.com/humazed/RoomAsset
See also
Android schema utils
SQLiteHelper
sqlbrite-migrations
Android-LazyDatabase
RoomDatabaseBackupAndRestore

Additional

Language
Kotlin
Version
1.0.3 (Apr 14, 2018)
Created
Jul 21, 2017
Updated
Jan 13, 2020
Owner
Ibrahim Eid (humazed)
Contributors
Robert Theis (rmtheis)
Ibrahim Eid (humazed)
spiral6
kevinzhow
ueen
5
Activity
Badge
Generate
Download
Source code
APK file

Advertisement

Room now supports using a pre-packaged database out of the box, since version 2.2.0

https://developer.android.com/jetpack/androidx/releases/room#2.2.0

As the built-in Room support is limited here's a library that supports migration as well as keeping specified columns that eg contain userdata.

https://github.com/ueen/RoomAssetHelper

RoomAsset

An Android helper class to manage database creation and version management using an application's raw asset files.

This library provides developers with a simple way to ship their Android app with an existing SQLite database (which may be pre-populated with data) and to manage its initial creation and any upgrades required with subsequent version releases.

It is implemented as an extension to Room, providing an easy way to use Room with an existing SQLite database.

Add the dependency

dependencies {
    // ... other dependencies
    implementation 'com.github.humazed:RoomAsset:1.0.3'
}

RoomAsset is intended as a drop in alternative for the framework's Room.

You can use 

RoomAsset as you use Room but with two changes:Use RoomAsset.databaseBuilder() instead of Room.databaseBuilder()In @Database use version = 2 instead of version = 1val db =RoomAsset.databaseBuilder(applicationContext, AppDatabase::class.java, "chinook.db").build() val employees = db.chinookDao().employees
RoomAsset relies upon asset file and folder naming conventions. Your assets folder will either be under your project root, or under src/main if you are using the default gradle project structure. At minimum, you must provide the following:A databases folder inside assetsA SQLite database inside the databases folder whose file name matches the database name you provide in code (including the file extension, if any)
For the example above, the project would contain the following:
assets/databases/chinook.db 
The database will be extracted from the assets and copied into place within your application's private data directory. If you prefer to store the database file somewhere else (such as external storage) you can use the alternate constructor to specify a storage path. You must ensure that this path is available and writable whenever your application needs to access the database.
val db =RoomAsset.databaseBuilder(applicationContext, AppDatabase::class.java, "chinook.db",
        applicationContext.getExternalFilesDir(null).absolutePath).build()
The library will throw a SQLiteAssetHelperException if you do not provide the appropriately named file.
Supported data types: TEXT, INTEGER, REAL, BLOB
The sample project demonstrates a simple database creation and usage example using the classic Chinook database.