python 接口

import flask #导入模块
from day07.api.lib.tools import coon_mysql,md5_passwd #引用方法
from day07.api.conf.setting import SERVER_HOST,SERVER_PORT_reg,SERVER_PORT_login,REDIS_HOST,REDIS_PORT,REDIS_DB #引用环境变量

from flask import request  #获取到请求参数时倒入这个
server = flask.Flask(__name__)#吧这个python文件当成一个web服务

@server.route('/reg',methods=['get','post'])
def reg():#方法和上面的@必须紧紧挨在一起
    # username = request.values.get('username')
    # password = request.values.get('password')
    username = request.json.get('username')#入参类型是json的话，必须用.json方法才可以
    password = request.json.get('password')
    if username or password:
        return '{"code":404,"msg":"请传入参数！"}'
    if username and password:
        #sql = 'select username,password from user where username=="%s";'%username
        sql = 'select username,password from user where username==“{name}“'.format(name=username)#注意sql语句中后面格式化的变量引用时有引号
        res = coon_mysql(sql)
        if res:
            return '{"code":300,"msg":"你注册的用户已经存在！"}'
        else:
            password = md5_passwd(password)#调用加密函数
            sql = 'insert into user(username,password) values("%s","%s");'%(username,password)
            coon_mysql(sql)
            return '{"code":200,"msg":"注册成功！"}'
    else:
        return '{"code":938,"msg":"请看接口文档！"}'

server.run(port=SERVER_PORT,debug=True,host=HOST)#运行服务