summaryrefslogtreecommitdiff
path: root/app/routes/basic.py
blob: 0ef66f9b995f6ebc140f7c3d4aa7ea6cebc8d215 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
from app import app, db
from flask import render_template
from flask_login import current_user, login_required
from tables import Workout, WorkoutRecord, SetRecord


@app.route("/", methods=["GET"])
def index():
    return render_template("index.html")


@app.route("/home", methods=["GET"])
@login_required
def home():
    # Prepare so we don't have to do this in the template
    records = (
        db.session.query(WorkoutRecord)
        .filter_by(user_id=current_user.id)
        .order_by(WorkoutRecord.finished.desc())
    )

    sets_completed = (
        db.session.query(SetRecord, WorkoutRecord)
        .filter(
            WorkoutRecord.id == SetRecord.workout_record_id,
            WorkoutRecord.user_id == current_user.id,
        )
        .count()
    )

    return render_template("home.html", records=records, sets_completed=sets_completed)