realworld-axum-sqlx

realworld-axum-sqlx copied to clipboard

Favoriting an article causes all articles to show as favorited: true.

Hi! I'm tinkering around with my own frontend implementation and I grabbed this repo to use as a local backend to run requests against. So I know that this repo hasn't been touched in a while, I question if I should even open this issue..

Seems to be solved by changing:

exists(select 1 from article_favorite where user_id = $1) "favorited!",

to:

exists(select 1 from article_favorite where user_id = $1 and article_id = article.article_id) "favorited!",

But it might be wrong, I'm not a backend dev. Thanks for your work and the very educational repo.