How to send the objects found in the database to the template?

Question

Flask

Hello, there is a function like this ormka ponyorm

@db_session
def select_allvalid_users():
    users = select(x for x in User)
    print(type(users))
    print(users)
    return users

she returns

[User[1], User[2]]

when i try to return send this to the template

usr = select_allvalid_users()


    return jsonify(user = usr)

he tells me

TypeError: User[1] is not JSON serializable

how to return the object normally to the template so that it can be used in the object field in the template?

Answer 1

This is a security problem and it is described here flask.pocoo.org/docs/0.10/security/#json-security
Now you need to do something like this to return the entire list

usr = select_allvalid_users()
return jsonify({"user":usr})