Python and sqlite3 simplest example not working

Question

I'm trying to execute this simple python script but it seems to do nothing: I don't get any error, I try to execute the query directly on sqlite3 and it works....I don't have any idea why isn't working, can anyone help me?

import sqlite3 as lite
import sys

con = None

try:
    con = lite.connect('/home/pi/Moranberries/web/moranberries.db')

    cur = con.cursor()    
    cur.execute("INSERT INTO sensor_interior (temperatura,humedad) VALUES (111,222)")

except lite.Error, e:

    print "Error %s:" % e.args[0]
    sys.exit(1)

finally:

    if con:
        con.close()

To execute this script I named it prueba.py an call it from terminal as this:

python prueba.py

There is no error message.

so what is the problem?

Marcus Müller
– Marcus Müller

2015-12-23 14:49:51 +00:00
Commented Dec 23, 2015 at 14:49 — Marcus Müller
– Marcus Müller, Commented Dec 23, 2015 at 14:49
Missing commit: con.commit()?..

alecxe
– alecxe

2015-12-23 14:55:48 +00:00
Commented Dec 23, 2015 at 14:55 — alecxe
– alecxe, Commented Dec 23, 2015 at 14:55

lotsofstorage · Accepted Answer · 2015-12-23 15:13:33Z

1

You're not committing your changes to the DB. If you call con.commit() after cur.execute, it should write the changes.

answered Dec 23, 2015 at 15:13

lotsofstorage

3123 silver badges18 bronze badges

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

1 Comment

Robᵩ Over a year ago

The documentation mentions this explicitly.

Collectives™ on Stack Overflow

Python and sqlite3 simplest example not working

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