Python doesn't save data to sqlite db

Question

This is my code:

conn = sqlite3.connect(nnpcconfig.commondb)
cur = conn.cursor()
query = ['2124124', 'test2', 'test3', 'test4', 'test5']
cur.execute("insert into users(id, encpass, sname, name, fname) values (?, ?, ?, ?, ?)", query)
conn.commit
cur.execute("select * from users")
for row in cur:
    print row

This code works, returning row fed to it. But it comes out that once script terminated, table is clear again! Where's the mistake? Of course, table users exists.

John Machin · Accepted Answer · 2010-08-21 00:15:54Z

12

You have another mistake: conn.commit instead of conn.commit()

answered Aug 21, 2010 at 0:15

John Machin

83.2k12 gold badges147 silver badges193 bronze badges

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

1 Comment

postfuturist Over a year ago

This is the actual problem in the above code that would cause the table to be empty. The connection will close when the script exits.

Collectives™ on Stack Overflow

Python doesn't save data to sqlite db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related