Flask开发实现在线问答系统的点赞评论模块

绝地灬酷狼 2022-10-12 05:48 216阅读 0赞

# 前言 #

实现评论模块

--------------------

# 实现答案评论功能开发 #

from flask import Blueprint, render_template, request, abort, redirect, url_for, flash, jsonify
    from flask_login import login_required, current_user
    
    from models import Question, Answer, AnswerComment, db
    from qa.forms import WriteQuestionForm, WriteAnswerForm
    
    qa = Blueprint('qa', __name__,
                   template_folder='templates',
                   static_folder='../assets')
    
    
    @qa.route('/')
    def index():
        """ 首页 回答列表 """
        per_page = 20  # 每页数据的大小
        page = int(request.args.get('page', 1))
        page_data = Answer.query.filter_by(is_valid=True).paginate(
            page=page, per_page=per_page)
        return render_template('index.html', page_data=page_data)
    
    
    @qa.route('/follow')
    def follow():
        """ 关注 问题列表 """
        per_page = 20  # 每页数据的大小
        page = int(request.args.get('page', 1))
        page_data = Question.query.filter_by(is_valid=True).paginate(
            page=page, per_page=per_page)
        return render_template('follow.html', page_data=page_data)
    
    
    @qa.route('/qa/list')
    def question_list():
        """ 查询问题数据列表
        // json
        { 
            'code': 0,
            'data': ''
        }
        """
        try:
            per_page = 2  # 每页数据的大小
            page = int(request.args.get('page', 1))
            page_data = Question.query.filter_by(is_valid=True).paginate(
                page=page, per_page=per_page)
            data = render_template('qa_list.html', page_data=page_data)
            return { 'code': 0, 'data': data}
        except Exception as e:
            print(e)
            data = ''
        return { 'code': 1, 'data': ''}
    
    
    @qa.route('/write', methods=['GET', 'POST'])
    @login_required
    def write():
        """ 写文章，提问 """
        form = WriteQuestionForm()
        if form.validate_on_submit():
            try:
                que_obj = form.save()
                if que_obj:
                    flash('发布问题成功', 'success')
                    return redirect(url_for('qa.index'))
            except Exception as e:
                print(e)
            flash('发布问题失败，请稍后重试', 'danger')
        return render_template('write.html', form=form)
    
    
    @qa.route('/detail/<int:q_id>', methods=['GET', 'POST'])
    def detail(q_id):
        """ 问题详情 """
        # 1. 查询问题信息
        question = Question.query.get(q_id)
        if not question.is_valid:
            abort(404)
        # 2. 展示第一条回答信息
        answer = question.answer_list.filter_by(is_valid=True).first()
        # 添加回答
        form = WriteAnswerForm()
        if form.validate_on_submit():
            try:
                if not current_user.is_authenticated:
                    flash('请先登录', 'danger')
                    return redirect(url_for('accounts.login'))
                form.save(question=question)
                flash('回答问题成功', 'success')
                return redirect(url_for('qa.detail', q_id=q_id))
            except Exception as e:
                print(e)
        return render_template('detail.html',
                               question=question,
                               answer=answer,
                               form=form)
    
    
    @qa.route('/comments/<int:answer_id>', methods=['GET', 'POST'])
    def comments(answer_id):
        """ 评论 """
        answer = Answer.query.get(answer_id)
        if request.method == 'POST':
            # 添加评论
            try:
                if not current_user.is_authenticated:
                    result = { 'code': 1, 'message': '请登录'}
                    return jsonify(result), 400
                # 1. 获取数据
                content = request.form.get('content', '')
                # 2. 保存到数据库
                question = answer.question
                comment_obj = AnswerComment(content=content,
                                            user=current_user,
                                            answer=answer,
                                            question=question
                                            )
                db.session.add(comment_obj)
                db.session.commit()
                return '', 201
            except Exception as e:
                result = { 'code': 1, 'message': '服务器正忙，请稍后重试'}
                return jsonify(result), 400
        else:
            # 获取评论列表
            pass

