如何使用Room和moshi with Kotlin持久化JSON对象及其内部的JSON数组

implementation "androidx.room:room-runtime:2.4.0"
kapt "androidx.room:room-compiler:2.4.0"
implementation "com.squareup.moshi:moshi:1.12.0"
implementation "com.squareup.moshi:moshi-kotlin:1.12.0"

data class MyData(
    @PrimaryKey val id: Int,
    val name: String,
    val jsonArray: List<JsonObject>
)

@Dao
interface MyDataDao {
    @Query("SELECT * FROM mydata")
    fun getAll(): List<MyData>

    @Insert
    fun insert(myData: MyData)

    @Delete
    fun delete(myData: MyData)
}

@Database(entities = [MyData::class], version = 1)
abstract class MyDatabase : RoomDatabase() {
    abstract fun myDataDao(): MyDataDao
}

object DatabaseProvider {
    private var instance: MyDatabase? = null

    fun getDatabase(context: Context): MyDatabase {
        if (instance == null) {
            instance = Room.databaseBuilder(
                context.applicationContext,
                MyDatabase::class.java,
                "my-database"
            ).build()
        }
        return instance!!
    }
}

class JsonArrayAdapter {
    @FromJson
    fun fromJson(jsonReader: JsonReader): List<JsonObject> {
        val jsonArray = JsonParser.parseReader(jsonReader).asJsonArray
        val list = mutableListOf<JsonObject>()
        for (jsonElement in jsonArray) {
            if (jsonElement.isJsonObject) {
                list.add(jsonElement.asJsonObject)
            }
        }
        return list
    }

    @ToJson
    fun toJson(jsonWriter: JsonWriter, jsonArray: List<JsonObject>) {
        jsonWriter.beginArray()
        for (jsonObject in jsonArray) {
            jsonWriter.jsonValue(jsonObject.toString())
        }
        jsonWriter.endArray()
    }
}

class JsonArrayAdapterFactory : JsonAdapter.Factory {
    override fun create(type: Type, annotations: Set<Annotation>, moshi: Moshi): JsonAdapter<*>? {
        if (Types.getRawType(type) == List::class.java && annotations.isEmpty()) {
            return JsonArrayAdapter().nullSafe()
        }
        return null
    }
}

val moshi = Moshi.Builder()
    .add(JsonArrayAdapterFactory())
    .build()

val myDataDao = DatabaseProvider.getDatabase(context).myDataDao()
val myData = MyData(1, "Example", listOf(JsonObject(), JsonObject()))
myDataDao.insert(myData)
val allData = myDataDao.getAll()