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

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

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

def detailpage(question_id):
    quest=Question.query.filter(Question.id==question_id).first()

    return render_template('detailpage.html',ques=quest)

 

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

  <div class="juli">
        {#<ul>
        <a class="author">{{ author}}</a>
        <a class="create_time">{{ create_time }}</a><br>
        <h3 class="title">{{ title}}</h3>
        <a class="detail">{{ detail}}</a>
    </ul>#}
    <ul>
        {% for foo in questions %}
            <li>
                <img id="tubiao" src="{{ url_for('static',filename='images/pl.jpg') }}">
                <a href="#">{{ foo.author.Username }}</a>
                <a class="creat_time" href="#">{{ foo.creat_time }}</a>
                <p class="title" href="#" onclick="window.location.replace({{ url_for('detailpage')}})">{{ foo.title }}</p>
{#                <p class="title" href="{{ url_for('detailpage')}}">{{ foo.title }}</p>#}
                <p class="abstract">{{ foo.detail }}</p>
            </li>
        {% endfor %}</ul>
    </div>

 

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

{{ ques.title}}
{{ ques.id  }}{{  ques.creat_time }}

{{ ques.author.username }} 
{{ ques.detail }}

       <div class="xianshi">
                    <h3>{{ ques.title }}<br><small>{{ ques.author.Username }}
                    <span class="badge">{{ ques.creat_time }}</span></small></h3></div>
                    <p class="lead">{{ ques.detail }}</p>
            <hr>
        <form action="{{ url_for('comment') }}" method="post">
            <h4>评论:({{ ques.comments|lenght }})</h4>
        </form>
        <div class="ping">
            <div class="pinglun"><label for="comment">评论</label><br></div>
            <textarea id="comment" rows="12" name="commentdetail"></textarea></div>
        <input type="submit" class="fasong" value="发送评论">
    </div>

 

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

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'))#外键
    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'))

 

5. 尝试实现发布评论。