def filter_plans(self):
search_form = SearchPlanForm(self.request.GET)
product_id = self.request.GET.get('product')
search_form.populate(int(product_id) if product_id else None)
plans = TestPlan.objects.none()
if search_form.is_valid():
# Determine the query is the user's plans and change the sub module value
author = self.request.GET.get('author__email__startswith')
req_user = self.request.user
if req_user.is_authenticated and author in (req_user.username,
req_user.email):
self.SUB_MODULE_NAME = "my_plans"
plans = (TestPlan.list(search_form.cleaned_data).select_related(
'author', 'type', 'product').order_by('-create_date'))
plans = TestPlan.apply_subtotal(
plans,
cases_count=True,
runs_count=True,
children_count=True,
)
return search_form, plans
def ajax_search(request, template_name='plan/common/json_plans.txt'):
"""Display all testplans"""
# If it's not a search the page will be blank
test_plans = TestPlan.objects.none()
# if it's a search request the request will be full
if request.GET:
search_form = SearchPlanForm(request.GET)
search_form.populate(product_id=request.GET.get('product'))
if search_form.is_valid():
# Detemine the query is the user's plans and change the sub
# module value
author = request.GET.get('author__email__startswith')
if author and len(search_form.changed_data) == 1:
if request.user.is_authenticated:
if author == request.user.username or author == request.user.email:
query = Q(author__email__startswith=author) | \
Q(owner__email__startswith=author)
test_plans = TestPlan.objects.filter(query).distinct()
else:
test_plans = TestPlan.list(search_form.cleaned_data)
test_plans = test_plans.select_related('author', 'owner',
'type', 'product')
# columnIndexNameMap is required for correct sorting behavior, 5 should
# be product, but we use run.build.product
column_names = [
'plan_id', 'name', 'author__username', 'owner__username', 'product',
'product_version', 'type', 'num_cases', 'num_runs', ''
]
return ajax_response(request, test_plans, column_names, template_name)
def get_all(request): # pylint: disable=missing-permission-required
"""Display all testplans"""
# TODO: this function should be deleted
# todo: this function can be replaced with the existing JSON-RPC search
# TODO: this function now only performs a forward feature, no queries
# need here. All of it will be removed in the future.
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
query_result = False
order_by = request.GET.get('order_by', 'create_date')
asc = bool(request.GET.get('asc', None))
# if it's a search request the page will be fill
if request.GET:
search_form = SearchPlanForm(request.GET)
search_form.populate(product_id=request.GET.get('product'))
if search_form.is_valid():
query_result = True
# build a QuerySet:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'type', 'product')
tps = order_plan_queryset(tps, order_by, asc)
else:
# Set search active plans only by default
search_form = SearchPlanForm(initial={'is_active': True})
template_name = 'non-existing.html'
# used in tree preview only
# fixme: must be replaced by JSON RPC and the
# JavaScript dialog that displays the preview
# should be converted to Patternfly
# todo: when this is done SearchPlanForm must contain only the
# fields which are used in search.html
if request.GET.get('t') == 'html':
if request.GET.get('f') == 'preview':
template_name = 'plan/preview.html'
query_url = remove_from_request_path(request, 'order_by')
if asc:
query_url = remove_from_request_path(query_url, 'asc')
else:
query_url = '%s&asc=True' % query_url
page_type = request.GET.get('page_type', 'pagination')
query_url_page_type = remove_from_request_path(request, 'page_type')
if query_url_page_type:
query_url_page_type = remove_from_request_path(query_url_page_type,
'page')
context_data = {
'test_plans': tps,
'query_result': query_result,
'search_plan_form': search_form,
'query_url': query_url,
'query_url_page_type': query_url_page_type,
'page_type': page_type
}
return render(request, template_name, context_data)
def search(request):
form = SearchPlanForm(request.GET)
form.populate(product_id=request.GET.get('product'))
context_data = {
'form': form,
'plan_types': PlanType.objects.all().only('pk', 'name').order_by('name'),
}
return render(request, 'testplans/search.html', context_data)
def get_context_data(self, **kwargs):
form = SearchPlanForm(self.request.GET)
form.populate(product_id=self.request.GET.get("product"))
context_data = {
"form": form,
}
return context_data
def get_context_data(self, **kwargs):
form = SearchPlanForm(self.request.GET)
form.populate(product_id=self.request.GET.get('product'))
context_data = {
'form': form,
'plan_types': PlanType.objects.all().only('pk', 'name').order_by('name'),
}
return context_data
def get_context_data(self, **kwargs):
form = SearchPlanForm(self.request.GET)
form.populate(product_id=self.request.GET.get("product"))
context_data = {
"form":
form,
"plan_types":
PlanType.objects.all().only("pk", "name").order_by("name"),
}
return context_data
def ajax_search(request, template_name='plan/common/json_plans.txt'):
"""Display all testplans"""
# Define the default sub module
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
# if it's a search request the page will be fill
if list(request.GET.items()):
search_form = SearchPlanForm(request.GET)
if request.GET.get('product'):
search_form.populate(product_id=request.GET['product'])
else:
search_form.populate()
if search_form.is_valid():
# Detemine the query is the user's plans and change the sub
# module value
author = request.GET.get('author__email__startswith')
if author and len(search_form.changed_data) == 1:
if request.user.is_authenticated():
if author == request.user.username or author == request.user.email:
q = Q(author__email__startswith=author) | \
Q(owner__email__startswith=author)
tps = TestPlan.objects.filter(q).distinct()
else:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'owner', 'type', 'product')
# columnIndexNameMap is required for correct sorting behavior, 5 should
# be product, but we use run.build.product
column_names = [
'',
'plan_id',
'name',
'author__username',
'owner__username',
'product',
'product_version',
'type',
'num_cases',
'num_runs',
''
]
return ajax_response(request, tps, column_names,
'plan/common/json_plans.txt')
def clone(request, template_name='case/clone.html'):
"""Clone one case or multiple case into other plan or plans"""
request_data = getattr(request, request.method)
if 'selectAll' not in request_data and 'case' not in request_data:
messages.add_message(request, messages.ERROR,
_('At least one TestCase is required'))
# redirect back where we came from
return HttpResponseRedirect(request.META.get('HTTP_REFERER', '/'))
test_plan_src = plan_from_request_or_none(request)
test_plan = None
search_plan_form = SearchPlanForm()
# Do the clone action
if request.method == 'POST':
clone_form = CloneCaseForm(request.POST)
clone_form.populate(case_ids=request.POST.getlist('case'))
if clone_form.is_valid():
tcs_src = clone_form.cleaned_data['case']
for tc_src in tcs_src:
if clone_form.cleaned_data['copy_case']:
tc_dest = TestCase.objects.create(
is_automated=tc_src.is_automated,
script=tc_src.script,
arguments=tc_src.arguments,
extra_link=tc_src.extra_link,
summary=tc_src.summary,
requirement=tc_src.requirement,
case_status=TestCaseStatus.get_proposed(),
category=tc_src.category,
priority=tc_src.priority,
notes=tc_src.notes,
text=tc_src.text,
author=clone_form.
cleaned_data['maintain_case_orignal_author']
and tc_src.author or request.user,
default_tester=clone_form.
cleaned_data['maintain_case_orignal_default_tester']
and tc_src.author or request.user,
)
for test_plan in clone_form.cleaned_data['plan']:
# copy a case and keep origin case's sortkey
if test_plan_src:
try:
tcp = TestCasePlan.objects.get(
plan=test_plan_src, case=tc_src)
sortkey = tcp.sortkey
except ObjectDoesNotExist:
sortkey = test_plan.get_case_sortkey()
else:
sortkey = test_plan.get_case_sortkey()
test_plan.add_case(tc_dest, sortkey)
for tag in tc_src.tag.all():
tc_dest.add_tag(tag=tag)
else:
tc_dest = tc_src
tc_dest.author = request.user
if clone_form.cleaned_data['maintain_case_orignal_author']:
tc_dest.author = tc_src.author
tc_dest.default_tester = request.user
if clone_form.cleaned_data[
'maintain_case_orignal_default_tester']:
tc_dest.default_tester = tc_src.default_tester
tc_dest.save()
for test_plan in clone_form.cleaned_data['plan']:
# create case link and keep origin plan's sortkey
if test_plan_src:
try:
tcp = TestCasePlan.objects.get(
plan=test_plan_src, case=tc_dest)
sortkey = tcp.sortkey
except ObjectDoesNotExist:
sortkey = test_plan.get_case_sortkey()
else:
sortkey = test_plan.get_case_sortkey()
test_plan.add_case(tc_dest, sortkey)
# Add the cases to plan
for test_plan in clone_form.cleaned_data['plan']:
# Clone the categories to new product
if clone_form.cleaned_data['copy_case']:
try:
tc_category = test_plan.product.category.get(
name=tc_src.category.name)
except ObjectDoesNotExist:
tc_category = test_plan.product.category.create(
name=tc_src.category.name,
description=tc_src.category.description,
)
tc_dest.category = tc_category
tc_dest.save()
del tc_category
# Clone the components to new product
if clone_form.cleaned_data['copy_component'] and \
clone_form.cleaned_data['copy_case']:
for component in tc_src.component.all():
try:
new_c = test_plan.product.component.get(
name=component.name)
except ObjectDoesNotExist:
new_c = test_plan.product.component.create(
name=component.name,
initial_owner=request.user,
description=component.description,
)
tc_dest.add_component(new_c)
# Detect the number of items and redirect to correct one
cases_count = len(clone_form.cleaned_data['case'])
plans_count = len(clone_form.cleaned_data['plan'])
if cases_count == 1 and plans_count == 1:
return HttpResponseRedirect(
'%s?from_plan=%s' %
(reverse('testcases-get', args=[
tc_dest.pk,
]), test_plan.pk))
if cases_count == 1:
return HttpResponseRedirect(
reverse('testcases-get', args=[
tc_dest.pk,
]))
if plans_count == 1:
return HttpResponseRedirect(
reverse('test_plan_url_short', args=[
test_plan.pk,
]))
# Otherwise it will prompt to user the clone action is successful.
messages.add_message(request, messages.SUCCESS,
_('TestCase cloning was successful'))
return HttpResponseRedirect(reverse('plans-search'))
else:
selected_cases = get_selected_testcases(request)
# Initial the clone case form
clone_form = CloneCaseForm(
initial={
'case': selected_cases,
'copy_case': False,
'maintain_case_orignal_author': False,
'maintain_case_orignal_default_tester': False,
'copy_component': True,
})
clone_form.populate(case_ids=selected_cases)
# Generate search plan form
if request_data.get('from_plan'):
test_plan = TestPlan.objects.get(plan_id=request_data['from_plan'])
search_plan_form = SearchPlanForm(initial={
'product': test_plan.product_id,
'is_active': True
})
search_plan_form.populate(product_id=test_plan.product_id)
submit_action = request_data.get('submit', None)
context = {
'test_plan': test_plan,
'search_form': search_plan_form,
'clone_form': clone_form,
'submit_action': submit_action,
}
return render(request, template_name, context)
def all(request, template_name='plan/all.html'):
'''Display all testplans'''
# TODO: this function now only performs a forward feature, no queries
# need here. All of it will be removed in the future.
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
query_result = False
order_by = request.GET.get('order_by', 'create_date')
asc = bool(request.GET.get('asc', None))
# if it's a search request the page will be fill
if request.GET:
search_form = SearchPlanForm(request.GET)
if request.GET.get('product'):
search_form.populate(product_id=request.GET['product'])
else:
search_form.populate()
if search_form.is_valid():
query_result = True
# build a QuerySet:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'type', 'product')
# We want to get the number of cases and runs, without doing
# lots of per-test queries.
#
# Ideally we would get the case/run counts using m2m field tricks
# in the ORM
# Unfortunately, Django's select_related only works on ForeignKey
# relationships, not on ManyToManyField attributes
# See http://code.djangoproject.com/ticket/6432
# SQLAlchemy can handle this kind of thing in several ways.
# Unfortunately we're using Django
# The cleanest way I can find to get it into one query is to
# use QuerySet.extra()
# See http://docs.djangoproject.com/en/dev/ref/models/querysets
tps = tps.extra(select={
'num_cases': RawSQL.num_cases,
'num_runs': RawSQL.num_runs,
'num_children': RawSQL.num_plans,
})
tps = order_plan_queryset(tps, order_by, asc)
else:
# Set search active plans only by default
search_form = SearchPlanForm(initial={'is_active': True})
if request.GET.get('action') == 'clone_case':
template_name = 'case/clone_select_plan.html'
tps = tps.order_by('name')
if request.GET.get('t') == 'ajax':
results = []
for obj in tps:
dict_obj = model_to_dict(obj, fields=('name', 'parent', 'is_active'))
for attr in ['pk', 'num_cases', 'num_cases', 'num_runs', 'num_children']:
dict_obj[attr] = getattr(obj, attr)
dict_obj['get_url_path'] = obj.get_url_path()
results.append(dict_obj)
return JsonResponse(results, safe=False)
if request.GET.get('t') == 'html':
if request.GET.get('f') == 'preview':
template_name = 'plan/preview.html'
query_url = remove_from_request_path(request, 'order_by')
if asc:
query_url = remove_from_request_path(query_url, 'asc')
else:
query_url = '%s&asc=True' % query_url
page_type = request.GET.get('page_type', 'pagination')
query_url_page_type = remove_from_request_path(request, 'page_type')
if query_url_page_type:
query_url_page_type = remove_from_request_path(query_url_page_type, 'page')
context_data = {
'test_plans': tps,
'query_result': query_result,
'search_plan_form': search_form,
'query_url': query_url,
'query_url_page_type': query_url_page_type,
'page_type': page_type
}
return render(request, template_name, context_data)
def get_all(request):
"""Display all testplans"""
# TODO: this function now only performs a forward feature, no queries
# need here. All of it will be removed in the future.
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
query_result = False
order_by = request.GET.get('order_by', 'create_date')
asc = bool(request.GET.get('asc', None))
# if it's a search request the page will be fill
if request.GET:
search_form = SearchPlanForm(request.GET)
search_form.populate(product_id=request.GET.get('product'))
if search_form.is_valid():
query_result = True
# build a QuerySet:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'type', 'product')
tps = order_plan_queryset(tps, order_by, asc)
else:
# Set search active plans only by default
search_form = SearchPlanForm(initial={'is_active': True})
if request.GET.get('action') == 'clone_case':
template_name = 'case/clone_select_plan.html'
tps = tps.order_by('name')
# test plan TreeView
if request.GET.get('t') == 'ajax':
results = []
for obj in tps:
dict_obj = model_to_dict(obj,
fields=('name', 'parent', 'is_active'))
for attr in ['pk']:
dict_obj[attr] = getattr(obj, attr)
dict_obj['plan_url'] = reverse('test_plan_url_short',
args=[obj.pk])
results.append(dict_obj)
return JsonResponse(results, safe=False)
# used in tree preview
if request.GET.get('t') == 'html':
if request.GET.get('f') == 'preview':
template_name = 'plan/preview.html'
query_url = remove_from_request_path(request, 'order_by')
if asc:
query_url = remove_from_request_path(query_url, 'asc')
else:
query_url = '%s&asc=True' % query_url
page_type = request.GET.get('page_type', 'pagination')
query_url_page_type = remove_from_request_path(request, 'page_type')
if query_url_page_type:
query_url_page_type = remove_from_request_path(query_url_page_type,
'page')
context_data = {
'test_plans': tps,
'query_result': query_result,
'search_plan_form': search_form,
'query_url': query_url,
'query_url_page_type': query_url_page_type,
'page_type': page_type
}
return render(request, template_name, context_data)
def all(request, template_name='plan/all.html'):
"""Display all testplans"""
# Define the default sub module
SUB_MODULE_NAME = 'plans'
# TODO: this function now only performs a forward feature, no queries
# need here. All of it will be removed in the future.
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
query_result = False
order_by = request.GET.get('order_by', 'create_date')
asc = bool(request.GET.get('asc', None))
# if it's a search request the page will be fill
if list(request.GET.items()):
search_form = SearchPlanForm(request.GET)
if request.GET.get('product'):
search_form.populate(product_id=request.GET['product'])
else:
search_form.populate()
if search_form.is_valid():
# Detemine the query is the user's plans and change the sub
# module value
author = request.GET.get('author')
if author and request.user.is_authenticated():
if author == request.user.username or author == request.user.email:
SUB_MODULE_NAME = "my_plans"
query_result = True
# build a QuerySet:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'type', 'product')
# We want to get the number of cases and runs, without doing
# lots of per-test queries.
#
# Ideally we would get the case/run counts using m2m field tricks
# in the ORM
# Unfortunately, Django's select_related only works on ForeignKey
# relationships, not on ManyToManyField attributes
# See http://code.djangoproject.com/ticket/6432
# SQLAlchemy can handle this kind of thing in several ways.
# Unfortunately we're using Django
# The cleanest way I can find to get it into one query is to
# use QuerySet.extra()
# See http://docs.djangoproject.com/en/dev/ref/models/querysets
tps = tps.extra(
select={
'num_cases': RawSQL.num_cases,
'num_runs': RawSQL.num_runs,
'num_children': RawSQL.num_plans,
})
tps = order_plan_queryset(tps, order_by, asc)
else:
# Set search active plans only by default
# I wish to use 'default' argument, as the same as in ModelForm
# But it does not seem to work
search_form = SearchPlanForm(initial={'is_active': True})
if request.GET.get('action') == 'clone_case':
template_name = 'case/clone_select_plan.html'
tps = tps.order_by('name')
if request.GET.get('t') == 'ajax':
data = [
dict(
pk=plan.pk,
name=plan.name,
is_active=plan.is_active,
parent_id=plan.parent_id,
num_cases=plan.num_cases,
num_runs=plan.num_runs,
num_children=plan.num_children,
get_url_path=plan.get_absolute_url(),
) for plan in tps
]
return JsonResponse(data, safe=False)
if request.GET.get('t') == 'html':
if request.GET.get('f') == 'preview':
template_name = 'plan/preview.html'
query_url = remove_from_request_path(request, 'order_by')
if asc:
query_url = remove_from_request_path(query_url, 'asc')
else:
query_url = '%s&asc=True' % query_url
page_type = request.GET.get('page_type', 'pagination')
query_url_page_type = remove_from_request_path(request, 'page_type')
if query_url_page_type:
query_url_page_type = remove_from_request_path(query_url_page_type,
'page')
context_data = {
'module': MODULE_NAME,
'sub_module': SUB_MODULE_NAME,
'test_plans': tps,
'query_result': query_result,
'search_plan_form': search_form,
'query_url': query_url,
'query_url_page_type': query_url_page_type,
'page_type': page_type
}
return render(request, template_name, context=context_data)
def all(request, template_name='plan/all.html'):
'''Display all testplans'''
# Define the default sub module
SUB_MODULE_NAME = 'plans'
# TODO: this function now only performs a forward feature, no queries
# need here. All of it will be removed in the future.
# If it's not a search the page will be blank
tps = TestPlan.objects.none()
query_result = False
order_by = request.GET.get('order_by', 'create_date')
asc = bool(request.GET.get('asc', None))
# if it's a search request the page will be fill
if request.GET.items():
search_form = SearchPlanForm(request.GET)
if request.GET.get('product'):
search_form.populate(product_id=request.GET['product'])
else:
search_form.populate()
if search_form.is_valid():
# Detemine the query is the user's plans and change the sub
# module value
author = request.GET.get('author')
if author and request.user.is_authenticated():
if author == request.user.username or author == request.user.email:
SUB_MODULE_NAME = "my_plans"
query_result = True
# build a QuerySet:
tps = TestPlan.list(search_form.cleaned_data)
tps = tps.select_related('author', 'type', 'product')
# We want to get the number of cases and runs, without doing
# lots of per-test queries.
#
# Ideally we would get the case/run counts using m2m field tricks
# in the ORM
# Unfortunately, Django's select_related only works on ForeignKey
# relationships, not on ManyToManyField attributes
# See http://code.djangoproject.com/ticket/6432
# SQLAlchemy can handle this kind of thing in several ways.
# Unfortunately we're using Django
# The cleanest way I can find to get it into one query is to
# use QuerySet.extra()
# See http://docs.djangoproject.com/en/dev/ref/models/querysets
tps = tps.extra(select={
'num_cases': RawSQL.num_cases,
'num_runs': RawSQL.num_runs,
'num_children': RawSQL.num_plans,
})
tps = order_plan_queryset(tps, order_by, asc)
else:
# Set search active plans only by default
# I wish to use 'default' argument, as the same as in ModelForm
# But it does not seem to work
search_form = SearchPlanForm(initial={'is_active': True})
if request.GET.get('action') == 'clone_case':
template_name = 'case/clone_select_plan.html'
tps = tps.order_by('name')
if request.GET.get('t') == 'ajax':
return HttpResponse(serializers.serialize(
request.GET.get('f', 'json'),
tps,
extras=('num_cases', 'num_runs', 'num_children', 'get_url_path')
))
if request.GET.get('t') == 'html':
if request.GET.get('f') == 'preview':
template_name = 'plan/preview.html'
query_url = remove_from_request_path(request, 'order_by')
if asc:
query_url = remove_from_request_path(query_url, 'asc')
else:
query_url = '%s&asc=True' % query_url
page_type = request.GET.get('page_type', 'pagination')
query_url_page_type = remove_from_request_path(request, 'page_type')
if query_url_page_type:
query_url_page_type = remove_from_request_path(query_url_page_type, 'page')
context_data = {
'module': MODULE_NAME,
'sub_module': SUB_MODULE_NAME,
'test_plans': tps,
'query_result': query_result,
'search_plan_form': search_form,
'query_url': query_url,
'query_url_page_type': query_url_page_type,
'page_type': page_type
}
return render_to_response(template_name, context_data,
context_instance=RequestContext(request))