def post(self, token): args = parser.parse_args() result = {} #去除arg['pwd']两边的空格 pwd = args['pwd'].strip() print(pwd) if args['name'] == "": result['code'] = 4010 result['message'] = "用户名不能为空!" return jsonify(result) elif args['phone'] == "": result['code'] = 4011 result['message'] = "电话号码不能为空!" return jsonify(result) #用正则判断电话号码是否符合规定 elif re.match(r'^1[345789]\d{9}$', args['phone']) is None: result['code'] = 4020 result['message'] = "此号码不存在!" return jsonify(result) elif pwd == "": result['code'] = 4012 result['message'] = "密码不能为空!" return jsonify(result) elif len(pwd) < 6 or len(pwd) > 16: result['code'] = 4021 result['message'] = "密码必须在6~16位之间!" return jsonify(result) mq = Mysqllink() #查看phone是否已经被注册过 sql = 'select phone from users where phone=%s' valu = args['phone'] n = mq.select(sql, valu) if n: result['code'] = 4022 result['message'] = "此号码已注册!" return jsonify(result) else: now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) # sql='insert into users value (null,%s,%s,%s,%s)' sql = 'insert into users(name,phone,pwd,create_at) values (%s,%s,%s,%s)' valu = (args['name'], args['phone'], args['pwd'], now_time) #使用insert()向mysql添加数据 # mq.cursor.execute(sql,valu) mq.insert(sql, valu) #查询新增id: ID = mq.cursor.lastrowid result['code'] = 200 result['data'] = { 'user': { 'id': ID, 'name': args['name'], 'phone': args['phone'], 'pwd': args['pwd'], 'create_at': now_time } } return jsonify(result)
def post(self, token): args = parser.parse_args() result = {} pwd = args['pwd'].strip() print(pwd) if args['name'] == "": result['code'] = 4010 result['message'] = "用户名不能为空!" return jsonify(result) elif args['phone'] == "": result['code'] = 4011 result['message'] = "电话号码不能为空!" return jsonify(result) elif re.match(r'^1[345789]\d{9}$', args['phone']) is None: result['code'] = 4020 result['message'] = "此号码不存在!" return jsonify(result) elif pwd == "": result['code'] = 4012 result['message'] = "密码不能为空!" return jsonify(result) elif len(pwd) < 6 or len(pwd) > 16: result['code'] = 4021 result['message'] = "密码必须在6~16位之间!" return jsonify(result) mq = Mysqllink() sql = 'select phone from admin_users where phone=%s' valu = args['phone'] n = mq.select(sql, valu) if n: result['code'] = 4022 result['message'] = "此号码已注册!" return jsonify(result) now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) sql = 'insert into admin_users(name,phone,pwd,des,create_at,update_at,post_id,is_super) ' \ 'values (%s,%s,%s,%s,%s,%s,%s,%s)' valu = (args['name'], args['phone'], args['pwd'], args['des'], now_time, now_time, args['post_id'], args['is_super']) mq.insert(sql, valu) ID = mq.cursor.lastrowid result['code'] = 200 result['data'] = { 'admin_user': { 'id': ID, 'name': args['name'], 'phone': args['phone'], 'des': args['des'], 'create_at': now_time, 'update_at': now_time } } return jsonify(result)
def post(self, token): args = parser.parse_args() result = {} admin = args['admin_user_id'] if args['name']=="" or args['price']=="" or args['img']=="" or args['origin']=="" or \ args['unit']=="" or args['sales']=="" or args['des']=="" or args['class_id']=="": result['code'] = 4033 result['message'] = "数据不完善!" return jsonify(result) qr = Query_rules() sql = 'select post_id from admin_users where id=%s' qr.select(sql, admin) au_post_id = qr.cursor.fetchall()[0]['post_id'] qr.query_rule(au_post_id) admin_rules = qr.cursor.fetchall() rules = [] for i in admin_rules: rules.append(i['name']) if 'add_goods' not in rules: result['code'] = 4002 result['code'] = "无此权限!" return jsonify(result) mq = Mysqllink() sql = 'select * from goods where name=%s and price=%s and img=%s and origin=%s and unit=%s and sales=%s and des=%s and class_id=%s' valu = (args['name'], args['price'], args['img'], args['origin'], args['unit'], args['sales'], args['des'], args['class_id']) n1 = mq.select(sql, valu) if n1: result['code'] = 4033 result['code'] = "此商品已存在!" return jsonify(result) now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) sql = 'insert into goods values (null,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)' valu = [ args['name'], args['img'], args['unit'], args['price'], args['sales'], args['des'], args['origin'], now_time, now_time, args['class_id'] ] n2 = mq.insert(sql, valu) if n2: ID = mq.cursor.lastrowid result['code'] = 200 result['data'] = { 'id': ID, 'name': args['name'], 'price': args['price'], 'img': args['img'], 'origin': args['origin'], 'unit': args['unit'], 'sales': args['sales'], 'des': args['des'], 'class_id': args['class_id'], 'create_at': now_time } return jsonify(result) else: result['code'] = 4028 result['message'] = "添加失败!" return jsonify(result)
def post(self, token): args = parser.parse_args() result = {} name = args['name'] pid = args['pid'] if name == "": result['code'] = 4031 result['message'] = "分类名不能为空!" return jsonify(result) mq = Mysqllink() sql = 'select * from classes where name=%s' n = mq.select(sql, name) if n: result['code'] = 4027 result['message'] = "此分类已存在!" return jsonify(result) now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) tab = 'insert into classes(name,create_at,update_at,pid) values (%s,%s,%s,%s)' valu = (name, now_time, now_time, pid) n1 = mq.insert(tab, valu) ID = mq.cursor.lastrowid if n1: result['code'] = 200 result['message'] = {'id': ID, 'name': name} return jsonify(result) else: result['dode'] = 4028 result['message'] = "添加失败!" return jsonify(result)
def post(self, token): args = parser.parse_args() result = {} des = eval(args['des']) #eval()字符串转字典 name = args['name'].strip() phone = args['phone'].strip() user_id = args['user_id'].strip() province = des['province'].strip() city = des['city'].strip() area = des['area'].strip() detail = des['detail'].strip() is_default = args['is_default'].strip() print(des) if user_id == "": result['code'] = 4025 result['message'] = "未登录!" return jsonify(result) elif province == "" or city == "" or area == "" or detail == "" or phone == "" or name == "": result['code'] = 4026 result['message'] = "地址信息不完善!" return jsonify(result) elif re.match(r'^1[345789]\d{9}$', phone) is None: result['code'] = 4020 result['message'] = "此号码不存在!" return jsonify(result) mq = Mysqllink() valu = (user_id, name, phone, province, city, area, detail) sql = 'select * from addrs where user_id=%s and name=%s and phone=%s and province=%s and ' \ 'city=%s and area=%s and detail=%s' n1 = mq.select(sql, valu) now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) if n1: result['code'] = 4027 result['message'] = "此地址已存在!" return jsonify(result) else: tab = 'insert into addrs values (null,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)' valu = (name, phone, user_id, province, city, area, detail, is_default, now_time, now_time) n = mq.insert(tab, valu) ID = mq.cursor.lastrowid if n: result['code'] = 200 result['data'] = { 'id': ID, 'user_id': user_id, 'phone': phone, 'name': name, 'des': { 'province': province, 'city': city, 'area': area, 'detail': detail }, 'is_deafult': is_default } return jsonify(result) else: result['code'] = 4028 result['message'] = "地址添加失败!" return jsonify(result)
def post(self, token): mq = Mysqllink() args = parser.parse_args() result = {} pwd = args['pwd'].strip() print(pwd) if args['name'] == "": result['code'] = 1020 result['message'] = "用户名不能为空!" return jsonify(result) elif args['phone'] == "": result['code'] = 1030 result['message'] = "电话号码不能为空!" return jsonify(result) elif re.match(r'^1[345789]\d{9}$', args['phone']) is None: result['code'] = 1031 result['message'] = "此号码不存在!" return jsonify(result) elif pwd == "": result['code'] = 1040 result['message'] = "密码不能为空!" return jsonify(result) elif len(pwd) < 6 or len(pwd) > 16: result['code'] = 1051 result['message'] = "密码必须在6~16位之间!" return jsonify(result) # name = args['name'] # sql = 'select name from users where name=%s' # n = mq.cursor.execute(sql, name) feild1 = 'name' tab = 'users' cond = 'name="%s"' % args['name'] n = mq.select(feild1, tab, cond) feild1 = 'phone' cond = 'phone="%s"' % args['phone'] m = mq.select(feild1, tab, cond) if n: result['code'] = 1010 result['message'] = "用户名已存在!" return jsonify(result) elif m: result['code'] = 1011 result['message'] = "此号码已注册!" return jsonify(result) now_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) print(now_time) # sql='insert into users value (null,%s,%s,%s,%s)' tab = 'users(name,phone,pwd,create_at)' valu = (args['name'], args['phone'], args['pwd'], now_time) # mq.cursor.execute(sql,pp) mq.insert(tab, valu) ID = mq.cursor.lastrowid result['code'] = 2000 result['date'] = { 'user': { 'id': ID, 'name': args['name'], 'phone': args['phone'], 'pwd': args['pwd'], 'create_at': now_time } } return jsonify(result)