SQLite Python does not insert

Question

I am working on a project in which I am using python to store sensor data in a SQLite Database.

If the table does not exists it will be created like this:

query_db('create table if not exists %s (id INTEGER PRIMARY KEY AUTOINCREMENT, value double, datetimestamp DATETIME, user CHAR(2));' % (sensor_name+'_VALUES'))

Next I want to insert the values from a HTTP Post Request:

  sensor_value = request.json['value']
        dtstamp = request.json['timestamp']
        user_name = request.json['user']
        result = query_db('INSERT INTO %s  ("value", "datetimestamp", "user") VALUES ( "%s" ,"%s" , "%s");' % (sensor_name + '_VALUES', sensor_value, dtstamp, user_name))

But I don't get an error and it also seems like the insert is not executed. The request looks like this:

{
    "value" : 22,
    "timestamp" : "2017-02-17 22:22:22",
    "user" : "TE"
}

Anyone know why?

Solved it - but why do you have to commit on Inserts? DDL Statements just work -.- — Curunir
– Curunir, Commented Dec 13, 2017 at 13:16

alecxe · Accepted Answer · 2017-12-13 19:48:13Z

1

You need to commit the transaction to persist the changes in the database:

db.commit()

Here is some additional information about why and when do you need to commit:

python sqlite3, how often do I have to commit?

answered Dec 13, 2017 at 19:48

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Collectives™ on Stack Overflow

SQLite Python does not insert

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related