How to view the tables of Room Database in sqlite DB browser?

Question

I am using RoomDB in my sample app.i am able to perform CRUD operation on DB. but i am not able to view db file.i want to view table structure in sqlite DB browser.

this is my APPDatabase class

 @Database(entities = {User.class}, version = 1,exportSchema = false)

public abstract class AppDatabase extends RoomDatabase {

    private static AppDatabase INSTANCE;  
    public abstract UserDao userDao();        
    public static AppDatabase getAppDatabase(Context context) {
        if (INSTANCE == null) {
            INSTANCE =
                    Room.databaseBuilder(context.getApplicationContext(), AppDatabase.class, "user-database")                                
                            .allowMainThreadQueries()
                            .build();
        }
        return INSTANCE;
    }    
    public static void destroyInstance() {
        INSTANCE = null;
    }
}

help me to get DB file.

See this? https://stackoverflow.com/questions/44429372/view-contents-of-database-created-with-room-persistence-library — OneCricketeer, Feb 21 '18 at 07:12
@pskink yes it is giving the path like this /data/data/com.example.manvish.roomdb/databases/user.db but there is no folder called data in memory..is it possible to change the path — Gaju Kollur, Feb 21 '18 at 09:47
so does `adb shell` work or not? what do you see when you run `adb shell` on your terminal window? — pskink, Feb 21 '18 at 10:33
@pskink adb shell works.. i am able to access other files but not data folder — Gaju Kollur, Feb 21 '18 at 10:34
@pskink yes cd data will change the directory but after that for evry operation i will get error as permission denies ..even ls also not able to list the files inside that folder.. — Gaju Kollur, Feb 21 '18 at 10:39
@pskink ls -ld /data giving output like drwxrwx--x system system 2018-02-21 10:14 data — Gaju Kollur, Feb 21 '18 at 10:46
I have a problem like this , please check [https://stackoverflow.com/questions/56628647/android-room-database-file-is-invalid-file-format-in-db-browser](this) — milad salimi, Jun 17 '19 at 10:01

hjchin · Answer 1 · 2018-07-07T16:48:27.673

This is how I have done it. In Android Studio 3.1,

Access to View>Tool Windows>Device File Explorer.
Navigate to folder /data/data/<your package>/databases
Save your database file which ended with .db

If you can't see your database file, consider to copy the file with following code

fun exportDB(context: Context){
        try {
            val sd = Environment.getExternalStorageDirectory()

            if (sd.canWrite()) {
                val backupDBPath = "database.db"
                val currentDB = context.getDatabasePath("database.db")
                val backupDB = File(sd, backupDBPath)

                val src = FileInputStream(currentDB).getChannel()
                val dst = FileOutputStream(backupDB).getChannel()
                dst.transferFrom(src, 0, src.size())
                src.close()
                dst.close()
                Log.i("database","export database done. Original path: $currentDB")
            }else{
                Log.i("database","cannot write database")
            }
        } catch (e: Exception) {
            Log.e("database","export database failed. "+e.message)
        }
    }

UPDATE: the db file is empty, and u need .db-shm and .db-wal to open .db file.

How to view the tables of Room Database in sqlite DB browser?

1 Answers1