Cannot insert data into an sqlite3 database using Python

Question

I can successfully use Python to create a database and run the execute() method to create 2 new tables and specify the column names. However, I cannot insert data into the database. This is the code that I am trying to use to insert the data into the database:

#! /usr/bin/env python

import sqlite3

companies = ('GOOG', 'AAPL', 'MSFT')

db = sqlite3.connect('data.db')
c = db.cursor()

for company in companies:
    c.execute('INSERT INTO companies VALUES (?)', (company,))

Here is the code that I use to successfully create the database with:

#! /usr/bin/env python

import sqlite3

db = sqlite3.connect('data.db')

db.execute('CREATE TABLE companies ' \
      '( '\
      'company varchar(255) '\
      ')')

db.execute('CREATE TABLE data ' \
      '( '\
      'timestamp int, '\
      'company int, '\
      'shares_held_by_all_insider int, '\
      'shares_held_by_institutional int, '\
      'float_held_by_institutional int, '\
      'num_institutions int '\
      ')')

Nope, everything seemed to run fine other than the fact that the records weren't being added to the table. — Peter Horne
– Peter Horne, Commented Jul 29, 2009 at 17:19

balpha · Accepted Answer · 2009-07-29 16:46:56Z

21

Try to add

db.commit()

after the inserting.

answered Jul 29, 2009 at 16:46

balpha♦

51.2k18 gold badges114 silver badges133 bronze badges

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

Comments

rado · Accepted Answer · 2009-07-29 16:44:46Z

4

To insert the data you don't need a cursor

just use the db

db.execute() instead of c.execute() and get rid of the c = db.cursor() line

Cursors aren't used to insert data, but usually to read data, or update data in place.

answered Jul 29, 2009 at 16:44

rado

4,1153 gold badges34 silver badges26 bronze badges

Collectives™ on Stack Overflow

Cannot insert data into an sqlite3 database using Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related