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(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(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(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(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(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(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)
