def update_data(): if 'whereStr' in req.form: str_where = req.form['whereStr'] if not str_where: return make_response('whereStr错误') else: return make_response('whereStr错误') if 'updateJson' in req.form: try: dict_update = json.loads(req.form['updateJson']) if len(dict_update) == 0: return make_response('updateJson错误') if 'id' in dict_update or 'username' in dict_update: return make_response('updateJson错误') except: return make_response('updateJson错误') else: return make_response('updateJson错误') if 'password' in dict_update: if len(dict_update['password']) < 6: return make_response('密码长度不能小于6') else: password = "******" + dict_update['password'] + dict_update[ 'password'][0:3] md5 = hashlib.md5() md5.update(password.encode(encoding='utf-8')) md5_password = md5.hexdigest() dict_update['password'] = md5_password else: pass dict_update['update_name'] = dict_login['username'] dict_update['update_time'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) result = mysqldb.update_data(table_name, str_where, dict_update) # print(result) if result: # 操作记录 content = 'whereStr=' + re.sub( r'\"', "'", str_where) + '&updateJson=' + re.sub( r'\"', "'", json.dumps(dict_update, ensure_ascii=False)) dict_record = { 'username': dict_login['username'], 'dbName': table_name, 'action': '修改', 'content': content, 'os': dict_login['os'], 'px': dict_login['px'], 'ip': req.remote_addr, 'time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) } mysqldb.set_record(dict_record) return make_response('操作成功') else: return make_response('操作失败')
def update_data(): if 'whereStr' in req.form: str_where = req.form['whereStr'] if not str_where: return make_response('whereStr错误') else: return make_response('whereStr错误') if 'updateJson' in req.form: try: dict_update = json.loads(req.form['updateJson']) if len(dict_update) == 0: return make_response('updateJson错误') except: return make_response('updateJson错误') else: return make_response('updateJson错误') dict_update['update_name'] = dict_login['username'] dict_update['update_time'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) result = mysqldb.update_data(table_name, str_where, dict_update) # print(result) if result: return make_response('操作成功') else: return make_response('操作失败')
def update_data(self): if 'whereStr' in self.req.form: str_where = self.req.form['whereStr'] if not str_where: return make_response('whereStr错误') else: return make_response('whereStr错误') if 'updateJson' in self.req.form: try: dict_update = json.loads(self.req.form['updateJson']) if len(dict_update) == 0: return make_response('updateJson错误') if 'id' in dict_update: return make_response('updateJson错误') except: return make_response('updateJson错误') else: return make_response('updateJson错误') dict_update['update_name'] = self.dict_login['username'] dict_update['update_time'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) result = mysqldb.update_data(self.table_name, str_where, dict_update) # print(result) if result: # 操作记录 content = 'whereStr=' + re.sub(r'\"', "'", str_where) + '&updateJson=' + re.sub(r'\"', "'", json.dumps(dict_update, ensure_ascii=False)) dict_record = {'username': self.dict_login['username'], 'dbName': self.table_name, 'action': '修改', 'content': content, 'os': self.dict_login['os'], 'px': self.dict_login['px'], 'ip': self.req.remote_addr, 'time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())} mysqldb.set_record(dict_record) return make_response('操作成功') else: return make_response('操作失败')
def update_data_fn(self, str_where, dict_update): result = mysqldb.update_data(self.table_name, str_where, dict_update) # print(result) if result: # 操作记录 content = 'whereStr=' + re.sub(r'\"', "'", str_where) + '&updateJson=' + re.sub(r'\"', "'", json.dumps(dict_update, ensure_ascii=False)) dict_record = {'username': self.dict_login['username'], 'dbName': self.table_name, 'action': '修改', 'content': content, 'os': self.dict_login['os'], 'px': self.dict_login['px'], 'ip': self.req.remote_addr, 'time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())} mysqldb.set_record(dict_record) return make_response('操作成功') else: return make_response('操作失败')
def update_data(self): if 'whereJson' in self.req.form: try: dict_where = json.loads(self.req.form['whereJson']) except: return make_response('whereJson错误') else: return make_response('whereJson错误') if 'updateJson' in self.req.form: try: dict_update = json.loads(self.req.form['updateJson']) if len(dict_update) == 0: return make_response('updateJson错误') except: return make_response('updateJson错误') else: return make_response('updateJson错误') if 'username' not in dict_where: return make_response('whereJson错误') else: pass dict_login = json.loads(self.req.cookies['logining']) if dict_where['username'] != dict_login['username']: return make_response('没有权限') else: pass if len(dict_update['password']) >= 6: password = "******" + dict_update['password'] + dict_update[ 'password'][0:3] md5 = hashlib.md5() md5.update(password.encode(encoding='utf-8')) md5_password = md5.hexdigest() dict_update['password'] = md5_password else: return make_response('密码不能为空') str_where = 'username="******"' dict_update['update_name'] = dict_login['username'] dict_update['update_time'] = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) result = mysqldb.update_data(self.table_name, str_where, dict_update) # print(result) if result: # 操作记录 content = 'change password' dict_record = { 'username': dict_login['username'], 'dbName': self.table_name, 'action': '修改', 'content': content, 'os': dict_login['os'], 'px': dict_login['px'], 'ip': self.req.remote_addr, 'time': time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) } mysqldb.set_record(dict_record) return make_response('操作成功') else: return make_response('操作失败')