接口自动化实践

最新推荐文章于 2022-07-02 10:22:20 发布

tetsuki

最新推荐文章于 2022-07-02 10:22:20 发布

阅读量507

点赞数 1

分类专栏：接口自动化文章标签：接口自动化实践 testng 自动化测试 java Httpclient

本文链接：https://blog.csdn.net/tetsuki/article/details/99564170

版权

接口自动化专栏收录该内容

2 篇文章 0 订阅

订阅专栏

接口自动化实践

接口自动化采用框架：Java+Httpclient+TestNG+Jenkins

接口自动化采用框架：Java+Httpclient+TestNG+Jenkins

新建一个maven的sass项目

1.新建一个maven项目
新建maven项目
2.引入pom文件所需要的依赖

 <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-surefire-plugin</artifactId>
                <version>2.19.1</version>
                <inherited>true</inherited>
                <configuration>
                    <suiteXmlFiles>
                        <suiteXmlfile>${project.basedir}/src/main/resources/testng.xml</suiteXmlfile>
                    </suiteXmlFiles>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>

            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <mainClass>com.gs.Application</mainClass>
                </configuration>
                <executions>
                    <execution>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>


        </plugins>
    </build>

    <!-- 定义公共资源版本 -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>org.testng</groupId>
            <artifactId>testng</artifactId>
            <version>6.9.10</version>
        </dependency>
        <dependency>
            <groupId>com.relevantcodes</groupId>
            <artifactId>extentreports</artifactId>
            <version>2.41.2</version>
        </dependency>

        <dependency>
            <groupId>com.vimalselvam</groupId>
            <artifactId>testng-extentsreport</artifactId>
            <version>1.3.1</version>
        </dependency>

        <dependency>
            <groupId>com.aventstack</groupId>
            <artifactId>extentreports</artifactId>
            <version>3.0.6</version>
        </dependency>

        <dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpclient</artifactId>
            <version>4.5.6</version>
        </dependency>

        <dependency>
            <groupId>org.json</groupId>
            <artifactId>json</artifactId>
            <version>20170516</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.29</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.13</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.14</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl -->
        <dependency>
            <groupId>net.sourceforge.jexcelapi</groupId>
            <artifactId>jxl</artifactId>
            <version>2.6.12</version>
        </dependency>


    </dependencies>

进行模块分层，该sass项目大致分为controller层，model层，utils层

1.建立各个层次的目录结构,如下
目录层次结构
2.在controller下建立测试基类BaseTest

package com.sass.controller;

import org.testng.annotations.BeforeTest;
import org.testng.annotations.Parameters;

/**
 * @Author: lzq
 * @Date: 2019/8/14 14:43
 */
public class BaseTest {
    public static String localFileName = "";

	//测试用例执行前，通过Parameters参数获取excel的文件名
    @BeforeTest
    @Parameters({"fileName"})
    public void initExcelData(String fileName){
        localFileName = fileName;
    }
}

3.在utils下新建一个ExcelData工具类，用来解析excel数据，框架采用excel作为数据输入源

package com.sass.utils;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
 * @Author: lzq
 * @Date: 2019/3/19 14:03
 */

public class ExcelData {
    public Workbook workbook;
    public Sheet sheet;
    public Cell cell;
    int rows;
    int columns;
    public String fileName;
    public String caseName;
    public ArrayList<String> arrkey = new ArrayList<String>();
    String sourceFile;

    /**
     * @param fileName   excel文件名
     * @param caseName   sheet名
     */
    public ExcelData(String fileName, String caseName) {
        super();
        this.fileName = fileName;
        this.caseName = caseName;
    }

    /**
     * 获得excel表中的数据
     */
    public Object[][] getExcelData() throws BiffException, IOException {

        workbook = Workbook.getWorkbook(new File(getPath()));
        sheet = workbook.getSheet(caseName);
        rows = sheet.getRows();
        columns = sheet.getColumns();
        // 为了返回值是Object[][],定义一个多行单列的二维数组
        HashMap<String, String>[][] arrmap = new HashMap[rows - 1][1];
        // 对数组中所有元素hashmap进行初始化
        if (rows > 1) {
            for (int i = 0; i < rows - 1; i++) {
                arrmap[i][0] = new HashMap<>();
            }
        } else {
            System.out.println("excel中没有数据");
        }

        // 获得首行的列名，作为hashmap的key值
        for (int c = 0; c < columns; c++) {
            String cellvalue = sheet.getCell(c, 0).getContents();
            arrkey.add(cellvalue);
        }
        // 遍历所有的单元格的值添加到hashmap中
        for (int r = 1; r < rows; r++) {
            for (int c = 0; c < columns; c++) {
                String cellvalue = sheet.getCell(c, r).getContents();
                arrmap[r - 1][0].put(arrkey.get(c), cellvalue);
            }
        }
        return arrmap;
    }

    /**
     * 获得excel文件的路径
     * @return
     * @throws IOException
     */
     //excel同一存放在/src/main/resources/TestCaseExcelData路径下
    public String getPath() throws IOException {
        File directory = new File(".");
        sourceFile = directory.getCanonicalPath() + "/src/main/resources/TestCaseExcelData/"
                + fileName + ".xls";
        return sourceFile;
    }

}

