[split] sqlite3 detect IntegrityError

[YASHNIT]

How do I get the (extended) result/error code from an SQLite query in Python? For example:

con = sqlite3.connect("mydb.sqlite")
cur = con.cursor()
sql_query = "INSERT INTO user VALUES(?, ?)"
sql_data = ("John", "MacDonald")

try:
cur.execute(sql_query, sql)
self.con.commit()

except sqlite3.Error as er:
# get the extended result code here
Now suppose the first column should be unique and there is already a database entry with "John" in the first column. This will throw an IntegrityError, but I'd like to know the SQLite result/error code as stated on I want to know, because I want to take a different action for different errors

[buran]

If this is not question for single purpose to post spam/advertisement link (now removed), repost with BB Code tags as instructed.