Room SQLCipher PRAGMA keyの記述方法がわからない

Question

Roomで動的に生成したクエリ(SQL文)を扱う方法 - Qiita@RawQueryを使用すると実装でｓきそうですが、実際に、PRAGMA keyを指定したい場合の記述方法がわからず、質問させて頂きました。不躾なご質問で恐縮ですが、よろしくお願いします。

ViewModelは以下です。

class RequestDocumentsViewModel(application: Application): AndroidViewModel(application) {

    private val requestDocumentsPersonInfoDao: RequestDocumentsPersonInfoDao
    

    init {
        val query = SimpleSQLiteQuery("PRAGMA key = 'passphrase'")
        val db = RequestDocumentsPersonInfoDatabase.buildDatabase(application)
        requestDocumentsPersonInfoDao = db.requestDocumentsPersonInfoDao()
        

    }

    val personData = requestDocumentsPersonInfoDao.loadAllRequestDocumentsPersonInfo()
    val personDataAll = requestDocumentsPersonInfoDao.loadAllRequestDocumentsPersonInfoLiveData()



    fun insert(name: String, phoneticGuides: String, birthday: String, mailAddress: String, phoneNumber: String) {
        viewModelScope.launch(Dispatchers.IO) {
            requestDocumentsPersonInfoDao.saveRequestDocumentsPersonInfo(
                RequestDocumentsPersonInfo(
                    id = 0,
                    name = name,
                    phoneticGuides = phoneticGuides,
                    birthday = birthday,
                    mailAddress = mailAddress,
                    phoneNumber = phoneNumber,
                    zipStr = "",
                    prefecture = "",
                    city = "",
                    address = "",
                    disableCertifidate = "",
                    sendingMaterials = "",
                    remarks = ""
                )
            )
        }
    }

    fun updateAddress(zipStr: String, prefecture: String, city: String, address: String) {
        viewModelScope.launch (Dispatchers.IO) {
            val editPersonInfo = personData.first()
            editPersonInfo.zipStr = zipStr
            editPersonInfo.prefecture = prefecture
            editPersonInfo.city = city
            editPersonInfo.address = address
            requestDocumentsPersonInfoDao.updateRequestDocumentsPersonInfo(editPersonInfo)
        }
    }

    fun updateParam(disableCertificate: String, sendingMaterials: String, remarks: String) {
        viewModelScope.launch (Dispatchers.IO) {
            val editPersonInfo = personData.first()
            editPersonInfo.disableCertifidate = disableCertificate
            editPersonInfo.sendingMaterials = sendingMaterials
            editPersonInfo.remarks = remarks
        }
    }

}

Entityは以下です。

import androidx.room.ColumnInfo
import androidx.room.Entity
import androidx.room.PrimaryKey

@Entity(tableName = "request_documents_person_info")
data class RequestDocumentsPersonInfo (
    @PrimaryKey(autoGenerate = true)
    @ColumnInfo(name = "id")
    val id: Int,
    @ColumnInfo(name = "name")
    val name : String,
    @ColumnInfo(name="phoneticGuides")
    val phoneticGuides: String,
    @ColumnInfo(name="birthday")
    val birthday: String,
    @ColumnInfo(name="zipStr")
    var zipStr: String,
    @ColumnInfo(name="prefecture")
    var prefecture: String,
    @ColumnInfo(name="city")
    var city: String,
    @ColumnInfo(name="address")
    var address :String,
    @ColumnInfo(name="phoneNumber")
    val phoneNumber: String,
    @ColumnInfo(name="mailAddress")
    val mailAddress: String,
    @ColumnInfo(name="disableCertificate")
    var disableCertifidate: String,
    @ColumnInfo(name="sendingMaterials")
    var sendingMaterials : String,
    @ColumnInfo(name="remarks")
    var remarks: String
)

Daoクラスが以下です。

import androidx.lifecycle.LiveData
import androidx.room.*

@Dao
interface RequestDocumentsPersonInfoDao {


    // データ取得メソッド
    @Query("SELECT * FROM request_documents_person_info")
    fun loadAllRequestDocumentsPersonInfo(): List<RequestDocumentsPersonInfo>

    @Query("SELECT * FROM request_documents_person_info")
    fun loadAllRequestDocumentsPersonInfoLiveData(): LiveData<List<RequestDocumentsPersonInfo>>

    // 挿入メソッド
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun saveRequestDocumentsPersonInfo(vararg requestDocumentsPersonInfo: RequestDocumentsPersonInfo)

    // 更新メソッド
    @Update(onConflict = OnConflictStrategy.REPLACE)
    fun updateRequestDocumentsPersonInfo(requestDocumentsPersonInfo: RequestDocumentsPersonInfo)

    // 削除メソッド
    @Delete
    fun deleteRequestDocumentsPersonInfo(requestDocumentsPersonInfo: RequestDocumentsPersonInfo)

}

Databaseクラスが以下です。

import android.content.Context
import androidx.room.Database
import androidx.room.Room
import androidx.room.RoomDatabase
import net.sqlcipher.database.SQLiteDatabase
import net.sqlcipher.database.SupportFactory

@Database(entities = [RequestDocumentsPersonInfo::class], version = 2, exportSchema = false)
abstract class RequestDocumentsPersonInfoDatabase : RoomDatabase(){
    abstract fun requestDocumentsPersonInfoDao(): RequestDocumentsPersonInfoDao

    companion object {
        fun buildDatabase(context: Context): RequestDocumentsPersonInfoDatabase {
            return Room.databaseBuilder(
                context,
                RequestDocumentsPersonInfoDatabase::class.java,
                "request_documents_person_info.db"
            ).openHelperFactory(SupportFactory(SQLiteDatabase.getBytes("PassPhrase".toCharArray())))
                .build()
        }
    }
}

Answer 1

PRAGMA Keyを使わなくても、Activity側で

val list = requestDocumentsViewModel.personData

とすることでレコードが取得でき、

list.count()

とすることで、レコードの件数も取得できました。