-
Notifications
You must be signed in to change notification settings - Fork 161
/
Copy pathdatabase.sql
180 lines (159 loc) · 14.5 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
create database markov_demo;
use markov_demo;
CREATE TABLE `got_testcase` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`scenario_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'scenario id',
`gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
`gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
`name` longtext COMMENT 'name',
`description` longtext COMMENT 'description',
`long_description` longtext COMMENT '详细描述',
`content` longtext COMMENT '存储case的阶段数据，比如数据准备阶段，数据执行阶段',
`case_group` varchar(100) DEFAULT NULL COMMENT 'case分组',
`is_deleted` int(11) DEFAULT '0' COMMENT '用例是否被删除。0-没有删除；1-已删除，此类case不会展示到页面上',
`case_template` text COMMENT '用例模板 java/c++',
`features` text COMMENT '业务特征',
`is_visible` int DEFAULT '0' COMMENT '是否可见用例',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='testcase';
CREATE TABLE `got_pipeline` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键（id）',
`pipeline` longtext COMMENT 'pipeline的json配置',
`extend` text COMMENT '扩展字段',
`tag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义/自定义\n',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='存储流程执行的pipeline配置文件';
CREATE TABLE `got_scenario` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) DEFAULT NULL COMMENT 'name',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='测试场景表';
CREATE TABLE `got_envs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
`gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
`host_ip` varchar(20) DEFAULT NULL COMMENT 'host_ip',
`status` varchar(20) DEFAULT NULL COMMENT '状态',
`name` varchar(200) DEFAULT NULL COMMENT '环境名称',
`env_detail` text COMMENT '环境详情',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6928 DEFAULT CHARSET=utf8 COMMENT='环境列表';
CREATE TABLE `pipeline_ui` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
`content` text COMMENT 'pipeline_ui的jsonString\n',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='pipeline_ui表';
CREATE TABLE `got_datasource` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键/场景id',
`content` longtext COMMENT '数据源内容',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
PRIMARY KEY (`id`),
KEY `idx_scenario_id` (`scenario_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='测试数据源表';
CREATE TABLE `got_menu` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`content` text COMMENT 'menu的jsonString\n',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='menu表';
insert into got_menu values(0, "{ \"buinfo\": { \"buid\": 1, \"appSecneMap\": { \"1\": \"1\" }, \"menu\": [{ \"businessId\": 1, \"businessName\": \"markov-demo\", \"appMenuList\": [{ \"appName\": \"测试模块\", \"appId\": 1, \"scenarioMenuList\": [{ \"isMember\": true, \"scenarioId\": 1, \"scenarioName\": \"场景1\" },{ \"isMember\": true, \"scenarioId\": 2, \"scenarioName\": \"场景2\" }] }] }, ], \"buName\": \"markov-demo\" }}");
CREATE TABLE `got_reports` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`user` text COMMENT '执行用户',
`report_name` text COMMENT '报告名称',
`status` varchar(100) DEFAULT NULL COMMENT '执行状态',
`message` text COMMENT '信息',
`app_id` bigint(20) unsigned DEFAULT NULL COMMENT 'appid',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
`run_type` text COMMENT '执行方式',
`exec_id` text COMMENT '批次id',
`analysis` text COMMENT '分析报告',
`task_id` text COMMENT 'zk任务id',
`zk_info` longtext COMMENT 'zk信息',
`accuracy_report_id` bigint(20) unsigned DEFAULT NULL COMMENT '精准测试报告id',
`case_num` int(10) unsigned DEFAULT '0' COMMENT '回归用例数',
`image_name` text COMMENT '回归的镜像版本',
`branch_name` text COMMENT '执行用例的分支',
`git_branch` text COMMENT '测试源码的分支',
`git_commit` text COMMENT '测试源码的commit版本',
`cc_cov_rate` text COMMENT '增量代码覆盖率',
`is_visible` int DEFAULT '0' COMMENT '是否可见报告',
PRIMARY KEY (`id`),
KEY `idx_scenarioid` (`scenario_id`),
KEY `idx_appid` (`app_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7858 DEFAULT CHARSET=utf8mb4 COMMENT='回归测试报告表';
CREATE TABLE `got_testcase_snaps` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`scenario_id` bigint(20) unsigned DEFAULT NULL COMMENT '场景id',
`app_id` bigint(20) unsigned DEFAULT NULL COMMENT 'appid',
`name` varchar(100) DEFAULT NULL COMMENT '用例名',
`description` text COMMENT '描述',
`long_description` longtext COMMENT '详情',
`content` longtext COMMENT '输入，输出，期望，数据准备',
`status` varchar(100) DEFAULT NULL COMMENT '用例执行状态',
`testreport_id` bigint(20) unsigned NOT NULL COMMENT '归属的报告id',
`testcase_id` bigint(20) unsigned NOT NULL COMMENT '归属的用例id',
`case_group` varchar(100) DEFAULT NULL COMMENT '测试用例分组',
`tag` varchar(100) DEFAULT NULL COMMENT 'case标签，可有有多个值',
`version` varchar(100) DEFAULT NULL COMMENT 'case版本号',
`run_time` bigint(20) unsigned DEFAULT NULL COMMENT '执行时间',
`run_time_str` text COMMENT '执行时间标准化',
`retry_num` bigint(20) unsigned DEFAULT NULL COMMENT '重试次数',
`constancy` text COMMENT '稳定性',
`env_name` text COMMENT '环境名',
`conflict_desc` text COMMENT '冲突用例描述',
`is_parallel` tinyint(1) DEFAULT NULL COMMENT '是否串行',
`trouble_shoot_box` longtext COMMENT '智能归因',
PRIMARY KEY (`id`),
KEY `idx_caseid` (`testcase_id`),
KEY `idx_reportid` (`testreport_id`)
) ENGINE=InnoDB AUTO_INCREMENT=303953 DEFAULT CHARSET=utf8mb4 COMMENT='测试报告用例集快照'
;
CREATE TABLE `got_features_pool` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`scenario_id` bigint unsigned NULL COMMENT 'scenario_id',
`app_id` bigint unsigned NULL COMMENT 'app_id',
`features` text NULL COMMENT '特征集',
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET=utf8mb4 COMMENT='特征池';
CREATE TABLE `got_case_generate_task` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`creator` text COMMENT '任务创建者',
`seed_case_list` text COMMENT '种子用例id列表，以”,“分隔',
`scenario_id` bigint unsigned DEFAULT NULL COMMENT '场景id',
`env_info` text COMMENT '测试环境信息',
`feature_conf` longtext COMMENT '任务相关配置，jsonObject',
`task_name` text COMMENT '任务名',
`task_snap` longtext COMMENT '任务生成信息',
`task_result` longtext COMMENT '最终生成用例',
`task_status` text COMMENT 'crate 、executing、success or fail ',
`gene_bank_snap` longtext COMMENT 'json格式gene bank',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用例智能生成任务记录表';
CREATE TABLE `got_case_accuracy` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`case_id` bigint unsigned DEFAULT NULL COMMENT 'case id',
`exe_id` bigint unsigned DEFAULT NULL COMMENT '回归执行id',
`cov_line` longtext COMMENT 'case覆盖的代码行，json格式',
`collect_type` text COMMENT 'single : 单case收集；total：任务整体收集',
PRIMARY KEY (`id`),
KEY `idx_caseid` (`case_id`),
KEY `idx_exe_id` (`exe_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='case精准数据覆盖数据记录表';
INSERT INTO `got_testcase` (`gmt_create`,`gmt_modified`,`scenario_id`,`name`,`description`,`long_description`,`content`,`case_group`,`is_deleted`,`case_template`,`is_visible`) VALUES ('2020-04-28 19:12:55','2020-04-28 19:12:55',1,'case名','用例智能生成-种子用例','种子用例','{\"prepareData\":[{\"Tair\":[{\"dsName\":\"table.markovtair.test\",\"data\":[{\"key\":\"testkey\",\"value\":\"testvalue\",\"property\":\"\"}]}]}],\"caseRunStage\":[{\"group_name\":\"ERPC校验（第一组）\",\"data\":[{\"input\":\"{\\n \\\"ad_id\\\": \\\"222\\\",\\n \\\"search_key\\\": \\\"key1\\\",\\n \\\"match_level\\\": 2,\\n \\\"user_type\\\": \\\"type1\\\",\\n \\\"top_num\\\": 10,\\n \\\"use_feature\\\": false,\\n \\\"other1\\\": \\\"1\\\",\\n \\\"other2\\\": \\\"0\\\"\\n}\",\"expect\":\"{\\n \\\"result\\\": \\\"1\\\" \\n}\",\"actual\":\"null\"}]}]}','test',0,'c++',0);
INSERT INTO `got_testcase` (`gmt_create`,`gmt_modified`,`scenario_id`,`name`,`description`,`long_description`,`content`,`case_group`,`is_deleted`,`case_template`,`is_visible`) VALUES ('2020-04-28 19:12:55','2020-04-28 19:12:55',1,'case名','用例智能推荐用例1','普通用例','{\"prepareData\":[{\"Tair\":[{\"dsName\":\"table.markovtair.test\",\"data\":[{\"key\":\"testkey\",\"value\":\"testvalue\",\"property\":\"\"}]}],\"Imock\":[{\"dsName\":\"erpc_merger_inner\",\"data\":[{\"key\":\"key1\",\"value\":\"value1\",\"property\":\"\"},{\"key\":\"key2\",\"value\":\"value2\",\"property\":\"\"}],\"restartFlag\":\"0\"}]}],\"caseRunStage\":[{\"group_name\":\"ERPC校验（第一组）\",\"data\":[{\"input\":\"{\\n \\\"param_manager\\\": {\\n \\\"expand_param\\\": {\\n \\\"key_value_list\\\": [\\n {\\n \\\"key\\\": \\\"feature1\\\",\\n \\\"value\\\": \\\"true\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature2\\\",\\n \\\"value\\\": \\\"3,8;4,16\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature3\\\",\\n \\\"value\\\": \\\"1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature4\\\",\\n \\\"value\\\": \\\"one_phase_model_searching,200,166,1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature5\\\",\\n \\\"value\\\": \\\"false\\\"\\n }\\n ]\\n }\\n }\\n}\",\"expect\":\"{\\n \\\"result\\\": \\\"1\\\"\\n}\",\"actual\":\"null\"}]}]}','猜你喜欢',0,'c++',0);
INSERT INTO `got_testcase` (`gmt_create`,`gmt_modified`,`scenario_id`,`name`,`description`,`long_description`,`content`,`case_group`,`is_deleted`,`case_template`,`is_visible`) VALUES ('2020-04-28 19:12:55','2020-04-28 19:12:55',1,'case名','用例智能推荐用例2','普通用例','{\"prepareData\":[{\"Tair\":[{\"dsName\":\"table.markovtair.test\",\"data\":[{\"key\":\"testkey\",\"value\":\"testvalue\",\"property\":\"\"}]}],\"Imock\":[{\"dsName\":\"erpc_merger_inner\",\"data\":[{\"key\":\"key1\",\"value\":\"confict-value\",\"property\":\"\"},{\"key\":\"key2\",\"value\":\"value2\",\"property\":\"\"}]}]}],\"caseRunStage\":[{\"group_name\":\"ERPC校验（第一组）\",\"data\":[{\"input\":\"{\\n \\\"param_manager\\\": {\\n \\\"expand_param\\\": {\\n \\\"key_value_list\\\": [\\n {\\n \\\"key\\\": \\\"feature1\\\",\\n \\\"value\\\": \\\"true\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature2\\\",\\n \\\"value\\\": \\\"3,8;4,16\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature3\\\",\\n \\\"value\\\": \\\"1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature4\\\",\\n \\\"value\\\": \\\"one_phase_model_searching,200,166,1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature5\\\",\\n \\\"value\\\": \\\"false\\\"\\n }\\n ]\\n }\\n }\\n}\",\"expect\":\"{\\n \\\"result\\\": \\\"1\\\"\\n}\"}]}]}','购物车',0,'c++',0);
INSERT INTO `got_testcase` (`gmt_create`,`gmt_modified`,`scenario_id`,`name`,`description`,`long_description`,`content`,`case_group`,`is_deleted`,`case_template`,`is_visible`) VALUES ('2020-04-28 19:12:55','2020-04-28 19:12:55',1,'case名','用例智能推荐用例3','普通用例','{\"prepareData\":[{\"Tair\":[{\"dsName\":\"table.markovtair.test\",\"data\":[{\"key\":\"testkey\",\"value\":\"testvalue\",\"property\":\"\"}]}],\"Imock\":[{\"dsName\":\"erpc_merger_inner\",\"data\":[{\"key\":\"key1\",\"value\":\"value1\",\"property\":\"\"},{\"key\":\"key3\",\"value\":\"value3\",\"property\":\"\"}]}]}],\"caseRunStage\":[{\"group_name\":\"ERPC校验（第一组）\",\"data\":[{\"input\":\"{\\n \\\"param_manager\\\": {\\n \\\"expand_param\\\": {\\n \\\"key_value_list\\\": [\\n {\\n \\\"key\\\": \\\"feature1\\\",\\n \\\"value\\\": \\\"true\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature2\\\",\\n \\\"value\\\": \\\"3,8;4,16\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature3\\\",\\n \\\"value\\\": \\\"1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature4\\\",\\n \\\"value\\\": \\\"one_phase_model_searching,200,166,1\\\"\\n },\\n {\\n \\\"key\\\": \\\"feature5\\\",\\n \\\"value\\\": \\\"false\\\"\\n }\\n ]\\n }\\n }\\n}\",\"expect\":\"{\\n \\\"result\\\": \\\"1\\\"\\n}\"}]}]}','直播',0,'c++',0);
INSERT INTO `got_envs` (`gmt_create`,`gmt_modified`,`scenario_id`,`name`,`status`,`host_ip`,`env_detail`) VALUES ('2020-04-28 19:12:55','2020-04-28 19:12:55',1,'初始测试环境','SUCCESS','11.167.254.210','123');