SQLite3 Python variables

Question

I've written this code for an SQLite3 database in python:

 i = datetime.datetime.now()
        v_day = i.day
        v_month = i.month
        v_year = i.year
        v_hour = i.hour
        v_minute = i.minute

    cur.execute("""INSERT INTO weather(
                day,month,year,hour,minut,temperature,humidity) VALUES (
                ?,?,?,?,?,?,?),
                (v_day,v_month,v_year,v_hour,v_minute,temp,hum)""")

After trying it, it displayed this Error: File "store_data.py", line 68, in main (v_day,v_month,v_year,v_hour,v_minute,temp,hum)""") sqlite3.OperationalError: no such column: v_day I've already tried to put the variables names in the VALUES' list, but I occured in the same Error.

Thank you for the answer.

Badgy · Accepted Answer · 2020-04-04 10:43:43Z

1

Your tuple is inside your string. Also you shouldn't denote the table columns in the query. Try

    cur.execute("INSERT INTO weather VALUES (?,?,?,?,?,?,?)",
                (v_day,v_month,v_year,v_hour,v_minute,temp,hum))

answered Apr 4, 2020 at 10:43

Badgy

8194 silver badges14 bronze badges

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

Comments

Gabio · Accepted Answer · 2020-04-04 10:54:43Z

0

Try this one:

sql = f"""INSERT INTO weather(day,month,year,hour,minut,temperature,humidity) VALUES ({v_day},{v_month},{v_year},{v_hour},{v_minute},{temp},{hum})"""
cur.execute(sql)

answered Apr 4, 2020 at 10:54

Gabio

9,5643 gold badges17 silver badges38 bronze badges

Collectives™ on Stack Overflow

SQLite3 Python variables

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