该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
这是从网页post进来的数据(其实要查询的数据还有,所以才考虑有源生的sql):
def search_log(request, context, id_m):
if request.method == 'POST':
platform = request.POST['platform']
product = request.POST['product']
device = request.POST['device']
ip = request.POST['ip']
这个是使用django自带的查询写的,但是条件要是很多就相当不方便
if platform and product and device:
result_list = CrashLog.objects.filter(platform=platform, product=product, device=device)
elif platform and product:
result_list = CrashLog.objects.filter(platform=platform, product=product)
elif platform and device:
result_list = CrashLog.objects.filter(platform=platform, device=device)
elif device and product:
result_list = CrashLog.objects.filter(product=product, device=device)
elif ip:
result_list = CrashLog.objects.filter(ip=ip)
elif ip and platform and product and device:
result_list = CrashLog.objects.filter(platform=platform, product=product, device=device, ip=ip)
elif ip and platform and device:
result_list = CrashLog.objects.filter(platform=platform, device=device, ip=ip)
elif ip and device and product:
result_list = CrashLog.objects.filter(product=product, device=device, ip=ip)
else:
result_list = CrashLog.objects.all().filter(Q(platform=platform) | Q(product=product) | Q(device=device))