Issues with DB browser and INSERT function in python

Question

I am attempting to use sqlite3 through python commands in Visual Code Studio. After importing sqlite3, here is my code:

connection = sqlite3.connect("test.db")
crsr = connection.cursor()
crsr.execute("CREATE TABLE list (id INTEGER PRIMARY KEY, name TEXT);")
crsr.execute("INSERT INTO list VALUES(1, 'value1');")

The program runs fine with no errors. When I open the database in DB browser, I see that the table list has been successfully created with the columns I specified. But when I actually view the SQL data, no values are in the table.

Clearly, I am successfully connecting to DB Browser since I'm able to make a table- but why is my data not inserting into it?

Also do connection.commit() after your INSERT statement.

mechanical_meat
– mechanical_meat

2019-12-31 18:26:52 +00:00
Commented Dec 31, 2019 at 18:26 — mechanical_meat
– mechanical_meat, Commented Dec 31, 2019 at 18:26

Mureinik · Accepted Answer · 2019-12-31 18:28:26Z

1

Creating the table is a DDL action, which doesn't need committing. Inserting data, on the other hand, is a DML operation, and you need to explicitly commit it after it completes:

connection.commit()

answered Dec 31, 2019 at 18:28

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

Issues with DB browser and INSERT function in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related