完成评论功能

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

from flask import Flask, render_template, request, redirect, url_for, session
from flask_sqlalchemy import SQLAlchemy
import config

app = 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)


# db.create_all()





@app.route('/')
def base():
    return render_template('base.html')


@app.route('/shouye/')
def shouye():
    return render_template('shouye.html')


@app.route('/login/', methods=['GET', 'POST'])
def login():
    if request.method == 'GET':
        return render_template('login.html')
    else:
        usern = request.form.get('username')
        passw = request.form.get('password')
        user = User.query.filter(User.username == usern).first()
        if user:
            if user.password == passw:
                session['user'] = usern
                return redirect(url_for('shouye'))
            else:
                return u'password error'
        else:
            return u'username is not existed.'


@app.context_processor
def mycontext():
    usern = session.get('user')
    if usern:
        return {'username': usern}
    else:
        return {}


@app.route('/logout')
def logout():
    session.clear()
    return redirect(url_for('shouye'))


@app.route('/zhuce/', methods=['GET', 'POST'])
def zhuce():
    if request.method == 'GET':
        return render_template('zhuce.html')
    else:
        usern = request.form.get('username')
        passw = request.form.get('password')
        user = User.query.filter(User.username == usern).first()
        if user:
            return u'username existed'
        else:
            user1 = User(username=usern, password=passw)
            db.session.add(user1)
            db.session.commit()
            return redirect(url_for('login'))


@app.route('/wenda/')
def wenda():
    return render_template('wenda.html')


@app.route('/')
def lx():
    context = {
        'question': Ques.query.all()

    }
    return render_template('lx3.html', **context)


@app.route('/detail/')
def detail():
    # quest=Ques.query.filter(Ques.id == Ques_id).first()
    return render_template('detail.html')
@app.route('/comment/', methods=['POST'])
@log
def comment():
    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
    comm=Comment(author_id=auth_id,question_id=ques_id,detail=comment)
    db.session.add(comm)
    db.session.commit()
    return redirect(url_for('detail',question_id=ques_id))


if __name__ == '__main__':
    app.run(debug=True)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>
        {% block logintitle %}{% endblock %}
        {% block registertitle %}{% endblock %}
       啦啦啦</title>

    <link rel="stylesheet" type="text/css" href="{{ url_for('static',filename='css/base.css') }}">
    <script src ="{{ url_for('static',filename='js/base.js') }}"></script>
{% block head %}
{% endblock %}
</head>
<body id="myBody">

<nav>
    

    <img id="myOnOff" onclick="mySwitch()" 
src="https://www.runoob.com/images/pic_bulbon.gif"　height="20" width="20px">
    <a href="{{ url_for('shouye') }}">首页</a>
    <a href="{{ url_for('wenda') }}">发布问答</a>
    <a href="{{ url_for('shouye') }}">听一听</a>

    <input type="text" name="search">
    <button type="submit">看一看</button>

        <ul class="nav nav-tabs">
            <li><a href="{{ url_for('lx') }}">首页</a></li>
 

    {% if username %}
         <a class="right" href="#">{{ username }}</a>
         <a href="{{ url_for('logout') }}">注销</a>
    {% else %}
         <a class="right" href="{{ url_for('login') }}">登录</a>
         <a href="{{ url_for('zhuce') }}">注册</a>
    {% endif %}

</nav>
{% extends 'base.html' %}
{% block title %}
    问答详情
{% endblock %}
{% block main %}
    <div class="box">
        <h3 href="#" >{{ ques.title }}</h3>
        <small> {{ ques.author.username }}<span class="badge" style="margin-left: 75%">{{ ques.create_time }}</span></small>
        <hr>
        <p>{{ ques.detail }}</p>
        <hr>
        <form action="{{ url_for('comment') }}" method="post">
            <div><textarea class="form-control" id="comment" rows="3" style="margin-left: 1%" name="comment" placeholder="write your comment"></textarea><br></div>
            <input type="hidden" name="question_id" value="{{ ques.id }}">
            <button type="submit" >发送</button>
        </form>
      <h4>评论:（{{ ques.comment|length }}）</h4>
         <ul class="list-unstyled">
            {% for foo in comments %}
                <li class="list-group-item">
                    <a>{{ foo.author.username }}</a>
                    <span class="badge pull-right">{{ foo.create_time }}</span>
                    <p>{{ foo.detail }}</p>
                    <br>
                </li>
            {% endfor %}
        </ul>

    </div>
{% endblock %}


    {% block loginhead %}{% endblock %}
    {% block registerhead %}{% endblock %}





    <p class="text1">哈哈哈<br>
   by：厚脸皮羊
    </p>

</body>
</html>

posted @ 2017-12-08 21:59 201506050096谢阳阅读(107) 评论(0) 收藏举报

刷新页面返回顶部

20150605096谢阳

完成评论功能

公告