从python sqlite异常中获取更多信息(Getting more info from python sqlite exceptions)

 我正在使用python的内置sqlite3数据库模块 。 
 
 在将对象插入我的数据库表时，引发了以下sqlite异常： 
 
"PRIMARY KEY must be unique"
 
 由于每个对象有不同的插入方法，我无法确定它在哪个表中失败： 
 
import sqlite3
...
class SomeObject1:
....
def _insert_some_object1(self, db_object):
        self._cursor.execute('insert into %s values (?,?,?)' % TABLE_NAME,
        (db_oject.v1, db_object.v2, db_object_v3,))
 
 except Exception as e:被main()捕获，所以它只是我得到的信息。 
 
 我想知道哪个表插入失败，失败的值等等... 
 
 从sqlite异常中获取最多信息的正确方法是什么？ 
 
 谢谢 

I'm using python's builtin sqlite3 DB module.
 
While inserting objects to my DB tables, following sqlite exception raised:
 
"PRIMARY KEY must be unique"
 
As there are different insert methods for each object, I can't say for sure in which table does it failed:
 
import sqlite3
...
class SomeObject1:
....
def _insert_some_object1(self, db_object):
        self._cursor.execute('insert into %s values (?,?,?)' % TABLE_NAME,
        (db_oject.v1, db_object.v2, db_object_v3,))
 
Exception got caught in main() by except Exception as e:, so it's only info I've got.
 
I would want to know in which table insertion failed, value that failed, etc...
 
What's the right way to get the most info from sqlite exceptions?
 
Thanks

原文：https://stackoverflow.com/questions/34530463