主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=Question.query.filter(Question.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=a.id) }}">{{ a.question }}</a><br><br>
在详情页将数据的显示在恰当的位置。
{{ ques.title}}
{{ ques.id }}{{ ques.creat_time }}
{{ ques.author.username }}
{{ ques.detail }}
{% extends 'index.html' %}
{% block title %}问答详情{% endblock %}
{% block main %}
<body style="url(../image/picture.jpg) no-repeat" >
<div class="container">
<div class="box">
<h3 style="font-family:宋体;text-align: left;font-size: 40px">详情页</h3>
</div>
<div>
<h2>{{ ques.question }}<br><small>{{ ques.author.username }} <span class="badge">{{ ques.creat_time }}</span></small></h2></div>
问题详情:<p class="lead">{{ ques.questionDetail }}</p>
<p class="location">评论</p>
<hr>
<form action="{{ url_for('question') }}" method="post">
<div>
<textarea class="form-control" id="new_comment" rows="6" placeholder="write your comment"style="height:200px;width:800px" ></textarea><br></div>
<button type="submit" class="fabu"style="width:100px">发布</button>
</form>
<ul class="list-group" style="margin: 10px"></ul>
</div>
</body>
{% endblock %}
建立评论的对象关系映射:
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'))
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'))
尝试实现发布评论。