def main(): ## 从yaml列表中获取数据 textTagList = yamlDict.get('textTagList') legendList = [ x.get('name') for x in textTagList ] colorList = yamlDict.get('colorList') titleName = yamlDict.get('titleName') yUnit = yamlDict.get('yUnit') divUnit = yamlDict.get('divUnit') or 1 picType = yamlDict.get('picType') ## 获取之前一年的月份列表 clockList = pre_twelve_month() ## 生成X轴刻度列表 xLabel = [ '{}年{}月'.format( datetime.datetime.fromtimestamp(min(x)).year, datetime.datetime.fromtimestamp(min(x)).month ) for x in clockList ] ## 生成series列表 seriesList = [ { 'name' : x.get('name'), 'type' : picType, 'data' : data_list(x, clockList, divUnit) } for x in textTagList ] ## 生成输出字典 outputDict = { 'title' : titleName, 'legend' : legendList, 'color' : colorList, 'xlabel' : xLabel, 'yname' : yUnit, 'series' : seriesList } ## 输出字典转字符串 outputStr = json.dumps( outputDict, ensure_ascii = False ) ## 存储结果到数据库 mysql_update( host = mysql_conn.host, user = mysql_conn.user, passwd = mysql_conn.passwd, port = mysql_conn.port, db = mysql_conn.db, tb = mysql_conn.tb, name = event.label, data = outputStr, unixTime = int(time.time()) )
def main(): ## 从yaml列表中获取数据 filterKey = yamlDict.get('filter') colorList = yamlDict.get('colorList') titleName = yamlDict.get('titleName') yUnit = yamlDict.get('yUnit') divUnit = yamlDict.get('divUnit') or 1 ## 取出本月开始时间 clockList = pre_twelve_month() startUtime = max(max(x) for x in clockList) ## mysql连接信息 db = zbxdb_conn.db tb = zbxdb_conn.tb querySQL = nowport10.querySQL ## 查询语句 sql = querySQL.format(db, tb, startUtime, filterKey) ## 生成数据列表 dataList = data_query(sql) ## 汇总数据列表和阴影列表 dataList += stealth_list(dataList) ## 生成标签列表 legendList = [x.get('name') for x in dataList] ## 生成输出字典 outputDict = { 'title': titleName, 'label': legendList, 'color': colorList, 'data': dataList } ## 输出字典转字符串 outputStr = json.dumps(outputDict, ensure_ascii=False) ## 存储结果到数据库 mysql_update(host=mysql_conn.host, user=mysql_conn.user, passwd=mysql_conn.passwd, port=mysql_conn.port, db=mysql_conn.db, tb=mysql_conn.tb, name=nowport10.label, data=outputStr, unixTime=int(time.time()))
def main(): ## 从yaml列表中获取数据 textTagList = yamlDict.get('textTagList') legendList = [ x.get('name') for x in textTagList ] colorList = yamlDict.get('colorList') titleName = yamlDict.get('titleName') yUnit = yamlDict.get('yUnit') divUnit = yamlDict.get('divUnit') or 1 ## 获取之前一年的月份列表 clockList = pre_twelve_month() ## 生成X轴刻度列表 dataList=[ { 'name': x.get('name'), 'value':data_list(x,clockList,divUnit) } for x in textTagList ] ## 生成输出字典 outputDict = { 'title' : titleName, 'label' : legendList, 'color' : colorList, 'data' : dataList } ## 输出字典转字符串 outputStr = json.dumps( outputDict, ensure_ascii = False ) ## 存储结果到数据库 mysql_update( host = mysql_conn.host, user = mysql_conn.user, passwd = mysql_conn.passwd, port = mysql_conn.port, db = mysql_conn.db, tb = mysql_conn.tb, name = nowevent.label, data = outputStr, unixTime = int(time.time()) )