bytes-like object is required not 'tuple' when trying to use query parameters

Question

In a phython script I read a value from a hardware module. This value I want to insert in a mariadb

I convert the hardware value to a string.

wert_float="{:.1f}".format(sensor1)
wert = str(wert_float)

mycursor =mydb.cursor()
sql = "INSERT INTO werte (feuchtigkeit) VALUES (?)", (wert)
mycursor.execute(sql)
mydb.commit()
mycursor.close()
mydb.close()

I tried the statement with (%s) too, but at all tries I got the error:

Traceback (most recent call last):
  File "./waterpi_sql.py", line 118, in <module>
    mycursor.execute(sql)
TypeError: a bytes-like object is required, not 'tuple'

Can someone help me?

chepner · Accepted Answer · 2021-07-13 01:14:50Z

1

You need to move your query params to actual function params

sql = "INSERT INTO werte (feuchtigkeit) VALUES (?)"
mycursor.execute(sql, (wert,))

Otherwise, you've assigned sql to a tuple, which is not executable, and the way you've written is not expressed in any docs that I've seen, so make sure you refer back to those

edited Jul 13, 2021 at 1:14

chepner

538k77 gold badges594 silver badges747 bronze badges

answered Jul 13, 2021 at 0:23

OneCricketeer

193k20 gold badges147 silver badges277 bronze badges

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

1 Comment

chepner Over a year ago

mycursor.execute(*sql) would also be an option, if sql were assigned the correct tuple originally (i.e., sql = "...", (wert,)).

Collectives™ on Stack Overflow

bytes-like object is required not 'tuple' when trying to use query parameters

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