DAL: How to define compound keys.

[tiago almeida]

Hello all,

What should one do to force a specific pair of columns to be unique?

Lets say I have a table where 2 of the columns are "user" and "bookmark" and I want the database to force the pair (user,bookmark) to be unique so that a specific user doesn't insert the same bookmark twice or more. Is it possible to do this with DAL? The only solution I see is to explicitly check for the existence of that pair with a select..

Thanks a lot in advance,

Tiago Almeida

[mdipierro]

This comes up often. You have to enforce at the validators level.

db.define_table('t',Field('a'),Field('b'))

db.t.b.requires=IS_NOT_IN_DB(db(db.t.a==request.vars.a),db.t.b)

[tiago almeida]

I see. Thank you for your prompt answer :)

Tiago Almeida
----------

--
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to web2py+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/web2py?hl=en.