Arslan Mushtaq
02/23/2020, 7:21 PM@Query("SELECT * FROM cart_table")
fun getAllItemsFromCart(): LiveData<List<Cart>>
@Insert(onConflict = OnConflictStrategy.REPLACE)
suspend fun insert(cart: Cart)
@Query("DELETE FROM cart_table")
suspend fun deleteAllItemsFromCart()
@Delete
suspend fun deleteItemFromCart(cart: Cart)
@Query("SELECT COUNT(*) FROM cart_table")
suspend fun itemCount(): Int
@Query("SELECT SUM(total) FROM cart_table")
fun getGrandTotal(): LiveData<Double>
@Query("UPDATE cart_table SET quantity = quantity + 1 WHERE id = :id")
suspend fun increaseQuantity(id: Int)
@Query("UPDATE cart_table SET quantity = quantity - 1 WHERE id = :id")
suspend fun decreaseQuantity(id: Int)
Ahmed Ibrahim
02/23/2020, 7:30 PM@Query("SELECT SUM(total) FROM cart_table")
fun getGrandTotal(): LiveData<Double>
Once the cart_table gets updated the LiveData will emit a new grand total.Arslan Mushtaq
02/23/2020, 7:33 PMAhmed Ibrahim
02/23/2020, 7:39 PMArslan Mushtaq
02/23/2020, 7:41 PMgetGrandTotal()
in my Fragment. It works but when I try to call it from my adapter. It’s not updating the result.Ahmed Ibrahim
02/23/2020, 7:42 PMArslan Mushtaq
02/24/2020, 1:01 AM