Java自动化测试(参数化 19)

{"mobile_phone":"13212332111","pwd":"12345678"}

{"mobile_phone":"${register_md}","pwd":"${register_pwd}"}

["select count(*) from member a where a.mobile_phone = '${register_mb}';"]

<dependency>
    <groupId>com.github.binarywang</groupId>
    <artifactId>java-testdata-generator</artifactId>
    <version>1.1.2</version>
</dependency>

package com.zhongxin.utils;

import cn.binarywang.tools.generator.ChineseMobileNumberGenerator;

import java.util.HashMap;
import java.util.Map;

public class UserData {
    // 存储接口响应对象
    public static Map<String, Object> VARS = new HashMap<>();
    // 存储默认请求头
    public static Map<String, String> DEFAULT_HEADERS = new HashMap<>();

    static {
        // 静态代码：类在加载时会自动加载一次此代码
        DEFAULT_HEADERS.put("X-Lemonban-Media-Type", "lemonban.v2");
        DEFAULT_HEADERS.put("Content-Type", "application/json");

        // 把需要参数化的数据存储到VARS
        // 随机手机号码
        VARS.put("${register_mb}", ChineseMobileNumberGenerator.getInstance().generate());
        VARS.put("${register_pwd}", "12345678");
        VARS.put("${amount}", "5000");
    }
}

public void paramsReplace(CaseInfo caseInfo) {
        Set<String> keySet = UserData.VARS.keySet();
        String params = caseInfo.getParams();
        String sql = caseInfo.getSql();
        String expectedResult = caseInfo.getExpectedResult();
        String url = caseInfo.getUrl();
        for (String placeHolder : keySet) {
            String value = UserData.VARS.get(placeHolder).toString();
            if (StringUtils.isNotBlank(params)) {
                params = params.replace(placeHolder, value);
            }
            if (StringUtils.isNotBlank(sql)) {
                sql = sql.replace(placeHolder, value);
            }
            if (StringUtils.isNotBlank(expectedResult)) {
                expectedResult = expectedResult.replace(placeHolder, value);
            }
            if (StringUtils.isNotBlank(url)) {
                url = url.replace(placeHolder, value);
            }
        }
        caseInfo.setParams(params);
        caseInfo.setSql(sql);
        caseInfo.setExpectedResult(expectedResult);
        caseInfo.setUrl(url);
    }

<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>4.0.0</version>
    <exclusions>
        <exclusion>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
        </exclusion>
    </exclusions>
</dependency>

package com.zhongxin.utils;

public class Constants {            

    // 响应数据回写列
    public static final int PESPONSE_CELL_NUM = 8;
    // 断言数据回写列
    public static final int ASSERT_CELL_NUM = 10;
    // 用例文件路径
    public static final String EXCEL_PATH = "src/test/resources/cases_v3.xlsx";

}

<dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
</dependency>

log4j.rootLogger = INFO,console,file

log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern = %d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

log4j.appender.file = org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.File = log/api_auto.log
log4j.appender.file.Append = false
log4j.appender.file.layout = org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern = %d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

import org.apache.log4j.Logger;

private static Logger logger = Logger.getLogger(HttpUtils.class);

logger.info(statusCode);