Dennis Lee Bieber wrote:
> On 1 Feb 2007 10:17:31 -0800, "baur79" <[EMAIL PROTECTED]> declaimed the
> following in comp.lang.python:
>>IntegrityError: (1062, "Duplicate entry '[EMAIL PROTECTED]' for key 1")
>
> So show us the schema for the database... My take: Your database
> ALREADY HAS a record with that "[EMAIL PROTECTED]" value AND emails.email
> is defined as a unique key field.
Right. That's not a bug; it's supposed to do that when you try
to add a duplicate. What do you want to happen?
If you want to allow duplicates, remove the UNIQUE on that
field from the schema.
If you want the new entry to replace the old entry, use REPLACE
instead of INSERT.
If you just want to detect the problem, provide
import MySQLdb
kmysqlduplicateentry = 1062 # MySQL error code when INSERT finds a duplicate
try :
... # do INSERT
except MySQLdb.IntegrityError, message:
errorcode = message[0] # get MySQL error code
if errorcode == kmysqlduplicateentry : # if duplicate
... # handle duplicate
else:
raise # unexpected error, reraise
John Nagle
--
http://mail.python.org/mailman/listinfo/python-list
