完成评论功能-白红宇

完成评论功能

阅读量：4563 次

发布时间：2019-06-08

本文共 9647 字，大约阅读时间需要 32 分钟。

1. 定义评论的视图函数
  @app.route('/comment/',methods=['POST'])
  def comment()：
  读取前端页面数据，保存到数据库中
2. 用<input type="hidden" 方法获取前端的"question_id"
3. 显示评论次数
4. 要求评论前登录
5. 尝试实现详情页面下的评论列表显示

index.py

import configfrom flask import Flask, render_template, url_for, redirect, request,sessionfrom flask_sqlalchemy import SQLAlchemyfrom functools import wrapsfrom datetime import datetimeapp = Flask(__name__)app.config.from_object(config)db = SQLAlchemy(app)class User(db.Model):    __tablename__ = 'user'    id = db.Column(db.Integer, primary_key=True, autoincrement=True)    username = db.Column(db.String(20), nullable=False)    password = db.Column(db.String(20), nullable=False)    nickname = db.Column(db.String(20))class Question(db.Model):    __tablename__='question'    id=db.Column(db.Integer,primary_key=True,autoincrement=True)    title=db.Column(db.String(100),nullable=False)    detail=db.Column(db.Text,nullable=False)    creat_time=db.Column(db.DateTime,default=datetime.now)    author_id=db.Column(db.Integer,db.ForeignKey('user.id'))    author=db.relationship('User',backref=db.backref('question'))class Comment(db.Model):    __tablename__='comment'    id=db.Column(db.Integer,primary_key=True,autoincrement=True)    detail=db.Column(db.Text,nullable=False)    creat_time=db.Column(db.DateTime,default=datetime.now)    author_id=db.Column(db.Integer,db.ForeignKey('user.id'))    question_id = db.Column(db.Integer, db.ForeignKey('question.id'))    question = db.relationship('Question', backref=db.backref('comment', order_by=creat_time.desc))    author=db.relationship('User',backref=db.backref('comment'))db.create_all()@app.route('/')def shouye():    context={        'question':Question.query.all()    }    return render_template('shouye.html',**context)@app.route('/pinglun
     
      ')def pinglun(question_id):    quest = Question.query.filter(Question.id==question_id).first()    return render_template('pinglun.html',ques=quest)def log(func):    @wraps(func)    def wrapper(*args,**kwargs):        if session.get('user'):            return  func(*args,**kwargs)        else:            return render_template('denglu.html')    return wrapper@app.route('/commemt/',methods=['GET','POST'])@logdef comment():    if request.method=='GET':        return render_template(url_for('pinglun'))    else:        comment=request.form.get('new_comment')        ques_id=request.form.get('question_id')        auth_id=User.query.filter(User.username == session.get('user')).first().id        comment=Comment(author_id=auth_id,question_id=ques_id,detail=comment)        db.session.add(comment)        db.session.commit()        return redirect(url_for('pinglun',question_id=ques_id))@app.route('/zhuce',methods=['GET','POST'])def zhuce():    if request.method == 'GET':        return render_template('zhuce.html')    else:        username = request.form.get('username')        password = request.form.get('password')        nickname = request.form.get('nickname')        user1 = User.query.filter(User.username == username).first()    if user1:        return 'username existed'    else:        user1 = User(username=username, password=password, nickname=nickname)        db.session.add(user1)        db.session.commit()        return redirect(url_for('denglu'))@app.route('/denglu',methods=['GET','POST'])def denglu():    if request.method == 'GET':        return render_template('denglu.html')    else:        username = request.form.get('username')        password = request.form.get('password')        user=User.query.filter(User.username == username).first()    if user:        if user.password == password:            session['user'] = username            session.permanent = True            return redirect(url_for('shouye'))        else:            return 'password error'    else:        return 'username is not existed'@app.route('/logout/')def logout():    session.clear()    return redirect(url_for('shouye'))@app.route('/neirong',methods=['GET','POST'])@logdef fankui():    if request.method=='GET':        return render_template('fankui.html')    else:        title=request.form.get('title')        detail=request.form.get('detail')        author_id=User.query.filter(User.username==session.get('user')).first().id        question=Question(title=title,detail=detail,author_id=author_id)        db.session.add(question)        db.session.commit()        return redirect(url_for('shouye'))@app.context_processordef mycontext():    usern=session.get('user')    if usern:        return {
   'username':usern}    else:        return {}if __name__ == '__main__':    app.run(debug='True')