4.在resources目录下创建application.properties存放域名和uri,框架暂时仅支持测试环境

5.在utils下编写post方法工具类

package com.sass.utils;

import org.apache.http.HttpEntity;
import org.apache.http.NameValuePair;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.util.EntityUtils;
import org.json.JSONObject;

import java.io.IOException;
import java.util.*;

import static org.apache.commons.codec.CharEncoding.UTF_8;

/**
 * @Author: lianzheqi
 * @Date: 2019/3/21 10:08
 */

public class Post {
    public static String cookie = "";
    public static HttpPost post = null;
    public static HashMap<String,String> map = new HashMap<>();

    public static String getUrl(String domainKey,String uriKey){
        //通过ResourceBundle获取resources下的application资源
        ResourceBundle bundle = ResourceBundle.getBundle("application", Locale.CHINA);
        String domain = bundle.getString(domainKey);
        String uri = bundle.getString(uriKey);
        //拼接url
        return domain + uri;
    } 

    public static String post(String urikey)throws IOException {
        post = new HttpPost(getUrl("domainApp",urikey));
        CloseableHttpClient client = HttpClients.createDefault();
        //设置请求头
        post.setHeader("Content-Type","application/x-www-form-urlencoded");
        post.setHeader("Origin","http://gs-oa.test.youximao.com");
        if (!Post.cookie.isEmpty()){
            post.setHeader("Cookie",Post.cookie);
        }
        //设置请求体
        List<NameValuePair> paramenters = new ArrayList<NameValuePair>();
        if(null != map){
            for (Map.Entry<String, String> entry : Post.map.entrySet()) {
                paramenters.add(new BasicNameValuePair(entry.getKey(),entry.getValue()));
                System.out.println("key = " + entry.getKey() + ", value = " + entry.getValue());
            }
            map.clear();
            //设置post方法传递编码格式为UTF_8
            HttpEntity requestEntity = new UrlEncodedFormEntity(paramenters,UTF_8);
            post.setEntity(requestEntity);
        }

        //执行post请求
        CloseableHttpResponse response = client.execute(post);
        //获得响应内容
        HttpEntity entity = response.getEntity();
        String entityString = EntityUtils.toString(entity);
        //对响应内容断言

        JSONObject json = new JSONObject(entityString);
        System.out.println(json);
        return entityString;
    }

}

6.由于该项目登录有不同的角色,故将登录接口抽离出一个公共方法,在utils下新建一个Login的工具类,

package com.sass.utils;

import com.alibaba.fastjson.JSON;
import com.sass.model.BaseBean;
import jxl.read.biff.BiffException;
import org.testng.Assert;

import java.io.IOException;
import java.util.HashMap;

/**
 * @Author: lzq
 * @Date: 2019/8/14 15:35
 */
public class Login {
    //fileName:excel文件名,caseName:excel sheet名
    public static Object[][] expectedData(String fileName, String caseName) throws BiffException, IOException {
        ExcelData e = new ExcelData(fileName, caseName);
        return e.getExcelData();
    }

    public static void login(HashMap<String, String> excelData) throws IOException {
    	//传入的参数为excel的数据
        Post.map.put("account", excelData.get("account"));
        Post.map.put("password", excelData.get("password"));
        String str = Post.post("login");
        //通过fastjson进行解析
        BaseBean json = JSON.parseObject(str, BaseBean.class);
        //断言登录返回码是否是excel对应的返回码
        Assert.assertEquals(json.getCode(), excelData.get("code"), "sass系统登录异常");
    }
}

7.登录方法中的Bean采用fastjson来解析，在model下建立对应的BaseBean类,通用的接口返回值只有code、data、message

package com.sass.model;

import lombok.Data;

/**
 * @Author: lzq
 * @Date: 2019/8/14 14:44
 */
@Data
public class BaseBean {
    private String code;
    private String data;
    private String message;

    @Override
    public String toString(){
        return(
                "{code:"+code+","+
                        "data:"+data+","+
                        "message:"+message+"}"
        );
    }
}

8.框架的设计思想是一个类为一个用例集，一个类中可以有多个方法，自行组合用例执行顺序，下面会讲到，目前先在controller下创建一个负责人登录类,excel数据通过testng的DataProvider，经过excelData的解析，返回一个HashMap,key为excel的文件的第一行，value为excel第一行对应的值

package com.sass.controller;

import com.sass.utils.Login;
import jxl.read.biff.BiffException;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

import java.io.IOException;
import java.util.HashMap;

/**
 * @Author: lzq
 * @Date: 2019/8/14 15:45
 */
public class LeaderLogin extends BaseTest {
    //提供excel的参数
    @DataProvider(name="loginDataExpected")
    public Object[][] expectedData() throws BiffException, IOException {
        return Login.expectedData(localFileName,"loginLeader");
    }

    @Test(dataProvider="loginDataExpected")
    public void loginExpected(HashMap<String, String> excelData) throws IOException {
        Login.login(excelData);
    }
}

