How to display specific user information in a separate page using flask and flask-sqlalchemy?

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)

      {% for data in database %}
      
  {% endfor %}
Rank ID Name Profile Summary Personality Score Skills Score Experience Score Total Score
{{data.id}} {{ data.name }} {{ data.text }} {{ data.personality_score }} {{data.skills_score}} {{data.experience_score}} {{data.total_score}}
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
                           )

            {% for data in user_info %}
               
           {% endfor %}
         
Rank ID Name Profile Summary Personality Score Skills Score Experience Score Total Score
{{data.id}} {{ data.name }} {{ data.text }} {{ data.personality_score }} {{data.skills_score}} {{data.experience_score}} {{data.total_score}}