java调用testlink实现测试用例集导出为excel功能

2019独角兽企业重金招聘Python工程师标准>>>

一、java连接testlink（获取testlink api url 和api 密钥）

testlink api url = testlink url + /lib/api/xmlrpc/v1/xmlrpc.php 

api密钥在“个人中心---api接口下面”

部分代码：application.properties(配置文件)

testlink.api.url = http://localhost/testlink/lib/api/xmlrpc/v1/xmlrpc.php

testlink.user.devKey = e37c9bb787a534b20cc58e797cc4d31d

 

export.excel.path = C:Users/FE/Desktop/FEV6.6.0.xls

 

@Configuration

public class TestLinkConfig {

 

@Value("${testlink.api.url}")

private String testLinkUrl;

 

@Value("${testlink.user.devKey}")

private String testLinkUserKey;

 

@Bean

public TestLinkAPI getTestLinkApi() {

TestLinkAPI api = null;

URL testLinkURL = null;

try {

testLinkURL = new URL(testLinkUrl);

} catch (MalformedURLException mue) {

mue.printStackTrace(System.err);

System.exit(-1);

}

try {

api = new TestLinkAPI(testLinkURL, testLinkUserKey);

} catch (Exception te) {

te.printStackTrace(System.err);

System.exit(-1);

}

return api;

}

}

 

二、获取测试用例集

TestProject feSeriesProject = testLinkAPI.getProjects()[2];

TestPlan testPlan = testLinkAPI.getProjectTestPlans(feSeriesProject.getId())[0];

TestSuite[] testSuites = testLinkAPI.getTestSuitesForTestPlan(testPlan.getId());

三、遍历测试用例集获取测试用例

private List<TestCaseDto> buildTestCasesByTestSuitId(Integer testSuitId) {

TestCase[] cases = testLinkAPI.getTestCasesForTestSuite(testSuitId, true, null);

List<TestCase> list = Arrays.asList(cases);

List<TestCaseStep> steps = null;

List<TestCaseDto> testCaseDtos = new ArrayList<>();

for (TestCase testCase : list) {

if(Arrays.asList(ConstantData.TEST_CASE_EXCLUDE_IDS).contains(testCase.getId())) {

continue;

}

String moduleName = getSuitName(testCase.getParentId()).toString();

if (moduleName != null && moduleName.length() > 1 && moduleName.contains("/")) {

moduleName = moduleName.substring(0, moduleName.length() - 1);

}

TestCaseDto testCaseDto = new TestCaseDto();

TestCase tc = testLinkAPI.getTestCaseByExternalId(testCase.getFullExternalId(), null);

// logger.debug("Build test case {} start...", tc.getName());

// System.out.println("Build test case " + tc.getName() + " start...");

steps = tc.getSteps();

testCaseDto.setModule(moduleName);

testCaseDto.setSubModule(tc.getName());

// testCaseDto.setPreCondition(DelHtmlTag.delHtmlTag(tc.getPreconditions()));

// testCaseDto.setTestCaseLevel(tc.getTestCaseStatus() == null ? "" :

// CaseLeverConvert.convertToString(tc.getTestCaseStatus().toString()));

// 遍历测试action步骤

List<TestStepDto> testStepDtos = new ArrayList<>();

for (TestCaseStep testCaseStep : steps) {

TestStepDto testStepDto = new TestStepDto();

String sceneName = StringUtils.getSubStringByReg(testCaseStep.getActions(), "<strong>(.*?)</strong>");

String step = TestStepUtils.getTestStep(testCaseStep.getActions());

testStepDto.setSceneName(DelHtmlTag.delHtmlTag(sceneName));

testStepDto.setStep(DelHtmlTag.delHtmlTag(step));

testStepDto.setPreResult(DelHtmlTag.delHtmlTag(testCaseStep.getExpectedResults()));

testStepDtos.add(testStepDto);

}

testCaseDto.setTestStepDtos(testStepDtos);

testCaseDtos.add(testCaseDto);

// logger.debug("Build test case {} finish.", tc.getName());

// System.out.println("Build test case " + tc.getName() + " finish.");

}

return testCaseDtos;

}

 

四、java写excel, 数据导出至excel

ExcelObjConvertUtil excelObjConvertUtil = new ExcelObjConvertUtil();

List<ExSheet> sheets = excelObjConvertUtil.builderSheet(testSuitDtos);

SampleExcelBuilder sampleExcelBuilder = new SampleExcelBuilder();

sampleExcelBuilder.drawExcel(exportPath, sheets);

完整代码见：https://download.csdn.net/download/u012748719/10480947