Suppose I have one string list may have duplicated items:
CREATE TABLE aa ( myid INTEGER PRIMARY KEY AUTOINCREMENT,
UNIQUE (myid) ON CONFLICT FAIL,
UNIQUE (name) ON CONFLICT FAIL);
Why not try it out and check which Exception is raised? That's not too hard I think, but...
try: conn.excecute('...') except IntegrityError: pass