Defeered @Query with insert, update or delete throwing main thread exception. [123695593]

Fixed

Bug

Status Update

No update yet.

Description

da...@google.com

created issue #1

Jan 31, 2019 05:18PM

A dao method such as:

@Query("DELETE FROM book WHERE salesCnt = 0")
fun deleteUnsoldBooksSingle(): Single<Int>

will throw a main thread DB access exception if its called from the main thread since the sql compile / acquire invocation is done immediately while the actually execution of the query and data parsing is deferred.

Comments

yb...@google.com <yb...@google.com> #2Jan 31, 2019 05:22PM

Wondering is there any workaround currently?

da...@google.com <da...@google.com> #3Jan 31, 2019 10:49PM

Hi, thanks for trying Room KMP! The current alpha release indeed does not have support yet to use room-paging in a KMP project (in non-Android targets). We are working on having it available in upcoming releases and we'll update https://developer.android.com/kotlin/multiplatform/room#feature-differences shortly to mention this missing item.

ap...@google.com <ap...@google.com> #4Feb 8, 2019 10:31PM

You can use cashapp's multiplatform paging:

https://github.com/cashapp/multiplatform-paging

da...@google.com <da...@google.com> #5Feb 8, 2019 10:32PM

Marked as fixed.

#4 Sorry I don't get it. The key point is it couldn't generate the PagingSource from DAO, how do you connect with kmp-paging?

al...@gmail.com <al...@gmail.com> #6May 21, 2019 05:01AM

Any ETA on this?
It seems like paging-common is sufficient to make room happy on non-Android targets.
We've just ran into this issue and struggling to find a solution.

al...@gmail.com <al...@gmail.com> #7May 21, 2019 06:41AM

No concrete ETA but we do want to migrate the room-paging artifact to KMP before making the 2.7.0 release 'stable'.

Issue 123695593