uniqueness_of on many columns

[Tom Allison]

Greetings!

I'm trying to set up a validation to ensure that a record is unique across three columns; col_one, col_two, col_three. 

tried this:
validates_uniqueness_of :col_one, :scope=>[:col_two, :col_three]

and it really doesn't work at all like I had hoped.
the docs says this should work

  class TeacherSchedule < ActiveRecord::Base
    validates_uniqueness_of :teacher_id, :scope => [:semester_id, :class_id]
  end


Just want to know if there are any experiences out there to share before I write my own validation code.

[Andrew Skegg]

Tom Allison <tom@...> writes:

>
>
> Greetings!I'm trying to set up a validation to ensure that a record is

unique across three columns; col_one, col_two, col_three.  tried
this:validates_uniqueness_of :col_one, :scope=>[:col_two, :col_three]and it

really doesn't work at all like I had hoped.the docs says this should work

class TeacherSchedule < ActiveRecord::Base
> validates_uniqueness_of :teacher_id, :scope => [:semester_id, :class_id]
> end
> Just want to know if there are any experiences out there to share before I
write my own validation code.
>

Composite keys are frowned upon. You might want to reconsider what you are
attempting and introduce a few models to handle the relationship.

Of course, you could always create a customer validator. See the rails API.

[Tom Allison]

Yeah, but in this case I'm just regurgitation someone else's data and I don't want to pick up duplicate records.

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

[Chirag Singhal]

Can you post your sample data here and if possible your model and controller code?

I have used it on several apps, and works just fine for me.