{ % extends 'base_layout.html' %}
    { % block title %}{ {  super() }} - 文章详情{ % endblock %}
    { % block header %}
      <link rel="stylesheet" href="/assets/style/detail.css">
      { % endblock %}
    { % block content %}
      
      <div class="layout-question">
        <div class="container">
          <div class="row">
            <div class="col-md-9">
            { % include 'components/flash_messages.html' %}
              
            { % if question.tags %}
              <ul class="que-tag-ls">
                { % for tag in question.tags %}
                <li><a href="#">{ {  tag.tag_name }}</a></li>
                { % endfor %}
              </ul>
            { % endif %}
              
              <h3>{ {  question.title }}</h3>
              <div class="show-desc hidden">
                { {  question.desc|d('暂无', True) }}…
                <span class="btn-show-more">显示全部<i class="glyphicon glyphicon-menu-down"></i></span>
              </div>
              <div class="show-all ">
                { % autoescape false %}
                { {  question.content|safe }}
                { % endautoescape %}
                <span class="btn-show-less">收起<i class="glyphicon glyphicon-menu-up"></i></span>
              </div>
              
              <div class="qa-footer">
                <div>
                  <button type="button" class="btn btn-info btn-sm">关  注</button>
                </div>
                <div>
                  <button type="button" class="btn btn-info btn-sm" data-toggle="modal" data-target="#addComment">写回答</button>
                </div>
                <div class="txt-menu"><i class="glyphicon glyphicon-comment"></i> { {  question.comment_count }}条评论</div>
                <div class="txt-menu"><i class="glyphicon glyphicon-send"></i>分享</div>
                <div class="txt-menu"><i class="glyphicon glyphicon-flag"></i>举报</div>
                <div class="txt-menu"></div>
                <div class="txt-menu btn-group">
                  <i class="glyphicon glyphicon-option-horizontal dropdown-toggle" data-toggle="dropdown"
                    aria-haspopup="true" aria-expanded="false"></i>
                  <ul class="dropdown-menu">
                    <li><a href="#">不感兴趣</a></li>
                  </ul>
                </div>
              </div>
              
            </div>
            <div class="col-md-3">
              <div class="que-stats-box">
                
                <div>
                  <span>关注者</span>
                  <strong>{ {  question.follow_count|number_split }}</strong>
                </div>
                
                
                <div>
                  <span>被浏览</span>
                  <strong>{ {  question.view_count|number_split }}</strong>
                </div>
                
              </div>
            </div>
          </div>
        </div>
      </div>
      
    
      <div class="layout-answer">
        <div class="container">
          <div class="row">
            <div class="col-md-9 left-content">
              { % block link_more %}
              <a class="link-more" href="#">查看全部 { {  question.answer_count|number_split }} 个回答</a>
              { % endblock %}
              
              { % if answer %}
              <div class="answer-content box-wrap">
                <div class="user-info">
                  <div class="avater">
                    { % if answer.user.avatar %}
                      <img src="{ { answer.user.avatar }}" alt="用户头像">
                    { % else %}
                      <img src="/assets/home/qa/user_head.jpg" alt="用户头像">
                    { % endif %}
                  </div>
                  <div class="desc">
                    <h4>{ {  answer.user.nickname }}</h4>
                    <p>{ {  answer.user.profile.maxim }}</p>
                  </div>
                </div>
                <div class="answer-stats">5,550 人赞同了该回答</div>
                <div class="answer-txt">
                  { % autoescape false %}
                  { {  answer.content|safe }}
                  { % endautoescape %}
                </div>
                <div class="answer-time">发布于{ {  answer.created_at }}</div>
                
                <div class="qa-footer">
                  <div><button type="button" class="btn btn-info btn-sm">
                      <i class="glyphicon glyphicon-thumbs-up"></i> 赞同 { {  answer.love_count }}</button>
                    <button type="button" class="btn btn-info btn-sm"><i
                        class="glyphicon glyphicon-thumbs-down"></i></button>
                  </div>
                  <div class="txt-menu"><i class="glyphicon glyphicon-comment"></i> 113条评论</div>
                  <div class="txt-menu"><i class="glyphicon glyphicon-send"></i>分享</div>
                  <div class="txt-menu"><i class="glyphicon glyphicon-heart"></i>收藏</div>
                  <div class="txt-menu"><i class="glyphicon glyphicon-flag"></i>举报</div>
                  <div class="txt-menu"></div>
                  <div class="txt-menu btn-group">
                    <i class="glyphicon glyphicon-option-horizontal dropdown-toggle" data-toggle="dropdown"
                      aria-haspopup="true" aria-expanded="false"></i>
                    <ul class="dropdown-menu">
                      <li><a href="#">不感兴趣</a></li>
                    </ul>
                  </div>
                </div>
                
                
                <div class="comment-box box-wrap">
                  
                  <div class="comment-stats">
                    <div class="title">8条评论</div>
                    <div class="menu"><i class="glyphicon glyphicon-random"></i>切换为时间顺序</div>
                  </div>
                  
                  
                  <div class="comment-ls">
                    <div class="comment-item">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                    <div class="comment-item">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish hidden">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                    <div class="comment-item">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish hidden">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                    <div class="comment-item reply">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish hidden">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                    <div class="comment-item">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish hidden">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                    <div class="comment-item">
                      <div class="header">
                        <div class="user-info">
                          <img class="avater" src="/assets/home/qa/user_head.jpg" alt="">
                          <strong class="uname">用户昵称</strong>
                        </div>
                        <div class="time">2小时前</div>
                      </div>
                      <div class="body">
                        不能这么说，是他们的眼界让他们不能接受。现在中国做到的事是让他们世界观崩塌的事[飙泪笑][飙泪笑]
                      </div>
                      <div class="footer">
                        <div><i class="glyphicon glyphicon-thumbs-up"></i> 5</div>
                        <div><i class="glyphicon glyphicon-share-alt"></i> 回复</div>
                        <div><i class="glyphicon glyphicon-thumbs-down"></i> 踩</div>
                        <div><i class="glyphicon glyphicon-flag"></i> 举报</div>
                      </div>
                      
                      <form class="form-horizontal comment-publish hidden">
                        <input type="text" class="form-control" placeholder="写下你的评论...">
                        <button type="button" class="btn btn-default btn-grey">发布</button>
                      </form>
                      
                    </div>
                  </div>
                  
                  
                  <form class="form-horizontal comment-publish">
                    <input type="text" name="content" class="form-control" placeholder="写下你的评论...">
                    <button type="button" class="btn btn-default btn-grey">发布</button>
                  </form>
                  
                </div>
                
              </div>
              { % else %}
                <div class="answer-content box-wrap">
                暂无人回答该问题
                </div>
              { % endif %}
              
              { {  self.link_more() }}
            </div>
            <div class="col-md-3 right-content">
              
              <div class="about-user box-wrap">
                <div class="user-info">
                  <div class="avater">
                    <img src="/assets/home/qa/user_head.jpg" alt="用户头像">
                  </div>
                  <div class="desc">
                    <h4>舒大克</h4>
                    <p>《互联网营销人实战手记》新书上市； 公众号：舒大克。</p>
                  </div>
                </div>
                
                <div class="qa-stats">
                  <div>
                    <span>回答</span>
                    <strong>309</strong>
                  </div>
                  <div>
                    <span>文章</span>
                    <strong>40</strong>
                  </div>
                  <div>
                    <span>关注者</span>
                    <strong>85,265</strong>
                  </div>
                </div>
                
                <div class="menu-ls">
                  <div>
                    <a href="#" class="btn btn-info btn-sm"><i class="glyphicon glyphicon-plus"></i>关注他</a>
                  </div>
                  <div>
                    <a href="#" class="btn btn-default btn-sm btn-grey"><i class="glyphicon glyphicon-comment"></i>发私信</a>
                  </div>
                </div>
              </div>
              
              
              <div class="rel-ques box-wrap">
                <div class="title">相关问题</div>
                <div class="rel-que-ls">
                  <div>
                    <a href="#">疫情过后，你会报复性消费吗？</a><span>30 个回答</span>
                  </div>
                  <div>
                    <a href="#">疫情过后你最想去哪？和谁一起？</a><span>19 个回答</span>
                  </div>
                  <div>
                    <a href="#">如果能熬过这波疫情，你最想做的事情是什么？</a><span>21 个回答</span>
                  </div>
                  <div>
                    <a href="#">请问这次疫情可能有积极影响吗？</a><span>9 个回答</span>
                  </div>
                  <div>
                    <a href="#">如果疫情结束了你最想做什么？</a><span>3 个回答</span>
                  </div>
                </div>
              </div>
              
              
              <div class="right-footer">
                <a href="#">用户指南</a><span class="dot">·</span>
                <a href="#">用户使用协议</a><span class="dot">·</span>
                <a href="#">用户隐私权政策</a>
                <br />
                <a href="#">侵权举报</a><span class="dot">·</span>
                <a href="#">网上有害信息举报专区</a>
                <br />
                <a href="#">京ICP证 第10001000号</a>
                <br />
                <a href="#">京ICP备 第10001000号</a>
                <br />
                <a href="#">联系我们 © 2020在线问答</a>
              </div>
              
            </div>
          </div>
        </div>
      </div>
      <div class="layout-footer">
        <a href="#" data-toggle="tooltip" title="意见反馈"><i class="glyphicon glyphicon-briefcase"></i></a>
        <a href="#" data-toggle="tooltip" title="回到顶部"><i class="glyphicon glyphicon-arrow-up"></i></a>
      </div>
      
      <div class="modal fade" id="addComment" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
        <form class="form-horizontal modal-dialog" role="document"
              method="post" action="{ { url_for('qa.detail', q_id=question.id) }}">
          { {  form.csrf_token }}
          <div class="modal-content">
            <div class="modal-header">
              <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
              <h4 class="modal-title" id="myModalLabel">写回答</h4>
            </div>
            <div class="modal-body">
              <div class="form-group">
                { {  form.content }}
                { {  ckeditor.load() }}
                { {  ckeditor.config(name='content') }}
              </div>
            </div>
            <div class="modal-footer">
              <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
              <button type="submit" class="btn btn-primary">提交</button>
            </div>
          </div>
        </form>
      </div>
      
    { % endblock %}
    { % block js_inline %}
          // 点击，查看更多，把详细的那个p标签展示出来，把自己隐藏
          $('.show-desc').click(function () { 
            $(this).addClass('hidden');
            $(this).next().removeClass('hidden')
          })
          $('.show-all').click(function () { 
            $(this).addClass('hidden');
            $(this).prev().removeClass('hidden')
          })
    { % endblock %}
    { % block js_extra %}
      <script>
        $(function(){ 
            var form = $('.comment-publish');
            $('.btn', form).click(function() { 
                var _form =$(this).parent()
                var content = $('input[name=content]', _form)
                $.ajax({ 
                  url: '{ { url_for("qa.comments", answer_id=answer.id) }}',
                  method: 'post',
                  data: { 
                      content: content.val()
                  },
                  complete: function(res){ 
                    console.log('res:', res)
                    if(res.status === 201) { 
                        window.alert('评论成功');
                        content.val('')
                    }else if (res.status === 400) { 
                        window.alert(res.responseJSON.message);
                    } else { 
                        window.alert('请求失败, 请稍后重试');
                    }
                  }
              })
            })
    
        })
      </script>
    { % endblock %}

