def json_batt(): result = [] dbconn() query = (RAWdata.select(RAWdata.tst, RAWdata.payload).where( RAWdata.topic == 'owntracks/gw/356612028111492/voltage/batt')) query = query.order_by(RAWdata.tst.desc()).limit(190) time_format = "%Y-%m-%d %H:%M:%S" for q in query.naive(): tstamp = q.tst.strftime(time_format) print tstamp, q.payload result.append({'tst': tstamp, 'batt': float(q.payload)}) j = json.dumps(result) print j return j
def json_batt(): result = [] dbconn() query = (RAWdata.select(RAWdata.tst, RAWdata.payload) .where( RAWdata.topic == 'owntracks/gw/356612028111492/voltage/batt' ) ) query = query.order_by(RAWdata.tst.desc()).limit(190) time_format = "%Y-%m-%d %H:%M:%S" for q in query.naive(): tstamp = q.tst.strftime(time_format) print tstamp, q.payload result.append( { 'tst' : tstamp, 'batt' : float(q.payload) } ) j = json.dumps(result) print j return j