I have this query ```updateLike: UPDATE NewsEntity SET likesCount = likesCount + :likesDelta , isLik...

# squarelibraries

[Vaibhav Jaiswal]

I have this query

updateLike:
UPDATE NewsEntity
SET likesCount = likesCount + :likesDelta , isLiked = :isLiked
WHERE id = :id;

This is how I have defined my columns

likesCount INTEGER NOT NULL,
isLiked INTEGER AS Boolean NOT NULL,

and I am observing it from db like

fun observeById(id: String) = queries.findById(id).asFlow().mapToOneNotNull(Dispatchers.IO)

But i get the updated isLiked only, likesCount is still the old one