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

1、主PY文件写视图函数，带id参数。 

@app.route('/detail/<question_id>')  # 和idea的update一样，将id带到控制器
def detail(question_id):
    fa = Question.query.filter(Question.id == question_id).first()  # 根据id查询出整条元组记录，丢进fa
    return render_template('detail.html', fa=fa)  # 把值fa丢进键fa，在fabuview.html页面调用

 

2、首页标题的标签做带参数的链接

3、在详情页将数据的显示在恰当的位置。

           <ul class="list-unstyled">
                {% for foo in question %}
                <li class="list-group-item-success">
                    <a href="#">{{ foo.author.username }}</a>
                    <h4 class="text-center"><a href="{{ url_for('detail',question_id=foo.id) }}">{{ foo.title }}</a>
                    </h4>
                    <span class="badge pull-right">{{ foo.creat_time }}</span>
                    <br>
                    <p>{{ foo.detail }}</p>
                </li>
                {% endfor %}
            </ul>

4、建立评论的对象关系映射

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'))
    detail = db.Column(db.Text, nullable=False)
    crea_time = db.Column(db.DateTime, default=datetime.now)
    author = db.relationship('User', backref=db.backref('comment'))
    question = db.relationship('Question', backref=db.backref('comment'))