Accessing read/unread stats via another relationship about unread HOT 7 CLOSED

I ended up not eager loading the comments at all (as I don't actually use the objects). Instead I'm generating a statistics hash like this:

default_hash = Hash.new { |h, k| h[k] = { unread: 0, total: 0 } }
document.comments.with_read_marks_for(current_user).reduce(default_hash) do |hash, comment|
  hash[comment.value_id][:unread] += 1 if comment.unread?(current_user)
  hash[comment.value_id][:total] += 1
  hash
end

Results in one query at the start plus several (ultimately cached) queries on the read_marks table when there are no read_marks. Works pretty well.

from unread.

Using with_read_marks_for is the key. It uses just one query and make sure that the following unread? invocations use the result of the first query (see code).

Your solution looks fine.

from unread.

Thanks @ledermann, yep it's working great. Thanks for the help :)

from unread.

Just stumbled upon this. @brendon's solution was exactly what we were looking for.

It would be a great addition to the README (the whole example?), and explaining that subsequent unread?(user) doesn't do an additional query. 👍

A bit unnecessary to dig through the issues / finding it by chance :)

from unread.

Glad I was able to be of some help @Frexuz :) I'm sure @ledermann would appreciate a PR with the documentation enhancements if you had the time to do it. Would you be keen? :)

from unread.

Let me give it a go :) Then @ledermann can adjust

from unread.

PR here #98

from unread.