Support async return types with @Query with INSERT/UPDATE/DELETE statements. [120227284]

Fixed

Feature Request

Status Update

No update yet.

Description

da...@google.com

created issue #1

Nov 29, 2018 09:24PM

Shortcut method support async types"

@Insert
fun addBook(book: Book) : Completable

we should expand this support for prepared queries:

@Query("INSERT INTO BOOK (id, name) VALUES (1, 'A Song of Ice and Fire')")
fun addAwesomeBook() : Completable

Comments

da...@google.com <da...@google.com> Nov 29, 2018 09:24PM

Accepted by da...@google.com.

da...@google.com <da...@google.com> #2Dec 10, 2018 09:31PM

Marked as fixed.

Is there any updates? This is a big problem!

ph...@gmail.com <ph...@gmail.com> #3Jan 31, 2019 04:52AM

Hi there - could you provide more context on the issue & a sample project to reproduce? Database locked exceptions are quite difficult to pinpoint without a repro project. Thanks!

da...@google.com <da...@google.com> #4Jan 31, 2019 05:21PM

Hi. It is reproduceable on some users by using this code:

suspend fun <R> MyDatabase.workaroundWithTransaction(block: suspend TransactionScope<R>.() -> R) {
    useWriterConnection {
        it.immediateTransaction(block)
    }

    // TODO: Temporally fix https://issuetracker.google.com/issues/340606803#comment2
    // Manually triggers invalidation
    invalidationTracker.refreshAsync()
}

cm...@gmail.com <cm...@gmail.com> #5Feb 7, 2019 12:46PM

Maybe it is about this? https://android-review.googlesource.com/c/platform/frameworks/support/+/3114928

I am not sure.

Issue 120227284