# 评论及回复列表加载\_ #

from datetime import datetime
    
    from flask_sqlalchemy import SQLAlchemy
    
    from utils import constants
    
    db = SQLAlchemy()
    
    
    class User(db.Model):
        """ 用户模型 """
        __tablename__ = 'accounts_user'
        id = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 主键
        # 用户名，用于登录
        username = db.Column(db.String(64), unique=True, nullable=False)
        # 用户昵称
        nickname = db.Column(db.String(64))
        password = db.Column(db.String(256), nullable=False)
        # 用户的头像地址
        avatar = db.Column(db.String(256))
    
        # 是否有效，无效用户将不能登录系统
        status = db.Column(db.SmallInteger,
                           default=constants.UserStatus.USER_ACTIVE.value,
                           comment='用户状态')
        # 是否是超级管理员，管理员可以对所有内容进行管理
        is_super = db.Column(db.SmallInteger,
                             default=constants.UserRole.COMMON.value)
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 最后修改的时间
        updated_at = db.Column(db.DateTime,
                               default=datetime.now, onupdate=datetime.now)
        # profile = db.relationship('UserProfile')
    
        @property
        def is_authenticated(self):
            return True
    
        @property
        def is_active(self):
            """ 有效的用户才能登录系统 """
            return self.status == constants.UserStatus.USER_ACTIVE.value
    
        @property
        def is_anonymous(self):
            return False
    
        def get_id(self):
            return '{}'.format(self.id)
    
        def __str__(self):
            return self.nickname
    
    
    class UserProfile(db.Model):
        """ 用户详细信息 """
        __tablename__ = 'accounts_user_profile'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 用户名，用于登录
        username = db.Column(db.String(64), unique=True, nullable=False)
        # 用户真实姓名
        real_name = db.Column(db.String(64))
        # 用户的格言
        maxim = db.Column(db.String(128))
        # 性别
        sex = db.Column(db.String(16))
        # 地址
        address = db.Column(db.String(256))
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 最后修改的时间
        updated_at = db.Column(db.DateTime,
                               default=datetime.now, onupdate=datetime.now)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 建立用户的一对一关系属性user.profile profile.user
        user = db.relationship('User', backref=db.backref('profile', uselist=False))
    
    
    class UserLoginHistory(db.Model):
        __tablename__ = 'accounts_login_history'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 用户名，用于登录
        username = db.Column(db.String(64), nullable=False)
        # 账号平台
        login_type = db.Column(db.String(32))
        # IP地址
        ip = db.Column(db.String(32))
        # user-agent
        ua = db.Column(db.String(128))
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 建立与用户的一对多属性,user.history_list
        user = db.relationship('User', backref=db.backref('history_list', lazy='dynamic'))
    
    
    class Question(db.Model):
        """ 问题 """
        __tablename__ = 'qa_question'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 问题标题
        title = db.Column(db.String(128), nullable=False)
        # 问题描述
        desc = db.Column(db.String(256))
        # 问题图片
        img = db.Column(db.String(256))
        # 问题详情
        content = db.Column(db.Text, nullable=False)
        # 浏览人数
        view_count = db.Column(db.Integer, default=0)
        # 逻辑删除
        is_valid = db.Column(db.Boolean, default=True)
        # 排序
        reorder = db.Column(db.Integer, default=0)
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 最后修改的时间
        updated_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 建立与用户的一对多属性,user.question_list
        user = db.relationship('User', backref=db.backref('question_list', lazy='dynamic'))
    
        @property
        def get_img_url(self):
            return 'medias/' + self.img if self.img else ''
    
        @property
        def comment_count(self):
            """ 评论数量 """
            return self.question_comment_list.filter_by(is_valid=True).count()
    
        @property
        def follow_count(self):
            """ 关注数量 """
            return self.question_follow_list.filter_by(is_valid=True).count()
    
        @property
        def answer_count(self):
            return self.answer_list.filter_by(is_valid=True).count()
    
        @property
        def tags(self):
            """ 文章的标签 """
            return self.tag_list.filter_by(is_valid=True)
    
        @property
        def love_count(self):
            """ 点赞的数量 """
            return self.question_love_list.count()
    
    
    class QuestionTags(db.Model):
        """ 问题下的标签 """
        __tablename__ = 'qa_question_tags'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 标签名称
        tag_name = db.Column(db.String(16), nullable=False)
        # 逻辑删除
        is_valid = db.Column(db.Boolean, default=True)
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
    
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('tag_list', lazy='dynamic'))
    
    
    class Answer(db.Model):
        """ 问题的回答 """
        __tablename__ = 'qa_answer'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 回答的内容详情
        content = db.Column(db.Text, nullable=False)
        # 逻辑删除
        is_valid = db.Column(db.Boolean, default=True)
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 最后修改的时间
        updated_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
        # 建立与用户的一对多属性
        user = db.relationship('User', backref=db.backref('answer_list', lazy='dynamic'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('answer_list', lazy='dynamic'))
    
        @property
        def love_count(self):
            """ 点赞的数量 """
            return self.answer_love_list.count()
    
    
    class AnswerComment(db.Model):
        """ 回答的评论 """
        __tablename__ = 'qa_answer_comment'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 评论内容
        content = db.Column(db.String(512), nullable=False)
        # 赞同人数
        love_count = db.Column(db.Integer, default=0)
        # 评论是否公开
        is_public = db.Column(db.Boolean, default=True)
        # 逻辑删除
        is_valid = db.Column(db.Boolean, default=True)
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 最后修改的时间
        updated_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
        # 回复ID
        reply_id = db.Column(db.Integer, db.ForeignKey('qa_answer_comment.id'), nullable=True)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 关联答案
        answer_id = db.Column(db.Integer, db.ForeignKey('qa_answer.id'))
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
    
        # 建立与用户的一对多属性
        user = db.relationship('User', backref=db.backref('answer_comment_list', lazy='dynamic'))
        # 建立与答案的一对多属性
        answer = db.relationship('Answer', backref=db.backref('answer_comment_list', lazy='dynamic'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('question_comment_list', lazy='dynamic'))
    
    
    class AnswerLove(db.Model):
        """ 回答点赞 """
        __tablename__ = 'qa_answer_love'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 关联答案
        answer_id = db.Column(db.Integer, db.ForeignKey('qa_answer.id'))
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
    
        # 建立与用户的一对多属性
        user = db.relationship('User', backref=db.backref('answer_love_list', lazy='dynamic'))
        # 建立与答案的一对多属性
        answer = db.relationship('Answer', backref=db.backref('answer_love_list', lazy='dynamic'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('question_love_list', lazy='dynamic'))
    
    
    class AnswerCollect(db.Model):
        """ 收藏的回答 """
        __tablename__ = 'qa_answer_collect'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        # 创建时间
        created_at = db.Column(db.DateTime, default=datetime.now)
        # 逻辑删除
        is_valid = db.Column(db.Boolean, default=True)
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
        # 关联答案
        answer_id = db.Column(db.Integer, db.ForeignKey('qa_answer.id'))
    
        # 建立与用户的一对多属性
        user = db.relationship('User', backref=db.backref('answer_collect_list', lazy='dynamic'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('question_collect_list', lazy='dynamic'))
        # 建立与答案的一对多属性
        answer = db.relationship('Answer', backref=db.backref('answer_collect_list', lazy='dynamic'))
    
    
    class QuestionFollow(db.Model):
        """ 关注的问题 """
        __tablename__ = 'qa_question_follow'
        id = db.Column(db.Integer, primary_key=True)  # 主键
        created_at = db.Column(db.DateTime)
        is_valid = db.Column(db.Boolean, default=True, comment='逻辑删除')
        # 关联用户
        user_id = db.Column(db.Integer, db.ForeignKey('accounts_user.id'))
        # 关联问题
        q_id = db.Column(db.Integer, db.ForeignKey('qa_question.id'))
    
        # 建立与用户的一对多属性
        user = db.relationship('User', backref=db.backref('question_follow_list', lazy='dynamic'))
        # 建立与问题的一对多属性
        question = db.relationship('Question', backref=db.backref('question_follow_list', lazy='dynamic'))

def number_split(num):
        """
        数字格式化
        12345678 => 12,345,678
        :param num: 需要格式化的数字
        :return: 格式化后的字符串
        """
        return '{:,}'.format(int(num))