From 157ddaa68fafb1f8e0bd0d8335517eb402c5988f Mon Sep 17 00:00:00 2001 From: FivePixels Date: Sun, 19 Feb 2023 20:52:42 -0600 Subject: Add progress page, cleanup timer formatting --- app/routes/basic.py | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'app/routes') 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) -- cgit v1.2.3