一、接口自动化的实现总流程图逻辑流程代码模块流程二、各个环节概述2.1 case的管理推荐方式数据库、excel示例2.2 主要模块简介util---operation_excel:操作excel#-*-encoding:utf-8-*- import xlrd from xlutils.copy import copy import os diros.path.dirname(os.path.dirname(os.path.abspath(__file__))) class OperationExcel(): 操作excel获取testcase def __init__(self,filenameNone,sheet_idNone): if filename: self.filenamefilename self.sheet_idsheet_id else: self.filename dir\\dataconfig\\interface.xlsx self.sheet_id 0 self.data self.get_data() #获取sheet的内容 def get_data(self): dataxlrd.open_workbook(self.filename) table data.sheets()[self.sheet_id] return table #获取sheet的行数 def get_lines(self): self.linesself.data.nrows return self.lines #获取某一个单元格的内容 def get_cell_value(self,row,column): self.cell_valueself.data.cell_value(row,column) return self.cell_value #写入单元格内容 def write_cell_value(self,row,column,value): read_data xlrd.open_workbook(self.filename) write_data copy(read_data) sheet_data write_data.get_sheet(self.sheet_id) sheet_data.write(row,column,value) write_data.save(self.filename) #根据caseid,找到对应用例所在行的内容 def get_row_data(self,case_id): row_num self.get_row_num(case_id) row_dataself.get_row_values(row_num) return row_data #根据case_id找到对应用例的行的行所在的索引号行号 def get_row_num(self,case_id): row_num0 cols_data self.get_col_data() for col_data in cols_data: if case_id in col_data: return row_num row_num row_num1 #根据行号row找到该行的内容 def get_row_values(self,row): row_data self.data.row_values(row) return row_data #根据列column获取某一列的内容 def get_col_data(self,columnNone): if column ! None: col_dataself.data.col_values(column) else: col_data self.data.col_values(0) return col_datautil-operation_json:操作json# coding:utf-8 # Time : 2026/8/16 09:49 # Author : ithing # FileName: json_operation.py import json class OperationJson(): 操作json文件 def __init__(self, surce_path../resources/data/msg.js): self.surce_path surce_path self.data self.read_data() # 读取json文件 def read_data(self): try: with open(self.surce_path, r,encodingutf-8) as fp: data json.load(fp) except Exception as e: data {error: 文件读取错误} finally: return data # 根据关键字获取数据 def get_data(self, key): if key in self.data: return self.data[key] else: return %s对应的值不存在%key # 写json def write_data(self, value): try: with open(self.surce_path, w, encodingutf-8) as fp: fp.write(json.dumps(value)) res 写入成功 except Exception as e: res 写入错误请排查数据类型、关键字等, e finally: return resrunmethod:基于requests封装的函数#-*-encoding:utf-8-*- import requests,json,urllib3 from urllib3.exceptions import InsecureRequestWarning #避免添加verify参数后安全请求警告 urllib3.disable_warnings(InsecureRequestWarning) class RunMethod(): def post_main(self,url,data,headerNone): 备注这里header主要是cookies;如果之后接口不仅是cookies需要重新添加header、cookies :param url: :param data: :param header: :return: resNone if header !None: resrequests.post(urlurl,datadata,cookiesheader,verifyFalse) try: resres.json() return json.dumps(res, ensure_asciiFalse, indent2, sort_keysTrue) except: return res.text else: resrequests.post(urlurl,datadata,verifyFalse) try: resres.json() return json.dumps(res, ensure_asciiFalse, indent2, sort_keysTrue) except: return res.text def get_main(self,url,dataNone,headerNone): 备注这里header主要是cookies;如果之后接口不仅是cookies需要重新添加header、cookies :param url: :param data: :param header: :return: resNone if header !None: resrequests.get(urlurl,datadata,cookiesheader,verifyFalse) try: resres.json() return json.dumps(res, ensure_asciiFalse, indent2, sort_keysTrue) except: return json.dumps(res.text) else: resrequests.get(urlurl,datadata,verifyFalse) try: resres.json() return json.dumps(res, ensure_asciiFalse, indent2, sort_keysTrue) except: return json.dumps(res.text) def run_main(self,method,url,data,headerNone): resNone if method post: resself.post_main(url,data,header) else: resself.get_main(url,data,header) return resmain--run_main:#-*-encoding:utf-8-*- import os,sys #备注在jenkins构建项目时有可能找不到项目地址、python项目的环境地址所以需要加入 #加入项目地址 dir os.path.dirname(os.path.dirname(os.path.abspath(__file__))) sys.path.append(dir) #加入环境的三方包地址 sys.path.append(D:\\environment\\pyhon\\Lib\\site-packages) from base.runmethod import RunMethod from util import operation_excel,common_util from data.get_data import GetData from data.dependent_data import DependentData from util.send_email import SendEmial from util.operation_header import OperatonHeader from util.operation_json import OperationJson class RunTest: def __init__(self): self.run_method RunMethod() self.data GetData() self.com_util common_util.CommonUtil() def go_on_run(self): resNone pass_row[]#excel中通过用例的行号 fail_row[]#excel中失败用例的行号 rows_countself.data.get_case_lines() print(str(rows_count)-----------------------------------------------) for i in range(1,rows_count): print(i) is_run self.data.is_run(i) if is_run: url self.data.get_request_url(i) method self.data.get_request_method(i) header self.data.is_header(i) data self.data.get_request_data_for_json(i) expect self.data.get_expect_data(i) depend_fied self.data.is_depend(i) if depend_fied !None: self.depend_data DependentData() #获取的依赖用例响应的数据的那个字段的值 depend_response_data self.depend_data.get_depend_data_for_key(i) #获取依赖的所属字段 depend_key self.data.is_depend(i) data[depend_key] depend_response_data #header有无判断进行不同操作 if header write: operaheaderOperatonHeader() res operaheader.write_cookie_in_json(url,data) elif header !None and header ! write: res self.run_method.run_main(method, url, data, header) else: res self.run_method.run_main(method, url, data) print(res) if self.com_util.is_contain(expect,res): pass_row.append(i) self.data.write_result(i,测试通过) print(测试通过——————————————————————————————》) else: fail_row.append(i) self.data.write_result(i, res) print(测试失败————————————————————————————————》) send_email SendEmial() send_email.send_main(pass_row,fail_row) if __name__ __main__: run RunTest() resrun.go_on_run()