Finally fixed a PyMySQL issue with commits. Turns out you have to enable autocommit.