TypeError: 'int' object is not iterable - Python
You need to give cursor.execute
a tuple, but you only gave it one integer:
(id)
Add a comma to make that a tuple:
(id,)
The full line then'd be:
cursor.execute("""select test_id from test_logs where id = %s """, (id,))
Putting an expressione in parentheses just 'groups' that one expression. It is the comma that makes something a tuple:
>>> (42)
42
>>> (42,)
(42,)
Any iterable will do really, so you could also use [...]
brackets:
cursor.execute("""select test_id from test_logs where id = %s """, [id])