9.resources下建立TestCaseExcelData文件夹，在该文件夹内建立对应的excel文件
excel文件路径
文件路径要和ExcelData类里的路径对应，要修改路径的话需要对应修改ExcelData里的路径即可

10.查看excel格式要求如下

ps: 如果数据有多行的话，该框架会遍历全部数据，一行数据作为1次测试用例

11.框架由testng.xml文件作为入口，用例执行顺序有testng.xml统一管理，在resources下建立testng.xml文件

<?xml version="1.0" encoding="UTF-8" ?>

<suite name="TestSuite" preserve-order="true">

    <test name="登录负责人账号">
        <classes>
            <!-- testng的参数通过parameter传递 -->
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录负责人 -->
            <class name="com.sass.controller.LeaderLogin"/>

        </classes>

    </test>


    <!-- 引入报告文件样式 -->
    <listeners>
        <listener class-name="com.sass.utils.ExtentTestNGIReporterListener"/>
    </listeners>

</suite>

12.在utils下建立输出报告文件样式 ExtentTestNGIReporterListener,样式有需要可以自行修改

package com.sass.utils;


import com.aventstack.extentreports.ExtentReports;
import com.aventstack.extentreports.ExtentTest;
import com.aventstack.extentreports.ResourceCDN;
import com.aventstack.extentreports.Status;
import com.aventstack.extentreports.model.TestAttribute;
import com.aventstack.extentreports.reporter.ExtentHtmlReporter;
import com.aventstack.extentreports.reporter.configuration.ChartLocation;
import com.aventstack.extentreports.reporter.configuration.Theme;
import org.testng.*;
import org.testng.xml.XmlSuite;

import java.io.File;
import java.util.*;

public class ExtentTestNGIReporterListener implements IReporter {
    //生成的路径以及文件名
    private static final String OUTPUT_FOLDER = "test-output/";
    private static final String FILE_NAME = "AutoTest.html";

    private ExtentReports extent;

    @Override
    public void generateReport(List<XmlSuite> xmlSuites, List<ISuite> suites, String outputDirectory) {
        init();
        boolean createSuiteNode = false;
        if(suites.size()>1){
            createSuiteNode=true;
        }
        for (ISuite suite : suites) {
            Map<String, ISuiteResult> result = suite.getResults();
            //如果suite里面没有任何用例，直接跳过，不在报告里生成
            if(result.size()==0){
                continue;
            }
            //统计suite下的成功、失败、跳过的总用例数
            int suiteFailSize=0;
            int suitePassSize=0;
            int suiteSkipSize=0;
            ExtentTest suiteTest=null;
            //存在多个suite的情况下，在报告中将同一个一个suite的测试结果归为一类，创建一级节点。
            if(createSuiteNode){
                suiteTest = extent.createTest(suite.getName()).assignCategory(suite.getName());
            }
            boolean createSuiteResultNode = false;
            if(result.size()>1){
                createSuiteResultNode=true;
            }
            for (ISuiteResult r : result.values()) {
                ExtentTest resultNode;
                ITestContext context = r.getTestContext();
                if(createSuiteResultNode){
                    //没有创建suite的情况下，将在SuiteResult的创建为一级节点，否则创建为suite的一个子节点。
                    if( null == suiteTest){
                        resultNode = extent.createTest(r.getTestContext().getName());
                    }else{
                        resultNode = suiteTest.createNode(r.getTestContext().getName());
                    }
                }else{
                    resultNode = suiteTest;
                }
                if(resultNode != null){
                    resultNode.getModel().setName(suite.getName()+" : "+r.getTestContext().getName());
                    if(resultNode.getModel().hasCategory()){
                        resultNode.assignCategory(r.getTestContext().getName());
                    }else{
                        resultNode.assignCategory(suite.getName(),r.getTestContext().getName());
                    }
                    resultNode.getModel().setStartTime(r.getTestContext().getStartDate());
                    resultNode.getModel().setEndTime(r.getTestContext().getEndDate());
                    //统计SuiteResult下的数据
                    int passSize = r.getTestContext().getPassedTests().size();
                    int failSize = r.getTestContext().getFailedTests().size();
                    int skipSize = r.getTestContext().getSkippedTests().size();
                    suitePassSize += passSize;
                    suiteFailSize += failSize;
                    suiteSkipSize += skipSize;
                    if(failSize>0){
                        resultNode.getModel().setStatus(Status.FAIL);
                    }
                    resultNode.getModel().setDescription(String.format("Pass: %s ; Fail: %s ; Skip: %s ;",passSize,failSize,skipSize));
                }
                buildTestNodes(resultNode,context.getFailedTests(), Status.FAIL);
                buildTestNodes(resultNode,context.getSkippedTests(), Status.SKIP);
                buildTestNodes(resultNode,context.getPassedTests(), Status.PASS);
            }
            if(suiteTest!= null){
                suiteTest.getModel().setDescription(String.format("Pass: %s ; Fail: %s ; Skip: %s ;",suitePassSize,suiteFailSize,suiteSkipSize));
                if(suiteFailSize>0){
                    suiteTest.getModel().setStatus(Status.FAIL);
                }
            }

        }
//        for (String s : Reporter.getOutput()) {
//            extent.setTestRunnerOutput(s);
//        }

        extent.flush();
    }

