import flask
import json
import MySQL
import 加密模块 as tools
import send_message
server = flask.Flask(__name__)
@server.route('/api/user',methods=['post','get'])
def user_info():
d = {"id":3,"username":"wanshucheng"}
return json.dumps(d)
@server.route('/get',methods=['get'])
def user2():
name = flask.request.values.get("name")
data = {"name":name}
return json.dumps(data,ensure_ascii=False) # ensure_ascii true的话,返回的是ascii字节,false返回汉字
@server.route('/header',methods=['get','post'])
#这个接口是为了说明怎么获取cooke,获取header的
def user3():
name = flask.request.headers.get("hhhh") #从header里面获取数据
time = flask.request.cookies.get("time") #cookie获取数据
data = {"hhhh":name,'time':time}
return json.dumps(data)
@server.route('/json',methods=['post'])
def user4():
if flask.request.is_json:
age = flask.request.json.get("age")
name = flask.request.json.get("name")
sex = flask.request.json.get("sex")
data = {"age":age,"sex":sex,"name":name}
else:
data = {"code":-1,"msg":"入参不是json"}
return json.dumps(data,ensure_ascii=False)
@server.route('/file',methods=['post'])
def user5():
file = flask.request.files.get("file")
file.save(file.filename)
return json.dumps({"code":0,"msg":"上传成功"},ensure_ascii=False)
@server.route('/test')
def test():
return tools.my_md5("sdgsg")
#user、stu_new
#table_name=user
#/table_data?table_name=
#
@server.route('/table_data')
def table_data():
table_names = ['user','stu_new']
table_name = flask.request.values.get('table_name') #table_name=stu+salt
# table_name = flask.request.values.get('sign') #sdgsdsdgsgds
if table_name:
if table_name in table_names:
sql = 'select * from %s;' % table_name
result = MySQL.execute_sql(sql)
data = {"code":0,"msg":"成功","data":result}
return json.dumps(data, ensure_ascii=False)
else:
return json.dumps({"code":-1,"msg":"没有查询该表的权限"},ensure_ascii=False)
return json.dumps({"code":-1,"msg":"请传入table_name"},ensure_ascii=False)
@server.route('/send_dingding')
def send_dingding():
content = flask.request.values.get("content")
if content:
send_message.send_dd(content)
return "ok"
return "请传入发送内容"
@server.route('/send_mail')
def send_mail():
content = flask.request.values.get("content")
subject = flask.request.values.get("subject")
send_message.send_mail(subject,content)
return "ok"
server.run(port=8888,debug=True,host='0.0.0.0')