CipherMigrateTest.java

package net.zetetic.tests;

import android.util.Log;
import net.sqlcipher.database.SQLiteDatabase;
import net.sqlcipher.database.SQLiteDatabaseHook;
import net.zetetic.QueryHelper;
import net.zetetic.ZeteticApplication;

import java.io.File;

public class CipherMigrateTest extends SQLCipherTest {

    File olderFormatDatabase = ZeteticApplication.getInstance().getDatabasePath("2x.db");

    @Override
    public boolean execute(SQLiteDatabase database) {
        database.close();
        final boolean[] status = {false};
        try {
            ZeteticApplication.getInstance().extractAssetToDatabaseDirectory("2x.db");
            SQLiteDatabaseHook hook = new SQLiteDatabaseHook() {
                public void preKey(SQLiteDatabase database) {}
                public void postKey(SQLiteDatabase database) {
                    String value = QueryHelper.singleValueFromQuery(database, "PRAGMA cipher_migrate");
                    setMessage(String.format("cipher_migrate result:%s", value));
                    status[0] = Integer.valueOf(value) == 0;
                }
            };
            database = SQLiteDatabase.openDatabase(olderFormatDatabase.getPath(),
                    ZeteticApplication.DATABASE_PASSWORD, null,
              SQLiteDatabase.OPEN_READWRITE | SQLiteDatabase.CREATE_IF_NECESSARY, hook);
            if(database != null){
                database.close();
            }
        } catch (Exception e) {
            Log.i(TAG, "error", e);
        }
        return status[0];
    }

    @Override
    public String getName() {
        return "Cipher Migrate Test";
    }
}