主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>
-
建立评论的对象关系映射:
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'))