def del_data():
if 'whereJson' in req.form:
try:
dict_where = json.loads(req.form['whereJson'])
if len(dict_where) != 1:
return make_response('whereJson错误')
except:
return make_response('whereJson错误')
else:
return make_response('whereJson错误')
result = mysqldb.del_data(table_name, dict_where)
# print(result)
if result:
# 操作记录
content = 'whereJson=' + re.sub(
r'\"', "'", json.dumps(dict_where, 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 delete_data_fn(self, dict_where):
result = mysqldb.del_data(self.table_name, dict_where)
# print(result)
if result:
# 操作记录
content = 'whereJson=' + re.sub(r'\"', "'", json.dumps(dict_where, 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 del_data():
if 'whereJson' in req.form:
try:
dict_where = json.loads(req.form['whereJson'])
if len(dict_where) != 1:
return make_response('whereJson错误')
except:
return make_response('whereJson错误')
else:
return make_response('whereJson错误')
result = mysqldb.del_data(table_name, dict_where)
# print(result)
if result:
return make_response('操作成功')
else:
return make_response('操作失败')
def del_data():
if 'whereJson' in req.form:
try:
dict_where = json.loads(req.form['whereJson'])
if not dict_where['url']:
return make_response('whereJson错误')
except:
return make_response('whereJson错误')
else:
return make_response('whereJson错误')
result = mysqldb.del_data(table_name, dict_where)
# print(result)
if result:
for url in dict_where['url']:
file_path = os.path.normpath(
os.path.dirname(os.path.dirname(__file__)) + url)
if os.path.exists(file_path):
os.remove(file_path)
else:
pass
# 操作记录
content = 'whereJson=' + re.sub(
r'\"', "'", json.dumps(dict_where, 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('操作失败')