Room And sqlclipher

[Soulfloret]

After combining sqlcipher-android in the room database, the data update took effect. However, when restarting the app, the data returned to the original database db data, and the previously updated data was missing

[Soulfloret]

This issue occurs when fallbackToDestructiveMigration is enabled

[developernotes]

Hi @Soulfloret,

Can you provide a standalone reproduction that showcases the behavior you are seeing? We would be happy to look into this further.

[Soulfloret]

return Room.databaseBuilder(context, DataBase.class, DB_NAME)
.createFromFile(file)
.addCallback(new Callback() {
@OverRide
public void onOpen(@nonnull SupportSQLiteDatabase db) {
super.onOpen(db);
db.execSQL("PRAGMA synchronous= FULL;");
}
})
.openHelperFactory(new SupportOpenHelperFactory(("xingzhi321" + date).getBytes()))
.enableMultiInstanceInvalidation()
.setJournalMode(RoomDatabase.JournalMode.WRITE_AHEAD_LOGGING)
.fallbackToDestructiveMigration()
.build();

This is my calling method, and when using this method, database updates will only be generated at the current runtime. The next time it is reopened, the original database will be reloaded because the mechanism of room will clone a new piece of data instead of loading the already cloned data. We tried to remove the call 'sqlclip openHelperFactory', but it will take effect after adding it. Currently, when using this' sqlclip 'and' room ', we can also remove' fallbackToDestructiveMigration ', which can also take effect

[developernotes]

Hi @Soulfloret,

.openHelperFactory(new SupportOpenHelperFactory(("xingzhi321" + date).getBytes()))

You're passing a variable called date as part of the password material you feed to SupportOpenHelperFactory. Is date changing? Please consider sharing a sample standalone application which reproduces the behavior you are seeing on GitHub which we can clone and review.

[Soulfloret]

Hi @developernotes This is the method I used before discovering the problem, but after removing fallbackToDestructiveMigration, it runs normally

private static DataBase create(Context context) {
System.loadLibrary("sqlcipher");
Calendar calendar = Calendar.getInstance();
String date = calendar.get(Calendar.YEAR) + "" + (calendar.get(Calendar.MONTH) + 1) + calendar.get(Calendar.DAY_OF_MONTH);
File file = new File(SettingHelper.FileDirPath.DIR_SETTING.getPath() + DB_NAME);
File encrypteddatabaseFile = new File(SettingHelper.FileDirPath.DIR_SETTING.getPath() + ENCRYPTED_DB_NAME);
if (!file.exists() && !encrypteddatabaseFile.exists()) {
T.show("PASSWORD FILE NOT EXISTS" + file.getAbsolutePath());
return null;
} else {
File password = new File(SettingHelper.FileDirPath.DIR_SETTING.getPath() + "password.log");
if (!password.exists()) {
Commons.saveFile(password.getAbsolutePath(), date);
} else {
date = Commons.getFileByPath(password.getAbsolutePath());
}
if (!encrypteddatabaseFile.exists()) {
SQLiteDatabase sqLiteDatabase = SQLiteDatabase.openOrCreateDatabase(file.getAbsolutePath(), null);
//连接到加密后的数据库，并设置密码
sqLiteDatabase.rawExecSQL(
String.format(
"ATTACH DATABASE '%s' as " + ENCRYPTED_DB_NAME.split("\.")[0] + " KEY '" + "xxxxxx" + date + "';",
encrypteddatabaseFile.getAbsolutePath()
)
);
//输出要加密的数据库表和数据到加密后的数据库文件中
sqLiteDatabase.rawExecSQL("SELECT sqlcipher_export('" + ENCRYPTED_DB_NAME.split("\.")[0] + "');");
//断开同加密后的数据库的连接
sqLiteDatabase.rawExecSQL("DETACH DATABASE " + ENCRYPTED_DB_NAME.split("\.")[0] + ";");
SQLiteDatabase encrypteddatabase =
SQLiteDatabase.openOrCreateDatabase(encrypteddatabaseFile, "xxxxxx" + date, null, null, null);
encrypteddatabase.close(); //关闭数据库
sqLiteDatabase.close();
file.delete();
}
}
return Room.databaseBuilder(context, DataBase.class, DB_NAME)
.createFromFile(encrypteddatabaseFile)
.addCallback(new Callback() {
@OverRide
public void onOpen(@nonnull SupportSQLiteDatabase db) {
super.onOpen(db);
db.execSQL("PRAGMA synchronous= FULL;");
}
})
.enableMultiInstanceInvalidation()
.openHelperFactory(new SupportOpenHelperFactory(("xxxxxx" + date).getBytes()))
.setJournalMode(RoomDatabase.JournalMode.WRITE_AHEAD_LOGGING)
.fallbackToDestructiveMigration()
.build();
}

[developernotes]

Hi @Soulfloret,

As a follow-up, we would be happy to look into this if you can provide a standalone reproduction that is publicly available on GitHub that reproduces the behavior you are seeing. Please let us know if you are able to do so.