import pymysql
sqldb = pymysql.connect(host='localhost', user='user', password='password', db='database')
JSONARRAY = []
try:
with sqldb.cursor() as cursor:
# noinspection SqlResolve
query = "SELECT Logged, AVG(Value) AS Value FROM TemperatureLog GROUP BY Logged"
cursor.execute(query)
for result in cursor.fetchall():
JSONARRAY.append({'Logged': str(result[0]), 'Value': result[1]})
except Exception as e:
print "DEATH!\n%s" % str(e)
finally:
sqldb.close()