def create_framework_excel_to_debug(cls) -> str:
"""
author: DuPanPan
date : 2021.01.18
description: 产生一条用例的编号
"""
framework_case_dict_List = list()
for case_dict in cls.case_dict_list:
framework_case_dict = dict()
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_ID] = "1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TITLE] = case_dict.get(
constants.case_title)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_VERSION] = "0"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TYPE] = case_dict.get(
constants.case_type)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_LEVEL] = "A1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_LOCATION] = case_dict.get(
constants.case_script)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_BRANCH_ID] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_MODULE_ID] = ""
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_MODULE_NAME] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_STEP] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_RUN_ID] = "0"
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_NEED_RUN] = "Y"
framework_case_dict_List.append(framework_case_dict)
ExcelManager.create_framework_excel(framework_case_dict_List)
class ScriptManager(object):
"""
author: DuPanPan
date : 2021.01.18
description: 生产Script
"""
case_dict_list = ExcelManager.get_case_dict_list()
file_path = constants.INPUT_FILE.replace("\\", "/")
sum = 0
@classmethod
def create_script(cls) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例批量生成脚本
"""
for case_dict in cls.case_dict_list:
cls.create_one_script(case_dict)
print(len(cls.case_dict_list), cls.sum)
@classmethod
def create_script_file(cls, script_path, context) -> None:
current_path = os.path.dirname(os.path.abspath(__file__))
script_dir = os.path.join(current_path, os.path.dirname(script_path))
if not os.path.exists(script_dir):
os.makedirs(script_dir)
script_path = script_path.replace("\\", "/").split("/")[-1]
script_path = os.path.join(script_dir, script_path)
f = open(script_path, 'w', encoding='utf-8')
f.write(context)
f.close()
@classmethod
def create_one_script(cls, case_dict: dict) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例生成一个脚本
"""
# 生成
# 读取case_number
with open(cls.file_path, 'r', encoding='utf-8') as f:
script_template = f.read()
script_path = case_dict.get(constants.case_script)
case_number = case_dict.get(constants.case_number)
case_title = case_dict.get(constants.case_title)
test_category = case_dict.get(constants.case_classification)
check_point = case_dict.get(constants.case_check_point)
case_steps = case_dict.get(constants.case_steps)
case_scene = case_dict.get(constants.case_scene)
pd_info = case_scene.split("2.")[-1].split("3.")[0]
pd_count_str = pd_info.split("块")[0]
vd_info = case_scene.split("3.")[-1].split("4.")[0]
if "x" in pd_count_str:
pd_count = int(pd_count_str.split("x")[-1])
else:
pd_count = int(pd_count_str)
pd_per_array = vd_info.split("pdPerArray=")[-1].split(",")[0]
pd_interface = pd_info.split("块")[-1][0:-4].upper()
pd_medium = pd_info.split("块")[-1][-4:-1].upper()
raid_type = case_scene.split("3.")[-1].split("个")[-1].split(
":")[0].upper()
io_pattern = case_steps.split("IO配置")[-1]
isalign = io_pattern.split("对齐到")[-1].split("测试时间")[0][:-1]
if isalign != "":
isalign = "bio_constants.ALIGN: " + "\"" + isalign + "\","
seekpct = io_pattern.split("数据随机比例为")[-1].split("读写比例为")[0][:-1]
rdpct = io_pattern.split("读写比例为")[-1].split("数据块大小")[0][:-1]
blocks = io_pattern.split("数据块大小设为(")[-1].split(")测试并发")[0].replace(
",", ":")
context = script_template.format(case_number=case_number,
case_title=case_title,
test_category=test_category,
check_point=check_point,
case_steps=case_steps,
pd_count=pd_count,
pd_per_array=pd_per_array,
blocks=blocks,
rdpct=rdpct,
seekpct=seekpct,
is_align=isalign)
cls.sum += 1
cls.create_script_file(script_path, context)
@classmethod
def create_framework_excel_to_debug(cls) -> str:
"""
author: DuPanPan
date : 2021.01.18
description: 产生一条用例的编号
"""
framework_case_dict_List = list()
for case_dict in cls.case_dict_list:
framework_case_dict = dict()
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_ID] = "1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TITLE] = case_dict.get(
constants.case_title)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_VERSION] = "0"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TYPE] = case_dict.get(
constants.case_type)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_LEVEL] = "A1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_LOCATION] = case_dict.get(
constants.case_script)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_BRANCH_ID] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_MODULE_ID] = ""
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_MODULE_NAME] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_STEP] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_RUN_ID] = "0"
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_NEED_RUN] = "Y"
framework_case_dict_List.append(framework_case_dict)
ExcelManager.create_framework_excel(framework_case_dict_List)
class ScriptManager(object):
"""
author: DuPanPan
date : 2021.01.18
description: 生产Script
"""
case_dict_list = ExcelManager.get_case_dict_list()
file_path = constants.INPUT_FILE.replace("\\", "/")
sum = 0
@classmethod
def select_template(cls, check_point):
if check_point.split("-")[1] in ["缓IO时间内"]:
script_base = "reliability.hot_plug.diff_dg.hold_io.script_bases.hold_io"
if check_point.split("-")[3] in ["原槽位插拔DG下所有盘"]:
plug_method = "cls.plug_in_out_method = bio_constants.PLUG_METHOD_DG_ALL"
elif check_point.split("-")[3] in ["原盘原槽位插回"]:
plug_method = "cls.plug_in_out_method = bio_constants.PLUG_METHOD_OLD_PD_OLD_SLOT"
elif check_point.split("-")[3] in ["原盘原槽位反复热拔插"]:
plug_method = "cls.plug_in_out_method = bio_constants.PLUG_METHOD_REPEAT5"
elif check_point.split("-")[3] in ["原盘换槽位插回"]:
plug_method = "cls.plug_in_out_method = bio_constants.PLUG_METHOD_CHANGE_SLOT"
else:
plug_method = ""
if check_point.split("-")[3] in ["新盘原槽位插回"]:
script_base = "reliability.hot_plug.diff_dg.non_hold_io.script_bases.new_pd_old_slot"
elif check_point.split("-")[3] in ["原盘原槽位插回"]:
script_base = "reliability.hot_plug.diff_dg.non_hold_io.script_bases.old_pd_old_slot"
elif check_point.split("-")[3] in ["原槽位插拔DG下所有盘"]:
script_base = "reliability.hot_plug.diff_dg.non_hold_io.script_bases.all_dg_pd_old_slot"
elif check_point.split("-")[3] in ["原盘换槽位插回"]:
script_base = "reliability.hot_plug.diff_dg.non_hold_io.script_bases.old_pd_change_slot"
if check_point.split("-")[4] in ["不带io"]:
io_flag = "cls.plug_with_io = False"
else:
io_flag = ""
return script_base, plug_method, io_flag
@classmethod
def create_script(cls) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例批量生成脚本
"""
for case_dict in cls.case_dict_list:
cls.create_one_script(case_dict)
print(len(cls.case_dict_list), cls.sum)
@classmethod
def create_script_file(cls, script_path, context) -> None:
current_path = os.path.dirname(os.path.abspath(__file__))
script_dir = os.path.join(current_path, os.path.dirname(script_path))
if not os.path.exists(script_dir):
os.makedirs(script_dir)
script_path = script_path.replace("\\", "/").split("/")[-1]
script_path = os.path.join(script_dir, script_path)
f = open(script_path, 'w', encoding='utf-8')
f.write(context)
f.close()
@classmethod
def create_one_script(cls, case_dict: dict) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例生成一个脚本
"""
# 生成
# 读取case_number
with open(cls.file_path, 'r', encoding='utf-8') as f:
script_template = f.read()
script_path = case_dict.get(constants.case_script)
case_number = case_dict.get(constants.case_number)
case_title = case_dict.get(constants.case_title)
test_category = case_dict.get(constants.case_classification)
check_point = case_dict.get(constants.case_check_point)
case_steps = case_dict.get(constants.case_steps)
case_scene = case_dict.get(constants.case_scene)
pd_info = case_scene.split("2.")[-1].split("3.")[0]
pd_count_str = pd_info.split("块")[0]
if "x" in pd_count_str:
pd_count = int(pd_count_str.split("x")[-1])
else:
pd_count = int(pd_count_str)
pd_interface = pd_info.split("块")[-1][0:-4].upper()
pd_medium = pd_info.split("块")[-1][-4:-1].upper()
raid_type = case_scene.split("3.")[-1].split("个")[-1].split(
":")[0].upper()
io_pattern = case_steps.split("IO配置")[-1]
seekpct = io_pattern.split("数据随机比例为")[-1].split("读写比例为")[0][:-1]
rdpct = io_pattern.split("读写比例为")[-1].split("数据块大小")[0][:-1]
blocks = io_pattern.split("数据块大小设为(")[-1].split(")测试并发")[0].replace(
",", ":")
script_base, plug_method, io_flag = cls.select_template(check_point)
context = script_template.format(case_number=case_number,
case_title=case_title,
test_category=test_category,
check_point=check_point,
case_steps=case_steps,
script_base=script_base,
raid_type1=raid_type,
raid_type2=raid_type,
pd_count1=pd_count,
pd_count2=pd_count,
blocks=blocks,
rdpct=rdpct,
seekpct=seekpct,
io_flag=io_flag,
plug_method=plug_method)
cls.sum += 1
cls.create_script_file(script_path, context)
@classmethod
def get_scripts_path(cls, classification_index: int,
check_point_index: int, scene_index: int) -> str:
"""
class ScriptManager(object):
"""
author: DuPanPan
date : 2021.01.18
description: 生产Script
"""
case_dict_list = ExcelManager.get_case_dict_list()
file_path = "E:\生成用例\\Utils-du\scripts_auto_create\conf_manager\\basicio_raid5x_manager_data.txt"
sum = 0
@classmethod
def create_script(cls) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例批量生成脚本
"""
for case_dict in cls.case_dict_list:
cls.create_one_script(case_dict)
print(len(cls.case_dict_list), cls.sum)
@classmethod
def create_script_file(cls, script_path, context) -> None:
current_path = os.path.dirname(os.path.abspath(__file__))
script_dir = os.path.join(current_path, os.path.dirname(script_path))
if not os.path.exists(script_dir):
os.makedirs(script_dir)
script_path = script_path.replace("\\", "/").split("/")[-1]
script_path = os.path.join(script_dir, script_path)
f = open(script_path, 'w', encoding='utf-8')
f.write(context)
f.close()
@classmethod
def create_one_script(cls, case_dict: dict) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例生成一个脚本
"""
# 生成
# 读取case_number
with open(cls.file_path, 'r', encoding='utf-8') as f:
script_template = f.read()
with open(
"E:\生成用例\\Utils-du\scripts_auto_create\conf_manager\pd_dict_manager_data.txt",
'r',
encoding='utf-8') as f1:
pd_info_dict_template = f1.read()
script_path = case_dict.get(constants.case_script)
case_number = case_dict.get(constants.case_number)
case_title = case_dict.get(constants.case_title)
test_category = case_dict.get(constants.case_classification)
check_point = case_dict.get(constants.case_check_point)
case_steps = case_dict.get(constants.case_steps)
case_scene = case_dict.get(constants.case_scene)
pd_info = case_scene.split("1.")[-1].split("2.")[0].split("512B的")[-1]
vd_info = case_scene.split("2.")[-1].split("3.")[0]
base_class_file = base_class_file_dict[script_path.split("/")[9]]
base_class = base_class_dict[script_path.split("/")[9]]
raid_type = vd_info.split(":")[0]
if "size=" in vd_info:
vd_size = ("'" + vd_info.split("size=")[-1].split("，")[0].strip() +
"'").replace("\n", "")
print(vd_size)
else:
vd_size = "'all'"
vd_strip = vd_info.split("strip=")[-1].split("，")[0][:-1]
if vd_strip == "1":
vd_strip = "1024"
if "pdPerArray" in vd_info:
print("*****")
pd_perarray = ("bio_constants.VD_PD_PER_ARRAY: " +
vd_info.split("pdPerArray=")[-1].split("，")[0] + ","
"").replace("\n", "")
print(pd_perarray)
else:
pd_perarray = ""
pd_info_dict_list = ""
for pd_info_dict in pd_info.split("+"):
pd_connector = pd_info_dict.split("-")[0].strip()
backplane = backplane_dict[pd_connector]
sector_size = "SIZE_" + pd_info_dict.split("-")[1].split(
"硬盘粒度为")[-1]
if sector_size == "SIZE_512B":
sector_size = "SIZE_512N"
pd_interface = pd_info_dict.split("-")[0]
pd_medium = pd_info_dict.split("-")[1].split("(")[0]
pd_count = pd_info_dict.split("(")[-1].split("块")[0]
pd_info_dict_str = pd_info_dict_template.format(
pd_interface=pd_interface,
pd_medium=pd_medium,
pd_count=pd_count)
pd_info_dict_list = pd_info_dict_list + pd_info_dict_str
if "设置控制卡passthrough开关为" in case_steps:
passthrough = base_class + ".passthrough = SwitchEnum.SWITCH_" + \
case_steps.split("设置控制卡passthrough开关为")[-1].split("2")[
0].upper() + ".value"
else:
passthrough = ""
io_pattern = case_steps.split("IO配置")[-1]
seekpct = io_pattern.split("数据随机比例为")[-1].split("读写比例为")[0][:-1]
rdpct = io_pattern.split("读写比例为")[-1].split("，")[0]
blocks = io_pattern.split("数据块大小设为(")[-1].split(")")[0].replace(
",", ":")
thread = io_pattern.split("线程数为")[-1].split("，")[0]
depth = io_pattern.split("队列深度为")[-1].split("，")[0]
if len(thread) > 4:
thread = 32
if len(depth) > 4:
depth = 4
if "设置IOPS限速交替" in io_pattern:
rate_io = "bio_constants.IO_RATE_IOPS:'1000',"
else:
rate_io = ""
if "数据量为" in io_pattern:
io_size = "bio_constants.SIZE:" + "'" + io_pattern.split(
"数据量为")[-1].split("，")[0] + "',"
io_size = io_size.replace("\n", "").strip()
else:
io_size = ""
if "测试时间为" in io_pattern:
io_time = "bio_constants.RUN_TIME:'300',"
else:
io_time = ""
context = script_template.format(case_number=case_number,
case_title=case_title,
test_category=test_category,
check_point=check_point,
case_steps=case_steps,
raid_type=raid_type.upper(),
vd_strip=vd_strip,
vd_size=vd_size.strip(),
pd_perarray=pd_perarray,
pd_info_dict_list=pd_info_dict_list,
rate_io=rate_io,
blocks=blocks,
rdpct=rdpct,
seekpct=seekpct,
io_size=io_size,
io_time=io_time,
thread=thread,
depth=depth,
passthrough=passthrough.strip(),
base_class=base_class,
base_class_file=base_class_file)
cls.sum += 1
cls.create_script_file(script_path, context)
@classmethod
def create_framework_excel_to_debug(cls) -> str:
"""
author: DuPanPan
date : 2021.01.18
description: 产生一条用例的编号
"""
framework_case_dict_List = list()
for case_dict in cls.case_dict_list:
framework_case_dict = dict()
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_ID] = "1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TITLE] = case_dict.get(
constants.case_title)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_VERSION] = "0"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TYPE] = case_dict.get(
constants.case_type)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_LEVEL] = "A1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_LOCATION] = case_dict.get(
constants.case_script)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_BRANCH_ID] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_MODULE_ID] = ""
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_MODULE_NAME] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_STEP] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_RUN_ID] = "0"
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_NEED_RUN] = "Y"
framework_case_dict_List.append(framework_case_dict)
ExcelManager.create_framework_excel(framework_case_dict_List)
class ScriptManager(object):
"""
author: DuPanPan
date : 2021.01.18
description: 生产Script
"""
case_dict_list = ExcelManager.get_case_dict_list()
file_path = "E:\生成用例\\Utils-du\scripts_auto_create\conf_manager\\basicio_raid5x_stress.txt"
sum = 0
@classmethod
def create_script(cls) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例批量生成脚本
"""
for case_dict in cls.case_dict_list:
cls.create_one_script(case_dict)
print(len(cls.case_dict_list), cls.sum)
@classmethod
def create_script_file(cls, script_path, context) -> None:
current_path = os.path.dirname(os.path.abspath(__file__))
script_dir = os.path.join(current_path, os.path.dirname(script_path))
if not os.path.exists(script_dir):
os.makedirs(script_dir)
script_path = script_path.replace("\\", "/").split("/")[-1]
script_path = os.path.join(script_dir, script_path)
f = open(script_path, 'w', encoding='utf-8')
f.write(context)
f.close()
@classmethod
def create_one_script(cls, case_dict: dict) -> None:
"""
author: DuPanPan
date : 2021.01.18
description: 按照用例生成一个脚本
"""
# 生成
# 读取case_number
with open(cls.file_path, 'r', encoding='utf-8') as f:
script_template = f.read()
with open(
"E:\生成用例\\Utils-du\scripts_auto_create\conf_manager\pd_dict.txt",
'r',
encoding='utf-8') as f1:
pd_info_dict_template = f1.read()
direct_str = "bio_constants.VD_WRITE_POLICY: bio_constants.VD_WRITE_CACHE_DIRECT"
script_path = case_dict.get(constants.case_script)
case_number = case_dict.get(constants.case_number)
case_title = case_dict.get(constants.case_title)
test_category = case_dict.get(constants.case_classification)
check_point = case_dict.get(constants.case_check_point)
case_steps = case_dict.get(constants.case_steps)
case_scene = case_dict.get(constants.case_scene)
pd_info = case_scene.split("1.")[-1].split("2.")[0]
print(pd_info)
vd_info = case_scene.split("2.")[-1].split("3.")[0]
raid_type = vd_info.split(":")[0]
vd_strip = vd_info.split("strip=")[-1].split("，")[0][:-1]
if vd_strip == "1":
vd_strip = "1024"
wcache = vd_info.split("设置")[-1].split("、")[0]
rcache = vd_info.split("预读")[0].split("、")[-1]
if rcache == "开启":
rcache = "RA"
elif rcache == "关闭":
rcache = "NORA"
pd_cache = vd_info.split("pd缓存")[0].split("、")[-1]
if pd_cache == "开启":
pd_cache = "ON"
elif pd_cache == "关闭":
pd_cache = "OFF"
if "pdperarray=" in vd_info:
pd_perarray = "bio_constants.VD_PD_PER_ARRAY: " + vd_info.split(
"pdperarray=")[-1].split("，")[0] + ","
else:
pd_perarray = ""
if "direct" in vd_info:
direct = direct_str
else:
direct = ""
pd_info_dict_list = ""
for pd_info_dict in pd_info.split("+"):
pd_connector = pd_info_dict.split("-")[0].strip()
backplane = backplane_dict[pd_connector]
sector_size = "SIZE_" + pd_info_dict.split("-")[1].split(
"硬盘粒度为")[-1]
if sector_size == "SIZE_512B":
sector_size = "SIZE_512N"
pd_interface = pd_info_dict.split("-")[2]
print(pd_info_dict.split("-"))
pd_medium = pd_info_dict.split("-")[3].split("(")[0]
pd_count = pd_info_dict.split("(")[-1].split("块")[0]
pd_info_dict_str = pd_info_dict_template.format(
backplane=backplane,
sector_size=sector_size,
pd_interface=pd_interface,
pd_medium=pd_medium,
pd_count=pd_count)
pd_info_dict_list = pd_info_dict_list + pd_info_dict_str
if "打开控制卡passthrough开关" in case_steps:
passthrough = "ON"
elif "关闭控制卡passthrough开关" in case_steps:
passthrough = "OFF"
reg_mode = vd_info.split("寄存器模式为")[-1]
if "IO并发压力区间" in case_steps:
stress_type = "'concurrent_stress'"
elif "IO队列深度压力" in case_steps:
stress_type = "'depth_stress'"
elif "IOPS压力" in case_steps:
stress_type = "'iops_stress'"
elif "带宽压力" in case_steps:
stress_type = "'bandwidth_stress'"
io_pattern = case_steps.split("虚拟盘的IO配置")[-1]
seekpct = io_pattern.split("数据随机比例为")[-1].split("读写比例为")[0][:-1]
rdpct = io_pattern.split("读写比例为")[-1].split("，")[0]
blocks = io_pattern.split("数据块大小设为")[-1].split("测试")[0].replace(
",", ":")
context = script_template.format(case_number=case_number,
case_title=case_title,
test_category=test_category,
check_point=check_point,
case_steps=case_steps,
raid_type=raid_type.upper(),
vd_strip=vd_strip,
wcache=wcache.strip(),
rcache=rcache.strip(),
pd_cache=pd_cache.strip(),
pd_perarray=pd_perarray,
direct=direct,
pd_info_dict_list=pd_info_dict_list,
blocks=blocks,
rdpct=rdpct,
seekpct=seekpct,
passthrough=passthrough,
stress_type=stress_type,
reg_mode=reg_mode)
cls.sum += 1
cls.create_script_file(script_path, context)
@classmethod
def create_framework_excel_to_debug(cls) -> str:
"""
author: DuPanPan
date : 2021.01.18
description: 产生一条用例的编号
"""
framework_case_dict_List = list()
for case_dict in cls.case_dict_list:
framework_case_dict = dict()
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_ID] = "1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TITLE] = case_dict.get(
constants.case_title)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_VERSION] = "0"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_TYPE] = case_dict.get(
constants.case_type)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_LEVEL] = "A1"
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_LOCATION] = case_dict.get(
constants.case_script)
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_BRANCH_ID] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_MODULE_ID] = ""
framework_case_dict[
constants.FRAMEWORK_EXCEL_CASE_MODULE_NAME] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_STEP] = ""
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_RUN_ID] = "0"
framework_case_dict[constants.FRAMEWORK_EXCEL_CASE_NEED_RUN] = "Y"
framework_case_dict_List.append(framework_case_dict)
ExcelManager.create_framework_excel(framework_case_dict_List)