Eolink 神技之五：API 自动化高级应用之定时任务功能

前言

定时的 Task，相信大家工作的项目中肯定都用着呢，这个东西是在咱们工作中真的是无法少了它，很多功能都需要依靠定时任务来完成，自动化测试也一样。但是我们之前使用的工具统统没有这个功能，这回 Eolink 出来个这个功能是相当的给力，我知道这个功能后也是第一时间进行了测试。下面就是我整个的测试过程，希望能对大家有所帮助。

演示步骤

1、项目创建
2、创建定时任务
3、定时任务测试

一、项目创建

1、选择 API 自动化测试功能

我们要测试的是定时任务，肯定是属于自动化测试，这个功能位置安排的就很合理，这里需要给 GUI 的产品规划点个赞。

2、添加项目

我们既然测试一个新功能为了更加明确，我们单独创建一个新的项目。

填入自动化测试的名称以及备注，这里备注是【选填】。

3、引入测试用例

我们需要进入到项目中为项目添加对应的测试用例。

用例采用我提供的就可以，服务是在线的 MySQL，直接用即可。绝对可用，保障测试过程的顺畅。

直接复制，并制作成一个 json 文件。

{"caseList":[{"caseID":553171,"caseName":"Eolink_MySQL_API","caseDesc":"","caseType":0,"caseCode":"","caseTag":"","userID":643871,"priority":0,"caseStyle":"general","commonCaseList":[],"commonCaseApiConnCaseList":[],"caseSingleList":[],"dbStepList":[{"connID":6492,"caseID":553171,"apiName":"1\u3001\u65e0\u53c2\u6570\u67e5\u8be2","dbID":1022,"caseData":"{\"params\":[],\"keepGoing\":1,\"sqlCode\":\"select * from eolink_mysql_api;\"}","orderNumber":1,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\/\/\u6570\u636e\u5e93\u8fd4\u56de\u7ed3\u679c\u6821\u9a8c\u811a\u672c\u793a\u4f8b\n\/\/\u6570\u636e\u5e93\u64cd\u4f5c\u7ed3\u679c\u793a\u4f8b\u8bf7\u67e5\u770b\u5e2e\u52a9\u4e2d\u5fc3\u6559\u7a0b\n\/\/\u6570\u636e\u5e93\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\u50a8\u5b58\u5728\u53d8\u91cfdb_result\u4e2d\nif(db_result[\"status\"]==\"success\"){\n\t\/\/\u6570\u636e\u5e93\u8bed\u53e5\u6574\u4f53\u6267\u884c\u6210\u529f\n\t\/\/\u6bcf\u4e00\u6761\u6570\u636e\u5e93\u8bed\u53e5\u7684\u6267\u884c\u7ed3\u679c\u50a8\u5b58\u5728db_result[\"query\"][...]\u6570\u7ec4\u4e2d\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"result\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"status\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u72b6\u6001\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"time\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\n\teo.info(db_result[\"query\"][0][\"result\"]);\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 18:43:29","createTime":"2022-11-29 18:43:29","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}},{"connID":6493,"caseID":553171,"apiName":"2\u3001\u6709\u53c2\u67e5\u8be2\u8bed\u53e5","dbID":1022,"caseData":"{\"params\":[{\"paramKey\":\"userName\",\"paramNotNull\":\"0\",\"paramInfo\":\"Eolink_admin\"}],\"keepGoing\":1,\"sqlCode\":\"select * from eolink_mysql_api where userName = '$${userName}';\"}","orderNumber":2,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\nif(db_result[\"status\"]==\"success\"){\n\tif(db_result[\"query\"][0][\"result\"][0][\"userName\"]==\"Eolink_admin\"){\n\t    eo.info(\"\u67e5\u8be2\u7ed3\u679c\u7684userName\u662fEolink_admin\u6240\u4ee5\u6d4b\u8bd5\u6210\u529f\");\n\t}else{\n\t    eo.stop(\"\u8fd4\u56de\u7ed3\u679c\u4e0e\u9700\u6c42\u4e0d\u7b26\");\n\t}\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 18:57:50","createTime":"2022-11-29 18:54:46","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}},{"connID":6494,"caseID":553171,"apiName":"\u589e\u52a0\u8bed\u53e5","dbID":1022,"caseData":"{\"params\":[{\"paramKey\":\"phone\",\"paramNotNull\":\"0\",\"paramInfo\":\"13472040766\"},{\"paramKey\":\"userName\",\"paramNotNull\":\"0\",\"paramInfo\":\"Eolink_super_admin\"},{\"paramKey\":\"pwd\",\"paramNotNull\":\"0\",\"paramInfo\":\"123456\"},{\"paramKey\":\"introduce\",\"paramNotNull\":\"0\",\"paramInfo\":\"\u4e13\u4e3a\u5f00\u53d1\u8005\u8bbe\u8ba1\u7684API\u534f\u4f5c\u5e73\u53f0\"}],\"keepGoing\":1,\"sqlCode\":\"insert into eolink_mysql_api VALUES(0,NOW(),NOW(),'$${phone}','$${userName}','$${pwd}','$${introduce}');\"}","orderNumber":3,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\/\/\u6570\u636e\u5e93\u8fd4\u56de\u7ed3\u679c\u6821\u9a8c\u811a\u672c\u793a\u4f8b\n\/\/\u6570\u636e\u5e93\u64cd\u4f5c\u7ed3\u679c\u793a\u4f8b\u8bf7\u67e5\u770b\u5e2e\u52a9\u4e2d\u5fc3\u6559\u7a0b\n\/\/\u6570\u636e\u5e93\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\u50a8\u5b58\u5728\u53d8\u91cfdb_result\u4e2d\nif(db_result[\"status\"]==\"success\"){\n\t\/\/\u6570\u636e\u5e93\u8bed\u53e5\u6574\u4f53\u6267\u884c\u6210\u529f\n\t\/\/\u6bcf\u4e00\u6761\u6570\u636e\u5e93\u8bed\u53e5\u7684\u6267\u884c\u7ed3\u679c\u50a8\u5b58\u5728db_result[\"query\"][...]\u6570\u7ec4\u4e2d\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"result\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"status\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u72b6\u6001\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"time\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\n\teo.info(db_result[\"query\"][0][\"result\"]);\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 19:02:02","createTime":"2022-11-29 19:02:02","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}},{"connID":6495,"caseID":553171,"apiName":"\u5220\u9664\u8bed\u53e5","dbID":1022,"caseData":"{\"params\":[{\"paramKey\":\"phone\",\"paramNotNull\":\"0\",\"paramInfo\":\"13472040766\"}],\"keepGoing\":1,\"sqlCode\":\"DELETE from eolink_mysql_api where phone = '$${phone}';\"}","orderNumber":4,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\/\/\u6570\u636e\u5e93\u8fd4\u56de\u7ed3\u679c\u6821\u9a8c\u811a\u672c\u793a\u4f8b\n\/\/\u6570\u636e\u5e93\u64cd\u4f5c\u7ed3\u679c\u793a\u4f8b\u8bf7\u67e5\u770b\u5e2e\u52a9\u4e2d\u5fc3\u6559\u7a0b\n\/\/\u6570\u636e\u5e93\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\u50a8\u5b58\u5728\u53d8\u91cfdb_result\u4e2d\nif(db_result[\"status\"]==\"success\"){\n\t\/\/\u6570\u636e\u5e93\u8bed\u53e5\u6574\u4f53\u6267\u884c\u6210\u529f\n\t\/\/\u6bcf\u4e00\u6761\u6570\u636e\u5e93\u8bed\u53e5\u7684\u6267\u884c\u7ed3\u679c\u50a8\u5b58\u5728db_result[\"query\"][...]\u6570\u7ec4\u4e2d\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"result\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"status\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u72b6\u6001\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"time\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\n\teo.info(db_result[\"query\"][0][\"result\"]);\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 19:05:31","createTime":"2022-11-29 19:05:11","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}},{"connID":6496,"caseID":553171,"apiName":"\u4fee\u6539\u8bed\u53e5","dbID":1022,"caseData":"{\"params\":[{\"paramKey\":\"pwd\",\"paramNotNull\":\"0\",\"paramInfo\":\"123456\"},{\"paramKey\":\"userName\",\"paramNotNull\":\"0\",\"paramInfo\":\"Eolink_admin\"}],\"keepGoing\":1,\"sqlCode\":\"update eolink_mysql_api set pwd =PASSWORD('$${pwd}') where userName = '$${userName}';\"}","orderNumber":5,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\/\/\u6570\u636e\u5e93\u8fd4\u56de\u7ed3\u679c\u6821\u9a8c\u811a\u672c\u793a\u4f8b\n\/\/\u6570\u636e\u5e93\u64cd\u4f5c\u7ed3\u679c\u793a\u4f8b\u8bf7\u67e5\u770b\u5e2e\u52a9\u4e2d\u5fc3\u6559\u7a0b\n\/\/\u6570\u636e\u5e93\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\u50a8\u5b58\u5728\u53d8\u91cfdb_result\u4e2d\nif(db_result[\"status\"]==\"success\"){\n\t\/\/\u6570\u636e\u5e93\u8bed\u53e5\u6574\u4f53\u6267\u884c\u6210\u529f\n\t\/\/\u6bcf\u4e00\u6761\u6570\u636e\u5e93\u8bed\u53e5\u7684\u6267\u884c\u7ed3\u679c\u50a8\u5b58\u5728db_result[\"query\"][...]\u6570\u7ec4\u4e2d\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"result\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"status\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u72b6\u6001\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"time\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\n\teo.info(db_result[\"query\"][0][\"result\"]);\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 19:07:42","createTime":"2022-11-29 19:07:42","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}},{"connID":6497,"caseID":553171,"apiName":"\u89c6\u56fe\u67e5\u8be2","dbID":1022,"caseData":"{\"params\":[],\"keepGoing\":1,\"sqlCode\":\"select * from eolink_view;\"}","orderNumber":6,"isLock":0,"delayTime":0,"matchType":2,"matchRule":"\/\/\u6570\u636e\u5e93\u8fd4\u56de\u7ed3\u679c\u6821\u9a8c\u811a\u672c\u793a\u4f8b\n\/\/\u6570\u636e\u5e93\u64cd\u4f5c\u7ed3\u679c\u793a\u4f8b\u8bf7\u67e5\u770b\u5e2e\u52a9\u4e2d\u5fc3\u6559\u7a0b\n\/\/\u6570\u636e\u5e93\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\u50a8\u5b58\u5728\u53d8\u91cfdb_result\u4e2d\nif(db_result[\"status\"]==\"success\"){\n\t\/\/\u6570\u636e\u5e93\u8bed\u53e5\u6574\u4f53\u6267\u884c\u6210\u529f\n\t\/\/\u6bcf\u4e00\u6761\u6570\u636e\u5e93\u8bed\u53e5\u7684\u6267\u884c\u7ed3\u679c\u50a8\u5b58\u5728db_result[\"query\"][...]\u6570\u7ec4\u4e2d\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"result\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u8fd4\u56de\u7ed3\u679c\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"status\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u72b6\u6001\n\t\/\/\u53ef\u4ee5\u901a\u8fc7\u5982db_result[\"query\"][0][\"info\"][\"time\"]\u53d6\u51fa\u7b2c\u4e00\u6761\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\n\teo.info(db_result[\"query\"][0][\"result\"]);\n}\nelse{\n\t\/\/\u6267\u884c\u5931\u8d25\n\teo.stop(\"\u6570\u636e\u5e93\u8bed\u53e5\u6267\u884c\u5931\u8d25\");\n}","generateResponseCode":"","updateTime":"2022-11-29 19:09:55","createTime":"2022-11-29 19:09:55","isExecute":1,"resultParam":"[]","customInfo":"{}","operationGroupID":0,"dbConnectName":"Eolink_MySQL_Test","dbCreateTime":"2022-11-29 18:25:40","dbInfo":{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","dbCreateTime":"2022-11-29 18:25:40"}}],"dbStepApiConnCaseList":[],"dataCollectionData":null}],"commonDatabasesList":[{"dbID":1022,"dbConnectName":"Eolink_MySQL_Test","dbType":0,"dbInfoList":"[{\"envID\":0,\"port\":\"3306\",\"name\":\"eolink_test\",\"host\":\"C82b0XR5i89FWlGw6tQULUe7Ca+c6jquXsNF1UIzDZD1gP9\/Ac9cC6686FZW9zSs\",\"user\":\"Hy51ZQGees0ZX5lkDBa2xA==\",\"password\":\"NY18bypH9WTLsMMxErulHg==\"}]","dbDesc":"\u6d4b\u8bd5Eolink\u8fde\u63a5MySQL\u5e76\u521b\u5efa\u6d4b\u8bd5","createTime":"2022-11-29 18:25:40","updateTime":"2022-11-29 18:25:40"}],"caseType":"sceneCase"}

在添加分组的下拉菜单中选择【导入】