使用相同的测试数据运行所有测试

Question

从excel文件读取测试数据。要求：我想首先我的所有测试应该运行在相同的测试数据，即excel行，然后所有测试与另一行。

解决方案：尝试将@Factory与我的@DataProvider一起使用

问题：如果我在@dataProvider中使用核心值，那么它可以正常工作。但是当从excel动态获取时，如果给我错误：[错误]导致：java.lang.NullPointerException

package com;

import java.util.HashMap;
import utils.*;
import org.testng.annotations.*;

public class TestFile extends BaseClass {


public HashMap<String, String> values = new HashMap<String, String>();

@Test()
private void Test_01() {

    System.out.println(values.get("Number"));
}

@Factory(dataProvider = "getDataSet")
public TestFile(HashMap<String, String> values) {
    this.values = values;

}


@DataProvider
private static Object[] getDataSet() {
    String sheetName = mContext.getCurrentXmlTest().getSuite().getParameters().get(Constants.BU_LEISURE_SHEET_NAME);

    int i = 0;
    Object[] dataSet = null;
    HashMap<String, HashMap<String, String>> sheet = testData.get(sheetName);
    dataSet = new Object[sheet.size()][1];
    for (String row : sheet.keySet()) {

        HashMap<String, String> rowValuesMap = new HashMap<>();
        for (String columnName : sheet.get(row).keySet()) {
            rowValuesMap.put(columnName, sheet.get(row).get(columnName));
        }

        dataSet[i] = rowValuesMap;

        i++;
    }
    return dataSet;

}

}

基类

public class BaseClass extends DataReader {
@BeforeSuite
public static void setup(ITestContext context) throws IOException {
    mContext = context;
 // other code
}
}

用于读取excel文件的Datareader类

public class DataReader {
public static HashMap<String, HashMap<String, HashMap<String, String>>> testData = new HashMap<String, HashMap<String, HashMap<String, String>>>();

// other code
}

错误日志

[错误]未能执行目标inder.process： maven-sureFire插件： 2.18.1：测试（default-test）在项目ATGDMAP：执行default-test的目标inder.java:179： maven-surefire插件： 2.18.1：测试失败：有一个错误在分叉的进程[ERROR]org.testng.internal.运行时异常：java.lang.NullPointerException[ERROR]在org.testng.internal.方法调用elper.invoke方法调用异常（方法调用elper.java:49）[ERROR]在org.testng.internal.方法调用elper.invoke数据供应商（方法调用elper.java:131）[ERROR]在org.testng.internal.Parameters.handle参数（Parameters.java:706）[ERROR]在org.testng.internal.FactoryMethod.invoke（FactoryMethod.java:151）[ERROR]在org.testng.internal.TestNGClassFinder.process工厂（TestNGClassFinder.java:223）[ERROR]在org.testng.internal.TestNGClassForg.apache.maven.plugins方法（TestNGClassForg.apache.maven.plugins）[ERROR]在java.lang.TestNGGGGGTestRunner. init（TestRunner. java： 241）[错误]在org. testng。TestRunner。（TestRunner. java： 167）[错误]在org. testng。SuiteRunner$DefaultTestRunnerFactory. newTestRunner（SuiteRunner. java： 663）[错误]在org. testng。SuiteRunner. init（SuiteRunner. java： 260）[错误]在org. testng。SuiteRunner。（SuiteRunner. java： 198）[错误]在org. testng。TestNG. createSuiteRunner（TestNG. java： 1295）[错误]在org. testng。TestNG. createSuiteRunner（TestNG. java： 1273）[错误]在org. testng。TestNG. runSuitesLocally（TestNG.NullPointerException[ERROR]at com. TestFile. getDataSet（TestFile. java： 27）[ERROR]at sun.反射。NativeMachodAccessorImpl. invke0（本机方法）[ERROR]at sun.反射。NativeMEodAccessorImpl. invoke（NativeMEodAccessorImpl. java： 62）[ERROR]at sun.反射。委托方法访问或Impl. invoke（委托方法访问或Impl. java： 43）[ERROR]在java. lang.反射。方法.调用（方法. java： 498）[ERROR]在org. testng.内部。方法调用帮助者.发票方法（方法调用者. java： 124）[ERROR]在org. testng.内部。方法调用帮助者.发票方法（方法调用者. java： 74）[ERROR]

Answer 1

问题在于您的测试代码。

