How to get SQLite result / error codes in Python

Question

How to get (extended) result / error code from a SQLite query in Python? For instance:

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 must be unique, and the first column already has a database record with "John". This will raise an IntegrityError, but I would like to know the SQLite result / error code, as indicated at http://www.sqlite.org/rescode.html#extrc . I want to know because I want to take different actions for different errors.

Answer 1

Currently, you cannot get error codes through the sqlite3 Python sqlite3 . Per https://www.sqlite.org/c3ref/errcode.html , the C API provides basic error codes, extended error codes and error messages through sqlite3_errcode , sqlite3_extended_errcode and sqlite3_errmsg respectively. However, a search in the CPython source shows that:

• sqlite3_extended_errcode never gets called
• sqlite3_errmsg is called and the result is displayed as an exception message
• sqlite3_errcode is called, but the result is never displayed directly; he just used to decide which class of exception to raise

Although the feature you are asking for would be useful (indeed, I need it right now for debugging and frustrated by its absence), it just doesn't exist right now.

Answer 2

 try: cur.execute(sql_query, sql_) self.con.commit() except sqlite3.Error as er: print 'er:', er.message 

gives you an error. Or: er.args. This is a list, I don’t know if it can contain more than one item. The first element is the message returned by er.message

Another possibility:

 a,b,c = sys.exc_info() for d in traceback.format_exception(a,b,c) : print d, 

Sqlite error in c