flightinfo_sever/Functions/DButilsFunction/updateRiskdb.py

from .flightDB import flightDB
from unitls.LogerinTxt import app_logger
import openpyxl
import datetime
def updateRiskdb(database:flightDB, fileName):   #创建准备组提示数据库
    fdb = database
    fdb.deleteTable("RiskTable")
    try:
        workbook = openpyxl.load_workbook(filename=fileName)
        mysheet = workbook.active
        myrows = list(mysheet.values)[1:]
        mytitle = list(mysheet.values)[0]
        for myrow in myrows:
            mydics0 = {}
            for i in range(0, (len(mytitle))):
                mydics0[mytitle[i]] = "%s"%(myrow[i] if myrow[i] != None and myrow[i] else '')
            #print(mydics0)
            fdb.lazyInsertData('RiskTable',mydics0)
        fdb.FunctionCommit()
        return 1
    except Exception as e:
        app_logger.log_error(e)
        print(datetime.datetime.now(),'[数据库操作]数据库获取错误!!检查模板文件!风险提示功能失效!!')
        fdb.FunctionCommit()
        return 0