db.user.insert isn't throwing an exception if a duplicate record is
inserted but instead continues to the db.commit() instruction -- when
I using appadmin I can confirm that the duplicate record has been
added.
My insert code...
try:
existingEmail = db.user.insert(email=request.vars.email,
greet=False)
db.commit()
except:
#email record already exists
### handling code
Curiously... if I go to:
.../appadmin/select/db?query=db.user.id>0 then try to add a record
with a duplicate email address the form reports "value already in
database!"
This suggests that my db.py setting is okay. What am I missing in my
code?
Carl
On Apr 30, 7:17 pm, Carl <[email protected]> wrote:
> thanks M / very speedy concise reply.
> p 138/139 explains it all - sorry to have missed this detail.
>
> On Apr 30, 6:45 pm, mdipierro <[email protected]> wrote:
>
>
>
> > This
>
> > db.user.email.requires=[IS_NOT_EMPTY(),IS_LOWER(),IS_NOT_IN_DB
> > (db,db.user.email)]
>
> > is only enforced at the level for form validation. If you want the
> > database to enforce integrity
>
> > db.define_table('user',
>
> > > SQLField('email', 'string', length=320, unique=True),
> > > SQLField('hash','string'))
>
> > On Apr 30, 12:07 pm, Carl <[email protected]> wrote:
>
> > > I have this in my model: db.py:
>
> > > db.define_table('user',
> > > SQLField('email', 'string', length=320),
> > > SQLField('hash','string'))
> > > db.user.email.requires=[IS_NOT_EMPTY(),IS_LOWER(),IS_NOT_IN_DB(db,
> > > db.user.email)]
>
> > > In my controller: default.py:
>
> > > try:
> > > uid = db.user.insert(email=request.vars.email,
> > > hash=converted)
> > > except:
> > > etc...
>
> > > I can execute the controller code again and again with the same value
> > > in request.vars.email with success. I was expecting an exception to be
> > > throw (which I would catch) when I tried to insert an existing email
> > > address.
>
> > > What am I missing?
>
> > > Can anyone help?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
