python pymysql flask 简易使用 和返回指定的json格式数据

pymysql.demo

import pymysql
import json
#print(print.__doc__)
conn = pymysql.connect(host="192.168.169.132",
                user="root",
                password="111111",
                database="zb")


cursor = conn.cursor()


#cursor.execute("insert into tuser (name, pass) values ('ccc', 'ccc')")
#conn.commit()


cursor.execute("select * from tuser")


sb=cursor.fetchall()
sb1 = {"data":sb,"status":1}




print(sb1)
#{'data': ((1, 'cc', 'cc', 0, None, None), (3, 'ccc', 'ccc', 0, None, None), (4, 'a', '0cc175b9c0f1b6a831c399e269772661', None, None, None), (12, 'e', 'e1671797c52e15f763380b45e841ec32', None, None, None), (13, 'r', '4b43b0aee35624cd95b910189b3dc231', None, None, None), (14, 'aaa', '47bce5c74f589f4867dbd57e9ca9f808', None, None, None), (16, 'aaaa', '74b87337454200d4d33f80c4663dc5e5', None, None, None), (17, '1', 'c4ca4238a0b923820dcc509a6f75849b', None, None, None), (18, '2', 'c81e728d9d4c2f636f067f89cc14862c', None, None, None), (19, '23', '37693cfc748049e45d87b8c7d8b9aacd', None, None, None), (20, '234', '289dff07669d7a23de0ef88d2f7129e7', None, None, None), (21, '2345', '81b073de9370ea873f548e31b8adc081', None, None, None), (22, 'ee', '08a4415e9d594ff960030b921d42b91e', None, None, None), (23, '66', '3295c76acbf4caaed33c36b1b5fc2cb1', None, None, None)), 'status': 1}


print(sb1['data'][2])


#(4, 'a', '0cc175b9c0f1b6a831c399e269772661', None, None, None)
'''
for key in sb1:
    print(key,"value:",sb1[key])
 
cursor.execute("select * from tuser")
for i in range(cursor.rowcount):
    record = cursor.fetchone()
    print(record)
'''


cursor.execute("select * from tuser")
print(cursor.rowcount)
courses = []
for i in range(cursor.rowcount):
    record = cursor.fetchone()
    course = {}
    course["name"] = record[0]
    course["info"] = record[1]
    course["price"] = record[2]
    course["sdate"] = str(record[3])
    course["edate"] = str(record[4])
    course["id"] = record[5]
    courses.append(course)
print(courses)


cursor.execute("select * from tuser")
print(cursor.rowcount)
courses = []
data = {}
for i in range(cursor.rowcount):
    record = cursor.fetchone()
    course = {}
    course["name"] = record[0]
    course["info"] = record[1]
    course["price"] = record[2]
    course["sdate"] = str(record[3])
    course["edate"] = str(record[4])
    course["id"] = record[5]
    courses.append(course)
data['code'] = "haha"


dew = []
ew = {}
ew['xcode']="a"
dew.append(ew)




data['status'] = "1"
data['data'] = courses


dew.append(data['data'])
data['xcode'] = dew
print(data)




# 'data': ((1, 'cc', 'cc', 0, None, None), (3, 'ccc', 'ccc', 0, None, None), (4, 'a', '0cc175b9c0f1b6a831c399e269772661', None, None, None), (12, 'e', 'e1671797c52e15f763380b45e841ec32', None, None, None), (13, 'r', '4b43b0aee35624cd95b910189b3dc231', None, None, None), (14, 'aaa', '47bce5c74f589f4867dbd57e9ca9f808', None, None, None), (16, 'aaaa', '74b87337454200d4d33f80c4663dc5e5', None, None, None), (17, '1', 'c4ca4238a0b923820dcc509a6f75849b', None, None, None), (18, '2', 'c81e728d9d4c2f636f067f89cc14862c', None, None, None), (19, '23', '37693cfc748049e45d87b8c7d8b9aacd', None, None, None), (20, '234', '289dff07669d7a23de0ef88d2f7129e7', None, None, None), (21, '2345', '81b073de9370ea873f548e31b8adc081', None, None, None), (22, 'ee', '08a4415e9d594ff960030b921d42b91e', None, None, None), (23, '66', '3295c76acbf4caaed33c36b1b5fc2cb1', None, None, None)), 'status