IIRC, you can iterate only one level in depth, so you might have a
structure like:
items.categories.each do |category|
category.users.each do |user|
# do something here
end
end
On Sep 10, 2007, at 5:13 PM, Cccc Bb wrote:
>
> Hi I have a site that has the following model declarations:
>
> User:
>
> has_and_belongs_to_many :categories
> has_and_belongs_to_many :sub_categories
>
> Item:
>
> has_and_belongs_to_many :sub_categories
> has_and_belongs_to_many :categories
>
> Category:
> has_many :sub_categories
> has_and_belongs_to_many :items
> has_and_belongs_to_many :users
>
> SubCategory:
> belongs_to :category
> has_and_belongs_to_many :items
> has_and_belongs_to_many :users
>
> So when a user registers they select a number of categories and if
> they
> want they can also select sub categories for more fine grained
> interests. When a new item is added to the site, part of the item
> registration process is to select the categories and sub-categories to
> which the item belongs.
>
>
> The bit that i would like advice/help/suggestions on is one a day i
> want
> to run a cron job to go through the items added that day and to
> find all
> the user-registered categories and sub-categories and find where they
> intersect with the items categories and sub-cats and then produce a
> user
> specific email telling that user about items they may be interested
> in.
>
> Basically is it possible to iterate through the list of items and
> write
> something like
>
> item.categories.users and get a list of the users who registered
> interest in this items categories?
>
>
>
> Am i asking too much here? Will i just have to write some big
> iterative
> function or is there an easier smarter approach?
>
> Any help gratefully received.
>
> best regards
> caspar
> --
> Posted via http://www.ruby-forum.com/.
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---