the only way to do it efficiently would be to be this:
db.define_table('firm',
Field('name'),
Field('lname',writable=False,readable=False))
def validate_name(form):
form.vars.lname,form.errors.name=IS_IN_DB(db,'firm.lname')
(form.vars.name.lower())
form=crud.create(db.first,onvalidation=validate_name)
A little cumbersome but I am sure you get the idea.
On Oct 16, 6:04 pm, oneroler <[email protected]> wrote:
> Thanks for the fast response. This works perfectly. You said using
> like is way less efficient, is there a way to use IS_NOT_IN_DB that
> would achieve the same goal?
>
> On Oct 16, 3:45 pm, mdipierro <[email protected]> wrote:
>
> > Two things...
> > 1)
>
> > db.firm.name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db,
> > 'firm.name')]
>
> > and
>
> > db.firm.name.requires = IS_NOT_IN_DB(db, 'firm.name')
>
> > are equivalent. Is not in db, does not accept empty anyway.
> > Back to your question.
>
> > You can make your own validator:
>
> > class IS_NOT_IN_DB_ANYCASE:
> > def __init__(self,db, field, error_message='oops')
> > self.db=db
> > self.tablename,self.fieldname=field.split('.')
> > self.error_message=error_message
> > def __call__(self,value):
> > if self.db(self.db[self.tablename]
> > [self.fieldname].like(value)).count():
> > return (value,self.error_message)
> > return (value,None)
>
> > db.firm.name.requires = IS_NOT_IN_DB_ANYCASE(db, 'firm.name')
>
> > but using like is way less efficient that not IS_NOT_IN_DB.
>
> > On Oct 16, 5:18 pm, oneroler <[email protected]> wrote:
>
> > > I just started working with web2py and have what is probably a simple
> > > question on database validation. Below is what I have in db.py.
> > > Currently this will allow duplicate names that are in different cases
> > > (e.g. Firm 1 and firm 1). I want to make it so that it won't allow
> > > this but stores the name in the database the way the person enters it,
> > > so I don't want to convert everything to upper or lowercase and store
> > > it that way. Thanks in advance for any help.
>
> > > db.define_table('firm',
> > > Field('name', unique=True))
>
> > > db.firm.name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'firm.name')]
>
>
