virtual fields are not computed fields. They do not exist in the db. They are computed when records are retrieved. They cannot have requirements or attributes because there no way to input their values in a form. So this is simply imporssible:
db.mytable.uniqueField.requires = ... On Dec 29, 5:57 am, Manuele Pesenti <[email protected]> wrote: > Il 28/12/2010 23:40, Luther Goh Lu Feng ha scritto:> Is there a reason why > you are not using Auth, if you aren't? > > >http://www.web2py.com/book/default/chapter/08#Authentication > > > Anyway, assuming that you truly want to add the unique constraint, > > then I am guessing that you could construct virtual fields > > >http://www.web2py.com/book/default/chapter/06#Virtual-Fields > > > and apply the > > constrainthttp://www.web2py.com/book/default/docstring/IS_NOT_IN_DB > > > db.page.title.requires = IS_NOT_IN_DB(db, 'page.title') #http:// > >www.web2py.com/book/default/chapter/03 > > interesting answer, but trying what is suggested ti seams not possible > to refer to a virtual field such as it's possible with real fields... I > mean trying this little example that's the result I get > > >>> db.define_table('mytable', > ... Field('field1','integer'), > ... Field('field2','integer'), > ... ) > >>> class MyVirtualFields(object): > ... def uniqueField(self): > ... d = dict() > ... for i in ['field1', 'field2']: > ... d[db.mytable[i].name] = self.mytable[i] > ... return d > ... > >>> db.mytable.virtualfields.append(MyVirtualFields()) > >>> db.mytable.uniqueField.requires = IS_NOT_IN_DB(db, > 'mytable.uniqueField') > Traceback (most recent call last): > File "<console>", line 1, in <module> > File "/home/manuele/Progetti/web2py/gluon/sql.py", line 1688, in > __getattr__ > return dict.__getitem__(self,key) > KeyError: 'uniqueField' > > what's wrong in it? > > thank you very much > > Manuele
