IssueTracker

+1, but Deferred does not solve the Observer problem that Rx and LiveData do, so I guess Google should implement Channels instead of LiveData which is actually a Kotlin Coroutine counterpart. Looking forward to this as I've decided not to use RxJava in most of future projects due to Kotlin Coroutines..

Project: platform/frameworks/support
Branch: androidx-master-dev

commit e78cceffeac28f0028342990c1391c640edf453c
Author: Daniel Santiago Rivera <danysantiago@google.com>
Date:   Wed Nov 28 12:40:24 2018

    Room Support for Coroutines
   
    This change allows users to define suspend functions in DAOs with
    @Query, @Insert, @Update and @Delete. The new artifact room-coroutine
    defines a helper classes for supporting the feature.
   
    Bug: 69474692
    Test: ./gradlew room:integration-tests:kotlintestapp:cC
    Change-Id: Id73a6b845df3f21f99d14cb6980130dcf3885c81

M       buildSrc/src/main/kotlin/androidx/build/PublishDocsRules.kt
A       room/compiler/src/main/kotlin/androidx/room/ext/KotlinMetadataElement.kt
D       room/compiler/src/main/kotlin/androidx/room/ext/KotlinMetadataProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/ext/element_ext.kt
M       room/compiler/src/main/kotlin/androidx/room/ext/javapoet_ext.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/DeletionMethodProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/InsertionMethodProcessor.kt
A       room/compiler/src/main/kotlin/androidx/room/processor/MethodProcessorDelegate.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/PojoProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/ProcessorErrors.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/QueryMethodProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/RawQueryMethodProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/ShortcutMethodProcessor.kt
M       room/compiler/src/main/kotlin/androidx/room/processor/UpdateMethodProcessor.kt
A       room/compiler/src/main/kotlin/androidx/room/solver/query/result/CoroutineResultBinder.kt
M       room/compiler/src/main/kotlin/androidx/room/solver/query/result/PojoRowAdapter.kt
A       room/compiler/src/main/kotlin/androidx/room/solver/shortcut/binder/CoroutineDeleteOrUpdateMethodBinder.kt
A       room/compiler/src/main/kotlin/androidx/room/solver/shortcut/binder/CoroutineInsertMethodBinder.kt
M       room/compiler/src/main/kotlin/androidx/room/solver/shortcut/result/DeleteOrUpdateMethodAdapter.kt
M       room/compiler/src/main/kotlin/androidx/room/solver/shortcut/result/InsertMethodAdapter.kt
M       room/compiler/src/main/kotlin/androidx/room/vo/RelationCollector.kt
M       room/compiler/src/test/kotlin/androidx/room/processor/QueryMethodProcessorTest.kt
A       room/coroutines/build.gradle
A       room/coroutines/src/main/AndroidManifest.xml
A       room/coroutines/src/main/java/androidx/room/CoroutinesRoom.kt
M       room/integration-tests/kotlintestapp/build.gradle
M       room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/dao/BooksDao.kt
M       room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/BooksDaoTest.kt
A       room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/SuspendRoomDispatcherTest.kt
M       settings.gradle

https://android-review.googlesource.com/833705
https://goto.google.com/android-sha1/e78cceffeac28f0028342990c1391c640edf453c

So do you support any Coroutine "observables" like channels? Or these are just one-off suspending calls?

For now we'll be just supporting one-off suspend functions in Room 2.1.0-alpha03. Coroutines stream functionality with channels is still a work in progress.

Relating to the original request, how about allowing a return type of Deferred<LiveData<T>> which suspends until LiveData<T>'s value has been set the first time?

I just tested out Room 2.1.0-alpha03 and added suspend to all of my functions.... there appears to be an issue with functions that use @Query() and UPDATE and DELETE queries.  Examples:

Code Example 1:
    @Query("DELETE FROM individual")
    suspend fun deleteAll()
Error:
    Deletion methods must either return void or return int (the number of deleted rows).

Code Example 2:
    @Query("UPDATE individual SET firstName = :firstName WHERE id = :id")
    suspend fun updateFirstName(id: Long, firstName: String)
