如何在sqlalchemy中添加db.Column整数？

Question

我有一个功能，当前用户将添加预算，并将获得平均预算。但我不知道如何正确获得用户预算

我尝试了以下方法以获取当前用户预算： routes.py：

@app.route("/user/<int:user_id>", methods=['GET', 'POST'])
@app.route("/<int:user_id>", methods=['GET', 'POST'])
@login_required
def user(user_id):
    budget_count = Budgets.query.filter_by(user_id=current_user.id).count()
    total_budget = Budgets.query.all()
    total_budget = current_user.current_budget
    added_budget = 0
    for budget in total_budget:
        added_budget = added_budget + budget
    average_budget = added_budget / budget_count
    user = User.query.get_or_404(user_id)
    return render_template("user.html", title=current_user.username, user=user, budget_count=budget_count, average_budget=average_budget)

它获取并键入错误

models.py：

class Budgets(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    new_budget = db.Column(db.Integer, nullable=False)
    date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    expense = db.relationship('Expenses', backref='budget_expenses', lazy=True)

是否有任何函数或方法可以方便地查询并获得所查询数据的平均值