I'm pulling some data from an external API and would like to cache the results locally. I have a class SearchTerm
, which I would like to be associated with a few different ActiveRecord types through the table searchable_items
. I'm pretty sure I have the tables set up correctly, but something in my associations must be wrong.
class Foo < ActiveRecord::Base
has_many :search_terms, :as => :searchable, :through => :searchable_items
end
class Bar < ActiveRecord::Base
has_many :search_terms, :as => :searchable, :through => :searchable_items
end
class SearchTerm < ActiveRecord::Base
has_many :searchables, :through => :searchable_items
end
class SearchableItem < ActiveRecord::Base
belongs_to :search_term
belongs_to :searchable, :polymorphic => true
end
I would expect to be able to do something like SearchTerm.find_by_term('SearchTerm').searchables
(and it would return an array of Foo and Bar objects) however, I get the error
Could not find the association :searchable_items in model SearchTerm
Thanks in advance for any insight you can provide to me!