can Countable support relation or condition ?

[gabrieltong]

trafficstars

Countable is easy to use , but It doesn't work in my case .

post has two state : active or inactive
user can has three relation to post : all post , active posts and inactive posts, 
and I want to cache all three count

thanks

[gabrieltong]

I checked the code, it's not based on eloquent relation, but db sql, why do we use relation ? so there's no condition problem, I can put the condition in relation .

[kirkbushell]

The reason is because the SQL statement helps to avoid race condition issues where 2 requests may be executed at the same time, resulting in an incorrect count on the related table. If you're fetching an object, and then making a change and doing the update that way, you will get incorrect counts over time.

That said, I think we could also do an update() call against the relation, that could work. I think this deserves some more thought, thanks for the heads up!

[divdax]

I also need to apply a condition for counting related rows. e.g. User (posts_count) - Post where active = 1.

[jaulz]

@kirkbushell is this still somewhere on the roadmap? would you accept a PR?

[kirkbushell]

@jaulz I would.