如何使用io.requery&Room在Android应用程序中执行PRAGMA语句

Question

我正在研究在我当前的Android应用程序上SqlitePRAGMA语句的性能改进。

我把这个代码作为RoomDatabase.CallbackonCreate函数

@Provides
@Singleton
fun providesRoomDatabaseCallback(@ApplicationContext appContext: Context): RoomDatabase.Callback {
return object : RoomDatabase.Callback() {
override fun onCreate(db: SupportSQLiteDatabase) {
super.onCreate(db)
db.execSQL("PRAGMA temp_store=2;")
db.execSQL("PRAGMA journal_mode=MEMORY")
db.execSQL("PRAGMA auto_vacuum=incremental;")
}
}
}

然而，当我的应用程序第一次启动时，我看到我的logcat崩溃:-

FATAL EXCEPTION: main
Process: com.my.app, PID: 30620
android.database.sqlite.SQLiteException: unknown error (code 0): Queries can be performed using SQLiteDatabase query or rawQuery methods only.
at io.requery.android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
at io.requery.android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:778)
at io.requery.android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:764)
at io.requery.android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:71)
at io.requery.android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1923)
at io.requery.android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1864)
at com.my.app.background.database.hilt.DatabaseModule$providesRoomDatabaseCallback$1.onCreate(DatabaseModule.kt:33)

有问题的PRAGMA语句是这个

db.execSQL("PRAGMA journal_mode=MEMORY")

如何在Android应用程序中配置sqlite journal_mode ?我错过了什么?

Answer 1

切换到query修复它

db.query("PRAGMA temp_store=2;")
db.query("PRAGMA journal_mode=memory;")
db.query("PRAGMA auto_vacuum=incremental;")