René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"net.zetetic.database.sqlcipher.SQLiteConstraintException thrown if @Upsert is used","articleBody":"I have implemented the sqlcipher-android in this commit:\r\nhttps://github.com/PrimalHQ/primal-android-app/commit/4bc4482565e6c0941ca859faae21822e8a347d3d\r\n\r\nIf I run clean install build I'm getting:\r\n```\r\nnet.zetetic.database.sqlcipher.SQLiteConstraintException: UNIQUE constraint failed: ProfileData.ownerId (code 1555)\r\n\tat net.zetetic.database.sqlcipher.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)\r\n\tat net.zetetic.database.sqlcipher.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:815)\r\n\tat net.zetetic.database.sqlcipher.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:823)\r\n\tat net.zetetic.database.sqlcipher.SQLiteStatement.executeInsert(SQLiteStatement.java:113)\r\n\tat androidx.room.EntityInsertionAdapter.insert(EntityInsertionAdapter.kt:51)\r\n\tat androidx.room.EntityUpsertionAdapter.upsert(EntityUpsertionAdapter.kt:91)\r\n\tat net.primal.android.profile.db.ProfileDataDao_Impl.upsertAll(ProfileDataDao_Impl.java:165)\r\n\t.....\r\n```\r\n\r\nIt turns out that `@Upsert` is the cause of the crash. If we replace it with `@Insert(onConflict = OnConflictStrategy.REPLACE)` everything works fine. https://github.com/PrimalHQ/primal-android-app/commit/a46232a1f390f9d0418b4f6189d6ed1d1646d5dc\r\n","author":{"url":"https://github.com/AleksandarIlic","@type":"Person","name":"AleksandarIlic"},"datePublished":"2023-11-03T22:32:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/23/sqlcipher-android/issues/23"}