9
@Dao
interface ExampleDao {

    @Query("SELECT * FROM example_table WHERE id = :id")
    fun get(id: Int): LiveData<Example>

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insert(something: Example)
}

When I try to check if there's a certain row in the database using line below

val exists = dao.get(id).value != null
if (exists) {
    ...
}

exists variable always return null I know there's the row already in the database and UI shows the info correctly. Why it always return null and how do I check if there's the row or not in the room database?

goodonion
  • 1,401
  • 13
  • 25

1 Answers1

21

I would do it by making another query that returns true if the item exists or false if it doesn't.

@Query("SELECT EXISTS (SELECT 1 FROM example_table WHERE id = :id)")
fun exists(id: Int): Boolean

And call it like this so you don't need to check if it's null or not:

val exists = dao.exists(id)
Glenn Sandoval
  • 3,455
  • 1
  • 14
  • 22
  • How we can check on main thread ? because db related query we cannt hit on main thread. I have used coroutine for the same but very 1st time its not give me correct result 2nd time onwards working fine. – Menu Aug 26 '21 at 06:41
  • @Menu You could use coroutine for that purpose. move your code inside viewModelScope.launch{..} or any other scope – Syyam Noor Aug 06 '22 at 17:02