flask + sqlAlchemy计数，平均值和总和在一个查询中

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)

class YourModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    value = db.Column(db.Integer)

from sqlalchemy import func

@app.route('/your_route')
def your_view():
    count = db.session.query(func.count(YourModel.id)).scalar()
    average = db.session.query(func.avg(YourModel.value)).scalar()
    total = db.session.query(func.sum(YourModel.value)).scalar()

    return f"Count: {count}, Average: {average}, Total: {total}"