Solution
from flask import redirect, url_for, render_template
@app.route("/home")
@app.route("/")
def root():
return redirect(url_for('root', ordering_by='date_created')
@app.route("/home/")
@app.route("/")
def root(ordering_by):
page = request.args.get('page', 1, type=int)
movies = None
match ordering_by:
case 'rating':
movies = Movie.query.order_by(Movie.rating.desc())
case 'release_year':
movies = Movie.query.order_by(Movie.release_year.desc())
case 'date_created':
movies = Movie.query.order_by(Movie.date_created.desc())
case _:
movies = Movie.query.all()
return render_template("index.html", movies=movies.paginate(per_page=5, page=page)