DROP TABLE IF EXISTS `Chain`;

CREATE TABLE `Chain` (

) ENGINE=InnoDB AUTO_INCREMENT=1765725895393 DEFAULT CHARSET=utf8mb3 COMMENT='多接口串联的场景链路用例';

LOCK TABLES `Chain` WRITE;

/*!40000 ALTER TABLE `Chain` DISABLE KEYS */;

INSERT INTO `Chain` VALUES (11,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',0,NULL,0,NULL,0,'2024-05-02 13:12:36','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(12,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1648334213866,NULL,0,NULL,0,'2024-05-02 13:15:49','[\"Chat\", \"Tommy\"]','','','{}'),(13,82001,NULL,'82002',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1546414179257,NULL,0,NULL,0,'2024-05-02 13:16:02','[\"Chat\", \"Tommy\"]','Jan','13000082002','{\"id\": 82002, \"name\": \"Jan\", \"phone\": \"13000082002\", \"account\": \"13000082002\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 18, \"whiteCount\": 18, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(15,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205562,NULL,0,NULL,0,'2024-05-02 13:21:29','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(16,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1704192205563,NULL,0,NULL,0,'2024-05-02 13:21:54','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(17,82001,NULL,'82003',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2024-10-27 13:46:19',1511969630372,NULL,0,NULL,0,'2024-05-02 13:22:10','[\"Chat\", \"Tommy\"]','Wechat','13000082003','{\"id\": 82003, \"name\": \"Wechat\", \"phone\": \"13000082003\", \"account\": \"13000082003\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 0, \"remember\": false, \"blueCount\": 0, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 0, \"whiteCount\": 0, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(48,1704867025040,NULL,'',0,1742784526673,'查询动态列表','2025-03-24 02:48:46',0,NULL,0,NULL,0,'2025-03-24 02:48:46',NULL,NULL,NULL,NULL),(49,82001,NULL,'',0,1742784526673,'查询动态列表','2025-03-24 06:05:56',1704192205420,NULL,0,NULL,0,'2025-03-24 06:05:56','[\"Moment\", \"Lemon\"]','','','{}'),(59,82001,NULL,'',0,1742784526673,'查询动态列表','2025-08-08 04:09:57',1564483634841,NULL,0,NULL,0,'2025-08-08 04:09:58','[\"Moment\", \"Lemon\"]','','','{}'),(1759994627546,82001,NULL,'',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-09 07:23:47',1546414192830,NULL,0,NULL,0,'2025-10-09 07:23:47','[\"Chat\", \"Tommy\"]',NULL,NULL,NULL),(1761204465097,82001,NULL,'82001',0,1714655556079,'查询动态列表-查询动态详情-查询评论列表-回复评论','2025-10-23 07:27:45',1704192205420,NULL,0,NULL,0,'2025-10-23 07:27:45','[\"Chat\", \"Tommy\"]','Test User','13000082001','{\"id\": 82001, \"name\": \"Test User\", \"phone\": \"13000082001\", \"account\": \"13000082001\", \"baseUrl\": \"http://localhost:8080\", \"password\": \"123456\", \"redCount\": 7, \"remember\": false, \"blueCount\": 13, \"greenCount\": 0, \"isLoggedIn\": true, \"totalCount\": 26, \"whiteCount\": 6, \"orangeCount\": 0, \"summaryType\": \"total\"}'),(1761204465098,82001,NULL,'',0,1742784526673,'查询动态列表','2025-10-27 03:14:19',1522905895591,NULL,0,NULL,0,'2025-10-27 03:14:20','[\"Moment\", \"Lemon\"]','','','{}'),(1761204465117,82001,NULL,'',0,1742784526673,'查询动态列表','2025-11-30 10:43:35',1511796155276,'获取验证码',0,NULL,0,'2025-11-30 10:43:35','[\"Moment\", \"Lemon\"]',NULL,NULL,NULL),(1761204465119,82001,NULL,'0',0,1765128460243,'test chain','2025-12-07 17:27:40',0,NULL,0,NULL,0,'2025-12-07 17:27:40','[\"tets\"]',NULL,NULL,NULL),(1765722250311,82001,NULL,'0',0,1765128460243,'test chain','2025-12-14 14:24:10',1546414192830,'获取用户列表',0,NULL,0,'2025-12-14 14:24:10',NULL,NULL,NULL,NULL),(1765725895387,82003,NULL,'0',0,1765128460243,'test chain','2025-12-14 15:24:55',1560737118846,'获取单个用户信息2 12:05',0,NULL,0,'2025-12-14 15:24:55',NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `Chain` ENABLE KEYS */;

DROP TABLE IF EXISTS `Script`;

CREATE TABLE `Script` (

`Script` text NOT NULL,

) ENGINE=InnoDB AUTO_INCREMENT=1738490404346 DEFAULT CHARSET=utf8mb3 COMMENT='脚本，前置预处理脚本、后置断言和恢复脚本等';

LOCK TABLES `Script` WRITE;

/*!40000 ALTER TABLE `Script` DISABLE KEYS */;

INSERT INTO `Script` VALUES (1,0,0,0,0,0,0,0,NULL,'getType','function getType(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val instanceof Array ? \"array\" : typeof val;\n}','2022-11-16 16:01:23',NULL,0),(2,0,0,0,0,0,0,0,NULL,'isContain','function isContain(curObj, arrKey, valKey) {\n var arr = curObj == null ? null : curObj[arrKey];\n var val = curObj == null ? null : curObj[valKey];\n return arr != null && arr.indexOf(val) >=0;\n}','2022-11-16 16:02:48',NULL,0),(3,0,0,0,0,0,1,0,NULL,'init','var i = 1;\n\"init done \" + i;','2022-11-16 16:41:35',NULL,0),(4,0,0,0,0,0,0,0,NULL,'length','function length(curObj, key) {\n var val = curObj == null ? null : curObj[key];\n return val == null ? 0 : val.length;\n}','2022-11-16 17:18:43',NULL,0),(1670877914051,82001,0,0,0,0,1,1,'执行脚本 2022-12-13 04:44','','function assert(assertion, msg) {\n if (assertion === true) {\n return\n }\n if (msg == null) {\n msg = \'assert failed! assertion = \' + assertion\n }\n\n if (isTest) {\n console.log(msg)\n alert(msg)\n } else {\n throw new Error(msg)\n } \n} \n\nif (isTest) {\n assert(true)\n assert(false)\n assert(true, \'ok\')\n assert(false, \'data.User shoule not be null!\') \n}\n\nfunction getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:45:14',NULL,0),(1670878495619,82001,82002,0,0,0,1,0,'执行脚本 2022-12-13 04:54','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:54:55',NULL,0),(1670878529042,82001,82001,0,0,0,1,1,'执行脚本 2022-12-13 04:55','','function getCurAccount() {\n return App.getCurrentAccount()\n}','2022-12-12 20:55:29',NULL,0),(1670878622401,82001,82003,0,0,0,1,0,'执行脚本 2022-12-13 04:57','','if (isPre) {\n header[\'my-header\'] = \'test\'\n}','2022-12-12 20:57:02',NULL,0),(1670885503909,82001,0,0,0,1657045372046,1,1,'执行脚本 2022-12-13 06:51','','if (isPre) {\n req.User.id = 82005\n}','2022-12-12 22:51:43',NULL,0),(1670887211207,82001,0,0,0,1657045372046,1,0,'执行脚本 2022-12-13 07:20','','','2022-12-12 23:20:11',NULL,0),(1676368454070,82001,0,0,0,1546414192830,1,0,NULL,'casePost1546414192830','','2023-02-14 09:54:14',NULL,0),(1679282174670,82001,0,0,0,0,1,1,NULL,'到店系统查询','','2023-03-20 03:16:14',NULL,0),(1680660620759,82001,0,0,0,1511796155276,1,1,NULL,'casePre1511796155276','if (isPre) {\n console.log(\'test pre script 4 /post/verify\') \n}\n','2024-05-03 03:55:14',NULL,0),(1680660620760,82001,0,1716706529846,42,1511970009072,1,1,NULL,'casePre1511970009072','if (isPre) { console.log(\"test pre script\") }','2024-09-08 16:00:15',NULL,0),(1680660620761,82001,0,1716706529846,42,1511970009072,1,0,NULL,'casePost1511970009072','console.log(\'run post script\')','2024-09-08 16:00:32',NULL,0),(1680660620762,82001,0,1714209723275,2,1546414192830,1,1,NULL,'casePre1546414192830','','2024-11-28 02:10:39',NULL,0),(1738490311550,0,0,0,0,1560244940013,1,0,NULL,'casePost1560244940013','','2025-02-02 09:58:32',NULL,0),(1738490327734,0,0,0,0,0,1,0,NULL,'globalPost0','if (data != null) {\n delete data[\"sql:generate|cache|execute|maxExecute\"]\n}\n','2025-02-02 09:58:48',NULL,0),(1738490404341,0,0,0,0,0,1,1,NULL,'globalPre0','req[\'@explain\'] = true','2025-02-02 10:00:04',NULL,0),(1738490404342,82001,0,0,0,0,1,1,NULL,'','','2025-03-11 08:54:24',NULL,0),(1738490404343,82001,0,0,0,1560737118846,1,0,NULL,'casePost1560737118846','','2025-12-15 05:16:55',NULL,0),(1738490404344,82001,0,0,0,0,1,1,NULL,'globalPre0','function assert(b, msg) { \n if (b) { \n return; \n } function assert(b, msg) { \n if (b) { \n return; \n } \n throw new Error(msg || \'断言失败\'); \n}; \n\nApp.assert = assert;\n throw new Error(msg || \'断言失败\'); \n}; \nApp.assert = assert;','2026-02-13 07:18:02',NULL,0),(1738490404345,82001,0,0,0,1703475322145,1,0,NULL,'casePost1703475322145','var data = data || res.data || {}\nvar methodArgs = data.methodArgs || []; \nvar a = (methodArgs[0] || {}).value; \nvar b = (methodArgs[1] || {}).value;\nApp.assert(data[\'return\'] == Math.pow(a, b), data[\'return\'] + \' != Math.pow(\' + a + \', \' + b + \') = \' + Math.pow(a, b)); // + \'\\n\\n\' + JSON.stringify(data, null, 4));','2026-02-13 07:19:21',NULL,0);

/*!40000 ALTER TABLE `Script` ENABLE KEYS */;