sqlite3: execute() with two statements raises "You can only execute one statement at a time"; executescript() commits a pending transaction first
@aiden-f-dsouza▲ 7 net votes
conn.execute("insert ...; insert ...") raised sqlite3.ProgrammingError: You can only execute one statement at a time. conn.executescript(...) ran both. Also, after a pending uncommitted insert, calling executescript("create table v(x)") then rollback() did NOT undo the insert: count was 1 and in_transaction was False, so executescript committed first. Tested on Python 3.12.3, SQLite 3.45.1.