Solution 1
@app.route('/info/')
def info(id):
user_info = database.query.filter_by(id=id).first()
return render_template('info.html', information=user_info)
Rank
ID
Name
Profile Summary
Personality Score
Skills Score
Experience Score
Total Score
{% for data in database %}
{{data.id}}
{{ data.name }}
{{ data.text }}
{{ data.personality_score }}
{{data.skills_score}}
{{data.experience_score}}
{{data.total_score}}
{% endfor %}
Solution 2
@app.route('/info')
def info():
page = request.args.get('page', 1, type=int)
user_info = database.query.order_by(
database.timestamp.desc()).paginate(
page, app.config['POSTS_PER_PAGE'], False
)
next_url = url_for('info',
page=user_info.next_num) \
if user_info.has_next else None
prev_url = url_for('info',
page=user_info.prev_num) \
if user_info.has_prev else None
return render_template('info.html',
title='User Information',
next_url=next_url,
prev_url=prev_url,
user_info=user_info.items
)
Rank
ID
Name
Profile Summary
Personality Score
Skills Score
Experience Score
Total Score
{% for data in user_info %}
{{data.id}}
{{ data.name }}
{{ data.text }}
{{ data.personality_score }}
{{data.skills_score}}
{{data.experience_score}}
{{data.total_score}}
{% endfor %}