sqlbrite | lightweight wrapper around SQLiteOpenHelper | Reactive Programming library

this is a bug in SQLDelight. here is the github issue for it: https://github.com/cashapp/sqldelight/issues/1325

I am not very familiar with SQLBrite but createQuery supposed to be keep notifying database changes. If you want to get value just once then you can use take() operator.

There are many ways to achieve what you want. You have not provided much context, so I will assume the following as an example:

• you have some Invoices stored in the database
• you have some method that fetches those from DB and returns the results as List

The example is for Kotlin, would be pretty similar in Java though.

So here is your DB fetch method:

1. First thing you need to use a recycler view for list of views. and ofcoarse you can use 100 different types of views with ViewTypes of recycler view
2. Second if you insist not to use recycler view then you may better use AsyncTask for adding views at least. Because in some methods of AsyncTask you can access the UI thread and can add elements.
3. Third possibility is with event bus. you will add a method to the fragment/activity and register it with event bus. make it run in background from the tag(java tags). and call it from background thread for adding items(views)

Hope some of it solve your problem :) if not get back to me with more explanation of the question.

P.S EventBus is a library work almost the same as BroadcastReceivers but it has more features and its more efficient as well.

As hinted by @BobDalgleish , the OnComplete was being called before the toList instead of after ZipWith .Now i have made the following changes , and i get as complete list from db. I have used concatMap for preserving the order and wait for complettion.

If RxUtils.applySchedulers is applying the following then at the point you go through the mapping operation and subsequently hit service.downloadFileByUrl this will be executed on the main thread.

Returning an empty list in Single doesn't make the Single empty, thus first will correctly stop at the first item, the empty list, never calling the remote source. You have to decide on the item via flatMap whether or not to resume with the remote source instead of concat:

Your problem is that when setUp runs the second time, DataRepository.getInstance returns the old data repository, meaning it does not create a new SQLiteOpenHelper. When you delete the database you also need to clean up your singletons for DataRepository and MyDbHelper.

Alternatively dont use singletons at all:

The results of a single query execution never change and represent a snapshot. To get more messages, you have to re-execute the query, i.e., call createQuery again.