作业31——从首页问答标题到问答详情页

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

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

3. 首页标题的标签做带参数的链接。
   1. {{ url_for('detail',question_id = foo.id) }}
4. 在详情页将数据的显示在恰当的位置。

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

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

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

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

   2.  尝试实现发布评论。

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

首页

<div>
        <ul class="news-list">
            {% for foo in questions %}
                <li class="list-group-item">
                    <span class="glyphicon glyphicon-leaf" aria-hidden="true"></span>
                    <a href="{{ url_for('detail',question_id=foo.id) }}" class="title">{{ foo.title }}</a>
                    <p class="detail">{{ foo.detail }}</p>
                    <span class="glyphicon glyphicon-leaf" aria-hidden="true"></span>
                    <a href="#">{{ foo.author.username }}</a>
                    <span class="badge">{{ foo.creat_time }}</span>
                </li>
            {% endfor %}
        </ul>
    </div>

detail.html

<div class="container">
        <div class="row clearfix">
            <div class="page-header">
                <h3>{{ quest.title }}<br>
                    <small>{{ quest.author.username }} <span class="badge">{{ quest.creat_time }}</span></small>
                </h3>
            </div>
            <p class="lead">{{ quest.detail }}</p>
            <hr>

            <form role="form" action="" method="post">
                <div class="form-group">
                    <label for="exampleInputEmail1">Write down your answer~~</label><input type="email"
                                                                                           class="form-control"
                                                                                           id="exampleInputEmail1"/>
                </div>
                <button type="submit" class="btn btn-default">Submit</button>
            </form>

<h4>评论：({{ quest.comments|length }})</h4>
{% for foo in comment %}
    <li class="list-group-item">
        <span class="glyphicon glyphicon-leaf" aria-hidden="true"></span>
        <p class="detail">{{ foo.detail }}</p>
        <a href="#">{{ foo.author.username }} </a>
        <span class="badge">{{ foo.creat_time }}</span>
    </li>

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