def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(mf_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) page_num = data.get('page_num') page_size = data.get('page_size', 10) mf_list = list() try: mfs = Manufacturer.query.filter_by(status=1).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if mfs: for mf in mfs: mf_info = { 'mf_id': mf.id, 'mf_name': mf.name, } mf_list.append(mf_info) data, total = list_page(mf_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(user_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) page_num = data.get('page_num') page_size = data.get('page_size', 10) user_list = list() if not page_num: res.update(code=-1, data='', msg=param_error) return jsonify(res.data) try: users = User.query.all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if users: for u in users: status = 1 if u.status else 0 user_info = { 'uid': u.id, 'username': u.username, 'role': u.roles.name, 'status': status, } user_list.append(user_info) data, total = list_page(user_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(case_res_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) case_id = data.get('case_id') page_num = data.get('page_num') page_size = data.get('page_size', 10) case_res_list = list() exist_case = TestCase.query.filter_by(id=case_id, status=True).first() if not exist_case: res.update(code=-1, data='', msg=case_not_exist_error) return jsonify(res.data) try: case_results = CaseResult.query.filter_by(case_id=case_id).order_by(CaseResult.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if case_results: for cr in case_results: case_info = { 'case_result_id': cr.id, 'case_type': cr.case_type, 'method': cr.method, 'path': cr.path, 'case_result': cr.case_result, 'start_time': datetime.datetime.strftime(cr.start_time, "%Y-%m-%d %H:%M:%S"), } case_res_list.append(case_info) data, total = list_page(case_res_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(eq_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) page_num = data.get('page_num') page_size = data.get('page_size', 10) eq_list = list() try: equip = Equipment.query.filter_by(status=1).order_by(Equipment.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if equip: for eq in equip: eq_info = { 'eq_id': eq.id, 'eq_code': eq.eq_code, 'eq_name': eq.eq_name, 'eq_type': eq.eq_type, 'eq_sys': eq.eq_sys, 'eq_sys_ver': eq.eq_sys_ver, 'eq_owner': eq.eq_owner, 'borrower': eq.borrower, 'have_sim': eq.have_sim, 'eq_status': eq.eq_status, 'mf_name': eq.manufacturers.name, } eq_list.append(eq_info) data, total = list_page(eq_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(model_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) project_id = data.get('project_id') page_num = data.get('page_num') page_size = data.get('page_size', 10) model_list = list() try: models = Model.query.filter_by(project_id=project_id, status=True).order_by( Model.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if models: for m in models: model_info = { 'model_id': m.id, 'model_name': m.model_name, 'create_user': m.users.username, } model_list.append(model_info) data, total = list_page(model_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(env_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) page_num = data.get('page_num') page_size = data.get('page_size', 10) env_list = list() try: environments = Environment.query.filter_by(status=True).order_by( Environment.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if environments: for env in environments: env_info = { 'env_id': env.id, 'env_name': env.env_name, 'url': env.url, 'create_user': env.users.username, } env_list.append(env_info) data, total = list_page(env_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(UserInfoByXid_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) xid = data.get('xid') data = get_user_info_by_xid(xid) pager = Pager(data) data = pager.page_data() res.update(code=1, data=data, msg=request_success) res.add_field(name='data_total', value=pager.data_count) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(eq_log_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) eq_id = data.get('eq_id') page_num = data.get('page_num') page_size = data.get('page_size', 10) eq_log_list = list() exist_eq = Equipment.query.filter_by(id=eq_id, status=1).first() if not exist_eq: res.update(code=-1, data='', msg=eq_not_exist_error) return jsonify(res.data) try: equip_log = EquipmentLog.query.filter_by(eq_id=eq_id).order_by(EquipmentLog.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if equip_log: for el in equip_log: eq_log = { 'eq_log_id': el.id, 'eq_code': el.eq_code, 'eq_name': el.eq_name, 'eq_desc': el.eq_desc, 'eq_type': el.eq_type, 'eq_sys': el.eq_sys, 'eq_sys_ver': el.eq_sys_ver, 'eq_owner': el.eq_owner, 'borrower': el.borrower, 'have_sim': el.have_sim, 'eq_log_status': el.status, 'mf_name': el.manufacturers.name, 'c_user': el.users.username, } eq_log_list.append(eq_log) data, total = list_page(eq_log_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(pro_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) project_name = data.get('project_name') page_num = data.get('page_num') page_size = data.get('page_size', 10) project_list = list() try: projects = Project.query.filter_by(status=True).order_by( Project.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if projects: for p in projects: if project_name: if project_name in p.project_name: project_info = { 'project_id': p.id, 'project_name': p.project_name, 'create_user': p.users.username, } project_list.append(project_info) else: project_info = { 'project_id': p.id, 'project_name': p.project_name, 'create_user': p.users.username, } project_list.append(project_info) data, total = list_page(project_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(CourseInfoByMobile_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) mobile = data.get('mobile') page_size = data.get('pageSize') page_num = data.get('pageNum') data = get_course_info_by_mobile(mobile) pager = Pager(data, page_size) data = pager.page_data(page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_size', value=pager.page_size) res.add_field(name='page_num', value=page_num) res.add_field(name='page_total', value=pager.page_total_num) res.add_field(name='data_total', value=pager.data_count) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(LiveLessonToday_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) page_size = data.get('pageSize') page_num = data.get('pageNum') data = get_live_lesson_yesterday() if data is False: res.update(code=-1, data='', msg=lld_locked) return jsonify(res.data) pager = Pager(data, page_size) data = pager.page_data(page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_size', value=pager.page_size) res.add_field(name='page_num', value=page_num) res.add_field(name='page_total', value=pager.page_total_num) res.add_field(name='data_total', value=pager.data_count) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(case_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) project_id = data.get('project_id') model_id = data.get('model_id') interface_id = data.get('interface_id') case_name = data.get('case_name') if data.get('case_name') is not None else '' page_num = data.get('page_num') page_size = data.get('page_size', 10) case_list = list() if interface_id: try: cases = TestCase.query.filter_by(interface_id=interface_id, status=True).filter( TestCase.case_name.like('%' + case_name + '%') ).order_by(TestCase.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) elif model_id: try: interface_list = [x.id for x in Interface.query.filter_by(model_id=model_id, status=True)] cases = TestCase.query.filter(TestCase.status == True).filter(TestCase.interface_id.in_(interface_list))\ .filter(TestCase.case_name.like('%' + case_name + '%')).all() # cases = TestCase.query.filter_by(model_id=model_id, status=True)\ # .order_by(TestCase.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) elif project_id: try: interface_list = [x.id for x in Interface.query.filter_by(project_id=project_id, status=True)] cases = TestCase.query.filter(TestCase.status == True).filter(TestCase.interface_id.in_(interface_list))\ .filter(TestCase.case_name.like('%' + case_name + '%')).all() # cases = TestCase.query.filter_by(project_id=project_id, status=True)\ # .order_by(TestCase.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) else: try: cases = TestCase.query.filter_by(status=True).filter( TestCase.case_name.like('%' + case_name + '%') ).order_by(TestCase.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if cases: for c in cases: project_name = c.interfaces.projects.project_name if c.interfaces.project_id else '' model_name = c.interfaces.models.model_name if c.interfaces.model_id else '' interface_name = c.interfaces.Interface_name if c.interface_id else '' case_info = { 'case_id': c.id, 'case_name': c.case_name, 'case_type': c.case_type, 'method': c.method, 'url': c.environments.url, 'path': c.path, 'project_name': project_name, 'model_name': model_name, 'interface_name': interface_name, 'create_user': c.users.username, } case_list.append(case_info) data, total = list_page(case_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): res = ResMsg() data = request.get_json() flag, mes = format_checker(interface_list_schema, data) if not flag: res.update(code=-1, data=mes, msg=param_format_error) return jsonify(res.data) project_id = data.get('project_id') model_id = data.get('model_id') interface_name = data.get('interface_name') if data.get( 'interface_name') is not None else '' page_num = data.get('page_num') page_size = data.get('page_size', 10) interface_list = list() if model_id: try: interfaces = Interface.query.filter_by( model_id=model_id, status=True).filter( Interface.Interface_name.like( '%' + interface_name + '%')).order_by( Interface.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) elif project_id: try: interfaces = Interface.query.filter_by( project_id=project_id, status=True).filter( Interface.Interface_name.like( '%' + interface_name + '%')).order_by( Interface.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) else: try: interfaces = Interface.query.filter_by(status=True).filter( Interface.Interface_name.like( '%' + interface_name + '%')).order_by( Interface.id.desc()).all() except Exception as e: res.update(code=-1, data=str(e), msg=request_fail) return jsonify(res.data) if interfaces: for i in interfaces: project_name = i.projects.project_name if i.project_id else '' model_name = i.models.model_name if i.model_id else '' interface_info = { 'interface_id': i.id, 'interface_name': i.Interface_name, 'interface_type': i.interface_type, 'method': i.method, 'path': i.path, 'project_name': project_name, 'model_name': model_name, 'create_user': i.users.username, } interface_list.append(interface_info) data, total = list_page(interface_list, page_size, page_num) res.update(code=1, data=data, msg=request_success) res.add_field(name='page_total_num', value=total) return jsonify(res.data)
def post(self): # 返回 res = ResMsg() report_list = list() # 获取请求数据 data = request.get_json() product_id = data.get("product_id") module_id = data.get("module_id") product_name = data.get("product_name") module_name = data.get("module_name") start_day = data.get("start_day") end_day = data.get("end_day") page_num = data.get('page_num') page_size = data.get('page_size', 10) # 调用方法,创建/跟新数据 if product_id != '' and end_day != '': new_end_day = datetime.datetime.now().strftime("%Y-%m-%d") update_data(product_id, module_id, product_name, module_name, start_day, new_end_day) try: if product_id == '' and module_id == '' and start_day == '' and end_day == '': report_product_list = ReportProduct.query.filter() \ .order_by(ReportProduct.id.desc()).limit(page_size) \ .offset((page_num - 1) * page_size) \ .all() elif start_day != '' or end_day != '': report_product_list = ReportProduct.query.filter(ReportProduct.start_day >= start_day, ReportProduct.start_day <= end_day) \ .order_by(ReportProduct.id.desc()).limit(page_size) \ .offset((page_num - 1) * page_size) \ .all() else: report_product_list = ReportProduct.query.filter(ReportProduct.product_id == product_id, ReportProduct.module_id == module_id, ReportProduct.start_day >= start_day, ReportProduct.start_day <= end_day) \ .order_by(ReportProduct.id.desc()).limit(page_size) \ .offset((page_num - 1) * page_size) \ .all() total = db.session.query(func.count(ReportProduct.id)).scalar() for product in report_product_list: report_info = { 'id': product.id, 'product_id': product.product_id, 'product_name': product.product_name, 'module_id': product.module_id, 'module_name': product.module_name, 'start_day': product.start_day, 'end_day': product.end_day } report_list.append(report_info) res.update(code=1, data=report_list, msg='获取成功!') res.add_field(name='page_num', value=page_num) res.add_field(name='page_size', value=page_size) res.add_field(name='total', value=total) return jsonify(res.data) except Exception as e: res.update(code=-1, data='', msg='获取失败!') return jsonify(res.data)