On Aug 10, 9:23 pm, Leigh Daniels <[email protected]> wrote: > >On Aug 10, 8:42 pm, Leigh Daniels <[email protected]> wrote: > >> 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? > > >I'd stick a unique index on that pair of columns too - it's the only > >way to get a cast iron guarantee for this sort of thing. > > Is this what you meant, Fred? > > add_index "availabilities", ["person_id", "event_id"], > :name => "person_id_event_id", :unique => true >
That's the one. Fred -- 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.
