def browse_vendor_products(request):
"""Browse vendor specific products in the database
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {
"vendors": Vendor.objects.all()
}
selected_vendor = ""
if request.method == "POST":
selected_vendor = request.POST['vendor_selection']
else:
default_vendor = "Cisco Systems"
for vendor in context['vendors']:
if vendor.name == default_vendor:
selected_vendor = vendor.id
break
context['vendor_selection'] = selected_vendor
return render(request, "productdb/browse/view_products_by_vendor.html", context=context)
def browse_vendor_products(request):
"""Browse vendor specific products in the database
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {"vendors": Vendor.objects.all()}
selected_vendor = ""
if request.method == "POST":
selected_vendor = request.POST['vendor_selection']
else:
default_vendor = "Cisco Systems"
for vendor in context['vendors']:
if vendor.name == default_vendor:
selected_vendor = vendor.id
break
context['vendor_selection'] = selected_vendor
return render(request,
"productdb/browse/view_products_by_vendor.html",
context=context)
def browse_all_products(request):
"""Browse all products in the database
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
return render(request, "productdb/browse/view_products.html", context={})
def about_view(request):
"""about view
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
return render(request, "productdb/about.html", context={})
def browse_all_products(request):
"""Browse all products in the database
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
return render(request, "productdb/browse/view_products.html", context={})
def about_view(request):
"""about view
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
return render(request, "productdb/about.html", context={})
def server_messages_list(request):
"""
show the server message log
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {
"recent_events": NotificationMessage.objects.all()
}
return render(request, "config/notification-list.html", context=context)
def server_message_detail(request, message_id):
"""
show a detailed server message
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
try:
context = {
"message": NotificationMessage.objects.get(id=message_id)
}
return render(request, "config/notification-detail.html", context=context)
except:
raise Http404()
def home(request):
"""view for the homepage of the Product DB
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {
"recent_events": NotificationMessage.objects.filter(
created__gte=datetime.now(get_current_timezone()) - timedelta(days=14)
).order_by('-created')[:5]
}
return render(request, "productdb/home.html", context=context)
def home(request):
"""view for the homepage of the Product DB
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {
"recent_events":
NotificationMessage.objects.filter(
created__gte=datetime.now(get_current_timezone()) -
timedelta(days=14)).order_by('-created')[:5]
}
return render(request, "productdb/home.html", context=context)
def view_product_details(request, product_id=None):
"""
view product details
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
if not product_id:
# if product_id is set to none, redirect to the all products view
return redirect(reverse("productdb:all_products"))
else:
try:
p = Product.objects.get(id=product_id)
except:
raise Http404("Product with ID %s not found in database" % product_id)
context = {
"product": p
}
return render(request, "productdb/browse/product_detail.html", context=context)
def view_product_details(request, product_id=None):
"""
view product details
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
if not product_id:
# if product_id is set to none, redirect to the all products view
return redirect(reverse("productdb:all_products"))
else:
try:
p = Product.objects.get(id=product_id)
except:
raise Http404("Product with ID %s not found in database" %
product_id)
context = {"product": p}
return render(request,
"productdb/browse/product_detail.html",
context=context)
def bulk_eol_check(request):
"""view that executes and handles the Bulk EoL check function
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {}
if request.method == "POST":
db_queries = request.POST['db_query'].splitlines()
# clean POST db queries
clean_db_queries = []
for q in db_queries:
clean_db_queries.append(q.strip())
db_queries = filter(None, clean_db_queries)
# detailed product results
query_result = []
# result statistics
result_stats = dict()
# queries, that are not found in the database or that are not affected by an EoL announcement
skipped_queries = dict()
for query in db_queries:
q_result_counter = 0
found_but_no_eol_announcement = False
db_result = Product.objects.filter(product_id=query.strip())
# go through the database results
for element in db_result:
q_result_counter += 1
# check if the product is affected by an EoL announcement
if element.eol_ext_announcement_date is None:
found_but_no_eol_announcement = True
# don't add duplicates to query result, create statistical element
if element.product_id not in result_stats.keys():
query_result.append(app_util.normalize_date(element))
result_stats[element.product_id] = dict()
result_stats[element.product_id]['count'] = 1
result_stats[element.product_id]['product'] = element
result_stats[element.product_id]['state'] = element.current_lifecycle_states
# increment statistics
else:
result_stats[element.product_id]['count'] += 1
# classify the query results
if (q_result_counter == 0) or found_but_no_eol_announcement:
if (q_result_counter == 0) and not found_but_no_eol_announcement:
q_res_str = "Not found in database"
if found_but_no_eol_announcement:
q_res_str = "no EoL announcement found"
else:
# add queries without result to the stats and the counter
if query not in result_stats.keys():
result_stats[query] = dict()
result_stats[query]['state'] = ["Not found in database"]
result_stats[query]['product'] = dict()
result_stats[query]['product']['product_id'] = query
result_stats[query]['count'] = 1
else:
result_stats[query]['count'] += 1
# ignore duplicates
if query not in skipped_queries.keys():
skipped_queries[query] = {
"query": query.strip(),
"result": q_res_str
}
context['query_result'] = query_result
context['result_stats'] = result_stats
context['skipped_queries'] = skipped_queries
# simply display an error message if no result is found
if len(query_result) == 0:
context['query_no_result'] = True
return render(request, "productdb/do/bulk_eol_check.html", context=context)
def bulk_eol_check(request):
"""view that executes and handles the Bulk EoL check function
:param request:
:return:
"""
if login_required_if_login_only_mode(request):
return redirect('%s?next=%s' % (settings.LOGIN_URL, request.path))
context = {}
if request.method == "POST":
db_queries = request.POST['db_query'].splitlines()
# clean POST db queries
clean_db_queries = []
for q in db_queries:
clean_db_queries.append(q.strip())
db_queries = filter(None, clean_db_queries)
# detailed product results
query_result = []
# result statistics
result_stats = dict()
# queries, that are not found in the database or that are not affected by an EoL announcement
skipped_queries = dict()
for query in db_queries:
q_result_counter = 0
found_but_no_eol_announcement = False
db_result = Product.objects.filter(product_id=query.strip())
# go through the database results
for element in db_result:
q_result_counter += 1
# check if the product is affected by an EoL announcement
if element.eol_ext_announcement_date is None:
found_but_no_eol_announcement = True
# don't add duplicates to query result, create statistical element
if element.product_id not in result_stats.keys():
query_result.append(app_util.normalize_date(element))
result_stats[element.product_id] = dict()
result_stats[element.product_id]['count'] = 1
result_stats[element.product_id]['product'] = element
result_stats[element.product_id][
'state'] = element.current_lifecycle_states
# increment statistics
else:
result_stats[element.product_id]['count'] += 1
# classify the query results
if (q_result_counter == 0) or found_but_no_eol_announcement:
if (q_result_counter
== 0) and not found_but_no_eol_announcement:
q_res_str = "Not found in database"
if found_but_no_eol_announcement:
q_res_str = "no EoL announcement found"
else:
# add queries without result to the stats and the counter
if query not in result_stats.keys():
result_stats[query] = dict()
result_stats[query]['state'] = [
"Not found in database"
]
result_stats[query]['product'] = dict()
result_stats[query]['product']['product_id'] = query
result_stats[query]['count'] = 1
else:
result_stats[query]['count'] += 1
# ignore duplicates
if query not in skipped_queries.keys():
skipped_queries[query] = {
"query": query.strip(),
"result": q_res_str
}
context['query_result'] = query_result
context['result_stats'] = result_stats
context['skipped_queries'] = skipped_queries
# simply display an error message if no result is found
if len(query_result) == 0:
context['query_no_result'] = True
return render(request, "productdb/do/bulk_eol_check.html", context=context)