def case_add(request):
if request.method == 'POST':
case_name = request.POST['case_name']
prj_id = request.POST['prj_id']
project = Project.objects.get(prj_id=prj_id)
description = request.POST['description']
content = request.POST['content']
case = Case(case_name=case_name, project=project, description=description, content=content)
case.save()
return HttpResponseRedirect("/base/case/")
prj_list = Project.objects.all()
return render(request, "base/case/add.html", {"prj_list": prj_list})
def case_update(request):
if request.method == 'POST':
raw_data = request.POST.getlist('excelData')
prj_id = request.POST.getlist('prj_id')
raw_delete = request.POST.getlist('deleteList')
raw_merge = request.POST.getlist('mergeList')
raw_unmerge = request.POST.getlist('unmergeList')
for data in raw_data:
case_list = data.split(",")
if case_list[13] == u'':
case = Case(case_sort=int(case_list[0]),
case_locate=case_list[1],
case_name=case_list[2],
case_pre=case_list[3],
case_type=case_list[4],
case_func=case_list[5],
case_expect=case_list[6],
case_result=case_list[7],
case_level=case_list[8],
case_creator=case_list[9],
case_executor=case_list[10],
case_time=case_list[11],
case_content=case_list[12],
project_id=int(prj_id[0]))
case.save()
else:
Case.objects.filter(case_id=int(case_list[13])).update(
case_sort=int(case_list[0]),
case_locate=case_list[1],
case_name=case_list[2],
case_pre=case_list[3],
case_type=case_list[4],
case_func=case_list[5],
case_expect=case_list[6],
case_result=case_list[7],
case_level=case_list[8],
case_creator=case_list[9],
case_executor=case_list[10],
case_time=case_list[11],
case_content=case_list[12],
project_id=int(prj_id[0]))
#Case.objects.filter(case_id=case_id).update(case_name=case_name,case_pre=case_pre,case_type=case_type,case_func=case_func,case_expect=case_expect,case_result=case_result,case_level=case_level,case_creator=case_creator,case_executor=case_executor,case_time=case_time,case_content=case_content)
if len(raw_delete) > 0:
for item in raw_delete:
delete_list = item.split(",")
if delete_list[13] == u'':
pass
else:
Case.objects.filter(case_id=int(delete_list[13])).delete()
if len(raw_merge) > 0:
for temp_merge in json.loads(raw_merge[0]):
merge = Merge(cell_range=temp_merge, project_id=int(prj_id[0]))
merge.save()
if len(raw_unmerge) > 0:
for temp_unmerge in json.loads(raw_unmerge[0]):
Merge.objects.filter(project_id=int(prj_id[0])).filter(
cell_range=temp_unmerge).delete()
return HttpResponseRedirect(("/base/case/?prj_id=%s") % prj_id[0])