python 数据库查询结果转dict_将python sql列表转换为字典

How to convert

cursor.execute("SELECT strftime('%m.%d.%Y %H:%M:%S', timestamp, 'localtime'), temp FROM data WHERE timestamp>datetime('now','-1 hours')")

# fetch all or one we'll go for all.

results = cursor.fetchall()

for row in results[:-1]:

row=results[-1]

rowstr="['{0}',{1}]\n".format(str(row[0]),str(row[1]))

temp_chart_table+=rowstr

result

['01.15.2015 21:38:52',21.812]

into dictionary output in form of:

[{timestamp:'01.15.2015 21:38:52',temp:21.812}]

Edit

This is fetchone sample I currenyly use and it works fine:

def get_avg():

conn=sqlite3.connect(dbname)

curs=conn.cursor()

curs.execute("SELECT ROUND(avg(temp), 2.2) FROM data WHERE timestamp>datetime('now','-1 hour') AND timestamp<=datetime('now')")

rowavg=curs.fetchone()

#print rowavg

#rowstrmin=format(str(rowavg[0]))

#return rowstrmin

**d = [{"avg":rowavg[0]}]**

return d

conn.close()

#print get_avg()

schema = {"avg": ("number", "avg")}

data = get_avg()

# Loading it into gviz_api.DataTable

data_table = gviz_api.DataTable(schema)

data_table.LoadData(data)

json = data_table.ToJSon()

#print results

#print "Content-type: application/json\n\n"

print "Content-type: application/json"

print

print json

Then I make jQuery call and pass it into javascript and found help for that in here

ajax json query directly to python generated html gets undefined

解决方案

Try this instead:

cursor.execute("SELECT strftime('%m.%d.%Y %H:%M:%S', timestamp, 'localtime'), temp FROM data WHERE timestamp>datetime('now','-1 hours')")

# fetch all or one we'll go for all.

results = cursor.fetchall()

temp_chart_table = []

for row in results:

temp_chart_table.append({'timestamp': row[0], 'temp': row[1]})