    private void init() {
        //文件夹不存在的话进行创建
        File reportDir= new File(OUTPUT_FOLDER);
        if(!reportDir.exists()&& !reportDir .isDirectory()){
            reportDir.mkdir();
        }
        ExtentHtmlReporter htmlReporter = new ExtentHtmlReporter(OUTPUT_FOLDER + FILE_NAME);
        // 设置静态文件的DNS
        //怎么样解决csdn无法加载的问题
        htmlReporter.config().setResourceCDN(ResourceCDN.EXTENTREPORTS);
        htmlReporter.config().setDocumentTitle("自动化测试报告");
        htmlReporter.config().setReportName("自动化测试报告");
        htmlReporter.config().setChartVisibilityOnOpen(true);
        htmlReporter.config().setTestViewChartLocation(ChartLocation.TOP);
        htmlReporter.config().setTheme(Theme.STANDARD);
        htmlReporter.config().setCSS(".node.level-1  ul{ display:none;} .node.level-1.active ul{display:block;}");
        // htmlReporter.config().setEncoding("gbk");
        extent = new ExtentReports();
        extent.attachReporter(htmlReporter);
        extent.setReportUsesManualConfiguration(true);
    }

    private void buildTestNodes(ExtentTest extenttest, IResultMap tests, Status status) {
        //存在父节点时，获取父节点的标签
        String[] categories=new String[0];
        if(extenttest != null ){
            List<TestAttribute> categoryList = extenttest.getModel().getCategoryContext().getAll();
            categories = new String[categoryList.size()];
            for(int index=0;index<categoryList.size();index++){
                categories[index] = categoryList.get(index).getName();
            }
        }

        ExtentTest test;

        if (tests.size() > 0) {
            //调整用例排序，按时间排序
            Set<ITestResult> treeSet = new TreeSet<ITestResult>(new Comparator<ITestResult>() {
                @Override
                public int compare(ITestResult o1, ITestResult o2) {
                    return o1.getStartMillis()<o2.getStartMillis()?-1:1;
                }
            });
            treeSet.addAll(tests.getAllResults());
            for (ITestResult result : treeSet) {
                Object[] parameters = result.getParameters();
                String name="";
                //如果有参数，则使用参数的toString组合代替报告中的name
                for(Object param:parameters){
                    name+=param.toString();
                }
                if(name.length()>0){
                    if(name.length()>50){
                        name= name.substring(0,49)+"...";
                    }
                }else{
                    name = result.getMethod().getMethodName();
                }
                if(extenttest==null){
                    test = extent.createTest(name);
                }else{
                    //作为子节点进行创建时，设置同父节点的标签一致，便于报告检索。
                    test = extenttest.createNode(name).assignCategory(categories);
                }
                //test.getModel().setDescription(description.toString());
                //test = extent.createTest(result.getMethod().getMethodName());
                for (String group : result.getMethod().getGroups())
                    test.assignCategory(group);

                List<String> outputList = Reporter.getOutput(result);
                for(String output:outputList){
                    //将用例的log输出报告中
                    test.debug(output);
                }
                if (result.getThrowable() != null) {
                    test.log(status, result.getThrowable());
                }
                else {
                    test.log(status, "TestDemo " + status.toString().toLowerCase() + "ed");
                }

                test.getModel().setStartTime(getTime(result.getStartMillis()));
                test.getModel().setEndTime(getTime(result.getEndMillis()));
            }
        }
    }

    private Date getTime(long millis) {
        Calendar calendar = Calendar.getInstance();
        calendar.setTimeInMillis(millis);
        return calendar.getTime();
    }
}

13.至此，我们先来运行一下用例,右键testng.xml,选择run
运行用例
出现环境问题的报错请自行配置jdk解决,配置方法本文不在阐述

结果如下：
运行结果
结果出现很多WARN,配置一下log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
 
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
 <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
   <param name="Encoding" value="UTF-8" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />
   </layout>
 </appender>
 <logger name="java.sql">
   <level value="debug" />
 </logger>
 <logger name="org.apache.ibatis">
   <level value="info" />
 </logger>
 <root>
   <level value="info" />
   <appender-ref ref="STDOUT" />
 </root>
</log4j:configuration>

在这里插入图片描述

实际项目中登录是不返回Token，为了获取token，需要我们自己去链接数据库获取token

连接数据库

1.在resources目录下新建一个数据库配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- 注册对象的空间命名 -->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!-- 1.加载数据库驱动 -->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <!-- 2.测试数据库连接地址 -->
                <property name="url" value="jdbc:mysql://192.168.57.214/sass"/>
                <!-- 数据库用户... -->
                <property name="username" value="admin"/>
                <!-- 数据库密码... -->
                <property name="password" value="admin"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 注册映射文件：java对象与数据库之间的xml文件路径！ -->
    <mappers>
        <mapper resource="mapper/SQLMapper.xml"/>
    </mappers>
