评论列表显示及排序，个人中心显示

显示所有评论
{% for foo in ques.comments %}

 

<ul class="list-group"style="margin:10px">
       {%for foo in ques.comments%}
       <li class="list-group-item">
           <span class="glyphicon lgyphicon-heart-empty" aira-hidden="true"></span>
           <a href="{{url_for('usercenter',user_id=foo.author_id)}}">{{foo.author.username}}</a>
           <span class="badge">{{foo.create_time}}</span>
           <p>{{foo.detail}}</p>
       </li>
       {%endfor%}
   </ul>
{% endblock %}

　　

所有评论排序
uquestion = db.relationship('Question', backref=db.backref('comments', order_by=creat_time.desc))

question=db.relationship('Question',backref=db.backref('comments',order_by=create_time.desc)

显示评论条数
{{ ques.comments|length }}

 <h4>评论:({{ ques.comments|length }})</h4>

@app.route('/usercenter/<user_id>')
@loginFirst
def usercenter(user_id):
    user=User.query.filter(User.id==user_id).first()
    context={
        'username':user.username,
        'questions':user.question,
        'comments':user.comments
    }
    return render_template('usercenter.html',**context)

　　

{% extends 'base.html'%}
{% block title %}个人中心{% endblock %}

{% block main%}
<div class="page-header">
    <h3> <span class="glyphicon glyphicon-user" aria-hidden="true"></span>{{username}}<br><small>全部问答<span class="bagde"></span></small>
    </h3>
    <ul class="list-group" style="">
        {%for foo in questions%}
        <li class="list-group-item">
            <span class="glyphicon glyphicon-heart-empty" aria-hidden="true"></span>
            <a href="{{url_for('usercenter',user_id=foo.author_id)}}">{{foo.author.username}}</a>
            <span class="badge">{{foo.create_time}}</span>
            <p>文章标题：{{ foo.title }}</p>
            <p>文章内容：{{foo.detail}}</p>
        </li>
        {% endfor %}
    </ul>
</div>

<div class="page-header" >
    <h3> <span class="glyphicon glyphicon-user" aria-hidden="true"></span>{{username}}<br><small>全部评论<span class="bagde"></span></small>
    </h3>
    <ul class="list-group" style="">
        {%for foo in comments%}
        <li class="list-group-item">
            <span class="glyphicon glyphicon-heart-empty" aria-hidden="true"></span>
            <a href="{{url_for('usercenter',user_id=foo.author_id)}}">{{foo.author.username}}</a>
            <span class="badge">{{foo.create_time}}</span>
            <p>文章标题：{{ foo.title }}</p>
            <p>评论内容：{{foo.detail}}</p>
        </li>
        {% endfor %}
    </ul>
</div>

<div class="page-header" style="">
    <h3> <span class="glyphicon glyphicon-user" aria-hidden="true"></span>{{username}}<br><small>个人信息<span class="bagde"></span></small>
    </h3>
    <ul class="list-group">
        <li class="list-group-item">用户：{{ username }}</li>
        <li class="list-group-item">编号：</li>
        <li class="list-group-item">昵称：</li>
        <li class="list-group-item">评论条数：{{ questions|length }}</li>

    </ul>
</div>

{% endblock %}