datamapper multi-field unique index

Question

In Datamapper, how would one specify the the combination of two fields must be unique. For example categories must have unique names within a domain:

class Category
  include DataMapper.resource
  property :name, String, :index=>true #must be unique for a given domain

  belongs_to :domain
end

Somewhere I saw mentioned that named keys will group like this. ie :unique_index=>:name for both name and domain. — John F. Miller, Sep 03 '09 at 18:52

score 16 · Answer 1 · answered Jan 05 '10 at 01:16

16

You have to create a unique index for the two properties:

class Category
  include DataMapper::Resource

  property :name, String, :unique_index => :u
  property :domain_id, Integer, :unique_index => :u

  belongs_to :domain
end

answered Jan 05 '10 at 01:16

joschi

11,459
4
40
47

This is incorrect as it will require that both name and domain be unique across the table. What I asked was how to make the set (:name, :domain) unique. – John F. Miller Mar 24 '10 at 00:06
Indeed, although the `:u` symbol could have been clearer -- for example `:index_on_name_and_domain_id` -- it actually is correct. See the section Indices on the DataMapper property documentation page: http://rubydoc.info/github/datamapper/dm-core/master/DataMapper/Property. The statements create a multi-column composite unique index. – Jochem Schulenklopper Feb 18 '13 at 20:06

score 2 · Answer 2 · answered Apr 13 '12 at 00:10

2

Actually, John, Joschi's answer is correct: the use of named :unique_index values does create a multiple-column index; it's important to read the right-hand side of those hash-rockets (i.e., if it had just been true, you would be right).

answered Apr 13 '12 at 00:10

cobbr2

111
1
2

I've moved away from DataMapper so this may have changed, but at the time I wrote the comment, it was correct. – John F. Miller Apr 13 '12 at 04:58

score 1 · Accepted Answer · answered Sep 02 '09 at 22:53

1

Did you try to define both properties as keys? Not sure I have tried it but that way they should become a composite key.

property :name, String, :key => true    
property :category, Integer, :key => true

answered Sep 02 '09 at 22:53

Jonas Elfström

28,718
6
66
102

Actually there already is a key, I just didn't include it in the code snippet. – John F. Miller Sep 03 '09 at 18:50

datamapper multi-field unique index

3 Answers3