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