[Python] sqlite query works form db viewer but not form python

I run this query from DB Browser for SQLite:

DELETE FROM ticket WHERE ROWID = (SELECT MAX(ROWID) FROM ticket);


and it works fine with no errors. Then, from a Python program:

connection.execute("DELETE FROM ticket WHERE ROWID = (SELECT MAX(ROWID) FROM ticket)")


runs with no errors but has no effect. What am I missing?

I have been looking at the SQLite explicit row id concept, but can't see how it applies to Python connections.

Continue reading...