从首页问答标题到问答详情页

    1. 主PY文件写视图函数,带id参数。 
      @app.route('/detail/<question_id>')
      def detail(question_id):
          quest = 
          return render_template('detail.html', ques = quest) 
    2. 首页标题的标签做带参数的链接。
            {{ url_for('detail',question_id = foo.id) }}

    3. 在详情页将数据的显示在恰当的位置。 
      {{ ques.title}}
      {{ ques.id  }}{{  ques.creat_time }}
      {{ ques.author.username }} 
      {{ ques.detail }}
    4. 建立评论的对象关系映射:

      class Comment(db.Model):
          __tablename__='comment'

    5.  尝试实现发布评论。

@app.route('/questionDetail/<question_id>')
def questionDetail(question_id):
    quest=Question.query.filter(Question.id==question_id).first()
    return render_template('questionDetail.html',ques=quest)
<div class="title_author_time">
{#    <a href="#" id="title">title</a>#}
        {{ ques.title }}<br>{{ ques.author.username }}
        <span class="badge">{{ ques.creat_time }}</span>
{#        <p>{{ username }}#}
{#    <a href="#" id="time">creat_time</a>#}
    </div>
    <p class="lead">{{ ques.detail }}</p>
    <hr>

index.html

<div class="list-container">
            <ul class="news-list">
                {% for foo in questions %}

                    <li style="padding-left: 0px; padding-right: 10px; box-shadow: rgba(0, 0, 0, 0.5) 0px 0px 0px 0px;">
                        <span class="glyphicon glyphicon-leaf" aria-hidden="true"></span>
                        <a href="#">{{ foo.author.username }}</a>
                        <br>
                        <a href=" {{ url_for('questionDetail',question_id=foo.id)}}">{{ foo.title }}</a>
                        <span class="badgs">{{ foo.creat_time }}</span>
                        <p>{{ foo.detail}}</p>
                    </li>
                {% endfor %}
            </ul>
</div>

创建表:

class Comment(db.Model):
    __tablename__ = 'comment'
    id=db.Column(db.Integer,primary_key=True,autoincrement=True)
    author_id = db.Column(db.Integer, db.ForeignKey('user_test.id'))
    question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
    detail = db.Column(db.Text,nullable=False)
    creat_time = db.Column(db.DateTime,default=datetime.now)
    question = db.relationship('Question',backref=db.backref('comments'))
    author = db.relationship('User',backref=db.backref('comments'))

 

posted @ 2017-12-07 12:41  091王卡  阅读(126)  评论(0编辑  收藏  举报