flightinfo_sever/Functions/DButilsFunction/mandealAllLogs.py

from .flightDB import flightDB
import datetime
from unitls.LogerinTxt import app_logger


def mandealAllLogs(database:flightDB,name:str,mode):
    try:
        if mode =="norm":
            now=datetime.datetime.now()
            clear=database.queryTabel('logs',"编号","警告信息 !='' and 处理时间 ='' and 变更字段 !='人工待办' and 变更字段 !='准备组任务' ")
            newdic = {"处理人": "'%s'" % name, "处理时间": "'%s'" % now,"信息状态":"'人工一键处理'"}
            if len(clear) != 0:
                for i in clear:
                    database.lazyUpdateItem('logs',newdic,"编号='%s'"%i[0])
        elif mode == "super":
            now = datetime.datetime.now()
            clear = database.queryTabel('logs', "编号", "警告信息 !='' and 处理时间 ='' and 变更字段 !='人工待办'")
            newdic = {"处理人": "'%s'" % name, "处理时间": "'%s'" % now, "信息状态": "'人工一键处理'"}
            if len(clear) != 0:
                for i in clear:
                    database.lazyUpdateItem('logs', newdic, "编号='%s'" % i[0])
        database.FunctionCommit()
    except Exception as e:
        app_logger.log_error(e)
        database.FunctionCommit()