</configuration>

2.在resources下建立数据库映射文件，结构如下
在这里插入图片描述
先建一个mapper文件夹，再在mapper建立对应的xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 命名空间mapper,如果有多个mapper文件，这个必须唯一 -->
<mapper namespace="com.sass.model">

    <select id="user_oa_token" parameterType="String" resultType="com.sass.model.User_oa_token">
        select token from user_oa_token where uid=#{uid};
    </select>

    <select id="user_register_account" parameterType="String" resultType="com.sass.model.User_register_account">
        select uid from user_register_account where account=#{account};
    </select>

</mapper>

3.在utils下新建数据库配置加载类DatabaseUtil

package com.sass.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.Reader;

/**
 * @Author: lianzheqi
 * @Date: 2019/6/28 17:41
 */
public class DatabaseUtil {
    public static SqlSession getSqlSession() throws IOException {
        //获取配置的资源文件
        Reader reader = Resources.getResourceAsReader("databaseConfig.xml");
        //得到SqlSessionFactory，使用类加载器加载xml文件
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        //得到sqlsession对象，这个对象就能执行配置文件中的sql语句啦
        SqlSession session = factory.openSession();

        return session;
    }
}

4.在model建立对应的User_oa_token 类和User_register_account类,对应数据库表的各个字段

package com.sass.model;

import lombok.Data;

/**
 * @Author: lzq
 * @Date: 2019/8/14 17:05
 */
@Data
public class User_oa_token {
    private String uid;
    private String token;
}

package com.sass.model;

import lombok.Data;

/**
 * @Author: lzq
 * @Date: 2019/8/14 16:59
 */
@Data
public class User_register_account {
    private String uid;
    private String account;
    private String account_type;
}

数据库表字段如下
在这里插入图片描述

过程：先从注册表根据excel表测试数据中的account账号获得uid，再从token表根据uid获取token值

5.获得token会在后面反复用到,so写成一个工具类GetToken,存放在utils下

package com.sass.utils;

import com.sass.model.User_oa_token;
import com.sass.model.User_register_account;
import jxl.read.biff.BiffException;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionException;

import java.io.IOException;
import java.util.HashMap;

/**
 * @Author: lianzheqi
 * @Date: 2019/6/28 17:31
 */
public class GetToken {
    private static User_oa_token user;

    public static Object[][] expectedData(String fileName, String caseName) throws BiffException, IOException {
        //fileName:excel文件名,caseName:excel sheet名
        ExcelData e = new ExcelData(fileName, caseName);
        return e.getExcelData();
    }

    public static void getToken(HashMap<String, String> excelData) throws IOException {
        SqlSession session = null;
        try {
            //链接数据库
            session = DatabaseUtil.getSqlSession();
            if(session == null){
                throw new SqlSessionException();
            }
            User_register_account user_register_account = session.selectOne("user_register_account", excelData.get("account"));
            user = session.selectOne("user_oa_token", user_register_account.getUid());
            //在这里给post方法里的token赋值
            Post.cookie = "token=" + user.getToken();

            System.out.println("数据库取到的token为:" + user.getToken());
        } finally {
            if (session != null) {
                session.close();
            }
        }

    }


}

6.登录用户后首先会调用列表接口,在controller新建一个LeaderListMenu类

package com.sass.controller;

import com.alibaba.fastjson.JSON;
import com.sass.utils.GetToken;
import com.sass.utils.Post;
import jxl.JXLException;
import org.testng.Assert;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

import java.io.IOException;
import java.util.HashMap;

/**
 * @Author: lzq
 * @Date: 2019/6/28 16:34
 */
public class LeaderListMenu extends BaseTest {
    @DataProvider(name="loginLeader")
    public Object[][] getToken() throws IOException, JXLException{
        return GetToken.expectedData(localFileName,"loginLeader");
    }

    @Test(dataProvider = "loginLeader",priority = 1)
    public void getToken(HashMap<String, String> excelData) throws IOException {
        GetToken.getToken(excelData);
    }

	@Test(priority = 2)
    public void listMenu() throws IOException {
        String str = Post.post("listMenu");
        ListMenuBean json = JSON.parseObject(str,ListMenuBean.class);
        Assert.assertEquals(json.getCode(),"2000","/web/auth/listMenu接口异常");
        System.out.println(json.getData().getMenus().get(0).getName());
    }

}

这里涉及到一个知识点,testng的执行顺序问题，加上优先级(priority = 1)可以单独设立方法的执行顺序，不加的话默认都是0,根据方法名字典排序执行,加上后手动排序,越小的越先执行

这里涉及到复杂的Bean的编写,idea有个好用的插件，GsonFormat,自行安装

在这里插入图片描述
在model新建一个ListMenuBean类，右键Generate

选择GsonFormat

将json返回值复制进去，如下，直接点击ok即可

Bean文件就自动创建好了，极其方便，创建的bean如下

package com.sass.model;

import java.util.List;

/**
 * @Author: lzq
 * @Date: 2019/8/14 17:54
 */
