On Tuesday, June 14, 2011 10:38:49 AM UTC-4, apple wrote: > > The following code in a model results in two rows with the name > "test". So what does unique=True do?
It translates to the "UNIQUE" SQL statement and is enforced at the level of the database. requires=IS_NOT_IN_DB, on the other hand, is a validator and is enforced by web2py forms. If you make insertions into the database without using a form, unique=True will still be enforced by the database, so duplicate values will result in an error (and the transaction will not be committed). See http://web2py.com/book/default/chapter/06#Record-Representation. Anthony
