for transfer in dtransfers:
dmount += float(transfer.mount)
print(dmount)
payload1.append(dmount)
print(payload1)
# print(transfers)
payload = []
for transfer in transfers:
id = transfer.id
sname = transfer.user_name
scard = transfer.scard
dname = transfer.dname
dcard = transfer.dcard
create_time = transfer.create_time.strftime("%Y-%m-%d %H:%M:%S"),
mount = transfer.mount
data = {
"id": id,
"mount": str(mount),
"sname": sname,
"scard": scard,
"dname": dname,
"dcard": dcard,
"create_time": create_time
}
payload.append((data))
return jsonify(code=200, msg="查询成功", data=payload, data1=payload1)
if __name__ == '__main__':
app.run(host="0.0.0.0", port=5000)
return jsonify(code=200, msg='查询成功', data=playload)
# 留言板留言区
@app.route('/user/message/board', methods=['GET'])
def user_select_board():
messages = Message.query.all()
playload = []
for message in messages:
content = message.content,
tag_names = []
tags = message.tag,
for tag in tags:
for t in tag:
tag_names.append(t.name)
creat_time = message.create_time.strftime("%Y-%m-%d %H:%M:%S"),
user_id = message.user_id
data = {
"content": content,
'message_id':message.id,
"tags": tag_names,
"create_time": creat_time,
"user_id": user_id
}
# print(data)
playload.append(data)
return jsonify(code=200, msg='查询成功', data=playload)
if __name__ == '__main__':
app.run()
'message_id':message.id,
'tags':tag_names,
'create_time':create_time,
'user_id':user_id}
historys.append(data)
return jsonify(code=200,msg='查询成功',data = historys)
#留言板所有公共留言
@app.route('/user/message/board')
def user_messages_board():
messages = Message.query.all()
historys=[]
for message in messages:
content = message.content
tags = message.tags
tag_names = []
for tag in tags:
tag_names.append(tag.taglname)
create_time = message.create_time.strftime("%Y-%m-%d %H:%M:%S")
user_id = message.user_id
data = {'content':content,
'message_id':message.id,
'tags':tag_names,
'create_time':create_time,
'user_id':user_id}
historys.append(data)
return jsonify(code=200,msg='查询成功',data = historys)
if __name__ == '__main__':
app.run(host='0.0.0.0',port=8080)
return jsonify(code=200, msg="查询成功", data=payload)
# 获取留言区留言
@app.route('/user/message/board', methods=["GET"])
def user_messages_board():
messages = Message.query.all()
payload = []
for message in messages:
content = message.content
tags = message.messages
tags_name = []
for tag in tags:
for t in tag:
tags_name.append(t.name)
create_time = message.create_time.strftime("%Y-%m-%d %H:%M:%S")
user_id = message.user_id
data = {
"content": content,
"message_id": message_id,
"tags": tags_name,
"create_time": create_time,
"user_id": user_id
}
payload.append(data)
return jsonify(code=200, msg="查询成功", data=payload)
if __name__ == "__main__":
app.run(debug=True, host="0.0.0.0", port="500")