public class ListMenuBean {

    private String code;
    private DataBean data;
    private String message;

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public DataBean getData() {
        return data;
    }

    public void setData(DataBean data) {
        this.data = data;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public static class DataBean {


        private UserInfoBean userInfo;
        private List<MenusBean> menus;

        public UserInfoBean getUserInfo() {
            return userInfo;
        }

        public void setUserInfo(UserInfoBean userInfo) {
            this.userInfo = userInfo;
        }

        public List<MenusBean> getMenus() {
            return menus;
        }

        public void setMenus(List<MenusBean> menus) {
            this.menus = menus;
        }

        public static class UserInfoBean {


            private String userName;
            private List<DepartmentsBean> departments;

            public String getUserName() {
                return userName;
            }

            public void setUserName(String userName) {
                this.userName = userName;
            }

            public List<DepartmentsBean> getDepartments() {
                return departments;
            }

            public void setDepartments(List<DepartmentsBean> departments) {
                this.departments = departments;
            }

            public static class DepartmentsBean {
                /**
                 * deptName : 自动组
                 * dutyType : 2
                 * uid : null
                 * deptId : 1157188773538131969
                 * dutyName :
                 */

                private String deptName;
                private int dutyType;
                private Object uid;
                private String deptId;
                private String dutyName;

                public String getDeptName() {
                    return deptName;
                }

                public void setDeptName(String deptName) {
                    this.deptName = deptName;
                }

                public int getDutyType() {
                    return dutyType;
                }

                public void setDutyType(int dutyType) {
                    this.dutyType = dutyType;
                }

                public Object getUid() {
                    return uid;
                }

                public void setUid(Object uid) {
                    this.uid = uid;
                }

                public String getDeptId() {
                    return deptId;
                }

                public void setDeptId(String deptId) {
                    this.deptId = deptId;
                }

                public String getDutyName() {
                    return dutyName;
                }

                public void setDutyName(String dutyName) {
                    this.dutyName = dutyName;
                }
            }
        }

        public static class MenusBean {
            /**
             * icon :
             * name : OA首页
             * permission : welcome
             * id : 1
             * type : 1
             * parentId : 0
             */

            private String icon;
            private String name;
            private String permission;
            private String id;
            private int type;
            private String parentId;

            public String getIcon() {
                return icon;
            }

            public void setIcon(String icon) {
                this.icon = icon;
            }

            public String getName() {
                return name;
            }

            public void setName(String name) {
                this.name = name;
            }

            public String getPermission() {
                return permission;
            }

            public void setPermission(String permission) {
                this.permission = permission;
            }

            public String getId() {
                return id;
            }

            public void setId(String id) {
                this.id = id;
            }

            public int getType() {
                return type;
            }

            public void setType(int type) {
                this.type = type;
            }

            public String getParentId() {
                return parentId;
            }

            public void setParentId(String parentId) {
                this.parentId = parentId;
            }
        }
    }
}

json内容可以通过postman先跑通，复制；若前端已联调完该接口，也可在浏览器直接复制response

7.由于新增了一个接口，需要在application.properties文件中新增一个uri
新增配置如下
在这里插入图片描述
8.在testng.xml中新增一个class用例

然后再次执行用例

结果按照预期的顺序执行了

9.查看报告文件,在sass\test-output\AutoTest.html里，打开该文件
在这里插入图片描述
测试报告的样式还算美观

至此，初步的框架已搭建完成，后续的接口只需在此基础上进行组合即可

新增一个查询组织用户的接口

1.首先在application.properties文件中新增一个uri

queryDeptUser = /web/userInfo/queryDeptUser

2.建立对应json返回的Bean类(QueryDeptUserBean)
3.使用插件自动生成Bean,上面有讲到

package com.sass.model;

import java.util.List;

/**
 * @Author: lianzheqi
 * @Date: 2019/8/5 11:34
 */
public class QueryDeptUserBean {


    /**
     * code : 2000
     * data : {"list":[{"account":"yuangong1","deptInfos":[{"deptId":"1157188773538131969","deptName":"自动组","dutyName":"成员","dutyType":1,"uid":"1157192455092662273"}],"isEnable":true,"leaderName":"自动组长","mobile":"18823434543","roleId":"1157191595524583425","roleName":"自动组","uid":"1157192455092662273","userName":"自动员工1"}],"total":1}
     * message : 成功
     */

    private String code;
    private DataBean data;
    private String message;

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public DataBean getData() {
        return data;
    }

