代码参考:
def index():
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM Users WHERE id=1''')
rv = cur.fetchall()
payload = []
content = {}
for result in rv:
content = {'id': result[0], 'username': result[1], 'password': result[2]}
payload.append(content)
content = {}
return jsonify(payload)
def get(self)# 获取
try:
# 从数据获取全部数据存到list
homework_li = HomeworkTable.query.all()
except:
# 获取失败,返回错误
return jsonify(code=11, message='query fail')
if homework_li is None:
return jsonify(code=11, message='query fail')
# 返回得到的homework对象,这里的homework是model对象,不可序列化,所以不能直接放入返回的json里面
# 需要把homework中的各个字段对应放到一个dict里面,这个功能上面封装成了serialize_course函数
return jsonify(code=0, message='OK', data={'homeworks': self.serialize_homework(homework_li)})