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