def close(project_id, cycle_id): # TODO: Check untested cases. """POST endpoint for closing cycles. Param: { reason: required, } """ project = get_project(project_id) cycle = get_cycle(cycle_id, project_id) if cycle.state_code == StateType.closed: return make_response(jsonify(message='CYCLE_CLOSED')) else: reason = check_none_and_blank(request, 'reason') user = g.user cycle.closed_reason = reason cycle.closed_by = user.id cycle.state_code = StateType.closed cycle.closed_at = datetime.now() cycle.last_change = datetime.now() db.session.add(cycle) db.session.commit() return make_response(jsonify(message='CYCLE_CLOSED'))
def get_cycle_timeline_resume(project_id, cycle_limit=5): # TODO: Need to find a better way - Did this cz chartist works like that. project = get_project(project_id) project_cycles = Cycle.query.filter_by( project_id=project.id).limit(cycle_limit).all() cycles = [] cycle_cases_passed = [] cycle_cases_failed = [] cycle_cases_blocked = [] cycle_cases_not_executed = [] for item in project_cycles: cycle_cases = CycleCases.query.filter_by(cycle_id=item.id).all() stats = count_cycle_stats(cycle_cases) cycles.append('Cycle Number {}'.format(item.cycle)) cycle_cases_passed.append(stats['total_passed']) cycle_cases_failed.append(stats['total_error']) cycle_cases_blocked.append(stats['total_blocked']) cycle_cases_not_executed.append(stats['total_not_executed']) return make_response( jsonify(cycles_number=cycles, cycles_passed=cycle_cases_passed, cycles_failed=cycle_cases_failed, cycles_blocked=cycle_cases_blocked, cycles_not_executed=cycle_cases_not_executed))
def get_cycle_resume(project_id, cycle_id): project = get_project(project_id) cycle = get_cycle(cycle_id, project_id) cycle_cases_h = CycleCases.query.filter_by(cycle_id=cycle.id).all() body_response = count_cycle_stats(cycle_cases_h) return make_response(jsonify(body_response))
def get_scenarios_for_cyle(project_id, cycle_id): project = get_project(project_id) cycle = get_cycle(cycle_id, project_id) cycle_scenarios_h = CycleScenarios.query.filter_by(cycle_id=cycle.id).all() scenarios = Scenario.query.filter_by(project_id=project_id).all() obj = [] for item in cycle_scenarios_h: for scenario in scenarios: if scenario.id == item.scenario_id: cases = CycleCases.query.filter_by( cycle_id=cycle.id).filter_by( scenario_id=scenario.id).all() scenario_tags_raw = TagScenario.query.filter_by( scenario_id=scenario.id).all() schema = TagScenarioSchema(many=True) scenario_tags = schema.dump(scenario_tags_raw).data temp = {} temp['scenario_name'] = scenario.name temp['scenario_id'] = scenario.id temp['scenario_cycle_id'] = item.id temp['cases_stats'] = count_cycle_stats(cases) temp['tags'] = scenario_tags obj.append(temp) break return make_response(jsonify(obj))
def get_cases_for_cyle(project_id, cycle_id, scenario_id): project = get_project(project_id) scenario = get_scenario(scenario_id) cycle = get_cycle(cycle_id, project_id) cycle_cases_h = CycleCases.query.filter_by(cycle_id=cycle.id).all() cases = Case.query.filter_by(scenario_id=scenario.id) obj = [] for item in cycle_cases_h: for case in cases: if item.case_id == case.id: cases_tags_raw = TagCase.query.filter_by(case_id=case.id).all() schema = TagCaseSchema(many=True) case_tags = schema.dump(cases_tags_raw).data temp = {} temp['case_name'] = case.name temp['case_id'] = case.id temp['case_cycle_id'] = item.id temp['case_cycle_state'] = item.state_code.value temp['tags'] = case_tags obj.append(temp) break return make_response( jsonify(scenario_name=scenario.name, scenario_id=scenario.id, cycle_id=cycle.id, cases=obj))
def edit(project_id): """POST endpoint for editing existing users. Param: { project_name: not required, privacy_policy: not required (public or false), project_owner: not required (id), type_of_project: not required } """ edited_project = get_project(project_id) if 'project_name' in request.json: project_name = check_none_and_blank(request, 'project_name') edited_project.name = project_name if 'privacy_policy' in request.json: privacy_policy = check_none_and_blank(request, 'privacy_policy') edited_project.privacy_policy = privacy_policy if 'project_owner' in request.json: project_owner = check_none_and_blank(request, 'project_owner') user = get_user({'id': project_owner}) edited_project.owner_id = user.id if 'type_of_project' in request.json: type_of_project = check_none_and_blank(request, 'type_of_project') edited_project.type_of_project = type_of_project db.session.add(edited_project) db.session.commit() return make_response(jsonify(message='PROJECT_EDITED'))
def get_cycle_timeline_resume(project_id, cycle_limit=7): # TODO: Need to find a better way - Did this cz chartist works like that. project = get_project(project_id) project_cycles = Cycle.query.filter_by(project_id=project.id).order_by( Cycle.id.desc()).limit(cycle_limit).all() cycles = [] cycle_cases_passed = [] cycle_cases_failed = [] cycle_cases_blocked = [] cycle_cases_not_executed = [] for item in reversed(project_cycles): cycle_cases = CycleCases.query.filter_by(cycle_id=item.id).all() stats = count_cycle_stats(cycle_cases) if item.cycle == project_cycles[0].cycle: cycles.append('Current Cycle') else: if item.name == "": cycles.append('Cycle Number {}'.format(item.cycle)) else: cycles.append(item.name) cycle_cases_passed.append(stats['total_passed']) cycle_cases_failed.append(stats['total_error']) cycle_cases_blocked.append(stats['total_blocked']) cycle_cases_not_executed.append(stats['total_not_executed']) return make_response( jsonify(cycles_number=cycles, cycles_passed=cycle_cases_passed, cycles_failed=cycle_cases_failed, cycles_blocked=cycle_cases_blocked, cycles_not_executed=cycle_cases_not_executed))
def get_project_details(project_id): """Show Project Details and last cycle Details.""" schema = ProjectSchema(many=False) project = schema.dump(get_project(project_id)).data user = User.query.filter_by(id=project['owner_id']).first() scenarios = Scenario.query.filter_by(project_id=project_id).first() project['owner_name'] = user.name project['owner_email'] = user.email if scenarios: project['have_scenarios'] = True cases = Case.query.join( Scenario, Case.scenario_id == Scenario.id).filter( Scenario.project_id == project_id).filter( Case.state_code == StateType.active).all() if len(cases) == 0: project['have_active_cases'] = False else: project['have_active_cases'] = True else: project['have_scenarios'] = False project['have_active_cases'] = False project_last_cycle = get_last_cycle(project_id) if project_last_cycle: cycle_cases_h = CycleCases.query.filter_by( cycle_id=project_last_cycle.id).all() project['have_cycles'] = True project['last_cycle'] = {} if project_last_cycle.state_code == StateType.closed: user_ = User.query.filter_by( id=project_last_cycle.closed_by).first() closed_by = user_.name project['last_cycle']['closed_at'] = datetime.strftime( project_last_cycle.closed_at, '%d-%m-%Y') project['last_cycle'][ 'closed_reason'] = project_last_cycle.closed_reason project['last_cycle']['closed_by'] = closed_by project['last_cycle']['id'] = project_last_cycle.id project['last_cycle'][ 'state_code'] = project_last_cycle.state_code.value project['last_cycle']['cycle'] = project_last_cycle.cycle project['last_cycle']['created_at'] = datetime.strftime( project_last_cycle.created_at, '%d-%m-%Y') project['last_cycle']['stats'] = count_cycle_stats(cycle_cases_h) else: project['have_cycles'] = False return make_response(jsonify(project))
def create(project_id): """POST endpoint for new cycles. Param: {'cycle_name': required but can be empty } """ project = get_project(project_id) project_lasty_cycle = get_last_cycle(project.id) if project_lasty_cycle: if project_lasty_cycle.state_code == StateType.active: return make_response(jsonify(message='CURRENT_CYCLE_ACTIVE')) cycle_number = int(project_lasty_cycle.cycle) + 1 else: cycle_number = 1 scenarios = Scenario.query.filter_by(project_id=project.id).filter_by( state_code=StateType.active).all() cases = Case.query.join(Scenario, Case.scenario_id == Scenario.id).filter( Scenario.project_id == project.id).filter( Case.state_code == StateType.active).all() if len(cases) == 0: abort(make_response(jsonify(message='NO_TEST_SCENARIOS'))) if request.json.get( 'cycle_name') == '' or request.json.get('cycle_name') is None: cycle_name = request.json.get('cycle_name') else: cycle_name = "Cycle Number {}".format(cycle_number) new_cycle = Cycle(cycle=cycle_number, name=cycle_name, project_id=project.id) db.session.add(new_cycle) db.session.commit() for scenario in scenarios: scenario_cycle = CycleScenarios(cycle_id=new_cycle.id, scenario_id=scenario.id) db.session.add(scenario_cycle) for case in cases: cyclecase = CycleCases(cycle_id=new_cycle.id, case_id=case.id, scenario_id=case.scenario_id) db.session.add(cyclecase) db.session.commit() return make_response( jsonify(message='CYCLE_CREATED', cycle_id=new_cycle.id))
def get_project_details(project_id): """Show Project Details and last cycle Details.""" schema = ProjectSchema(many=False) project = schema.dump(get_project(project_id)).data user = User.query.filter_by(id=project['owner_id']).first() scenarios = Scenario.query.filter_by(project_id=project_id).first() project['owner_name'] = user.name project['owner_email'] = user.email if scenarios: project['have_scenarios'] = True cases = Case.query.join( Scenario, Case.scenario_id == Scenario.id).filter( Scenario.project_id == project_id).filter( Case.state_code == StateType.active).all() if len(cases) == 0: project['have_active_cases'] = False else: project['have_active_cases'] = True else: project['have_scenarios'] = False project['have_active_cases'] = False project_last_cycle = get_last_cycle(project_id) if project_last_cycle: cycle_cases_h = CycleCases.query.filter_by( cycle_id=project_last_cycle.id).all() project['have_cycles'] = True project['last_cycle'] = {} if project_last_cycle.state_code == StateType.closed: user_ = User.query.filter_by(id=project_last_cycle.closed_by).first() closed_by = user_.name project['last_cycle']['closed_at'] = datetime.strftime( project_last_cycle.closed_at, '%d-%m-%Y') project['last_cycle']['closed_reason'] = project_last_cycle.closed_reason project['last_cycle']['closed_by'] = closed_by project['last_cycle']['id'] = project_last_cycle.id project['last_cycle']['state_code'] = project_last_cycle.state_code.value project['last_cycle']['cycle'] = project_last_cycle.cycle project['last_cycle']['created_at'] = datetime.strftime( project_last_cycle.created_at, '%d-%m-%Y') project['last_cycle']['stats'] = count_cycle_stats(cycle_cases_h) else: project['have_cycles'] = False return make_response(jsonify(project))