{% block main %}
<P align="center" style="background-color:rgba(255,255,0,0.25)">{{username}}请登录</P>
<ur class="sss" style="background-color:rgba(255,255,0,0.25)">
{% for foo in fankui %}
<li class="list">
<span class="glyphicon" aria-hidden="true"></span>
<a href="#">{{foo.author.username}}</a>
<br>
<a href="{{url_for('详情页',fankui_id = foo.id )}}">{{foo.biaoti}}</a>
<span class="badge">{{foo.creat_time}} </span>
<p>{{foo.questionDetail}}</p>
</li>
{% endfor %}
</ur>
{% endblock %}
{% block main %}
<div class="container" align="center">
<div class="row clearfix">
<div class="col-md-4 column">
</div>
<div class="col-md-4 column">
<div class="page-header">
<h1>
{{ ques.biaoti }} <small>{{ ques.author.username }}</small>
</h1>
</div>
<p>
detail {{ ques.creat_time }}
</p>
<form action="{{url_for('fankui')}}" method="post">
</form>
<p>
<a class="btn" href="#">{{ ques.questionDetail }}<br></a>
</p>
<form role="form">
<div class="form-group">
<h3>评论:({{ques.comments|length}})</h3>
<textarea class="form-control" id="questionDetail" cols="30" rows="5" name="questionDetail"></textarea>
</div>
<div class="input-area">
<button onclick="return fnLogin()">fabu</button>
</div>
</form>
</div>
<div class="col-md-4 column">
</div>
</div>
</div>
def danghangye():
context = {
'fankui':Fankui.query.order_by('creat_time').all()
}
return render_template('danghangye.html',**context)
@app.route('/详情页/<fankui_id>')
def 详情页(fankui_id):
quest=Fankui.query.filter(Fankui.id == fankui_id).first()
return render_template('详情页.html',ques = quest)
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'))