    public void setData(DataBean data) {
        this.data = data;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public static class DataBean {
        /**
         * list : [{"account":"yuangong1","deptInfos":[{"deptId":"1157188773538131969","deptName":"自动组","dutyName":"成员","dutyType":1,"uid":"1157192455092662273"}],"isEnable":true,"leaderName":"自动组长","mobile":"18823434543","roleId":"1157191595524583425","roleName":"自动组","uid":"1157192455092662273","userName":"自动员工1"}]
         * total : 1
         */

        private int total;
        private List<ListBean> list;

        public int getTotal() {
            return total;
        }

        public void setTotal(int total) {
            this.total = total;
        }

        public List<ListBean> getList() {
            return list;
        }

        public void setList(List<ListBean> list) {
            this.list = list;
        }

        public static class ListBean {
            /**
             * account : yuangong1
             * deptInfos : [{"deptId":"1157188773538131969","deptName":"自动组","dutyName":"成员","dutyType":1,"uid":"1157192455092662273"}]
             * isEnable : true
             * leaderName : 自动组长
             * mobile : 18823434543
             * roleId : 1157191595524583425
             * roleName : 自动组
             * uid : 1157192455092662273
             * userName : 自动员工1
             */

            private String account;
            private boolean isEnable;
            private String leaderName;
            private String mobile;
            private String roleId;
            private String roleName;
            private String uid;
            private String userName;
            private List<DeptInfosBean> deptInfos;

            public String getAccount() {
                return account;
            }

            public void setAccount(String account) {
                this.account = account;
            }

            public boolean isIsEnable() {
                return isEnable;
            }

            public void setIsEnable(boolean isEnable) {
                this.isEnable = isEnable;
            }

            public String getLeaderName() {
                return leaderName;
            }

            public void setLeaderName(String leaderName) {
                this.leaderName = leaderName;
            }

            public String getMobile() {
                return mobile;
            }

            public void setMobile(String mobile) {
                this.mobile = mobile;
            }

            public String getRoleId() {
                return roleId;
            }

            public void setRoleId(String roleId) {
                this.roleId = roleId;
            }

            public String getRoleName() {
                return roleName;
            }

            public void setRoleName(String roleName) {
                this.roleName = roleName;
            }

            public String getUid() {
                return uid;
            }

            public void setUid(String uid) {
                this.uid = uid;
            }

            public String getUserName() {
                return userName;
            }

            public void setUserName(String userName) {
                this.userName = userName;
            }

            public List<DeptInfosBean> getDeptInfos() {
                return deptInfos;
            }

            public void setDeptInfos(List<DeptInfosBean> deptInfos) {
                this.deptInfos = deptInfos;
            }

            public static class DeptInfosBean {
                /**
                 * deptId : 1157188773538131969
                 * deptName : 自动组
                 * dutyName : 成员
                 * dutyType : 1
                 * uid : 1157192455092662273
                 */

                private String deptId;
                private String deptName;
                private String dutyName;
                private int dutyType;
                private String uid;

                public String getDeptId() {
                    return deptId;
                }

                public void setDeptId(String deptId) {
                    this.deptId = deptId;
                }

                public String getDeptName() {
                    return deptName;
                }

                public void setDeptName(String deptName) {
                    this.deptName = deptName;
                }

                public String getDutyName() {
                    return dutyName;
                }

                public void setDutyName(String dutyName) {
                    this.dutyName = dutyName;
                }

                public int getDutyType() {
                    return dutyType;
                }

                public void setDutyType(int dutyType) {
                    this.dutyType = dutyType;
                }

                public String getUid() {
                    return uid;
                }

                public void setUid(String uid) {
                    this.uid = uid;
                }
            }
        }
    }
}

4.controller下编写用例类(QueryDeptUser)

package com.sass.controller;

import com.alibaba.fastjson.JSON;
import com.sass.model.QueryDeptUserBean;
import com.sass.utils.ExcelData;
import com.sass.utils.Post;
import jxl.read.biff.BiffException;
import org.testng.Assert;
import org.testng.annotations.*;

import java.io.IOException;
import java.util.HashMap;


/**
 * @Author: lianzheqi
 * @Date: 2019/8/5 10:39
 */
public class QueryDeptUser extends BaseTest {
    @DataProvider(name="queryDeptUserData")
    public static Object[][] expectedData() throws BiffException, IOException {
        ExcelData e=new ExcelData(localFileName, "queryDeptUser");
        return e.getExcelData();
    }

    @Test(dataProvider="queryDeptUserData")
    public void queryDeptUser(HashMap<String, String> excelData) throws IOException {
        Post.map.put("mobile",excelData.get("mobile"));
        Post.map.put("userName",excelData.get("userName"));
        Post.map.put("isEnable",excelData.get("isEnable"));
        Post.map.put("deptId",excelData.get("deptId"));
        Post.map.put("currentPage",excelData.get("currentPage"));
        Post.map.put("pageSize",excelData.get("pageSize"));

        String str = Post.post("queryDeptUser");
        QueryDeptUserBean json = JSON.parseObject(str,QueryDeptUserBean.class);
        //断言员工存不存在,根据自己测试需要断言
        Assert.assertEquals(json.getData().getList().get(0).getAccount(),excelData.get("account"),"查询员工查不到");
    }
}

5.将该测试类组装到testng.xml中
在这里插入图片描述

5.右键运行testng文件
在这里插入图片描述
结果该接口执行了2次,是因为excel文件中有2条数据

后面单个接口的过程类似,只是有的接口的返回值需要临时存储一下，当做另一个接口的入参

组装各个接口,达到完整的业务流的功能

具体过程不再展示,最终效果如下

<?xml version="1.0" encoding="UTF-8" ?>

<suite name="TestSuite" preserve-order="true">

