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()

        }
    }

 

How to save activity State in Android?

Android Studio project R can't find

Permission denied for window type 2010 in Marshmallow device

How do I check in SQLite whether a table exists?

How to start a new activity on button click

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

What are the notifications available in android?

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

What is ANR? How to avoid and resolve it?

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

How can i comment inside xml file in android studio?

What is Context?

Symmetric vs Asymmetric Encryption in Android Server - RRutors

What are Android Versions available?

How to reduce APK package size?

How to find Android Device UDID or unique ID?

How to Use Deprecated Handler() in Android - RRutors Guide

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

Extract Date and Time from Long Type Variable - RRutors

What is Android Fragments?

FCM Not Receiving Notifications in Android - RRutors

How do I generate random numbers in Dart?

How to stop EditText  focus at Activity startup in Android?

Add Jar/Library Files as Dependency in Android Studio

How to get complete address from latitude and longitude?

What is NetworkOnMainThread Exception?

How to Generate signed apk with android studio

What is "shared preferences" in Android ?

Fix Duplicate Files in APK Build.gradle Issue - RRutors

Check List for Generate Signed APK Android

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

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

Set Activity to Fullscreen Mode in Android - RRutors

What is the Different Between val and var in Kotlin?

How To Set Text Color Programmatically Android TextView?

What is ANR in android?

Fix Android Emulator Kill Error When Running Your App

Decompile APK Files: How to Get Source Code - RRutors Guide

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

How to validate email address in Android with Kotlin?

Projects By category