Finding data in Rails

rubyonrails-talk
1

Hi All,

I have 3 model, User, Post, Comment with definition like below

    class Post < ActiveRecord::Base       belongs_to :user       has_many :comments       def self.find_other_user_posts            ?       end     end     class User < ActiveRecord::Base       has_many :posts       has_many :comments       has_many :posts_commented_on, :through => :comments, :source => :posts     end     class Comment< ActiveRecord::Base       belongs_to :post       belongs_to :user     end

User can have many post and many comment, question is I want to make method in Post model that returning collection of posts. The method will find posts and comments that doesn't belong to current user. For example there are

Post: A have Comment: A1 Post: B have Comment: B1, B2, B3, B4 Post: C have Comment: C1, C2 Post: D have Comment: nil Post: E have Comment: nil Post: F have Comment: F1, F2, F3

current user own Post A, E and Comment A1, B2, so calling :

@posts = Post.find_other_user_posts

will return collection of C, D, F posts.

Thanks

2

If you want that to be a class method on Post you'll have to pass in the id of the user I think.

How about something like:

  def self.find_other_users_posts(this_user)     self.find(:all, :conditions => ["user_id <> ?", this_user.id])   end

HTH,

-Roy

3

My two cents would be to have a look at Searchlogic, It's my latest favorite and I find a use for it in every rails project I do...

http://github.com/binarylogic/searchlogic

4

Make it a named_scope instead of a function so that it can be chained in the future.

Class Post named_scope :other_users_posts, lambda { |user_object| {:conditions=> ["user_id <> ?", user_object.id]}} end

You can then do a Post.other_users_post(User.first) as an example and chain it just like other active record finder functions.

5

Ah, @Roy, sorry but the solution doesn't work. The question is to return C, D, F because current user doesn't own C, D, F, and current user doesn't make any comment on C, D, F. Actually there are 2 condition I want to achieve, I want to return collection of post that : 1. Other than my own post OR Haven't read it yet OR Post not created by me. 2. And Post that haven't got my Comment at all because if I'm already make a Comment on a Post then it assume that I'm already read the post before.

So what I want is a Post that is very very new to me and I want to read it and make Comment. How to do that ?

@Roy, wow I search and learn "searchlogic" and it's very very logic and super duper easy, thanks. @Mukund, hanks for named_scope suggestion I search the article and learn it and found out IT'S VERY COOL, especially the chain part. :slight_smile:

6

@heimdull, wow I search and learn "searchlogic" and it's very very logic and super duper easy, thanks. (sorry, mistype)