    <test name="负责人禁用员工1;禁用游戏1区;关联游戏2区;发布任务;分发给员工2">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录负责人 -->
            <class name="com.sass.controller.LeaderLogin"/>
            <class name="com.sass.controller.LeaderListMenu"/>
            <class name="com.sass.controller.QueryDeptUser"/>
            <!-- 禁用员工1 -->
            <class name="com.sass.controller.DisableUser"/>
            <!-- 禁用游戏1区 -->
            <class name="com.sass.controller.UpdateGameServer"/>
            <!-- 关联游戏2区 -->
            <class name="com.sass.controller.GameChannelBinding"/>
            <!-- 发布任务 -->
            <class name="com.sass.controller.PublishTask"/>
            <!-- 分发给员工2 -->
            <class name="com.sass.controller.AssignTask"/>

        </classes>

    </test>

    <test name="员工2核实分配到的账号;提交任务审核">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录员工2 -->
            <class name="com.sass.controller.Staff2Login"/>
            <class name="com.sass.controller.Staff2ListMenu"/>
            <!-- 核实员工2分配到的账号 -->
            <class name="com.sass.controller.ListStaffAccount"/>
            <!-- 员工2提交任务审核 -->
            <class name="com.sass.controller.StaffGetTaskDetail"/>
            <class name="com.sass.controller.Staff2SubmitTask"/>
        </classes>
    </test>

    <test name="负责人审核拒绝;查找任务交接:员工2;核对任务交接列表无自己(员工2)和禁用的员工1;启用员工1;将员工2的任务交接给员工1">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录负责人 -->
            <class name="com.sass.controller.LeaderLogin"/>
            <class name="com.sass.controller.LeaderListMenu"/>
            <!-- 负责人审核拒绝 -->
            <class name="com.sass.controller.VerifyTaskRefused"/>
            <!-- 查找任务交接:员工2 -->
            <class name="com.sass.controller.QueryHandoverTask"/>
            <!-- 核对任务交接列表无自己(员工2)和禁用的员工1 -->
            <class name="com.sass.controller.ListDeptAndUserNotDisableStaff"/>
            <!-- 启用员工1 -->
            <class name="com.sass.controller.EnableUser"/>
            <!-- 将员工2的任务交接给员工1 -->
            <class name="com.sass.controller.ListDeptAndUser"/>
            <class name="com.sass.controller.HandoverTask"/>
        </classes>
    </test>

    <test name="员工1核实分配到的账号">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录员工1 -->
            <class name="com.sass.controller.Staff1Login"/>
            <class name="com.sass.controller.Staff1ListMenu"/>
            <!-- 核实员工1分配到的账号 -->
            <class name="com.sass.controller.ListStaffAccount"/>
        </classes>
    </test>

    <test name="员工2核实分配到的账号被撤回">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录员工2 -->
            <class name="com.sass.controller.Staff2Login"/>
            <class name="com.sass.controller.Staff2ListMenu"/>
            <!-- 核实员工2分配到的账号被撤回 -->
            <class name="com.sass.controller.ListStaffNotAccount"/>
        </classes>
    </test>

    <test name="员工1修改上传内容后再次提交任务审核">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录员工1 -->
            <class name="com.sass.controller.Staff1Login"/>
            <class name="com.sass.controller.Staff1ListMenu"/>
            <!-- 员工1修改上传内容后再次提交任务审核 -->
            <class name="com.sass.controller.StaffGetTaskDetail"/>
            <class name="com.sass.controller.Staff1SubmitTask"/>
        </classes>
    </test>

    <test name="负责人审核通过;撤出任务">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录负责人 -->
            <class name="com.sass.controller.LeaderLogin"/>
            <class name="com.sass.controller.LeaderListMenu"/>
            <!-- 负责人审核通过 -->
            <class name="com.sass.controller.VerifyTaskPass"/>
            <!-- 撤出任务 -->
            <class name="com.sass.controller.WithdrawTask"/>
            <!-- 到达撤出时间后查看任务状态为已撤出 -->
            <class name="com.sass.controller.QueryTask"/>
        </classes>
    </test>

    <test name="员工1核实分配到的账号被撤回">
        <classes>
            <parameter name="fileName" value="LoginTrueData"/>
            <!-- 登录员工1 -->
            <class name="com.sass.controller.Staff1Login"/>
            <class name="com.sass.controller.Staff1ListMenu"/>
            <!-- 核实员工1分配到的账号被撤回 -->
            <class name="com.sass.controller.ListStaffNotAccount"/>
        </classes>
    </test>


    <listeners>
        <listener class-name="com.sass.utils.ExtentTestNGIReporterListener"/>
    </listeners>

</suite>

testng不支持同一个test跑2个相同的class,所以将单个用户的操作设计为一个test,切换用户时切换test
至此,通过接口自动化跑业务流已全部完成,后面要做的就是配置持续集成

tetsuki

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
接口自动化实践

接口自动化实践欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入欢迎使用Markd...
复制链接

扫一扫

专栏目录