Search code examples
javaandroidsqliteloggingdata-integrity

Android: SQLite: If isDatabaseIntegrityOK() returns false


if SQLiteDatabase.isDatabaseIntegrityOK() returns false, how do i get access to the 1-100 lines of logs the database is supposed to return?

I want to display the results of the integrity check in my Android app.

Thanks!


Solution

  • Just execute the command yourself, and pretend that it's a SELECT:

    Cursor cursor = db.rawQuery("PRAGMA integrity_check", null);
    while (cursor.moveToNext()) {
        String s = cursor.getString(0);
        ...
    }