How would I go about catching the errors thrown by fpmi.db? I think I understand how exception handling works in python, but my except clause never seems to fire. I would like my script to be a little more user friendly and hide the scary sql error messages…
Here’s what I have been trying so far:
fpmi.db.runPrepStmt("INSERT INTO %s (TypeID, TypeName, TypeColor, TypeDesc) VALUES (NULL, ?, ?, ?)" %
(types_table), [type_name, type_color, type_desc])
I want to be able to catch duplicate violations, etc. Also, is there a list of the possible exceptions somewhere?
Thanks for the help.