Need help with find

rubyonrails-talk
1

Kind of new at this and have been unable to find an example of what I want to do.

I have three models, people, clubs and members.

@members = @club.members.all --> finds all club members

How do I write a find of all people that are not members of @club

Thanks

2

Finally figured out something that worked.

@club = Club.find(params[:club_id]) ids = @club.members.connection.select_values('SELECT person_id FROM members') @people = Person.all(:order => 'name_sort',                                      :conditions => ["id NOT IN (?)", ids])

Any comments or better methods.

3

Kind of new at this and have been unable to find an example of what I want to do.

I have three models, people, clubs and members.

@members = @club.members.all --> finds all club members

How do I write a find of all people that are not members of @club

What are the relationships between the models (has_many, belongs_to and so on)?

Colin

4

Club has many Members Person has many Members Members belong to Club, Person

5

Club has many Members Person has many Members

That's novel. Possibly memberships would be a better name, or am I misunderstanding what this table is for?

Members belong to Club, Person

You seem to have snipped the original question. I will have to get it back from the earlier post.

Kind of new at this and have been unable to find an example of what I want to do.

I have three models, people, clubs and members.

@members = @club.members.all --> finds all club members

In fact you can just use @club.members to give you all the members of @club. Are you not more likely to want all the people that are members of the club though?

If you also say club has_many people through memberships then you can also @club.people to give you all the actual people.

How do I write a find of all people that are not members of @club

If you further have person has_many clubs through memberships then person.clubs will give you all his clubs and to get the people who are not members of @club you can do something like

person.find( :all, :include => :clubs, :conditions => ['club.id <> ?', @club.id] )

That might not be quite right, but something like that.