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

主PY文件写视图函数,带id参数。 

@app.route('/detail/<question_id>')
def detail(question_id):
    quest = 
    return render_template('detail.html', ques = quest)
@app.route('/detail/<question_id>')
def detail(question_id):
    quest = Ques.query.filter(Ques.id==question_id).first()
    return  render_template('detail.html',ques=quest)

首页标题的标签做带参数的链接。
      {{ url_for('detail',question_id = foo.id) }}

 <a href="{{ url_for('detail',question_id = foo.id) }}"><h4
                                    class="list-group-item-heading">{{ foo.title }}</h4></a>
<div class="container">
        <div class="row clearfix">
            <div class="col-md-3 column">
            </div>
            <div class="col-md-6 column">
                <div class="row clearfix">
                    <div class="col-md-12 column">
                        <h3>
                            {{ ques.title }}
                        </h3> <span class="label label-default">{{ ques.author.username }}</span> <span
                            class="label label-default">{{ ques.create_time }}</span>
                    </div>
                </div>
                <div class="row clearfix">
                    <div class="col-md-12 column">
                        <p>
                            {{ ques.detail }}
                        </p>
                    </div>
                </div>
                <div class="row clearfix">
                    <div class="col-md-12 column">
                        <textarea id="comment" name="comment" rows="5" cols="83" placeholder="请输入评论"></textarea>
                    </div>
                    <br /><br /><br /><br />
                    <button type="button" class="btn btn-default btn-block">发送</button>
                </div>
                <div class="row clearfix">

                </div>
            </div>
            <div class="col-md-3 column">
            </div>
        </div>
    </div>
    1. 建立评论的对象关系映射:

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

      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.id'))
          question_id = db.Column(db.Integer,db.ForeignKey('question.id'))
          create_time = db.Column(db.DateTime,default=datetime.now)
          detail = db.Column(db.Text,nullable=False)
          question = db.relationship('Ques',backref = db.backref('comments'))
          author = db.relationship('User',backref = db.backref('comments'))

       

 

posted on 2017-12-05 23:43  学徒小梁  阅读(90)  评论(0编辑  收藏  举报