sum the database values and display the result in the flask-sqlalchemy template

Question

have ma table with following information:

class Registro(db.Model):
id = db.Column(db.Integer, primary_key=True)
valores = db.Column(db.Float)

------------|
  valores   |
------------|
   1.50     |
------------|
   2.40     |
------------|
   3.55     |
------------

@app.route('/', methods=['GET', 'POST'])
va = Registro.query.all()
def index():
return render_template('index.html', va=va)

wanted to sum these values and shows the result in the template. How would be the logic to achieve this result using flask-sqlalchemy?

Answer 1

You can do it this way

from sqlalchemy.sql import func

@app.route('/')
def index():
    va = Registro.query(func.sum(Registro.valores)).all()
    return render_template('index.html', va=va)

in the index.html file

{{va}}