Error:
    Not sure how to convert a Cursor to this method's return type (kotlin.Unit).

Async return types with @Query that perform UPDATE, DELETE or INSERT are not yet supported. This also applies to coroutines. We are actively working on adding this for the next alpha of 2.1.0. Subscribe to the bug for updates: https://issuetracker.google.com/issues/120227284

Hello.
Any updates on returning Channel<T> from DAO?
Will contributions be accepted for that feature?

Channels are experimental right now so we probably want to wait until it is stable.

Channels +1

Marking as fix since core coroutines are supported in 2.1, in the mean time we'll keep an eye on the Channels API to potentially support it once its upgraded out of experimental. https://issuetracker.google.com/issues/127328278

Is it expected that we still have to ensure that suspended functions aren't dispatched from the main thread?
The first call (eg `final SupportSQLiteStatement _stmt = __preparedStmtOfDeleteAll.acquire();`) is not wrapped in a callable and can't be done on the ui thread, so we still have to wrap suspensions with our own context.

Kotlinx.coroutines 1.2 released with cold stream abstraction Flow:
https://kotlin.github.io/kotlinx.coroutines/kotlinx-coroutines-core/kotlinx.coroutines.flow/-flow/index.html

It's in "preview" status, but maybe we also could expect some experimental version of Room with Flow support for observable requests

Why the LiveData been blocked? the query always waiting for the insert end and return

Project: platform/frameworks/support
Branch: androidx-master-dev

commit 41bbdfb46058e7ef3ea6aa21ac8d7a3c7642fa1d
Author: Yuichi Araki <yaraki@google.com>
Date:   Wed May 23 17:38:58 2018

    Multi-instance invalidation
   
    Developers can now sync observers for InvalidationTracker and LiveData
    between multiple RoomDatabase instances by
    RoomDatabase.Builder.enableMultiInstanceInvalidation(). This can also be
    used for database instances in other processes. All the instances have
    to be using the same database file.
   
    When multi-instance invalidation is turned on, all the tables are
    observed by an instance of MultiInstanceInvalidationClient, and
    invalidation detected in one instance is broadcast to other instances by
    remote procedure call.
   
    Test: MultiInstanceInvalidationTest
    Bug: 62334005
    Bug: 80464228
    Change-Id: I76033c5ac543ddaef735be06f828b7d7d607883a

M       room/integration-tests/testapp/build.gradle
A       room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/test/MultiInstanceInvalidationTest.java
M       room/integration-tests/testapp/src/main/AndroidManifest.xml
A       room/integration-tests/testapp/src/main/aidl/androidx/room/integration/testapp/ISampleDatabaseService.aidl
A       room/integration-tests/testapp/src/main/java/androidx/room/integration/testapp/SampleDatabaseService.java
M       room/integration-tests/testapp/src/main/java/androidx/room/integration/testapp/database/CustomerDao.java
A       room/integration-tests/testapp/src/main/java/androidx/room/integration/testapp/database/Product.java
A       room/integration-tests/testapp/src/main/java/androidx/room/integration/testapp/database/ProductDao.java
M       room/integration-tests/testapp/src/main/java/androidx/room/integration/testapp/database/SampleDatabase.java
M       room/runtime/api/current.txt
M       room/runtime/src/main/AndroidManifest.xml
A       room/runtime/src/main/aidl/androidx/room/IMultiInstanceInvalidationCallback.aidl
A       room/runtime/src/main/aidl/androidx/room/IMultiInstanceInvalidationService.aidl
M       room/runtime/src/main/java/androidx/room/DatabaseConfiguration.java
M       room/runtime/src/main/java/androidx/room/InvalidationTracker.java
A       room/runtime/src/main/java/androidx/room/MultiInstanceInvalidationClient.java
A       room/runtime/src/main/java/androidx/room/MultiInstanceInvalidationService.java
M       room/runtime/src/main/java/androidx/room/RoomDatabase.java
M       room/testing/src/main/java/androidx/room/testing/MigrationTestHelper.java

https://android-review.googlesource.com/720919
https://goto.google.com/android-sha1/41bbdfb46058e7ef3ea6aa21ac8d7a3c7642fa1d