How do I determine if the row has been inserted?

Question

When using sqlite3 for python, how do I determine if a row has been successfully inserted into a table? e.g.

conn = sqlite3.connect("test.db")
c = conn.cursor()

c.execute("INSERT INTO TEST VALUES ('sample text')")

c.commit()
c.close()

Answer 1

If no exception was thrown when calling execute() or commit(), it was inserted when you called commit().

Committing a transaction successfully is a guarantee from the database layer that the insert was written to disk.