从首页问答标题到问答详情页
主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'))