您正在通过一个带注释的方法获取ITestContext对象。但是，当您使用与数据提供程序耦合的工厂时，TestNG首先查找与工厂方法相关联的数据提供程序（本例中为构造函数）。一旦找到数据提供程序方法，它将调用该方法以获取用于迭代和创建测试类实例的所有数据集。本例中的数据提供程序引用的是上下文对象（本例中为mContext），只有在调用BeforeSuite方法时才能初始化该对象。除非创建实例，否则不会调用BeforeSuite方法（工厂方法正试图这样做）

下面是正确的方法。

我的示例中的excel电子表格有两张表，即：。，

1. 员工

员工表中包含以下数据

+--------+--------------------+
|  name  |       email        |
+--------+--------------------+
| John   | [e-mail]   |
| Rajeev | [e-mail] |
| Jack   | [e-mail]   |
+--------+--------------------+

学生表中有以下数据。

+-------+--------+
| name  | rollNo |
+-------+--------+
| Surya |      1 |
| Rajni |      2 |
| Kamal |      3 |
+-------+--------+

使用工厂的测试类和读取上述电子表格的数据提供程序

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.testng.Assert;
import org.testng.ITestContext;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Factory;
import org.testng.annotations.Test;

public class TestclassSample {

  private Map<String, String> data;
  private static final String SHEET = "sheet";
  private static final String FILENAME = "filename";

  @Factory(dataProvider = "dp")
  public TestclassSample(Map<String, String> data) {
    this.data = data;
  }

  @Test
  public void dataIsNotEmpty() {
    System.err.println("Ensuring that " + data + " is not empty");
    Assert.assertFalse(data.isEmpty());
  }

  @Test
  public void dataHasAtleastTwoColumns() {
    System.err.println("Ensuring that " + data + " has atleast 2 entries");
    Assert.assertTrue(data.size() >= 2);
  }

  @DataProvider(name = "dp")
  public static Object[][] getData(ITestContext context)
      throws IOException, InvalidFormatException {
    String filename = context.getCurrentXmlTest().getParameter(FILENAME);
    if (filename == null || filename.trim().isEmpty()) {
      throw new IllegalArgumentException("File name was not present as a parameter");
    }
    Workbook workbook = WorkbookFactory.create(new File(filename));
    String sheet = context.getCurrentXmlTest().getParameter(SHEET);
    if (sheet == null || sheet.trim().isEmpty()) {
      throw new IllegalArgumentException("Sheet name was not present as a parameter");
    }
    Sheet worksheet = workbook.getSheet(sheet);
    DataFormatter dataFormatter = new DataFormatter();
    Row headingRow = worksheet.getRow(0);
    List<String> heading = new ArrayList<>();
    for (Cell cell : headingRow) {
      heading.add(dataFormatter.formatCellValue(cell));
    }
    List<Map<String, String>> information = new ArrayList<>();
    for (int i = 1; i < worksheet.getLastRowNum(); i++) {
      Map<String, String> data = new HashMap<>();
      int index = 0;
      for (Cell cell : worksheet.getRow(i)) {
        data.put(heading.get(index++), dataFormatter.formatCellValue(cell));
      }
      information.add(data);
    }

    Object[][] data = new Object[information.size()][1];
    for (int i = 0; i < information.size(); i++) {
      data[i] = new Object[] {information.get(i)};
    }
    workbook.close();
    return data;
  }
}

testng套件xml如下所示

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd">
<suite name="53358567_suite" parallel="false" verbose="2" group-by-instances="true">
    <parameter name="sheet" value="student"/>
    <parameter name="filename" value="src/test/resources/53358567.xlsx"/>
    <test name="53358567_test">
        <classes>
            <class name="com.rationaleemotions.stackoverflow.qn53358567.TestclassSample"/>
        </classes>
    </test>
</suite>

输出如下

...
... TestNG 7.0.0-beta1 by Cédric Beust ([e-mail])
...
Ensuring that {name=Rajni, rollNo=2} has atleast 2 entries
Ensuring that {name=Rajni, rollNo=2} is not empty
Ensuring that {name=Surya, rollNo=1} has atleast 2 entries
Ensuring that {name=Surya, rollNo=1} is not empty
PASSED: dataHasAtleastTwoColumns
PASSED: dataIsNotEmpty
PASSED: dataHasAtleastTwoColumns
PASSED: dataIsNotEmpty

===============================================
    53358567_test
    Tests run: 4, Failures: 0, Skips: 0
===============================================

===============================================
53358567_suite
Total tests run: 4, Passes: 4, Failures: 0, Skips: 0
===============================================


Process finished with exit code 0