1.基于不同的参数类型（str、int、float、bool、list、tuple、dict、set、None、date、datetime、time、timestamp）自动生成正交测试用例
2.可以自定义参数长度与内容，方便覆盖边界值测试
3.提供自定义过滤参数组合的入口，方便自定义
实现思路
1.抓取api信息（目前公司用的swagger）： https://www.cnblogs.com/qtclm/p/17049176.html ，uri、method、params、response，解析完成后写入excle
2.读取抓取完毕的api信息，处理为allpairs所需要的ordereddict
3.调用allpairs工具生成测试用例
4.解析allpairs生成的测试用例（输出为字符串），并处理为dict
5.处理完毕后写入excel
后期优化
1.根据接口响应实现自动断言
2.增加其他接口平台的api抓取(openapi、eolink等)
3.增加其他自动化生成用例的方法（有效、无效等价类，流量回放等）
4.集成到平台
遇到的问题
1.allpairs只支持两个以上的参数生成，因为参数只有一个时，需要自行处理
2.参数为json嵌套时，allpairs输出的参数需要额外特殊处理，这块也是最麻烦的地方
3.可变类型在循环过程中尽量使用深拷贝对象，避免循环运行中被意外修改
4.类变量、实例变量需要合理运用，例如循环时需要合理的进行初始化
# _*_ coding: UTF-8 _*_
"""
@project -> file : city-test -> rr
@Author : qinmin.vendor
@Date : 2023/1/29 19:44
@Desc : 自动生成接口测试用例：支持正交实验，等价类，边界值
"""
import copy
import json
import os
import random
import re
import sys
from collections import OrderedDict
from allpairspy import AllPairs
from utils.operation_datas import operationExcle
import math
from utils.time_utils import timeUtil
from utils.wrapper_util import exec_time_wrapper
from inspect import isfunction
from faker import Faker
'''faker使用教程：https://blog.csdn.net/qq_42412061/article/details/122997802'''
class autoGenrateApiCaseAllpairspy(object):
time_util = timeUtil()
fake = Faker(locale="zh_cn") # 指定语言为中文
CONST_MAX_STRING_LENGTH = 100
CONST_MIN_STRING_LENGTH = 1
# 生成字符串相关的数据
# special_chars是否包含特殊字符;digits是否包含数字;upper_case是否包含大写字母,lower_case是否包含小写字母
special_character = fake.password(length=8, special_chars=True, digits=False, upper_case=False,
lower_case=False) # 生成随机特殊字符
random_str = fake.paragraph() # 生成随机字符
random_str_max = random_str * math.ceil(CONST_MAX_STRING_LENGTH / len(random_str))
phone_number = fake.phone_number() # 生成随机电话号码
# 生成时间相关的数据
random_date = fake.date(pattern="%Y-%m-%d", end_datetime=None) # 生成随机日期
random_start_datetime = time_util.adjust_time(num=-30)
random_end_datetime = time_util.adjust_time(num=0)
random_start_timestamp_millisecond = time_util.adjust_time(num=-30, is_timestamp=True, millisecond=True)
random_end_timestamp_millisecond = time_util.adjust_time(num=0, is_timestamp=True, millisecond=True)
random_start_timestamp = time_util.adjust_time(num=-30, is_timestamp=True, millisecond=False)
random_end_timestamp = time_util.adjust_time(num=0, is_timestamp=True, millisecond=False)
# 生成int与float相关的数据
random_int = random.randint(1, 100)
random_float = round(random.random(), 6) + random_int # 生成随机字符
random_int_max = str(random_int) * math.ceil(CONST_MAX_STRING_LENGTH / len(str(random_int)))
random_float_max = str(str(random_float) *
math.ceil(CONST_MAX_STRING_LENGTH / len(str(random_float).replace('.', '')))).\
replace('.','') + "." + str(random_int)
STRING_ENUM = ["", None, random_str, special_character,
random_str_max[:CONST_MAX_STRING_LENGTH], random_str[:CONST_MIN_STRING_LENGTH],
random_start_datetime, random_end_datetime, random_date]
INT_FLOAT_ENUM = [0, None, special_character, random_int, random_float,
int(random_int_max[:CONST_MAX_STRING_LENGTH]),
int(str(random_int)[:CONST_MIN_STRING_LENGTH]), int(random_float_max[:CONST_MAX_STRING_LENGTH]),
int(str(random_float)[:CONST_MIN_STRING_LENGTH]), random_start_timestamp,
random_start_timestamp_millisecond, random_end_timestamp, random_end_timestamp_millisecond]
LIST_ENUM=[[], None, [{}]]
BOOL_ENUM=[None, False, True,"true","false"]
OBJECT_ENUM=[None,{}]
NULL_ENUM=[None,"null"]
# 定义接口字段生成的类型与枚举
CONST_TYPE_ENUM = {
str: STRING_ENUM,"string": STRING_ENUM,
int: INT_FLOAT_ENUM,"integer": INT_FLOAT_ENUM,"number": INT_FLOAT_ENUM,
None: NULL_ENUM, "NONE": NULL_ENUM,"null": NULL_ENUM,
float: INT_FLOAT_ENUM,"double": INT_FLOAT_ENUM,
bool: BOOL_ENUM,'bool': BOOL_ENUM,"boolean": BOOL_ENUM,
dict: OBJECT_ENUM,'object': OBJECT_ENUM,set: LIST_ENUM,list: LIST_ENUM,'array': LIST_ENUM,
}
CONST_TYPE_ENUM_COPY = copy.deepcopy(CONST_TYPE_ENUM)
is_array = False #判断参数传入的参数是不是list
params_key_list = [] #判断参数的key对应的value是不是list类型，如果是，就将key存进此对象
extra_cases = [] #存放额外的case,请求参数中的key嵌套json的情况
excle_path = './'
excle_name_params_field_detail = 'auto_genrate_api_case_allpairspy_params_field_detail.xlsx'
excle_name_params_obj = 'auto_genrate_api_case_allpairspy_params_obj_5.xlsx'
# excle_name_cases_data = 'maint-api.xlsx'
excle_name_cases_data = 'maint-apiv2-api-docs.xlsx'
# 递归解析json，原文：https://blog.csdn.net/qq_45662588/article/details/122265447
read_excle_case_field_desc={'case':0,'uri':1,'method':2,"params_path":3,"params_body":5,"response_body":7,"skip":9}
# 数据处理前的case表头，写入excle中最终会删除params_path,且params_body替换为params && response_body替换为expected
write_excle_case_field_desc={'case':0,'uri':1,'method':2,'params_path':3,'params_body':4,'response_body':5,'skip':6}
@classmethod
def custom_valid_combination(cls,row):
"""
自定义过滤条件，返回false的条件不会出现在组合中
"""
n = len(row)
if n > 1:
if row[0] in (None,'',""):
return False
return True
# 指定：自定义过滤函数
all_pairs_filter_func=custom_valid_combination
if not (isfunction(all_pairs_filter_func) or isinstance(all_pairs_filter_func,(classmethod,staticmethod))) :
raise Exception(f"all_pairs_filter_func对象必须是一个方法:{all_pairs_filter_func}")
@classmethod
def read_all_cases_data(cls):
cases_data_obj=operationExcle(excle_path=cls.excle_path,excle_name=cls.excle_name_cases_data)
lines=cases_data_obj.get_lines()+1
case_list=[]
for i in range(lines):
# yield cases_data_obj.get_row_data(i+1)
values=cases_data_obj.get_row_data(i+1)
out_values=[]
for i in cls.read_excle_case_field_desc:
out_values.append(values[cls.read_excle_case_field_desc[i]])
if out_values[0] is not None:
case_list.append(out_values)
return case_list
@classmethod
def dict_parse_generator(cls,params,pre=None):
'''递归解析json，如果key为对应的值是list且list中的元素不是dict，则不返回'''
pre = pre[:] if pre else [] # 纪录value对应的key信息
# print("params:",params)
if isinstance(params,list) :
params=params[0]
if isinstance(params, dict):
for key, value in params.items():
if isinstance(value, dict):
if len(value) > 0:
for d in cls.dict_parse_generator(value, pre + [key]):
yield d
else:
yield pre + [key, '{}']
elif isinstance(value, (list, tuple)):
if len(value) > 0:
for index, v in enumerate(value):
# 纪录list的下标与key，方便动态提取
# print("index",index)
for d in cls.dict_parse_generator(v, pre + [key, str(index)]):
yield d
else:
yield pre + [key, '[]'] if isinstance(value,list) else pre + [key,'()']
else:
yield pre + [key, value]
@classmethod
def api_prams_convert(cls, params_info):
'''根据参数与参数类型转换为预期定义的数据类型定义的枚举'''
def get_params_field_type(params_field_value):
if str(params_field_value).startswith('"') and str(params_field_value).endswith('"'):
_type = 'string' or 'str'
elif str(params_field_value).startswith('{') and str(params_field_value).endswith("}"):
_type = 'object' or 'dict'
elif str(params_field_value).startswith('[') and str(params_field_value).endswith(']'):
_type = 'array' or 'list'
elif str(params_field_value) in ('0', '0.0'):
_type = 'number' or 'int'
elif str(params_field_value) in ("true", 'false', 'True', 'False'):
_type = 'boolean' or 'bool'
elif str(params_field_value) in ('None', 'null', 'nil'):
_type = 'null' or 'None'
else:
_type = 'string' or 'str'
return _type
def replace_params_values(params_info):
'''替换参数所有key的内容'''
parse_params_info = list(cls.dict_parse_generator(params_info))
parse_params_info_keys=[i[0] for i in parse_params_info]
# 将没有输出的key添加到字典
for params_info_key in params_info:
if params_info_key not in parse_params_info_keys:
parse_params_info.append([params_info_key,params_info[params_info_key]])
for i in range(len(parse_params_info)):
if parse_params_info[i] :
params_key = parse_params_info[i][:-1]
# 组装json提取表达式
params_extract_str = "']['".join(params_key)
params_extract_str = "['" + params_extract_str + "']"
params_extract_str_re = re.search("\['\d+'\]", params_extract_str)
if params_extract_str_re:
# 去除list索引下标的字符串，处理为eval能够识别的int字符串
params_extract_str_re = params_extract_str_re.group()
params_extract_str = params_extract_str.replace(params_extract_str_re,
params_extract_str_re.replace("'",'').replace('"',""))
# 获取key内容
params_field_value=eval(f"params_info{params_extract_str}")
params_type=get_params_field_type(params_field_value=params_field_value)
# # 将不为空得参数值且不在枚举定义范围内的数据添加到枚举定义中，避免影响原有数据且用于完善参数覆盖情况
if params_field_value and (params_field_value not in cls.CONST_TYPE_ENUM[params_type]):
cls.CONST_TYPE_ENUM[params_type].append(params_field_value)
#动态执行代码：替换key的内容
exec(f"params_info{params_extract_str}={cls.CONST_TYPE_ENUM[params_type]}")
def append_params_key_is_object_to_params_key_list(params_info):
'''追加参数key对应的值是object类型的key到指定list中'''
if isinstance(params_info,list):
params_info=params_info[0]
for i in params_info:
if isinstance(params_info[i],list) and isinstance(params_info[i][0],dict)\
and (i not in cls.params_key_list):
cls.params_key_list.append(i)
if not params_info:
return params_info
if isinstance(params_info, (list, dict)):
if isinstance(params_info, list):
if params_info:
params_info = params_info[0]
cls.is_array = True
replace_params_values(params_info)
append_params_key_is_object_to_params_key_list(params_info)
return params_info
@classmethod
def parse_uri_params_path_query(cls,uri: str, params_path: dict):
'''解析url中的params_path与params_query参数'''
if not params_path:
return {},{}
uri_split = uri.split('/')
uri_params = [i for i in uri_split if i.startswith('{') and i.endswith('}')]
params_path_keys = list(params_path.keys())
uri_params_path_dict = {} # 存储：uri中的参数是key的情况
uri_params_query_dict = {} # 存储：uri中的参数不是key的情况，代表是query参数
for params_path_key in params_path_keys:
if "{" + params_path_key + "}" in uri_params:
uri_params_path_dict[params_path_key]=params_path[params_path_key]
else:
uri_params_query_dict[params_path_key]=params_path[params_path_key]
return uri_params_path_dict,uri_params_query_dict
@classmethod
def join_request_uri(cls,uri,path_dict,query_dict):
def out_path_replace_uri(uri,dict_obj):
'''uri拼接替换后的path参数'''
if dict_obj:
for i in dict_obj:
uri = uri.replace("{" + i + "}",str(dict_obj[i]) )
return uri
return uri
def out_query_replace_uri(uri,dict_obj):
'''uri拼接替换后的query参数'''
if dict_obj:
uri += "?"
for i in dict_obj:
uri += f"{i}={str(dict_obj[i])}&"
uri = uri[:-1] if uri[-1] == "&" else uri
return uri
if not (path_dict or query_dict):
return uri
uri=out_path_replace_uri(uri=uri,dict_obj=path_dict)
uri=out_query_replace_uri(uri=uri,dict_obj=query_dict)
uri = cls.time_util.pyobject_to_json_str(uri)
return uri
@classmethod
def out_target_case(cls,src_obj_index, params_all_obj):
'''根据index返回符合条件的case'''
if not params_all_obj:
return {}
_l = len(params_all_obj) - 1
if src_obj_index > _l:
target_case = params_all_obj[random.randint(0, _l)]
else:
target_case = params_all_obj[src_obj_index]
return target_case
@classmethod
@exec_time_wrapper(round_num=10,module_obj=__file__,class_obj=sys._getframe().f_code.co_name,is_send_email=False)
def generate_all_cases(cls, ordered_dict_obj,params_info):
def convert_allpairs_cases_to_cases(params_keys,ordered_dict_obj,cases_obj):
'''将allparis输出的case字符串转换为dict输出'''
if len(params_keys)>=2:
cls.time_util.append_params_key_isobject_to_extra_cases(case_params_key_obj=ordered_dict_obj,
params_keys=params_keys,extra_cases=cls.extra_cases,filter_func=cls.all_pairs_filter_func,
cases_obj=cases_obj,is_append_extra_cases=False,params_key="")
else:
'''params只有一个key时,直接组装字典输出（allpairs这种情况处理会输出空）'''
cases = ordered_dict_obj
for case in cases:
for case_key in cases[case]:
cases_obj.append({case: case_key})
def append_extra_case_to_case(cases_obj,extra_cases,params_key_list):
# 将extra_case数据追加到参数中
for index,out_case in enumerate(cases_obj):
for params_key in params_key_list:
update_cases=[i for i in extra_cases for o in i if o == params_key]
extra_case=cls.out_target_case(src_obj_index=index,params_all_obj=update_cases)
out_case.update(extra_case)
def return_out_cases(params_info,ordered_dict_obj):
'''输出最终转换完成的测试用例集合'''
if isinstance(params_info,list):
params_info=params_info[0]
params_keys=[i for i in params_info]
out_cases = []
'''将allparis输出的case字符串转换为dict输出'''
convert_allpairs_cases_to_cases(params_keys=params_keys,ordered_dict_obj=ordered_dict_obj,cases_obj=out_cases)
'''将extra_case数据追加到参数中'''
append_extra_case_to_case(cases_obj=out_cases,extra_cases=cls.extra_cases,params_key_list=cls.params_key_list)
return out_cases
if not (params_info or ordered_dict_obj):
return []
return return_out_cases(params_info=params_info,ordered_dict_obj=ordered_dict_obj)
@classmethod
def rm_old_excel(cls, excle_path='./', excle_name=''):
if os.path.exists(os.path.join(excle_path, excle_name)):
os.remove(os.path.join(excle_path, excle_name))
@classmethod
def reset_params_key_list_and_extra_cases(cls):
'''每个api的参数不同，在写入后需要调用此方法重置，避免元素被重复使用'''
cls.params_key_list=[]
cls.extra_cases=[]
# 还原默认的枚举定义，避免数据一直递增
cls.CONST_TYPE_ENUM=cls.CONST_TYPE_ENUM_COPY
cls.is_array=False
@classmethod
def write_params_filed_detail_to_excle(cls, params,ex_obj:operationExcle=None):
'''将参数字段明细写入到excle'''
ex_obj_cp=copy.deepcopy(ex_obj)
if ex_obj is None:
cls.rm_old_excel(excle_path=cls.excle_path, excle_name=cls.excle_name_params_field_detail)
ex_obj = operationExcle(excle_path=cls.excle_path, excle_name=cls.excle_name_params_field_detail)
if not isinstance(ex_obj,operationExcle):
raise Exception(f"传入的对象预期是:{type(operationExcle)},实际为:{type(ex_obj)}")
# print("params:",params)
if isinstance(params,dict):
params=[params]
ordered_dict_obj = cls.api_prams_convert(params)
params_all = cls.generate_all_cases(ordered_dict_obj, params)
for case in params_all:
for case_key in case:
# 如果key存在与list中，说明参数是list,将object转换为array
if case_key in cls.params_key_list:
case[case_key] = [case[case_key]]
ex_obj.write_values([str(i) for i in case.values()])
# 重置参数状态
cls.reset_params_key_list_and_extra_cases()
if ex_obj_cp is None:
ex_obj.write_values(list(params_all[0].keys()))
ex_obj.save_workbook()
@classmethod
def write_cases_obj_to_excle(cls, case_info, params_path,params_body,ex_obj:operationExcle=None):
def write_cases_data_main(case_info,params_all_cases,is_body=False):
'''
将生成完毕的测试用例写入到excel，基础方法（将测试用例明细写入到excle）
Args:
case_info: 原始的测试用例信息
params_all_cases: 使用正交生成后的所有测试用例集合
is_body: 用于区分请求参数是否是body，如果不是bodu，则设置params_bodu为{},因为path与query类型不需要body请求，参数直接拼接到url上了
Returns:
'''
for index, case in enumerate(params_all_cases):
# print("params_all_cases:",id(params_all_cases))
path_dict = cls.out_target_case(src_obj_index=index,
params_all_obj=params_all_path) if params_all_path else {}
query_dict = cls.out_target_case(src_obj_index=index,
params_all_obj=params_all_query) if params_all_query else {}
# 拼接uri
uri = cls.join_request_uri(uri=uri_copy, path_dict=path_dict, query_dict=query_dict)
# print("path_dict:",path_dict)
# print("query_dict:",query_dict)
# # 忽略存在参数为空字符的uri
# if '//' in uri:
# continue
case_identifying_str = '-接口异常测试用例(基于正交实验自动生成)'
case_name = case_info[cls.write_excle_case_field_desc['case']]
# 拼接测试用例名称
if case_identifying_str in case_name:
case_name = case_name[:case_name.find(case_identifying_str)]
case_name = case_name + case_identifying_str + '-' + str(index + 1)
case_info[cls.write_excle_case_field_desc['case']] = case_name
case_info[cls.write_excle_case_field_desc['uri']] = uri
for case_key in case:
# 如果key存在与list中，说明参数是list,将object转换为array
if case_key in cls.params_key_list:
case[case_key] = [case[case_key]]
# print("case:",case)
# 判断最外层的参数是不是list，是list,将object转换为array
if cls.is_array:
case_info[cls.write_excle_case_field_desc['params_body']] = json.dumps([case], ensure_ascii=False)
else:
case_info[cls.write_excle_case_field_desc['params_body']] = json.dumps(case, ensure_ascii=False)
if not is_body:
# 从params_body中删除params_path¶ms_query对应的key
case_info[cls.write_excle_case_field_desc['params_body']] = json.dumps({})
ex_obj.write_values(case_info)
# ex_obj_cp=copy.deepcopy(ex_obj)
if ex_obj is None:
cls.rm_old_excel(excle_path=cls.excle_path, excle_name=cls.excle_name_params_obj)
ex_obj = operationExcle(excle_path=cls.excle_path, excle_name=cls.excle_name_params_obj)
if not isinstance(ex_obj,operationExcle):
raise Exception(f"传入的对象预期是:{type(operationExcle)},实际为:{type(ex_obj)}")
uri=case_info[cls.write_excle_case_field_desc['uri']]
uri_copy=copy.deepcopy(uri)
# 根据params_path对象区分uri_path参数、uri_query参数
uri_params_path_dict,uri_params_query_dict=cls.parse_uri_params_path_query(uri=uri_copy,params_path=params_path)
# 输出path与body的ordered_dict对象
ordered_dict_obj_path = cls.api_prams_convert(uri_params_path_dict)
ordered_dict_obj_query = cls.api_prams_convert(uri_params_query_dict)
# 输出path与body所有的正交测试用例
params_all_path = cls.generate_all_cases(ordered_dict_obj_path, uri_params_path_dict)
params_all_query = cls.generate_all_cases(ordered_dict_obj_query, uri_params_query_dict)
ordered_dict_obj_body = cls.api_prams_convert(params_body)
params_all_body = cls.generate_all_cases(ordered_dict_obj_body, params_body)
if params_all_body:
write_cases_data_main(case_info=case_info,params_all_cases=params_all_body,is_body=True)
elif params_all_path:
write_cases_data_main(case_info=case_info, params_all_cases=params_all_path, is_body=False)
elif params_all_query:
write_cases_data_main(case_info=case_info, params_all_cases=params_all_query, is_body=False)
# 重置参数状态
cls.reset_params_key_list_and_extra_cases()
@classmethod
@exec_time_wrapper(round_num=10,module_obj=__file__,class_obj=sys._getframe().f_code.co_name,is_send_email=True)
def batch_write_params_filed_detail_to_excle(cls,case_list=None):
if case_list is None:
case_list=cls.read_all_cases_data()
cls.rm_old_excel(excle_path=cls.excle_path, excle_name=cls.excle_name_params_field_detail)
ex_obj = operationExcle(excle_path=cls.excle_path, excle_name=cls.excle_name_params_field_detail)
if isinstance(case_list,dict):
case_list=[case_list]
# 写入首行数据
for params in case_list[1:]:
# params是一个可变类型，程序执行*用了此对象，这里需要传一个深拷贝对象给他，避免执行过程中params被替换
params=copy.deepcopy(params)
params_body=params[cls.write_excle_case_field_desc['params_body']]
sheet_name=params[cls.write_excle_case_field_desc['case']][:31]
sheet_name=cls.time_util.check_filename(sheet_name,priority_matching_chars=[':','/','\\','?','*','[',']'])
# print("sheet_name:",sheet_name)
ex_obj.create_sheet(sheet_name)
ex_obj.data=ex_obj.get_data_for_sheet_name(sheet_name)
if not isinstance(params_body, dict):
params_body = json.loads(params_body)
if isinstance(params_body,list):
params_body=params_body[0]
ex_obj.write_values(list(params_body.keys()))
cls.write_params_filed_detail_to_excle(params=params_body,ex_obj=ex_obj)
# 删除默认创建的sheet
ex_obj.delete_sheet(sheet_name='Sheet')
ex_obj.save_workbook()
@classmethod
@exec_time_wrapper(round_num=10,module_obj=__file__,class_obj=sys._getframe().f_code.co_name,is_send_email=False)
def batch_write_cases_obj_to_excle(cls,case_info=None,case_list=None):
if case_list is None:
case_list=cls.read_all_cases_data()
if isinstance(case_list, dict):
case_list = [case_list]
case_info_first_line=case_info
if case_info is None:
case_info_first_line=list(cls.write_excle_case_field_desc.keys())
# 删除params_path, 且params_body替换为params & & response_body替换为expected
case_info_first_line[cls.write_excle_case_field_desc['params_body']]='params'
case_info_first_line[cls.write_excle_case_field_desc['response_body']]='expected'
# 删除旧的文件
cls.rm_old_excel(excle_path=cls.excle_path, excle_name=cls.excle_name_params_obj)
ex_obj = operationExcle(excle_path=cls.excle_path, excle_name=cls.excle_name_params_obj)
ex_obj.write_values(case_info_first_line)
for case in case_list[1:]:
# params是一个可变类型，程序执行*用了此对象，这里需要传一个深拷贝对象给他，避免执行过程中params被替换
case_info=copy.deepcopy(case)
# if case_info[1]==:
if case_info[1] in (
# '/v1/work-order/{tenantId}/{aggregateId}/repair-info',
# # # # # '/v1/wx/user/logout',
# # # # '/v1/wx/work-order/{tenantId}/{userId}/my-work-orders',
# # '/v1/work-order/tenant/{tenantId}',
'/v1/stakes/section/{sectionId}/number/{stakeSerialNumber}',
# # '/v1/maintenance/search/select-explicit',
# # '/v1/collector/find-aggregate',
):
params_body=case_info[cls.write_excle_case_field_desc['params_body']]
params_path=case_info[cls.write_excle_case_field_desc['params_path']]
if not isinstance(params_body,dict):
params_body=json.loads(params_body)
if not isinstance(params_path,dict):
params_path=json.loads(params_path)
if params_body in ({},[],[{}],None) and params_path in ({},[],[{}],None) :
case_info[cls.write_excle_case_field_desc['params_body']]=json.dumps(params_body)
case_info[cls.write_excle_case_field_desc['params_path']] = json.dumps(params_path)
ex_obj.write_values(case_info)
else:
cls.write_cases_obj_to_excle(case_info=case_info,params_path=params_path,params_body=params_body,ex_obj=ex_obj)
# 删除params_path对应的列
ex_obj.del_ws_cols(cls.write_excle_case_field_desc['params_path']+1,is_save=False)
#重命名sheet_name
ex_obj.rename_sheet_name(src_sheet_name='Sheet',target_sheet_name='all_api_info')
ex_obj.save_workbook()
if __name__ == "__main__":
params = {"account": "demo", "pwd": "crmeb.com", "key": "533721295cb06314f4bcaacebc28e3bd", "code": "nbcw",
"wxCode": "", 'userinfo': {}, 'age': 0, 'is_vip': False, 'ext': None,
'orders': [{"order": "asc", "fileds": []}], 'orders2': [{"order2": "asc", "fileds2": []}],
"price2":0.05,"ip":""}
test_prams=OrderedDict([
('k1',[1,2,3]),
# ('k2',[('order',[1,2,3]),('order2',[4,5,6])])
])
params_array = [params]
params_array.extend(params_array)
#
auto_case = autoGenrateApiCaseAllpairspy()
path_dict = {'sectionId': 3448477344847734484773448477344847734484773448477344847734484773448477344847734484773448477344847734, 'stakeSerialNumber': '留言一点重要.文件发展就是资料论坛制作.留言一点重要.文件发展就是资料论坛制作.留言一点重要.文件发展就是资料论坛制作.留言一点重要.文件发展就是资料论坛制作.留言一点重要.文件发展就是资料论坛制作.'}
query_dict = {"tenantId2": 22,"df":"432fsfds"}
# url=auto_case.join_request_uri(uri="/v1/stakes/section/{sectionId}/number/{stakeSerialNumber}",path_dict=path_dict,query_dict=query_dict)
# print(url)
# json_str={'breakageThreshold': {}, 'breakageType': ['linear', 'alligator', 'pothole', 'raveling', 'explicit', 'subsidence', 'rut', 'seal', 'patch', 'horizontalCrack', 'verticalCrack'], 'endTime': 0, 'startTime': 0, 'tenantId': 0}
# print(list(auto_case.dict_parse_generator(json_str)))
# # 读取case数据
# print(auto_case.read_all_cases_data())
# auto_case.batch_write_cases_obj_to_excle()
# auto_case.join_uri_params_path('/v1/stakes/section/{sectionId}/number/{stakeSerialNumber}',{"sectionId": 0, "stakeSerialNumber": "","test":123})
# 单个写入
# auto_case.write_params_filed_detail_to_excle(params)
# auto_case.write_cases_obj_to_excle(case_info, params=params_array)
# 批量写入
# auto_case.batch_write_params_filed_detail_to_excle()
# print("case_info:before",case_info)
auto_case.batch_write_cases_obj_to_excle()
# print("case_info:after",case_info)