python将excel中的测试用例上传到testlink

导入的Excel模板

excel模板

目录结构

程序目录结构

upload内容

#! /usr/bin/python
# coding:utf-8 
""" 
@author:zgl
@file: upload.py 
@time: 2019/01/21
"""
import collections
import testlink
import xlrd
import os
import logging

#logger = Log(os.path.basename(__file__)) #当前目录
logger = logging.getLogger(__name__)

count_success = 0
count_fail = 0

#获取project_id
def get_projects_info():
    project_ids = []
    projects = tlc.getProjects()
    for project in projects:
        project_ids.append({project['name']: project['id']})
    return project_ids

def get_projects_id():
    project_ids = []
    projects = tlc.getProjects()
    for project in projects:
        project_ids.append(project['id'])
    return project_ids

#获取父节点id
def get_topsuite_id(project_id):
    suite_ids = []
    projects = tlc.getProjects()[project_id]
    suites = tlc.getFirstLevelTestSuitesForTestProject(projects['id'])
    for suite in suites:
        suite_ids.append({suite['name']:suite['id']})
    return suite_ids

def get_suites(suite_id):
    """
    获取用例集
    :return:
    """
    try:
        suites = tlc.getTestSuiteByID(suite_id)
        return suites
    except testlink.testlinkerrors.TLResponseError as e:
        # traceback.print_exc()
        logger.warning(str(e).split('\n')[1])
        logger.warning(str(e).split('\n')[0])
        return

def readExcel(file_path):
    """
    读取用例数据
    :return:
    """
    case_list = []
    try:
        book = xlrd.open_workbook(file_path)  # 打开excel
    except Exception as error:
        logger.error('路径不在或者excel不正确 : ' + str(error))
        return error
    else:
        sheet = book.sheet_by_index(0)  # 取第一个sheet页
        rows = sheet.nrows  # 取这个sheet页的所有行数
        for i in range(rows):
            if i != 0:
                case_list.append(sheet.row_values(i))  # 把每一条测试用例添加到case_list中
    return case_list

def check_excel_data(func):
    """
    参数有效性校验
    :param func:
    :return:
    """

    def _check(*args, **kw):
        global count_fail
        global count_success

        # 校验项目ID及测试集ID的有效性
        if not args[0] in get_projects_id():
            logger.error('project_id is not auth')
            return
        if not get_suites(args[1]):
            logger.error('father_id is not auth')
            return

        # 检测测试数据的有效性
        for k, v in kw.items():
            if v == "" and k not in ['summary', 'importance','preconditions']:
                logger.warning("TestCase '{title}' Parameter '{k}' is null".format(title=kw['title'], k=k))
        try:
            func(args[0], args[1], kw)
            count_success += 1
        except Exception as e:
            logger.error(e)
            count_fail += 1

    return _check

def format_info(source_data):
    """
    转换Excel中文关键字
    :param source_data:
    :return:
    """
    switcher = {
        "低": 1,
        "中": 2,
        "高": 3,
        "自动化": 2,
        "手工": 1
    }
    return switcher.get(source_data, "Param not defind")

@check_excel_data
def create_testcase(test_project_id, suits_id, data):
    """
    :param test_project_id:
    :param suits_id:
    :param data:
    :return:
    """
    # 设置优先级默认值及摘要默认值
    if data['importance'] not in [1, 2, 3]:
        data['importance'] = 3
    if data["summary"] == "":
        data["summary"] = "无"

    # 初始化测试步骤及预期结果
    for i in range(0, len(data["step"])):
        tlc.appendStep(data["step"][i][0], data["step"][i][1], data["automation"])

    tlc.createTestCase(data["title"], suits_id, test_project_id, data["authorlogin"], data["summary"],
                       preconditions=data["preconditions"], importance=data['importance'], executiontype=2)

def excute_creat_testcase(test_project_id, test_father_id, test_file_name):
    # 对project_id father_id 做有效性判断
    if test_project_id not in get_projects_id():
        logger.error('project_id is not auth')
        return
    if not get_suites(test_father_id):
        logger.error('father_id is not auth')
        return

    # 获取用例
    test_cases = readExcel(os.path.join('testCase', test_file_name))
    # print(test_cases)
    if not isinstance(test_cases, collections.Iterable):
        return

    # 格式化用例数据
    for test_case in test_cases:
        testCase_data = {
            "title": test_case[1],
            "preconditions": test_case[9],
            "step": list(zip(test_case[7].split('\n'), test_case[8].split('\n'))),  # 以换行符作为测试步骤的分界
            "automation": "2",  # 1  手工, 2 自动
            "authorlogin": "zhouguili",
            "importance": "3",
            "summary": "参数"+test_case[6]
        }

        create_testcase(test_project_id, test_father_id, **testCase_data)
    logger.info("本次操作共提交 {} 条数据，成功导入 {} 条，失败 {} 条".format(count_success + count_fail, count_success, count_fail))

if __name__ == "__main__":
    url = "http://testlink.***"  # 替换为testlink对应URL
    key = "***"  # 登陆testlink后点击上方个人账号进入个人中心，新页面点击 '生成新的秘钥'获取
    file_name = "testcase.xlsx"
    project_id = "2943"  # 可以通过 print(get_projects_info())获取需要导入的项目的编号
    father_id = "29571"  # get_topsuite_id()父节点ID获取测试用例集信息，29571用例集编号
    tlc = testlink.TestlinkAPIClient(url, key)
    project = get_projects_info()
    
    for i in range(0,len(project)):
        if project[i].get("**"):   #get里面为项目名字用于获取导入项目的下标
            print(i)
            print(project[i].values())
    print("项目信息: ", get_projects_info())
    print("测试用例集信息: ", get_topsuite_id(31))#31为导入项目的下标数字
    excute_creat_testcase(project_id, father_id, file_name)

如何获得testlink密钥

如何获得testlink的密钥

get_projects_info()返回的项目

get_projects_info()返回的项目
get_topsuite_id(31)下的测试用例集
get_topsuite_id(31)下的测试用例集

原文为https://www.cnblogs.com/Detector/p/9022408.html