Hi All,

Here's my situation. People have Availability for Events. I need to ensure that 
each Person is Available for each Event exactly once.

I'm thinking the way to do it would be with a before_save method in 
Availability that does an

 Availability.find("event_id = ? and person_id = ?", record.event_id, 
record.person_id)

 and complains if it finds one.

Is this the way to go or is there a better approach?

**Leigh


=============

#Person.rb
class Person < ActiveRecord::Base
  has_many  :availabilities
  has_many  :events, :through => :availabilities
  default_scope  :order => 'name ASC'
  validates_presence_of :name, :on => :create, :message => "-- You need to 
enter your name"
end

#Availability.rb
class Availability < ActiveRecord::Base
  belongs_to  :event
  belongs_to  :person
  validates_presence_of :person_id, :on => :create, :message => "can't be blank"
  validates_presence_of :event_id, :on => :create, :message => "can't be blank"
end

#Event.rb
class Event < ActiveRecord::Base
  has_many  :availabilities
  has_many  :people, :through => :availabilities
  
  default_scope  :order => 'date ASC'
  validates_presence_of :name, :on => :create, :message => "can't be blank"
  validates_presence_of :date, :on => :create, :message => "can't be blank"
end

# Schema.rb
ActiveRecord::Schema.define(:version => 20110809224443) do
  create_table "availabilities", :force => true do |t|
    t.integer  "event_id"
    t.integer  "person_id"
    . . . 
  end

  create_table "events", :force => true do |t|
    t.string   "name"
    t.datetime "date"
    . . . 
  end

  create_table "people", :force => true do |t|
    t.string   "name"
    . . . 
  end
end



-- 
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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to