I'm searching for a record in Users db and then looping through all the records. The code is something like below.
email = "[email protected]"
data = Users.query.filter(email=email).first()
for item in data:
if item["age"] == 15:
#do something
The above code throws error Users object not iterable. How can I loop through the records?
Because you only returned one row of data, it cannot be iterable. If your data is not null, you can use ‘data.age’ instead of ‘item["age"]’
email = "[email protected]"
data = Users.query.filter(email=email).first()
if data.age == 15:
#do something
email = "[email protected]"
data = []
data = Users.query.filter(email=email).first()
if data:
# ages = data['age'] # You can use this also
age = data.get('age') # Try This
# age = data.age #If you don't want to convert into a list
if age == 15:
print (age)
first, so there is ONE item, nothing to iterate on, what did you expect ?Users.query.filter(email=email).all()?