解析influxdb查询结果

def queryDB(self, gost, port , dbName, sqlList):
    res=[]
    try:
        url = "http://{}:{}/query".format(host , port)
        ps={
            "db":dbName ,
            "q":";".join(sqlList)
        }
        respObj = requests.post(url,ps).json()['results']
        t0=time.time()
        for objItem in respObj:
            resItem=[]
            try:
                if 'series' in objItem.keys():
                    for ser in objItem['series']:
                        rows =[
                            dict(zip(ser['columns'], x)) if not 'tags' in ser.keys() else dict( dict(zip(ser['columns'], x)) , **(ser['tags']))
                            for x in ser['values']
                        ]
                        resItem.extend(rows)
            except Exception as er2:
                print(er2)
            res.append(resItem)
        t=time.time()-t0
        print(t)
    except Exception as e1:
        print(e1)
    return  res