If I have:
query = db.session.query(Food, Person).filter(Food.id == Person.favourite_food)
for row in db.session.execute(query)
print row
The output for first print I get is:
(1, u'Alice', 25, u'F', u'z', None, False, 1, u'icecream', 1, None, False)
(5, u'Bob', 38, u'M', u'z', None, False, 3, u'pizza', 1, None, False)
How do I do:
print row.name, row.gender # <-- how do I do this?
The result does not seem to have column names anymore.
Edit: And also is there a way to serialise the query results with just one line, something like
return Response(json.dumps(query.results), mimetype='application/json')