CODEWITHSUNDEEP
pythonmysqlpython-3.xexception
Max
Max

Reputation: 4408

How to Catch MySql Insert Exception :"1062 (23000): Duplicate entry" while catching other exceptions Python 3?

I am trying to catch and count the duplicate entry exception :

1062 (23000): Duplicate entry '' for key 'tabale.item_UNIQUE'

Here is the code that will generate the duplicate Item exception:

stmt='INSERT INTO table.items(item) VALUES("iteratorI");'
    try:
        mc.execute(stmt)
        conn.commit()
    except pymysql.IntegrityError as e:
        duplicateCounter=duplicateCounter+1
    except Exception as ee:
        otherErrors=otherErrors+1

I would like to be able to count duplicate item entry exceptions separately to keeping the count of other exceptions.

I want to make sure the exception that I am counting is about the duplicate entry and nothing else. The other issue is that currently duplicateCounter is ending up being zero although I am getting at least 10 1062 exceptions which are counted in otherErrors

Upvotes: 1

Views: 1921

Answers (1)

Booboo
Booboo

Reputation: 44213

You haven't really stated what your concern is. Is it that you are worried that the pymysql.IntegrityError exception might be caused by something other than a duplicate key error? If that is the issue, you can check that the error code associated with the exception is 1062 (DUP_ENTRY) as follows:

stmt = 'INSERT INTO table.items(item) VALUES("iteratorI");'
try:
    mc.execute(stmt)
    conn.commit()
except pymysql.IntegrityError as e:
    if e.args[0] == 1062:
        duplicateCounter += 1
except Exception as ee:
    otherErrors += 1

If you do not want to hard-code the value 1062, you could ...

from pymysql.constants.ER import DUP_ENTRY

... and then compare e.args[0] with DUP_ENTRY. But you would then be substituting one coding dependency for another.

Upvotes: 3

Related Questions