How to copy database from assets folder in android using kotlin

We can copy database from assets folde by

class CopyAssetDatabaseOpenHelper(private val context: Context) {

companion object {

    private val DB_NAME = "dbName.db"
}

fun openDatabase(): SQLiteDatabase {
    val dbFile = context.getDatabasePath(DB_NAME)


    if (!dbFile.exists()) {
        try {
           val checkDB = context.openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE,null)

            checkDB?.close()
            copyDatabase(dbFile)
        } catch (e: IOException) {
            throw RuntimeException("Error creating source database", e)
        }

    }
    return SQLiteDatabase.openDatabase(dbFile.path, null, SQLiteDatabase.OPEN_READWRITE)
}


private fun copyDatabase(context:Context) {
            val dbFile = context.getDatabasePath("logicaldb")
            val assetdb = context.assets.open("logicaldb")
            val currentDB = FileOutputStream(dbFile)

            val buffer = ByteArray(1024)
            while (assetdb.read(buffer) > 0) {
                currentDB.write(buffer)
                Log.d("#DB", "Copying "+buffer.toString())
            }

            currentDB.flush()
            currentDB.close()
            assetdb.close()

        }
    }

 

What is Application?

How to check Android version?

Extract Date and Time from Long Type Variable - RRutors

What is Android?

What is "shared preferences" in Android ?

Permission denied for window type 2010 in Marshmallow device

Symmetric vs Asymmetric Encryption in Android Server - RRutors

What is Intent? What is the difference between an implicit intent and an explicit intent?

How do i load image from drawable folder in Jetpack Compose?

How to convert milli seconds to hours, minutes and seconds in Android? 

ERR_ACCESS_DENIED in Android Webview with sdk 30

How to find Android Device UDID or unique ID?

How do I check in SQLite whether a table exists?

Fix Duplicate Files in APK Build.gradle Issue - RRutors

What is Context?

How to save activity State in Android?

How to convert DP to Pixel and Pixel to Dp?

INSTALL_FAILED_INVALID_APK: Split lib_slice_9_apk was defined multiple times. It is possible that th

Add Jar/Library Files as Dependency in Android Studio

FragmentPagerAdapter deprecated, Since API 27.1.0 FragmentPagerAdapter is deprecated.

Check List for Generate Signed APK Android

Hide/Disable soft keyboard on Activity launch: Android

Invoke-customs are only supported starting with android 0 --min-api 26

FCM Not Receiving Notifications in Android - RRutors

How to get complete address from latitude and longitude?

How to install/ uninstall apk by command line ADB

How can i comment inside xml file in android studio?

How to get a contact image using a phone number in android?

Fix Play Store Rejection Due to SMS Permission - RRutors

Fix Behavior Subclass BottomSheetBehavior Exception - RRutors

What is the Different Between val and var in Kotlin?

How to start a new activity on button click

Explain Fragment Life Cycle

Emulator: emulator: ERROR: Can't find 'Linux version ' string in kernel image file: Andr

Android Studio project R can't find

How to Generate signed apk with android studio

Fix Error: Use JsonReader.setLenient(true) for Malformed JSON

Set Activity to Fullscreen Mode in Android - RRutors

What is the difference between match_parent and fill_parent?

How to stop EditText  focus at Activity startup in Android?

Projects By category