# -*- coding: utf-8 -*-
__author__ = 'kevin.cai'
import settings
from pages.jira_helper import JiraHelper
from pages.html_report_helper import HTML_Report
if __name__ == '__main__':
jira = JiraHelper(settings.jira_options, settings.jira_account)
h = HTML_Report()
sprint_name = "Sprint 1517 (12/28 - 01/15)"
sprint_id = jira.get_sprint_id_by_sprint_name(settings.board_id, sprint_name)
sprint_status = jira.html_get_sprint_status(sprint_id)
actual_points = jira.html_get_actual_story_points_by_sprint(sprint_id)
#
raw_bug_list =jira.get_bug_info_by_sprint(sprint_id)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
#
raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(sprint_id)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentange(sprint_id)
#
raw_live_defect_list = jira.get_live_defect_info_by_sprint(sprint_id)
sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(raw_live_defect_list)
sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(sprint_id)
def get_school_report():
jira_account = {}
jira_account['username'] = str(session['username'])
jira_account['password'] = str(session['password'])
jira = JiraHelper(config.jira_options, jira_account)
sprint_name = session['choice_sprint']
qa = str(session['qa_resource'])
raw_project_name = session['project_name']
standard_task_id_list = []
standard_tasks_info_by_sprint = []
unplanned_tasks_info = []
planned_tasks_info = []
raw_bug_id_list = []
raw_bug_list = []
change_request_id_list = []
raw_live_defect_id_list = []
raw_live_defect_list = []
bugs_opened_before_but_closed_in_sprint = []
raw_automation_bug_list = []
raw_change_request_list = []
sprint_status_list = []
bug_trends = []
un_completed_story_points = 0
raw_un_completed_tasks_nest_lists = []
p_name = ""
for p in raw_project_name:
project_name = str(p.upper())
p_name = project_name + " " + p_name
board_id = config.s_dict[p]
#
sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id), sprint_name)
#
temp_standard_task_id_list = jira.get_standard_tasks_id_by_sprint(sprint_id, project_name)
standard_task_id_list.append(temp_standard_task_id_list)
#
temp_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint(sprint_id, project_name)
standard_tasks_info_by_sprint.append(temp_standard_tasks_info_by_sprint)
#
temp_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint(sprint_id, board_id, project_name)
unplanned_tasks_info.append(temp_unplanned_tasks_info)
temp_planned_tasks_info = jira.get_planned_tasks_by_sprint(sprint_id, board_id, project_name)
planned_tasks_info.append(temp_planned_tasks_info)
temp_un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint(sprint_id, board_id, temp_standard_tasks_info_by_sprint)
un_completed_story_points += temp_un_completed_story_points
temp_raw_un_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint(sprint_id, board_id, temp_standard_tasks_info_by_sprint)
raw_un_completed_tasks_nest_lists.append(temp_raw_un_completed_tasks_nest_lists)
#
temp_raw_bug_id_list = jira.get_bug_id_by_sprint(sprint_id, board_id, project_name)
raw_bug_id_list.append(temp_raw_bug_id_list)
temp_raw_bug_list = jira.get_bug_info_by_sprint(sprint_id, board_id, project_name)
raw_bug_list.append(temp_raw_bug_list)
#
temp_change_request_id_list = jira.get_change_request_id_by_sprint(sprint_id, project_name)
change_request_id_list.append(temp_change_request_id_list)
#
temp_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint(sprint_id, project_name)
raw_live_defect_id_list.append(temp_raw_live_defect_id_list)
#
temp_raw_live_defect_list = jira.get_live_defect_info_by_sprint(sprint_id, project_name)
raw_live_defect_list.append(temp_raw_live_defect_list)
#
temp_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint(sprint_id, board_id, project_name)
bugs_opened_before_but_closed_in_sprint.append(temp_bugs_opened_before_but_closed_in_sprint)
#
temp_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(sprint_id, board_id, project_name)
raw_automation_bug_list.append(temp_raw_automation_bug_list)
#
temp_raw_change_request_list = jira.get_change_request_info_by_sprint(sprint_id, project_name)
raw_change_request_list.append(temp_raw_change_request_list)
#
temp_sprint_status = jira.html_get_sprint_status(sprint_id, board_id)
sprint_status_list.append(temp_sprint_status)
#
temp_bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(sprint_id, board_id, project_name)
bug_trends.append(temp_bug_trends)
# Remove the duplicated value and format the list to next use.
standard_task_id_list = jira.remove_nested_list_duplicated_value(standard_task_id_list)
standard_tasks_info_by_sprint = jira.remove_nested_list_duplicated_value(standard_tasks_info_by_sprint)
raw_un_completed_tasks_nest_lists = jira.remove_nested_list_duplicated_value(raw_un_completed_tasks_nest_lists)
un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint(raw_un_completed_tasks_nest_lists)
un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage(raw_un_completed_tasks_nest_lists, standard_tasks_info_by_sprint)
unplanned_tasks_info = jira.remove_nested_list_duplicated_value(unplanned_tasks_info)
planned_tasks_info = jira.remove_nested_list_duplicated_value(planned_tasks_info)
raw_bug_id_list = jira.remove_nested_list_duplicated_value(raw_bug_id_list)
raw_bug_list = jira.remove_nested_list_duplicated_value(raw_bug_list)
change_request_id_list = jira.remove_nested_list_duplicated_value(change_request_id_list)
raw_live_defect_id_list = jira.remove_nested_list_duplicated_value(raw_live_defect_id_list)
raw_live_defect_list = jira.remove_nested_list_duplicated_value(raw_live_defect_list)
bugs_opened_before_but_closed_in_sprint = jira.remove_nested_list_duplicated_value(bugs_opened_before_but_closed_in_sprint)
raw_automation_bug_list = jira.remove_nested_list_duplicated_value(raw_automation_bug_list)
raw_change_request_list = jira.remove_nested_list_duplicated_value(raw_change_request_list)
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_and_project(bug_trends)
# generate report
actual_points = jira.get_actual_story_points_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint)
unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint(unplanned_tasks_info)
unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(unplanned_tasks_info)
planned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(planned_tasks_info)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks(bugs_opened_before_but_closed_in_sprint)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage(raw_bug_id_list, raw_automation_bug_list)
sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(raw_live_defect_list)
sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(raw_live_defect_id_list, raw_bug_id_list )
sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks(raw_change_request_list)
sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects(standard_task_id_list, change_request_id_list)
bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list)
bug_priority_detail = jira.html_get_share_ratio_detail_by_priority(raw_bug_list)
story_list= jira.get_task_id_that_has_linked_task(raw_bug_id_list)
story_share = jira.html_get_linked_issue_num_group_by_story(story_list)
story_share_detail = jira.html_get_linked_issue_detail_group_by_story(story_list, raw_bug_id_list)[1]
story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail)
sprint_status = jira.html_get_mulitple_sprint_status(sprint_status_list)
render = render_template('sprint_report.html', project_required=p_name.strip(), \
customized_component=session["quick_filter"] if "quick_filter" in session else None, \
sprint_name_string=sprint_name,\
qa_resource = qa,\
sprint_status=sprint_status, actual_story_points=actual_points, \
unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \
planned_nest_lists = planned_nest_lists,\
un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \
un_completed_story_points=un_completed_story_points,\
un_completed_tasks_percentage =un_completed_tasks_percentage, \
sprint_bug_nested_lists=sprint_bug_nested_list,\
bug_priority_nested_lists=bug_priority_list, \
bug_priority_share_detail_info=bug_priority_detail,\
story_share_nested_lists=story_share, \
story_share_detail_info=story_share_detail,\
total_bug_and_opened_bug_pair_nested_list=bug_trends,\
sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \
sprint_automation_bug_percentage=sprint_automation_bug_percentage,\
previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint,
sprint_live_defect_nested_lists=sprint_live_defect_nested_list,\
sprint_live_defect_percentage=sprint_live_defect_percentage,\
sprint_change_request_nested_lists=sprint_change_request_nested_list, \
sprint_change_request_percentage=sprint_change_request_percentage
)
global response
response = make_response(render)
session.clear()
return render
def get_report():
project_name = session['project_name']
if type(project_name) is list:
return redirect(url_for('get_school_report'))
jira_account = {}
jira_account['username'] = str(session['username'])
jira_account['password'] = str(session['password'])
jira = JiraHelper(config.jira_options, jira_account)
board_id = str(session.get('board_id'))
sprint_name = session['choice_sprint']
qa = str(session['qa_resource'])
sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id), sprint_name)
sprint_status = jira.html_get_sprint_status(sprint_id, board_id)
original_standard_task_id_list = jira.get_standard_tasks_id_by_sprint(sprint_id, project_name)
original_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint(sprint_id, project_name)
original_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint(sprint_id, board_id, project_name)
original_planned_tasks_info = jira.get_planned_tasks_by_sprint(sprint_id, board_id, project_name)
original_raw_bug_id_list = jira.get_bug_id_by_sprint(sprint_id, board_id, project_name)
original_raw_bug_list = jira.get_bug_info_by_sprint(sprint_id, board_id, project_name)
original_change_request_id_list = jira.get_change_request_id_by_sprint(sprint_id, project_name)
original_raw_change_request_list = jira.get_change_request_info_by_sprint(sprint_id, project_name)
original_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint(sprint_id, project_name)
original_raw_live_defect_list = jira.get_live_defect_info_by_sprint(sprint_id, project_name)
original_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint(sprint_id, board_id, project_name)
original_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(sprint_id, board_id, project_name)
if "quick_filter" in session:
if str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components):
standard_task_id_list = jira.get_filtered_task_id_by_component(original_standard_task_id_list, session["quick_filter"])
#
standard_tasks_info_by_sprint = jira.get_filtered_task_info_by_component(original_standard_tasks_info_by_sprint, session["quick_filter"])
#
unplanned_tasks_info = jira.get_filtered_task_info_by_component(original_unplanned_tasks_info, session["quick_filter"])
#
planned_tasks_info = jira.get_filtered_task_info_by_component(original_planned_tasks_info, session["quick_filter"])
#
raw_bug_id_list = jira.get_filtered_task_id_by_component(original_raw_bug_id_list, session["quick_filter"])
#
raw_bug_list = jira.get_filtered_task_info_by_component(original_raw_bug_list, session["quick_filter"])
#
change_request_id_list = jira.get_filtered_task_id_by_component(original_change_request_id_list, session["quick_filter"])
#
raw_live_defect_id_list = jira.get_filtered_task_id_by_component(original_raw_live_defect_id_list, session["quick_filter"])
#
raw_live_defect_list = jira.get_filtered_task_info_by_component(original_raw_live_defect_list, session["quick_filter"])
#
bugs_opened_before_but_closed_in_sprint = jira.get_filtered_task_info_by_component(original_bugs_opened_before_but_closed_in_sprint, session["quick_filter"])
#
raw_automation_bug_list = jira.get_filtered_task_info_by_component(original_raw_automation_bug_list, session["quick_filter"])
#
raw_change_request_list = jira.get_filtered_task_info_by_component(original_raw_change_request_list, session["quick_filter"])
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(sprint_id, board_id, project_name, session["quick_filter"])
else:
standard_task_id_list = original_standard_task_id_list
standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint
raw_bug_id_list = original_raw_bug_id_list
raw_bug_list = original_raw_bug_list
change_request_id_list = original_change_request_id_list
raw_live_defect_id_list = original_raw_live_defect_id_list
raw_live_defect_list = original_raw_live_defect_list
unplanned_tasks_info = original_unplanned_tasks_info
planned_tasks_info = original_planned_tasks_info
bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint
raw_automation_bug_list = original_raw_automation_bug_list
raw_change_request_list = original_raw_change_request_list
filter_string_list = []
filter_string = ','
for item in config.quick_filter_choice[session["project_name"]]:
if str(item[0]) != str(config.show_all_but_exclude_those_have_components) and str(item[0]) != str(config.show_all):
filter_string_list.append(item[0])
filter_string = ',' + item[0] + filter_string
filter_string = filter_string.strip(',')
standard_task_id_list = jira.exclude_filtered_task_id_by_component(standard_task_id_list, filter_string_list)
#
standard_tasks_info_by_sprint = jira.exclude_filtered_task_info_by_component(standard_tasks_info_by_sprint, filter_string_list)
#
unplanned_tasks_info = jira.exclude_filtered_task_info_by_component(unplanned_tasks_info, filter_string_list)
#
planned_tasks_info = jira.exclude_filtered_task_info_by_component(planned_tasks_info, filter_string_list)
#
raw_bug_id_list = jira.exclude_filtered_task_id_by_component(raw_bug_id_list, filter_string_list)
#
raw_bug_list = jira.exclude_filtered_task_info_by_component(raw_bug_list, filter_string_list)
#
change_request_id_list = jira.exclude_filtered_task_id_by_component(change_request_id_list, filter_string_list)
#
raw_live_defect_id_list = jira.exclude_filtered_task_id_by_component(raw_live_defect_id_list, filter_string_list)
#
raw_live_defect_list = jira.exclude_filtered_task_info_by_component(raw_live_defect_list,filter_string_list)
#
bugs_opened_before_but_closed_in_sprint = jira.exclude_filtered_task_info_by_component(bugs_opened_before_but_closed_in_sprint, filter_string_list)
#
raw_automation_bug_list = jira.exclude_filtered_task_info_by_component(raw_automation_bug_list, filter_string_list)
#
raw_change_request_list = jira.exclude_filtered_task_info_by_component(raw_change_request_list, filter_string_list)
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_exclude_component_filter(sprint_id, board_id, project_name, filter_string)
else:
standard_task_id_list = original_standard_task_id_list
standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint
#
unplanned_tasks_info = original_unplanned_tasks_info
planned_tasks_info = original_planned_tasks_info
#
raw_bug_id_list = original_raw_bug_id_list
raw_bug_list = original_raw_bug_list
#
change_request_id_list = original_change_request_id_list
#
raw_live_defect_id_list = original_raw_live_defect_id_list
#
raw_live_defect_list = original_raw_live_defect_list
bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint
#
raw_automation_bug_list = original_raw_automation_bug_list
#
raw_change_request_list = original_raw_change_request_list
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(sprint_id, board_id, project_name)
actual_points = jira.get_actual_story_points_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint)
unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint(unplanned_tasks_info)
unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(unplanned_tasks_info)
planned_nest_lists = jira.html_get_planned_tasks_by_sprint(planned_tasks_info)
release_tasks_with_fix_version_and_size = jira.get_filtered_task_info_by_fix_version(planned_tasks_info)
t_size_number = jira.get_task_members_by_t_size(release_tasks_with_fix_version_and_size)
nested_release_tasks_with_fix_version_and_size = jira.html_get_release_tasks_with_fix_version_and_size(release_tasks_with_fix_version_and_size)
un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint)
raw_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint(sprint_id, board_id, standard_tasks_info_by_sprint)
un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint(raw_completed_tasks_nest_lists)
un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage(raw_completed_tasks_nest_lists, standard_tasks_info_by_sprint)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks(bugs_opened_before_but_closed_in_sprint)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage(raw_bug_id_list, raw_automation_bug_list)
sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(raw_live_defect_list)
sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(raw_live_defect_id_list, raw_bug_id_list )
sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks(raw_change_request_list)
sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects(standard_task_id_list, change_request_id_list)
#
bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list)
bug_priority_detail = jira.html_get_share_ratio_detail_by_priority(raw_bug_list)
#
story_list= jira.get_task_id_that_has_linked_task(raw_bug_id_list)
story_share = jira.html_get_linked_issue_num_group_by_story(story_list)
story_share_detail = jira.html_get_linked_issue_detail_group_by_story(story_list, raw_bug_id_list)[1]
story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail)
render = render_template('sprint_report.html', project_required=project_name, \
customized_component=session["quick_filter"] if "quick_filter" in session \
and str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components) else None, \
sprint_name_string=sprint_name, \
qa_resource = qa, \
sprint_status=sprint_status, actual_story_points=actual_points, \
unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \
planned_nest_lists =planned_nest_lists,\
un_finished_tasks_nest_lists=un_completed_tasks_nest_lists, \
un_completed_story_points = un_completed_story_points, \
un_completed_tasks_percentage=un_completed_tasks_percentage, \
un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \
sprint_bug_nested_lists=sprint_bug_nested_list, \
bug_priority_nested_lists=bug_priority_list, \
bug_priority_share_detail_info=bug_priority_detail, \
story_share_nested_lists=story_share, \
story_share_detail_info=story_share_detail, \
total_bug_and_opened_bug_pair_nested_list=bug_trends, \
sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \
sprint_automation_bug_percentage=sprint_automation_bug_percentage, \
previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint,
sprint_live_defect_nested_lists=sprint_live_defect_nested_list, \
sprint_live_defect_percentage=sprint_live_defect_percentage, \
sprint_change_request_nested_lists=sprint_change_request_nested_list, \
sprint_change_request_percentage=sprint_change_request_percentage, \
t_size_number=t_size_number,\
release_tasks_with_fix_version_and_size=nested_release_tasks_with_fix_version_and_size
)
global response
response = make_response(render)
session.clear()
return render
def get_school_report():
jira_account = {}
jira_account['username'] = str(session['username'])
jira_account['password'] = str(session['password'])
jira = JiraHelper(config.jira_options, jira_account)
sprint_name = session['choice_sprint']
qa = str(session['qa_resource'])
raw_project_name = session['project_name']
standard_task_id_list = []
standard_tasks_info_by_sprint = []
unplanned_tasks_info = []
planned_tasks_info = []
raw_bug_id_list = []
raw_bug_list = []
change_request_id_list = []
raw_live_defect_id_list = []
raw_live_defect_list = []
bugs_opened_before_but_closed_in_sprint = []
raw_automation_bug_list = []
raw_change_request_list = []
sprint_status_list = []
bug_trends = []
un_completed_story_points = 0
raw_un_completed_tasks_nest_lists = []
p_name = ""
for p in raw_project_name:
project_name = str(p.upper())
p_name = project_name + " " + p_name
board_id = config.s_dict[p]
#
sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id),
sprint_name)
#
temp_standard_task_id_list = jira.get_standard_tasks_id_by_sprint(
sprint_id, project_name)
standard_task_id_list.append(temp_standard_task_id_list)
#
temp_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint(
sprint_id, project_name)
standard_tasks_info_by_sprint.append(
temp_standard_tasks_info_by_sprint)
#
temp_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint(
sprint_id, board_id, project_name)
unplanned_tasks_info.append(temp_unplanned_tasks_info)
temp_planned_tasks_info = jira.get_planned_tasks_by_sprint(
sprint_id, board_id, project_name)
planned_tasks_info.append(temp_planned_tasks_info)
temp_un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint(
sprint_id, board_id, temp_standard_tasks_info_by_sprint)
un_completed_story_points += temp_un_completed_story_points
temp_raw_un_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint(
sprint_id, board_id, temp_standard_tasks_info_by_sprint)
raw_un_completed_tasks_nest_lists.append(
temp_raw_un_completed_tasks_nest_lists)
#
temp_raw_bug_id_list = jira.get_bug_id_by_sprint(
sprint_id, board_id, project_name)
raw_bug_id_list.append(temp_raw_bug_id_list)
temp_raw_bug_list = jira.get_bug_info_by_sprint(
sprint_id, board_id, project_name)
raw_bug_list.append(temp_raw_bug_list)
#
temp_change_request_id_list = jira.get_change_request_id_by_sprint(
sprint_id, project_name)
change_request_id_list.append(temp_change_request_id_list)
#
temp_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint(
sprint_id, project_name)
raw_live_defect_id_list.append(temp_raw_live_defect_id_list)
#
temp_raw_live_defect_list = jira.get_live_defect_info_by_sprint(
sprint_id, project_name)
raw_live_defect_list.append(temp_raw_live_defect_list)
#
temp_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint(
sprint_id, board_id, project_name)
bugs_opened_before_but_closed_in_sprint.append(
temp_bugs_opened_before_but_closed_in_sprint)
#
temp_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(
sprint_id, board_id, project_name)
raw_automation_bug_list.append(temp_raw_automation_bug_list)
#
temp_raw_change_request_list = jira.get_change_request_info_by_sprint(
sprint_id, project_name)
raw_change_request_list.append(temp_raw_change_request_list)
#
temp_sprint_status = jira.html_get_sprint_status(sprint_id, board_id)
sprint_status_list.append(temp_sprint_status)
#
temp_bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(
sprint_id, board_id, project_name)
bug_trends.append(temp_bug_trends)
# Remove the duplicated value and format the list to next use.
standard_task_id_list = jira.remove_nested_list_duplicated_value(
standard_task_id_list)
standard_tasks_info_by_sprint = jira.remove_nested_list_duplicated_value(
standard_tasks_info_by_sprint)
raw_un_completed_tasks_nest_lists = jira.remove_nested_list_duplicated_value(
raw_un_completed_tasks_nest_lists)
un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint(
raw_un_completed_tasks_nest_lists)
un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage(
raw_un_completed_tasks_nest_lists, standard_tasks_info_by_sprint)
unplanned_tasks_info = jira.remove_nested_list_duplicated_value(
unplanned_tasks_info)
planned_tasks_info = jira.remove_nested_list_duplicated_value(
planned_tasks_info)
raw_bug_id_list = jira.remove_nested_list_duplicated_value(raw_bug_id_list)
raw_bug_list = jira.remove_nested_list_duplicated_value(raw_bug_list)
change_request_id_list = jira.remove_nested_list_duplicated_value(
change_request_id_list)
raw_live_defect_id_list = jira.remove_nested_list_duplicated_value(
raw_live_defect_id_list)
raw_live_defect_list = jira.remove_nested_list_duplicated_value(
raw_live_defect_list)
bugs_opened_before_but_closed_in_sprint = jira.remove_nested_list_duplicated_value(
bugs_opened_before_but_closed_in_sprint)
raw_automation_bug_list = jira.remove_nested_list_duplicated_value(
raw_automation_bug_list)
raw_change_request_list = jira.remove_nested_list_duplicated_value(
raw_change_request_list)
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_and_project(
bug_trends)
# generate report
actual_points = jira.get_actual_story_points_by_sprint(
sprint_id, board_id, standard_tasks_info_by_sprint)
unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint(
unplanned_tasks_info)
unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(
unplanned_tasks_info)
planned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(
planned_tasks_info)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks(
bugs_opened_before_but_closed_in_sprint)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(
raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage(
raw_bug_id_list, raw_automation_bug_list)
sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(
raw_live_defect_list)
sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(
raw_live_defect_id_list, raw_bug_id_list)
sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks(
raw_change_request_list)
sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects(
standard_task_id_list, change_request_id_list)
bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list)
bug_priority_detail = jira.html_get_share_ratio_detail_by_priority(
raw_bug_list)
story_list = jira.get_task_id_that_has_linked_task(raw_bug_id_list)
story_share = jira.html_get_linked_issue_num_group_by_story(story_list)
story_share_detail = jira.html_get_linked_issue_detail_group_by_story(
story_list, raw_bug_id_list)[1]
story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail)
sprint_status = jira.html_get_mulitple_sprint_status(sprint_status_list)
render = render_template('sprint_report.html', project_required=p_name.strip(), \
customized_component=session["quick_filter"] if "quick_filter" in session else None, \
sprint_name_string=sprint_name,\
qa_resource = qa,\
sprint_status=sprint_status, actual_story_points=actual_points, \
unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \
planned_nest_lists = planned_nest_lists,\
un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \
un_completed_story_points=un_completed_story_points,\
un_completed_tasks_percentage =un_completed_tasks_percentage, \
sprint_bug_nested_lists=sprint_bug_nested_list,\
bug_priority_nested_lists=bug_priority_list, \
bug_priority_share_detail_info=bug_priority_detail,\
story_share_nested_lists=story_share, \
story_share_detail_info=story_share_detail,\
total_bug_and_opened_bug_pair_nested_list=bug_trends,\
sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \
sprint_automation_bug_percentage=sprint_automation_bug_percentage,\
previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint,
sprint_live_defect_nested_lists=sprint_live_defect_nested_list,\
sprint_live_defect_percentage=sprint_live_defect_percentage,\
sprint_change_request_nested_lists=sprint_change_request_nested_list, \
sprint_change_request_percentage=sprint_change_request_percentage
)
global response
response = make_response(render)
session.clear()
return render
def get_report():
project_name = session['project_name']
if type(project_name) is list:
return redirect(url_for('get_school_report'))
jira_account = {}
jira_account['username'] = str(session['username'])
jira_account['password'] = str(session['password'])
jira = JiraHelper(config.jira_options, jira_account)
board_id = str(session.get('board_id'))
sprint_name = session['choice_sprint']
qa = str(session['qa_resource'])
sprint_id = jira.get_sprint_id_by_sprint_name(int(board_id), sprint_name)
sprint_status = jira.html_get_sprint_status(sprint_id, board_id)
original_standard_task_id_list = jira.get_standard_tasks_id_by_sprint(
sprint_id, project_name)
original_standard_tasks_info_by_sprint = jira.get_standard_tasks_info_by_sprint(
sprint_id, project_name)
original_unplanned_tasks_info = jira.get_unplanned_tasks_by_sprint(
sprint_id, board_id, project_name)
original_planned_tasks_info = jira.get_planned_tasks_by_sprint(
sprint_id, board_id, project_name)
original_raw_bug_id_list = jira.get_bug_id_by_sprint(
sprint_id, board_id, project_name)
original_raw_bug_list = jira.get_bug_info_by_sprint(
sprint_id, board_id, project_name)
original_change_request_id_list = jira.get_change_request_id_by_sprint(
sprint_id, project_name)
original_raw_change_request_list = jira.get_change_request_info_by_sprint(
sprint_id, project_name)
original_raw_live_defect_id_list = jira.get_live_defect_id_by_sprint(
sprint_id, project_name)
original_raw_live_defect_list = jira.get_live_defect_info_by_sprint(
sprint_id, project_name)
original_bugs_opened_before_but_closed_in_sprint = jira.get_bugs_not_found_in_sprint_but_closed_in_sprint(
sprint_id, board_id, project_name)
original_raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(
sprint_id, board_id, project_name)
if "quick_filter" in session:
if str(session["quick_filter"]) != str(
config.show_all_but_exclude_those_have_components):
standard_task_id_list = jira.get_filtered_task_id_by_component(
original_standard_task_id_list, session["quick_filter"])
#
standard_tasks_info_by_sprint = jira.get_filtered_task_info_by_component(
original_standard_tasks_info_by_sprint,
session["quick_filter"])
#
unplanned_tasks_info = jira.get_filtered_task_info_by_component(
original_unplanned_tasks_info, session["quick_filter"])
#
planned_tasks_info = jira.get_filtered_task_info_by_component(
original_planned_tasks_info, session["quick_filter"])
#
raw_bug_id_list = jira.get_filtered_task_id_by_component(
original_raw_bug_id_list, session["quick_filter"])
#
raw_bug_list = jira.get_filtered_task_info_by_component(
original_raw_bug_list, session["quick_filter"])
#
change_request_id_list = jira.get_filtered_task_id_by_component(
original_change_request_id_list, session["quick_filter"])
#
raw_live_defect_id_list = jira.get_filtered_task_id_by_component(
original_raw_live_defect_id_list, session["quick_filter"])
#
raw_live_defect_list = jira.get_filtered_task_info_by_component(
original_raw_live_defect_list, session["quick_filter"])
#
bugs_opened_before_but_closed_in_sprint = jira.get_filtered_task_info_by_component(
original_bugs_opened_before_but_closed_in_sprint,
session["quick_filter"])
#
raw_automation_bug_list = jira.get_filtered_task_info_by_component(
original_raw_automation_bug_list, session["quick_filter"])
#
raw_change_request_list = jira.get_filtered_task_info_by_component(
original_raw_change_request_list, session["quick_filter"])
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(
sprint_id, board_id, project_name, session["quick_filter"])
else:
standard_task_id_list = original_standard_task_id_list
standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint
raw_bug_id_list = original_raw_bug_id_list
raw_bug_list = original_raw_bug_list
change_request_id_list = original_change_request_id_list
raw_live_defect_id_list = original_raw_live_defect_id_list
raw_live_defect_list = original_raw_live_defect_list
unplanned_tasks_info = original_unplanned_tasks_info
planned_tasks_info = original_planned_tasks_info
bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint
raw_automation_bug_list = original_raw_automation_bug_list
raw_change_request_list = original_raw_change_request_list
filter_string_list = []
filter_string = ','
for item in config.quick_filter_choice[session["project_name"]]:
if str(item[0]) != str(
config.show_all_but_exclude_those_have_components
) and str(item[0]) != str(config.show_all):
filter_string_list.append(item[0])
filter_string = ',' + item[0] + filter_string
filter_string = filter_string.strip(',')
standard_task_id_list = jira.exclude_filtered_task_id_by_component(
standard_task_id_list, filter_string_list)
#
standard_tasks_info_by_sprint = jira.exclude_filtered_task_info_by_component(
standard_tasks_info_by_sprint, filter_string_list)
#
unplanned_tasks_info = jira.exclude_filtered_task_info_by_component(
unplanned_tasks_info, filter_string_list)
#
planned_tasks_info = jira.exclude_filtered_task_info_by_component(
planned_tasks_info, filter_string_list)
#
raw_bug_id_list = jira.exclude_filtered_task_id_by_component(
raw_bug_id_list, filter_string_list)
#
raw_bug_list = jira.exclude_filtered_task_info_by_component(
raw_bug_list, filter_string_list)
#
change_request_id_list = jira.exclude_filtered_task_id_by_component(
change_request_id_list, filter_string_list)
#
raw_live_defect_id_list = jira.exclude_filtered_task_id_by_component(
raw_live_defect_id_list, filter_string_list)
#
raw_live_defect_list = jira.exclude_filtered_task_info_by_component(
raw_live_defect_list, filter_string_list)
#
bugs_opened_before_but_closed_in_sprint = jira.exclude_filtered_task_info_by_component(
bugs_opened_before_but_closed_in_sprint, filter_string_list)
#
raw_automation_bug_list = jira.exclude_filtered_task_info_by_component(
raw_automation_bug_list, filter_string_list)
#
raw_change_request_list = jira.exclude_filtered_task_info_by_component(
raw_change_request_list, filter_string_list)
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint_exclude_component_filter(
sprint_id, board_id, project_name, filter_string)
else:
standard_task_id_list = original_standard_task_id_list
standard_tasks_info_by_sprint = original_standard_tasks_info_by_sprint
#
unplanned_tasks_info = original_unplanned_tasks_info
planned_tasks_info = original_planned_tasks_info
#
raw_bug_id_list = original_raw_bug_id_list
raw_bug_list = original_raw_bug_list
#
change_request_id_list = original_change_request_id_list
#
raw_live_defect_id_list = original_raw_live_defect_id_list
#
raw_live_defect_list = original_raw_live_defect_list
bugs_opened_before_but_closed_in_sprint = original_bugs_opened_before_but_closed_in_sprint
#
raw_automation_bug_list = original_raw_automation_bug_list
#
raw_change_request_list = original_raw_change_request_list
#
bug_trends = jira.html_get_total_bug_and_open_bug_trend_by_sprint(
sprint_id, board_id, project_name)
actual_points = jira.get_actual_story_points_by_sprint(
sprint_id, board_id, standard_tasks_info_by_sprint)
unplanned_story_points = jira.html_get_unplanned_story_porints_by_sprint(
unplanned_tasks_info)
unplanned_nest_lists = jira.html_get_unplanned_tasks_by_sprint(
unplanned_tasks_info)
planned_nest_lists = jira.html_get_planned_tasks_by_sprint(
planned_tasks_info)
release_tasks_with_fix_version_and_size = jira.get_filtered_task_info_by_fix_version(
planned_tasks_info)
t_size_number = jira.get_task_members_by_t_size(
release_tasks_with_fix_version_and_size)
nested_release_tasks_with_fix_version_and_size = jira.html_get_release_tasks_with_fix_version_and_size(
release_tasks_with_fix_version_and_size)
un_completed_story_points = jira.html_get_un_completed_story_porints_by_sprint(
sprint_id, board_id, standard_tasks_info_by_sprint)
raw_completed_tasks_nest_lists = jira.get_un_completed_tasks_by_sprint(
sprint_id, board_id, standard_tasks_info_by_sprint)
un_completed_tasks_nest_lists = jira.html_get_un_completed_tasks_by_sprint(
raw_completed_tasks_nest_lists)
un_completed_tasks_percentage = jira.html_get_un_completed_tasks_percentage(
raw_completed_tasks_nest_lists, standard_tasks_info_by_sprint)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
previous_bugs_closed_in_sprint = jira.html_get_bug_list_by_tasks(
bugs_opened_before_but_closed_in_sprint)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(
raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentage(
raw_bug_id_list, raw_automation_bug_list)
sprint_live_defect_nested_list = jira.html_get_bug_list_by_tasks(
raw_live_defect_list)
sprint_live_defect_percentage = jira.html_get_live_defect_percentage_of_all_defects(
raw_live_defect_id_list, raw_bug_id_list)
sprint_change_request_nested_list = jira.html_get_bug_list_by_tasks(
raw_change_request_list)
sprint_change_request_percentage = jira.html_get_change_request_percentage_of_all_defects(
standard_task_id_list, change_request_id_list)
#
bug_priority_list = jira.html_get_share_ratio_by_priority(raw_bug_list)
bug_priority_detail = jira.html_get_share_ratio_detail_by_priority(
raw_bug_list)
#
story_list = jira.get_task_id_that_has_linked_task(raw_bug_id_list)
story_share = jira.html_get_linked_issue_num_group_by_story(story_list)
story_share_detail = jira.html_get_linked_issue_detail_group_by_story(
story_list, raw_bug_id_list)[1]
story_share_detail = jira.html_get_bug_list_by_tasks(story_share_detail)
render = render_template('sprint_report.html', project_required=project_name, \
customized_component=session["quick_filter"] if "quick_filter" in session \
and str(session["quick_filter"]) != str(config.show_all_but_exclude_those_have_components) else None, \
sprint_name_string=sprint_name, \
qa_resource = qa, \
sprint_status=sprint_status, actual_story_points=actual_points, \
unplanned_story_points=unplanned_story_points, unplanned_nest_lists=unplanned_nest_lists, \
planned_nest_lists =planned_nest_lists,\
un_finished_tasks_nest_lists=un_completed_tasks_nest_lists, \
un_completed_story_points = un_completed_story_points, \
un_completed_tasks_percentage=un_completed_tasks_percentage, \
un_completed_tasks_nest_lists=un_completed_tasks_nest_lists, \
sprint_bug_nested_lists=sprint_bug_nested_list, \
bug_priority_nested_lists=bug_priority_list, \
bug_priority_share_detail_info=bug_priority_detail, \
story_share_nested_lists=story_share, \
story_share_detail_info=story_share_detail, \
total_bug_and_opened_bug_pair_nested_list=bug_trends, \
sprint_automation_found_bug_nested_lists=sprint_automation_bug_list, \
sprint_automation_bug_percentage=sprint_automation_bug_percentage, \
previous_bugs_closed_in_sprint = previous_bugs_closed_in_sprint,
sprint_live_defect_nested_lists=sprint_live_defect_nested_list, \
sprint_live_defect_percentage=sprint_live_defect_percentage, \
sprint_change_request_nested_lists=sprint_change_request_nested_list, \
sprint_change_request_percentage=sprint_change_request_percentage, \
t_size_number=t_size_number,\
release_tasks_with_fix_version_and_size=nested_release_tasks_with_fix_version_and_size
)
global response
response = make_response(render)
session.clear()
return render
# -*- coding: utf-8 -*-
__author__ = 'kevin.cai'
import settings
from pages.jira_helper import JiraHelper
from pages.html_report_helper import HTML_Report
if __name__ == '__main__':
jira = JiraHelper(settings.jira_options, settings.jira_account)
h = HTML_Report()
sprint_name = "Sprint 1517 (12/28 - 01/15)"
sprint_id = jira.get_sprint_id_by_sprint_name(settings.board_id,
sprint_name)
sprint_status = jira.html_get_sprint_status(sprint_id)
actual_points = jira.html_get_actual_story_points_by_sprint(sprint_id)
#
raw_bug_list = jira.get_bug_info_by_sprint(sprint_id)
sprint_bug_nested_list = jira.html_get_bug_list_by_tasks(raw_bug_list)
#
raw_automation_bug_list = jira.get_automation_found_bug_info_by_sprint(
sprint_id)
sprint_automation_bug_list = jira.html_get_bug_list_by_tasks(
raw_automation_bug_list)
sprint_automation_bug_percentage = jira.html_get_automation_found_bug_percentange(
sprint_id)