从首页问答标题到问答详情页
主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) }}
{% extends 'base.html' %} }
{% block title %}首页{% endblock %}
{% block main %}
<p>{{ username }}用户,welcome</p>
<h1></h1>
<h2>欢迎光临</h2>
<ul class="list-group">
{% for foo in questions %}
<li style="box-shadow: #cccccc" class="list-group-item">
<span class="glyphicon glyphicon-leaf" aria-hidden="true"></span>
<a href="">{{foo.author.username}})</a>
<br>
<a href="{{ url_for('detail',question_id=foo.id) }}" class="title">{{foo.title}}</a>
<br>
<span class="badge">{{foo.creat_time}}</span>
<p class="detail">{{foo.detail}}</p>
</li>
{% endfor %}
</ul>
{% endblock %}
<!--评论:({{foo.comments.length }}-->
<!--<a href="{{url_for('usercenter',user_id = foo.author_id)}}">{{foo.author.username}}评论:({{foo.comments.length }})</a>-->
在详情页将数据的显示在恰当的位置。
{{ ques.title}}
{{ ques.id }}{{ ques.creat_time }}
{{ ques.author.username }}
{{ ques.detail }}
{% extends'base.html' %}
{% block title %}
问答详情
{% endblock %}
{% block head %}
<!-- 引入 Bootstrap -->
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
{% endblock %}
{% block main %}
<h3 >问题详情</h3>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<h3 class="text-center">
{{ques.title}}<br>
<small>{{ques.author.username}}
</small>
<span>{{ques.creat_time}}</span>
</h3>
<p class="text-center">
{{ques.detail}}
</p>
<form role="form">
<div class="form-group">
<label for="exampleInputEmail1">Write down your comment</label>
<input type="email" class="form-control" id="exampleInputEmail1" />
</div>
<button type="submit" class="btn btn-default">提交</button>
<br>
</form>
</div>
</div>
</div>
{% endblock %}
<!--{{ques.title}} {{ques.author.username}} {{ques.creat_time}} {{ques.detail}}-->
<!--pinglun:({{ques.comment[length}})-->
建立评论的对象关系映射:
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'))
creat_time = db.Column(db.DateTime,default=datetime.now)
detail = db.Colunmn(db.Text , nullable=False)
question = db.relationship('Question',backref = db.backref('comments'))
author = db.relationship('User',backref = db.backref('comments'))
尝试实现发布评论。

浙公网安备 33010602011771号