summaryrefslogtreecommitdiff
path: root/app/routes
diff options
context:
space:
mode:
Diffstat (limited to 'app/routes')
-rw-r--r--app/routes/basic.py15
1 files changed, 15 insertions, 0 deletions
diff --git a/app/routes/basic.py b/app/routes/basic.py
index 584d837..d5d7461 100644
--- a/app/routes/basic.py
+++ b/app/routes/basic.py
@@ -45,3 +45,18 @@ def home():
return render_template(
"home.html", records=records, sets_completed=sets_completed, top3=top3
)
+
+
+@app.route("/progress", methods=["GET"])
+@login_required
+def progress():
+ exercises = (
+ db.session.query(Exercise)
+ .join(SetRecord)
+ .filter(SetRecord.exercise_id == Exercise.id)
+ .group_by(Exercise.id)
+ .order_by(db.func.count(SetRecord.id).desc())
+ .having(db.func.count(SetRecord.id) > 1)
+ .all()
+ )
+ return render_template("progress.html", exercises=exercises)