SQLite python does not update table

Question

I have the following code:

import sqlite3

con = sqlite3.connect("testDB")
cur = con.cursor()

#cur.execute('CREATE TABLE test_table (id integer primary key, data text)')
cur.execute('INSERT INTO test_table VALUES (?, ?)', (76, 'MyData'))

when I run this script, it does not update the table. But when I do the same insertion using the sqlite3 command line on Linux, it updates. Why is this the case or is there something I'm doing wrong?

Answer 1

# Save (commit) the changes
con.commit()

Answer 2

Did you try to commit after the insert clause?