examine.py 文件源码

def black_list(del_id=None):
    produce.Async_log(g.user, request.url)
    db = db_op.haproxy_blacklist
    VAL = []
    try:
        val = db.query.with_entities(db.id,db.addtime,db.ip,db.rule,db.expire).filter(db.stats=='0').order_by(desc(db.id)).limit(1000).all()
        if val:
            tables = ['????','??IP','IP???','????','??????',' ??']
            if del_id:
                db.query.filter(db.id == str(del_id)).update({db.stats: '2'})
                db_op.DB.session.commit()
                val = db.query.with_entities(db.id, db.addtime,db.ip,db.rule,db.expire).filter(db.stats == '0').order_by(desc(db.addtime)).limit(1000).all()
            for va in val:
                va = list(va)
                va.insert(3,ip_area.Search(str(va[2])))
                VAL.append(va)
            return render_template('black_list.html',Main_Infos=g.main_infos,tables = tables,values = VAL)
        else:
            flash('??????!')
            return render_template('Message_static.html', Main_Infos=g.main_infos)
    except Exception as e:
        flash(e)
        return render_template('Message_static.html',Main_Infos=g.main_infos)