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 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 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 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 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))
