How to handle SQLlite error?

Question

Python

Good day friends.
I am getting data from an array and update it via UPDATE with rows in db by name value.
Sometimes, new entries appear and I don't need to update them, but add them. How to intercept (as it is called) an error that will help me identify that there is no entry in the database with such a name, it needs to be added.

Answer 1

when updating, you should get back the number of changed records cursor.rowcount , so look and yes, 0 is not an error.