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 table. But when I do the same insertion using sqlite3 commandline in Linux, it updates. Why is it so or there anything I am making wrong?

kev · Accepted Answer · 2012-03-21 11:53:11Z

12

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

answered Mar 21, 2012 at 11:53

kev

163k49 gold badges286 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user873286 Over a year ago

con.commit() this should be done after everything is finished, or can I commit after each con.execute() statement???

kev Over a year ago

If another program want to see the data immediately, you should commit immediately. Otherwise you can commit at the end.

Anuj Balan · Accepted Answer · 2012-03-22 05:00:33Z

1

Did you try commiting after the insert clause?

edited Mar 22, 2012 at 5:00

Anuj Balan

7,74123 gold badges62 silver badges94 bronze badges

answered Mar 21, 2012 at 11:56

Bruno Farina

316 bronze badges

2 Comments

user873286 Over a year ago

con.commit() work but con.commit() this should be done after everything is finished, or can I commit after each con.execute() statement??? what is the main purpos of commit?

Bruno Farina Over a year ago

the 'commit' is to finish all the alteration in your table...but if you want back at the last status you use the 'rollback clause'

Collectives™ on Stack Overflow

SQLite python does not update table

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related