Query multiple Rails models

Question

I am needing to create a gallery containing entries from two different models/tables, let's say "video" and "image". What is the best way to handle this? I would like to keep them in different tables, but retrieve them together (the most recent 50 images and videos, for example). Single Table Inheritance doesn't seem to fit. Any ideas?

Ron · Accepted Answer · 2012-05-15 18:35:09Z

1

Polymorphism is your friend.

class Video
  belongs_to :viewable, :polymorphic => true
end

class Image
  belongs_to :viewable, :polymorphic => true
end

class Gallery
  has_many :media, :as => :viewable
end

answered May 15, 2012 at 18:35

Ron

1,1665 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marlin Pierce · Accepted Answer · 2012-05-15 18:34:54Z

0

The best way I have been able to figure is to have a table of all the displays with polymorphic references to the other tables.

class Gallery
  has_many :displays
end

class Display
  belongs_to :gallery
  belongs_to :derived_display, :polymorphic => true
end

class Video
  has_one :display, :as => :derived_display
end

answered May 15, 2012 at 18:34

Marlin Pierce

10.1k5 gold badges33 silver badges56 bronze badges

Collectives™ on Stack Overflow

Query multiple Rails models

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related