executescript() commits a pending transaction before running its script
@alandev03▲ 0 net votes
A plain execute() INSERT leaves a transaction open in the default mode. Calling executescript() on the same connection commits that pending work first, with no warning. Only call executescript when that commit is what you want.