做床上用品网站,企业服务云,免费网站服务器域名,天河网站建设哪家强总体框架设计见我另一篇博客#xff1a;httpclienttestng接口自动化整体框架设计
block#xff1a;表示测试用例块 block后面是 测试用例的名称
||接口名,该接口名在URL.txt里维护接口
||get\post#xff1a;表示请求的方法
get_1\2\3\4#xff1a;代表加密
get: …总体框架设计见我另一篇博客httpclienttestng接口自动化整体框架设计
block表示测试用例块 block后面是 测试用例的名称
||接口名,该接口名在URL.txt里维护接口
||get\post表示请求的方法
get_1\2\3\4代表加密
get: 默认不加密
post_1\2\3\4表示要加密参数
post默认不加密
||参数
[|| post ]参数
||1表示人工检查或者是公用参数 其他数字表示程序检查
||预期结果 或者可以为空
参数替换
【RegisterUser_1,title】
RegisterUser_1表示序列号接口中的第一个RegisterUser
title表示序列号接口中的第一个RegisterUser返回的结果取第一个title的内容,进行参数替换
默认title不加_num 表示取默认第一个数据
【RegisterUser_2,title_2】
RegisterUser_2表示序列号接口中的第二个RegisterUser
title_2表示序列号接口中的第一个RegisterUser返回的结果取第二个title的内容,进行参数替换
1. 向公司开发人员要setting.xml 修改 localRepository/Users/qa/.m2/repository/localRepository 为自己的仓库地址 2. 如果有开发人员给的下载好的Maven仓库 可以直接解压缩用 3. 右击pom.xml 点击Maven-Download Source 完成依赖包的下载 4. 删除多余的类 只保留一个类
find *|grep -v hcecommon8302.java |xargs rm -rf
5. 基于被测新业务设计自动化case运行结果入库
申请数据库权限IP port username passwd建新库testng
设计2张表总体运行结果统计表api_job、单条case运行结果表api_test CREATE TABLE api_job ( id BIGINT NOT NULL AUTO_INCREMENT COMMENT 主键id, build_number varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 自动化任务构建ID-项目名称及运行时间, job_id varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 32位任务号, passed int NOT NULL DEFAULT 0 COMMENT case通过总数, failures int NOT NULL DEFAULT 0 COMMENT case失败总数, errors int NOT NULL DEFAULT 0 COMMENT case错误总数, skip int NOT NULL DEFAULT 0 COMMENT case失败总数, total int NOT NULL DEFAULT 0 COMMENT case总数, duration_time varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT COMMENT case运行时长, test_type varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 自动化框架类型, test_env varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 测试环境域名, comments varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT case类型-autocase, sub_test_type varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT api functions, start_time varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT case开始时间, product_address varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 线上地址, test_job_name varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT Job项目名称, PRIMARY KEY (id) USING BTREE, UNIQUE KEY uniq_job_id (job_id) USING BTREE, KEY idx_build_number (build_number) ) ENGINEInnoDB AUTO_INCREMENT152 DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_general_ci COMMENT自动化case总览表; CREATE TABLE api_test ( id bigint NOT NULL AUTO_INCREMENT COMMENT 主键id, build_number varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 自动化任务构建ID-项目名称及运行时间, job_id varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 32位任务号, casename varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT COMMENT case名称, status varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT COMMENT case运行结果, start_time varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT case开始时间, end_time varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT case结束时间, diff_info varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT json具体diff信息, duration_time varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT case运行时长, test_type varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT testng auto, test_env varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 测试环境域名, open_bugs varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT open状态的bug号, closed_bugs varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT open状态的bug号, sub_test_type varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT api functions, test_time varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 当前时间, product_address varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 线上地址, test_job_name varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT Job名称, PRIMARY KEY (id) USING BTREE, UNIQUE KEY uniq_job_id (job_id) USING BTREE, KEY idx_build_number (build_number) ) ENGINEInnoDB DEFAULT CHARSETutf8mb4 COLLATEutf8mb4_general_ci COMMENT自动化case单条执行结果;
6. 修改目录结构基于业务调整API
