tellypresence / assetsqliteopenhelper Goto Github PK

This module supports migrating SQLite to Room Persistence Library, loads pre-populated SQLite database base on albertogiunta/sqliteAsset

Step 1. Add it in your root build.gradle at the end of repositories:

allprojects {
	repositories {
		...
		maven { url "https://jitpack.io" }
	}
}

Step 2. Add the dependency

dependencies {
    implementation 'com.github.daolq3012:AssetSQLiteOpenHelper:1.0'
    // Because AssetSQLiteOpenHelper releases are few and far between (persistence room version using in module is 1.0.0),
    // it is recommended you also explicitly depend on Persistence Room's latest version for bug fixes and new features.
    implementation 'android.arch.persistence.room:runtime:x.x.x'
}

1. Put your SQLite DB database_name.db into the assets/databases folder
2. in your AppDatabase class, modify your Room's DB creation code accordingly:

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

• See samples in this project to show more

The Example are built using Android studio

• Open pull request with improvements
• Discuss ideas in issues
• Spread the word
• Reach out to me directly at [email protected]

The content of this project itself is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0)