Android database exporter

DatabaseExporter.kt

import android.content.Context
import android.util.Log
import java.io.File
import java.io.FileInputStream
import java.io.FileOutputStream

private val TAG = DatabaseExporter::class.java.simpleName

object DatabaseExporter {

    fun exportDatabase(context: Context, dbName: String) {

        val suffixes = listOf("", "-shm", "-wal")

        for (suffix in suffixes) {

            val targetFile = File(context.getExternalFilesDir(null), "export.db$suffix")
            val dbFile = context.getDatabasePath(dbName + suffix)


            if (dbFile.exists()) {
                val dest = FileOutputStream(targetFile).channel
                val src = FileInputStream(dbFile).channel

                dest.transferFrom(src, 0, src.size())
                src.close()
                dest.close()

                Log.d(TAG, "Exported from ${dbFile.absolutePath} to : ${targetFile.absolutePath}")

            } else {
                Log.d(TAG, "Cannot export file")
            }


        }

    }

}

Export database to public directory so that it could debugged

Beginning with Android 4.4 (API level 19), reading or writing files in your app's private external storage directory—accessed using getExternalFilesDir()—does not require the READ_EXTERNAL_STORAGE or WRITE_EXTERNAL_STORAGE permissions. So if your app supports Android 4.3 (API level 18) and lower, you should declare that the permission be requested only on the lower versions of Android by adding the maxSdkVersion attribute:

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"
                     android:maxSdkVersion="18" />