import configfrom flask import Flask, render_template, url_for, redirect, request,sessionfrom flask_sqlalchemy import SQLAlchemyfrom functools import wrapsfrom datetime import datetimeapp = Flask(__name__)app.config.from_object(config)db = SQLAlchemy(app)class User(db.Model):    __tablename__ = 'user'    id = db.Column(db.Integer, primary_key=True, autoincrement=True)    username = db.Column(db.String(20), nullable=False)    password = db.Column(db.String(20), nullable=False)    nickname = db.Column(db.String(20))class Question(db.Model):    __tablename__='question'    id=db.Column(db.Integer,primary_key=True,autoincrement=True)    title=db.Column(db.String(100),nullable=False)    detail=db.Column(db.Text,nullable=False)    creat_time=db.Column(db.DateTime,default=datetime.now)    author_id=db.Column(db.Integer,db.ForeignKey('user.id'))    author=db.relationship('User',backref=db.backref('question'))class Comment(db.Model):    __tablename__='comment'    id=db.Column(db.Integer,primary_key=True,autoincrement=True)    detail=db.Column(db.Text,nullable=False)    creat_time=db.Column(db.DateTime,default=datetime.now)    author_id=db.Column(db.Integer,db.ForeignKey('user.id'))    question_id = db.Column(db.Integer, db.ForeignKey('question.id'))    question = db.relationship('Question', backref=db.backref('comment', order_by=creat_time.desc))    author=db.relationship('User',backref=db.backref('comment'))db.create_all()@app.route('/')def shouye():    context={        'question':Question.query.all()    }    return render_template('shouye.html',**context)@app.route('/pinglun
     
      ')def pinglun(question_id):    quest = Question.query.filter(Question.id==question_id).first()    return render_template('pinglun.html',ques=quest)def log(func):    @wraps(func)    def wrapper(*args,**kwargs):        if session.get('user'):            return  func(*args,**kwargs)        else:            return render_template('denglu.html')    return wrapper@app.route('/commemt/',methods=['GET','POST'])@logdef comment():    if request.method=='GET':        return render_template(url_for('pinglun'))    else:        comment=request.form.get('new_comment')        ques_id=request.form.get('question_id')        auth_id=User.query.filter(User.username == session.get('user')).first().id        comment=Comment(author_id=auth_id,question_id=ques_id,detail=comment)        db.session.add(comment)        db.session.commit()        return redirect(url_for('pinglun',question_id=ques_id))@app.route('/zhuce',methods=['GET','POST'])def zhuce():    if request.method == 'GET':        return render_template('zhuce.html')    else:        username = request.form.get('username')        password = request.form.get('password')        nickname = request.form.get('nickname')        user1 = User.query.filter(User.username == username).first()    if user1:        return 'username existed'    else:        user1 = User(username=username, password=password, nickname=nickname)        db.session.add(user1)        db.session.commit()        return redirect(url_for('denglu'))@app.route('/denglu',methods=['GET','POST'])def denglu():    if request.method == 'GET':        return render_template('denglu.html')    else:        username = request.form.get('username')        password = request.form.get('password')        user=User.query.filter(User.username == username).first()    if user:        if user.password == password:            session['user'] = username            session.permanent = True            return redirect(url_for('shouye'))        else:            return 'password error'    else:        return 'username is not existed'@app.route('/logout/')def logout():    session.clear()    return redirect(url_for('shouye'))@app.route('/neirong',methods=['GET','POST'])@logdef fankui():    if request.method=='GET':        return render_template('fankui.html')    else:        title=request.form.get('title')        detail=request.form.get('detail')        author_id=User.query.filter(User.username==session.get('user')).first().id        question=Question(title=title,detail=detail,author_id=author_id)        db.session.add(question)        db.session.commit()        return redirect(url_for('shouye'))@app.context_processordef mycontext():    usern=session.get('user')    if usern:        return {
   'username':usern}    else:        return {}if __name__ == '__main__':    app.run(debug='True')

pinglun.html

    {% extends "text.html" %}    
         Title    
     {% block pinglun %}
     
        
       {
   { ques.title }}
      
  
            
       {
   { ques.author.username }} {
   { ques.creat_time }}
      
       
      
       {
   { ques.detail }}
      
       
       
             
            
         
         
          
                     
                 
        
       
       
  
      
      评论：
      
           {% for com in ques.comment %}    
       {
   { com.author.username }}    
       {
   { com.creat_time }}    
       {
   { com.detail }}
    {% endfor %}
      
     
{% endblock %}