I've been struggling with duplicate key exception handling myself.
I'm able to catch the SQLAlchemy exception with an exception handler,
but I'd rather just handle this inside my function.
@exception_handler(someFunctionName)
I've only tested the following code for a few minutes, but it seems to
work and I avoid the exception handler. It's similar in theory to
Paul's method. The sample code is for a RSS reader that only adds a
new feed if it doesn't already exist. unique=True is set for the link
column in the mysql database.
f = Feed.get_by(link=link)
if not f:
# create the feed entry if it is new
f = Feed(name=name, link=link, description=description)
f.users.append(identity.current.user)
else:
# the feed exists so test for a new user
new_user = 1
for usr in f.users:
if ( usr == identity.current.user ) :
# Don't need to add user to the feed
new_user = 0
break
if ( new_user == 1 ) :
f.users.append(identity.current.user)
Regards,
Todd
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
