On Jun 2, 2009, at 10:17 AM, Jeff Schwab wrote:
> Jay Covington wrote:
>> Hello,
>>
>> I have a table called "Itemlist" and have multiple columns in it
>> such as
>> "item1", "item2", "item3", "item4". These columns often have
>> repetitious
>> data between them and I'm trying to count it. The only working code I
>> have so far is:
>>
>> statcount = Itemlist.count(:all, :condition => {:item1 => "Apple"})
>>
>> And this works fine for retrieving the count for "Apple" in all the
>> :item1 fields, but I need to retrieve the count for "Apple" from the
>> columns :item2, :item3, and :item4 as well as :item1. Any ideas?
>> Thanks!
>
> item_ids = 1..4
> apple_query = item_ids.map {|id| "item#{id} = 'Apple'" }.join(" OR ")
> apple_count = ItemList.count(:all, :conditions => apple_query)
Yuck! Can you change the schema? Granted, these names are lame, but
I'm guess that you have better information from which to confer better
ones:
ItemList
id: integer
list: string
ItemListItem
id: integer
item_list_id: integer
item: string
(and add an index on item_list_id)
class ItemList < ActiveRecord::Base
has_many :item_list_items
end
class ItemListItem < ActiveRecord::Base
belongs_to :item_list
end
statcount = ItemListItem.count(:conditions => { :item => 'Apple' })
Even if an ItemList *always* has 4 items, this is likely to save you
much time in the long run.
-Rob
Rob Biedenharn http://agileconsultingllc.com
r...@agileconsultingllc.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@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
