movie model

class Movie < ActiveRecord::Base
  attr_accessible :name, :year, :rating, :watched, :imdb_id

  has_many :relationships
  has_many :people, :through => :relationships
  has_many :roles, :through => :relationships

  scope :is_acting, lambda { acting }
  scope :is_directing, lambda { directing }

  private

    def self.acting
      where(['relationships.role = ?', "actor"])
    end

    def self.directing
      where(['relationships.role = ?', "director"])
    end
end