-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathapi_db_2023-04-19.sql
More file actions
217 lines (165 loc) · 33.7 KB
/
api_db_2023-04-19.sql
File metadata and controls
217 lines (165 loc) · 33.7 KB
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
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.39)
# Database: api_db
# Generation Time: 2023-04-19 05:25:13 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table api_sample_response
# ------------------------------------------------------------
DROP TABLE IF EXISTS `api_sample_response`;
CREATE TABLE `api_sample_response` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`test_case_name` varchar(255) NOT NULL DEFAULT '',
`endpoint_URL` text NOT NULL,
`request` longtext NOT NULL,
`response` longtext NOT NULL,
`json_response` json DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `api_sample_response` WRITE;
/*!40000 ALTER TABLE `api_sample_response` DISABLE KEYS */;
INSERT INTO `api_sample_response` (`id`, `test_case_name`, `endpoint_URL`, `request`, `response`, `json_response`)
VALUES
(1,'Test','https://dog.ceo/api/breeds/list/all','','{\"message\":{\"affenpinscher\":[],\"african\":[],\"airedale\":[],\"akita\":[],\"appenzeller\":[],\"australian\":[\"shepherd\"],\"basenji\":[],\"beagle\":[],\"bluetick\":[],\"borzoi\":[],\"bouvier\":[],\"boxer\":[],\"brabancon\":[],\"briard\":[],\"buhund\":[\"norwegian\"],\"bulldog\":[\"boston\",\"english\",\"french\"],\"bullterrier\":[\"staffordshire\"],\"cattledog\":[\"australian\"],\"chihuahua\":[],\"chow\":[],\"clumber\":[],\"cockapoo\":[],\"collie\":[\"border\"],\"coonhound\":[],\"corgi\":[\"cardigan\"],\"cotondetulear\":[],\"dachshund\":[],\"dalmatian\":[],\"dane\":[\"great\"],\"deerhound\":[\"scottish\"],\"dhole\":[],\"dingo\":[],\"doberman\":[],\"elkhound\":[\"norwegian\"],\"entlebucher\":[],\"eskimo\":[],\"finnish\":[\"lapphund\"],\"frise\":[\"bichon\"],\"germanshepherd\":[],\"greyhound\":[\"italian\"],\"groenendael\":[],\"havanese\":[],\"hound\":[\"afghan\",\"basset\",\"blood\",\"english\",\"ibizan\",\"plott\",\"walker\"],\"husky\":[],\"keeshond\":[],\"kelpie\":[],\"komondor\":[],\"kuvasz\":[],\"labradoodle\":[],\"labrador\":[],\"leonberg\":[],\"lhasa\":[],\"malamute\":[],\"malinois\":[],\"maltese\":[],\"mastiff\":[\"bull\",\"english\",\"tibetan\"],\"mexicanhairless\":[],\"mix\":[],\"mountain\":[\"bernese\",\"swiss\"],\"newfoundland\":[],\"otterhound\":[],\"ovcharka\":[\"caucasian\"],\"papillon\":[],\"pekinese\":[],\"pembroke\":[],\"pinscher\":[\"miniature\"],\"pitbull\":[],\"pointer\":[\"german\",\"germanlonghair\"],\"pomeranian\":[],\"poodle\":[\"medium\",\"miniature\",\"standard\",\"toy\"],\"pug\":[],\"puggle\":[],\"pyrenees\":[],\"redbone\":[],\"retriever\":[\"chesapeake\",\"curly\",\"flatcoated\",\"golden\"],\"ridgeback\":[\"rhodesian\"],\"rottweiler\":[],\"saluki\":[],\"samoyed\":[],\"schipperke\":[],\"schnauzer\":[\"giant\",\"miniature\"],\"segugio\":[\"italian\"],\"setter\":[\"english\",\"gordon\",\"irish\"],\"sharpei\":[],\"sheepdog\":[\"english\",\"shetland\"],\"shiba\":[],\"shihtzu\":[],\"spaniel\":[\"blenheim\",\"brittany\",\"cocker\",\"irish\",\"japanese\",\"sussex\",\"welsh\"],\"spitz\":[\"japanese\"],\"springer\":[\"english\"],\"stbernard\":[],\"terrier\":[\"american\",\"australian\",\"bedlington\",\"border\",\"cairn\",\"dandie\",\"fox\",\"irish\",\"kerryblue\",\"lakeland\",\"norfolk\",\"norwich\",\"patterdale\",\"russell\",\"scottish\",\"sealyham\",\"silky\",\"tibetan\",\"toy\",\"welsh\",\"westhighland\",\"wheaten\",\"yorkshire\"],\"tervuren\":[],\"vizsla\":[],\"waterdog\":[\"spanish\"],\"weimaraner\":[],\"whippet\":[],\"wolfhound\":[\"irish\"]},\"status\":\"success\"}',NULL),
(2,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(3,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(4,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(5,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(6,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(7,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(8,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(9,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL),
(10,'Test2','https://dev2.fincent.com/api/v1/users/profile','','{\"status\":\"success\",\"message\":\"Found loggedin User\",\"data\":{\"id\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"guid\":\"cab413ca-9294-48e7-9b8d-7a2052007462\",\"email\":\"nivedita+rick@fincent.com\",\"isEmailVerified\":true,\"auth0Id\":\"auth0|635b69e2f86b19285f1e2026\",\"firstName\":\"Rick\",\"lastName\":\"Riordan\",\"phone\":\"\",\"registeredAs\":\"BO\",\"superAdmin\":false,\"communicationsEmail\":null,\"firstRun\":false,\"avatar\":\"\",\"lastPasswordResetTS\":\"2022-10-28T05:34:41.512Z\",\"createdAt\":\"2022-10-28T05:34:58.242Z\",\"updatedAt\":\"2023-01-30T05:16:13.492Z\",\"bookkeeperAdmin\":false}}',NULL);
/*!40000 ALTER TABLE `api_sample_response` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table api_test_data_main
# ------------------------------------------------------------
DROP TABLE IF EXISTS `api_test_data_main`;
CREATE TABLE `api_test_data_main` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`endpoint_url` varchar(255) DEFAULT NULL,
`method_type` varchar(11) DEFAULT NULL,
`json_request` json DEFAULT NULL,
`expected_response` longtext,
`wsdl_path` varchar(255) DEFAULT NULL,
`webservice_type` varchar(255) DEFAULT NULL,
`header_key` varchar(255) DEFAULT NULL,
`component_name` varchar(255) DEFAULT NULL,
`test_case_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `api_test_data_main` WRITE;
/*!40000 ALTER TABLE `api_test_data_main` DISABLE KEYS */;
INSERT INTO `api_test_data_main` (`id`, `endpoint_url`, `method_type`, `json_request`, `expected_response`, `wsdl_path`, `webservice_type`, `header_key`, `component_name`, `test_case_name`)
VALUES
(1,'/api/breeds/list/all','get',NULL,'\"message\":{\"affenpinscher\":[],\"african\":[],\"airedale\":[],\"akita\":[],\"appenzeller\":[],\"australian\":[\"shepherd\"],\"basenji\":[],\"beagle\":[],\"bluetick\":[],\"borzoi\":[],\"bouvier\":[],\"boxer\":[],\"brabancon\":[],\"briard\":[],\"buhund\":[\"norwegian\"],\"bulldog\":[\"boston\",\"english\",\"french\"],\"bullterrier\":[\"staffordshire\"],\"cattledog\":[\"australian\"],\"chihuahua\":[],\"chow\":[],\"clumber\":[],\"cockapoo\":[],\"collie\":[\"border\"],\"coonhound\":[],\"corgi\":[\"cardigan\"],\"cotondetulear\":[],\"dachshund\":[],\"dalmatian\":[],\"dane\":[\"great\"],\"deerhound\":[\"scottish\"],\"dhole\":[],\"dingo\":[],\"doberman\":[],\"elkhound\":[\"norwegian\"],\"entlebucher\":[],\"eskimo\":[],\"finnish\":[\"lapphund\"],\"frise\":[\"bichon\"],\"germanshepherd\":[],\"greyhound\":[\"italian\"],\"groenendael\":[],\"havanese\":[],\"hound\":[\"afghan\",\"basset\",\"blood\",\"english\",\"ibizan\",\"plott\",\"walker\"],\"husky\":[],\"keeshond\":[],\"kelpie\":[],\"komondor\":[],\"kuvasz\":[],\"labradoodle\":[],\"labrador\":[],\"leonberg\":[],\"lhasa\":[],\"malamute\":[],\"malinois\":[],\"maltese\":[],\"mastiff\":[\"bull\",\"english\",\"tibetan\"],\"mexicanhairless\":[],\"mix\":[],\"mountain\":[\"bernese\",\"swiss\"],\"newfoundland\":[],\"otterhound\":[],\"ovcharka\":[\"caucasian\"],\"papillon\":[],\"pekinese\":[],\"pembroke\":[],\"pinscher\":[\"miniature\"],\"pitbull\":[],\"pointer\":[\"german\",\"germanlonghair\"],\"pomeranian\":[],\"poodle\":[\"medium\",\"miniature\",\"standard\",\"toy\"],\"pug\":[],\"puggle\":[],\"pyrenees\":[],\"redbone\":[],\"retriever\":[\"chesapeake\",\"curly\",\"flatcoated\",\"golden\"],\"ridgeback\":[\"rhodesian\"],\"rottweiler\":[],\"saluki\":[],\"samoyed\":[],\"schipperke\":[],\"schnauzer\":[\"giant\",\"miniature\"],\"segugio\":[\"italian\"],\"setter\":[\"english\",\"gordon\",\"irish\"],\"sharpei\":[],\"sheepdog\":[\"english\",\"shetland\"],\"shiba\":[],\"shihtzu\":[],\"spaniel\":[\"blenheim\",\"brittany\",\"cocker\",\"irish\",\"japanese\",\"sussex\",\"welsh\"],\"spitz\":[\"japanese\"],\"springer\":[\"english\"],\"stbernard\":[],\"terrier\":[\"american\",\"australian\",\"bedlington\",\"border\",\"cairn\",\"dandie\",\"fox\",\"irish\",\"kerryblue\",\"lakeland\",\"norfolk\",\"norwich\",\"patterdale\",\"russell\",\"scottish\",\"sealyham\",\"silky\",\"tibetan\",\"toy\",\"welsh\",\"westhighland\",\"wheaten\",\"yorkshire\"],\"tervuren\":[],\"vizsla\":[],\"waterdog\":[\"spanish\"],\"weimaraner\":[],\"whippet\":[],\"wolfhound\":[\"irish\"]',NULL,'REST','Test1','Sample','Test'),
(2,'/api/v1/users/profile','get',NULL,'',NULL,'REST','Fincent','Fincent','Test2');
/*!40000 ALTER TABLE `api_test_data_main` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table checksum_data
# ------------------------------------------------------------
DROP TABLE IF EXISTS `checksum_data`;
CREATE TABLE `checksum_data` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`tag_names` varchar(255) DEFAULT NULL,
`tag_values` longtext,
`api_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table comp_base_url
# ------------------------------------------------------------
DROP TABLE IF EXISTS `comp_base_url`;
CREATE TABLE `comp_base_url` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`component_name` varchar(255) DEFAULT NULL,
`base_url` varchar(255) DEFAULT NULL,
`environment` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `comp_base_url` WRITE;
/*!40000 ALTER TABLE `comp_base_url` DISABLE KEYS */;
INSERT INTO `comp_base_url` (`id`, `component_name`, `base_url`, `environment`)
VALUES
(1,'Sample','https://dog.ceo','Dev'),
(2,'Fincent','https://dev2.fincent.com','Dev');
/*!40000 ALTER TABLE `comp_base_url` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table expected_param_values
# ------------------------------------------------------------
DROP TABLE IF EXISTS `expected_param_values`;
CREATE TABLE `expected_param_values` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`test_case_name` varchar(255) DEFAULT NULL,
`param_name` varchar(255) DEFAULT NULL,
`value` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `expected_param_values` WRITE;
/*!40000 ALTER TABLE `expected_param_values` DISABLE KEYS */;
INSERT INTO `expected_param_values` (`id`, `test_case_name`, `param_name`, `value`)
VALUES
(1,'Test','message_waterdog','[\"spanish\"]'),
(2,'Test','message_poodle','[\"medium\",\"miniature\",\"standard\",\"toy\"]'),
(3,'Test2','message_message','Found loggedin User'),
(4,'Test2','data_email','nivedita+rick@fincent.com1');
/*!40000 ALTER TABLE `expected_param_values` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table headers
# ------------------------------------------------------------
DROP TABLE IF EXISTS `headers`;
CREATE TABLE `headers` (
`id` int(11) NOT NULL,
`header_name` varchar(255) DEFAULT NULL,
`header_value` longtext,
`header_key` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `headers` WRITE;
/*!40000 ALTER TABLE `headers` DISABLE KEYS */;
INSERT INTO `headers` (`id`, `header_name`, `header_value`, `header_key`)
VALUES
(1,'Content-Type','application/json','Test1'),
(2,'Authorization','Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlU4RHNHSmZXTmc4OVJWOC1yNERPeSJ9.eyJodHRwczovL2ZpbmNlbnQuY29tL21hcGkvZW1haWwiOiJuaXZlZGl0YStyaWNrQGZpbmNlbnQuY29tIiwiaXNzIjoiaHR0cHM6Ly9kZXYtZGMudXMuYXV0aDAuY29tLyIsInN1YiI6ImF1dGgwfDYzNWI2OWUyZjg2YjE5Mjg1ZjFlMjAyNiIsImF1ZCI6WyJodHRwczovL2RldjIuZmluY2VudC5jb20vbWFwaS92MS8iLCJodHRwczovL2Rldi1kYy51cy5hdXRoMC5jb20vdXNlcmluZm8iXSwiaWF0IjoxNjgxNzQxMTc2LCJleHAiOjE2ODE4Mjc1NzYsImF6cCI6IlpVQ3dBdVJObFllaldaT25VdnRzckZITDc0WXJVeU00Iiwic2NvcGUiOiJvcGVuaWQgcHJvZmlsZSBlbWFpbCBvZmZsaW5lX2FjY2VzcyJ9.MgQD1QWCUnf0KDABloc-cheOe-9o_veHCmC-SvK-00Wzlbd7zAm7KRFHPu980eFjPF9pDa_qrorY9YZr1FcxyFjen1A07tU0nuTSfDKqh2NIptBA_NNno99b8DyuRQwFTG0hNpGUiNZh2UtTRWDO8Rfdt2RzczdgHgW_sQgCQYbFx21eclf50eEpyP7awnMYCOaaiBbTn7LfJkBB483NJJI3Q5-JXHuYCv1YZmEjYgaSVuDhts8hxeWqPuec2lRlOhZvY3WXTZr46p3MumgLOP5m_qKbN5Eux5upc5jLarUDPc4KeN60z_0b8MHqxs04R485IWwutBde5UhtT2efTA','Test2'),
(3,'Cookie',' connect.sid=s%3AENPS1V1xtU7iyciotH43XrOeZ0uMqFm3.EmKVBYBKoWHLyKRKlYf22oshXuFA1D9MgHO1FIwWcco','Fincent'),
(4,'Content-Type','application/json','Fincent'),
(2,'Authorization','Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6IlU4RHNHSmZXTmc4OVJWOC1yNERPeSJ9.eyJodHRwczovL2ZpbmNlbnQuY29tL21hcGkvZW1haWwiOiJuaXZlZGl0YStyaWNrQGZpbmNlbnQuY29tIiwiaXNzIjoiaHR0cHM6Ly9kZXYtZGMudXMuYXV0aDAuY29tLyIsInN1YiI6ImF1dGgwfDYzNWI2OWUyZjg2YjE5Mjg1ZjFlMjAyNiIsImF1ZCI6WyJodHRwczovL2RldjIuZmluY2VudC5jb20vbWFwaS92MS8iLCJodHRwczovL2Rldi1kYy51cy5hdXRoMC5jb20vdXNlcmluZm8iXSwiaWF0IjoxNjgxNzQxMTc2LCJleHAiOjE2ODE4Mjc1NzYsImF6cCI6IlpVQ3dBdVJObFllaldaT25VdnRzckZITDc0WXJVeU00Iiwic2NvcGUiOiJvcGVuaWQgcHJvZmlsZSBlbWFpbCBvZmZsaW5lX2FjY2VzcyJ9.MgQD1QWCUnf0KDABloc-cheOe-9o_veHCmC-SvK-00Wzlbd7zAm7KRFHPu980eFjPF9pDa_qrorY9YZr1FcxyFjen1A07tU0nuTSfDKqh2NIptBA_NNno99b8DyuRQwFTG0hNpGUiNZh2UtTRWDO8Rfdt2RzczdgHgW_sQgCQYbFx21eclf50eEpyP7awnMYCOaaiBbTn7LfJkBB483NJJI3Q5-JXHuYCv1YZmEjYgaSVuDhts8hxeWqPuec2lRlOhZvY3WXTZr46p3MumgLOP5m_qKbN5Eux5upc5jLarUDPc4KeN60z_0b8MHqxs04R485IWwutBde5UhtT2efTA','Fincent');
/*!40000 ALTER TABLE `headers` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table test_logs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `test_logs`;
CREATE TABLE `test_logs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`test_case_name` varchar(255) DEFAULT NULL,
`endpoint_url` text,
`request` longtext,
`response` json DEFAULT NULL,
`timestamp` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `test_logs` WRITE;
/*!40000 ALTER TABLE `test_logs` DISABLE KEYS */;
INSERT INTO `test_logs` (`id`, `test_case_name`, `endpoint_url`, `request`, `response`, `timestamp`)
VALUES
(1,'Test','https://dog.ceo/api/breeds/list/all','',X'7B22737461747573223A202273756363657373222C20226D657373616765223A207B226D6978223A205B5D2C2022707567223A205B5D2C202263686F77223A205B5D2C202264616E65223A205B226772656174225D2C2022616B697461223A205B5D2C2022626F786572223A205B5D2C2022636F726769223A205B22636172646967616E225D2C202264686F6C65223A205B5D2C202264696E676F223A205B5D2C20226672697365223A205B22626963686F6E225D2C2022686F756E64223A205B2261666768616E222C2022626173736574222C2022626C6F6F64222C2022656E676C697368222C20226962697A616E222C2022706C6F7474222C202277616C6B6572225D2C20226875736B79223A205B5D2C20226C68617361223A205B5D2C20227368696261223A205B5D2C2022737069747A223A205B226A6170616E657365225D2C2022626561676C65223A205B5D2C2022626F727A6F69223A205B5D2C2022627269617264223A205B5D2C2022627568756E64223A205B226E6F7277656769616E225D2C2022636F6C6C6965223A205B22626F72646572225D2C202265736B696D6F223A205B5D2C20226B656C706965223A205B5D2C20226B757661737A223A205B5D2C2022706F6F646C65223A205B226D656469756D222C20226D696E696174757265222C20227374616E64617264222C2022746F79225D2C2022707567676C65223A205B5D2C202273616C756B69223A205B5D2C2022736574746572223A205B22656E676C697368222C2022676F72646F6E222C20226972697368225D2C202276697A736C61223A205B5D2C20226166726963616E223A205B5D2C2022626173656E6A69223A205B5D2C2022626F7576696572223A205B5D2C202262756C6C646F67223A205B22626F73746F6E222C2022656E676C697368222C20226672656E6368225D2C2022636C756D626572223A205B5D2C202266696E6E697368223A205B226C61707068756E64225D2C20226D616C74657365223A205B5D2C20226D617374696666223A205B2262756C6C222C2022656E676C697368222C20227469626574616E225D2C202270697462756C6C223A205B5D2C2022706F696E746572223A205B226765726D616E222C20226765726D616E6C6F6E6768616972225D2C2022726564626F6E65223A205B5D2C202273616D6F796564223A205B5D2C20227365677567696F223A205B226974616C69616E225D2C202273686172706569223A205B5D2C202273686968747A75223A205B5D2C20227370616E69656C223A205B22626C656E6865696D222C20226272697474616E79222C2022636F636B6572222C20226972697368222C20226A6170616E657365222C2022737573736578222C202277656C7368225D2C202274657272696572223A205B22616D65726963616E222C20226175737472616C69616E222C20226265646C696E67746F6E222C2022626F72646572222C2022636169726E222C202264616E646965222C2022666F78222C20226972697368222C20226B65727279626C7565222C20226C616B656C616E64222C20226E6F72666F6C6B222C20226E6F7277696368222C202270617474657264616C65222C202272757373656C6C222C202273636F7474697368222C20227365616C7968616D222C202273696C6B79222C20227469626574616E222C2022746F79222C202277656C7368222C202277657374686967686C616E64222C20227768656174656E222C2022796F726B7368697265225D2C202277686970706574223A205B5D2C20226169726564616C65223A205B5D2C2022626C75657469636B223A205B5D2C2022636F636B61706F6F223A205B5D2C2022646F6265726D616E223A205B5D2C2022656C6B686F756E64223A205B226E6F7277656769616E225D2C2022686176616E657365223A205B5D2C20226B656573686F6E64223A205B5D2C20226B6F6D6F6E646F72223A205B5D2C20226C61627261646F72223A205B5D2C20226C656F6E62657267223A205B5D2C20226D616C616D757465223A205B5D2C20226D616C696E6F6973223A205B5D2C20226D6F756E7461696E223A205B226265726E657365222C20227377697373225D2C20226F76636861726B61223A205B2263617563617369616E225D2C2022706170696C6C6F6E223A205B5D2C202270656B696E657365223A205B5D2C202270656D62726F6B65223A205B5D2C202270696E7363686572223A205B226D696E696174757265225D2C2022707972656E656573223A205B5D2C20227368656570646F67223A205B22656E676C697368222C2022736865746C616E64225D2C2022737072696E676572223A205B22656E676C697368225D2C2022746572767572656E223A205B5D2C20227761746572646F67223A205B227370616E697368225D2C202262726162616E636F6E223A205B5D2C2022636174746C65646F67223A205B226175737472616C69616E225D2C2022636869687561687561223A205B5D2C2022636F6F6E686F756E64223A205B5D2C2022646163687368756E64223A205B5D2C202264616C6D617469616E223A205B5D2C202264656572686F756E64223A205B2273636F7474697368225D2C202267726579686F756E64223A205B226974616C69616E225D2C2022726574726965766572223A205B2263686573617065616B65222C20226375726C79222C2022666C6174636F61746564222C2022676F6C64656E225D2C202272696467656261636B223A205B2272686F64657369616E225D2C20227363686E61757A6572223A205B226769616E74222C20226D696E696174757265225D2C202273746265726E617264223A205B5D2C2022776F6C66686F756E64223A205B226972697368225D2C20226175737472616C69616E223A205B227368657068657264225D2C20226F74746572686F756E64223A205B5D2C2022706F6D6572616E69616E223A205B5D2C2022726F74747765696C6572223A205B5D2C202273636869707065726B65223A205B5D2C20227765696D6172616E6572223A205B5D2C2022617070656E7A656C6C6572223A205B5D2C202262756C6C74657272696572223A205B2273746166666F72647368697265225D2C2022656E746C65627563686572223A205B5D2C202267726F656E656E6461656C223A205B5D2C20226C61627261646F6F646C65223A205B5D2C20226E6577666F756E646C616E64223A205B5D2C2022616666656E70696E7363686572223A205B5D2C2022636F746F6E646574756C656172223A205B5D2C20226765726D616E7368657068657264223A205B5D2C20226D65786963616E686169726C657373223A205B5D7D7D','2023-04-13 10:50:33'),
(2,'Test','https://dog.ceo/api/breeds/list/all','',X'7B22737461747573223A202273756363657373222C20226D657373616765223A207B226D6978223A205B5D2C2022707567223A205B5D2C202263686F77223A205B5D2C202264616E65223A205B226772656174225D2C2022616B697461223A205B5D2C2022626F786572223A205B5D2C2022636F726769223A205B22636172646967616E225D2C202264686F6C65223A205B5D2C202264696E676F223A205B5D2C20226672697365223A205B22626963686F6E225D2C2022686F756E64223A205B2261666768616E222C2022626173736574222C2022626C6F6F64222C2022656E676C697368222C20226962697A616E222C2022706C6F7474222C202277616C6B6572225D2C20226875736B79223A205B5D2C20226C68617361223A205B5D2C20227368696261223A205B5D2C2022737069747A223A205B226A6170616E657365225D2C2022626561676C65223A205B5D2C2022626F727A6F69223A205B5D2C2022627269617264223A205B5D2C2022627568756E64223A205B226E6F7277656769616E225D2C2022636F6C6C6965223A205B22626F72646572225D2C202265736B696D6F223A205B5D2C20226B656C706965223A205B5D2C20226B757661737A223A205B5D2C2022706F6F646C65223A205B226D656469756D222C20226D696E696174757265222C20227374616E64617264222C2022746F79225D2C2022707567676C65223A205B5D2C202273616C756B69223A205B5D2C2022736574746572223A205B22656E676C697368222C2022676F72646F6E222C20226972697368225D2C202276697A736C61223A205B5D2C20226166726963616E223A205B5D2C2022626173656E6A69223A205B5D2C2022626F7576696572223A205B5D2C202262756C6C646F67223A205B22626F73746F6E222C2022656E676C697368222C20226672656E6368225D2C2022636C756D626572223A205B5D2C202266696E6E697368223A205B226C61707068756E64225D2C20226D616C74657365223A205B5D2C20226D617374696666223A205B2262756C6C222C2022656E676C697368222C20227469626574616E225D2C202270697462756C6C223A205B5D2C2022706F696E746572223A205B226765726D616E222C20226765726D616E6C6F6E6768616972225D2C2022726564626F6E65223A205B5D2C202273616D6F796564223A205B5D2C20227365677567696F223A205B226974616C69616E225D2C202273686172706569223A205B5D2C202273686968747A75223A205B5D2C20227370616E69656C223A205B22626C656E6865696D222C20226272697474616E79222C2022636F636B6572222C20226972697368222C20226A6170616E657365222C2022737573736578222C202277656C7368225D2C202274657272696572223A205B22616D65726963616E222C20226175737472616C69616E222C20226265646C696E67746F6E222C2022626F72646572222C2022636169726E222C202264616E646965222C2022666F78222C20226972697368222C20226B65727279626C7565222C20226C616B656C616E64222C20226E6F72666F6C6B222C20226E6F7277696368222C202270617474657264616C65222C202272757373656C6C222C202273636F7474697368222C20227365616C7968616D222C202273696C6B79222C20227469626574616E222C2022746F79222C202277656C7368222C202277657374686967686C616E64222C20227768656174656E222C2022796F726B7368697265225D2C202277686970706574223A205B5D2C20226169726564616C65223A205B5D2C2022626C75657469636B223A205B5D2C2022636F636B61706F6F223A205B5D2C2022646F6265726D616E223A205B5D2C2022656C6B686F756E64223A205B226E6F7277656769616E225D2C2022686176616E657365223A205B5D2C20226B656573686F6E64223A205B5D2C20226B6F6D6F6E646F72223A205B5D2C20226C61627261646F72223A205B5D2C20226C656F6E62657267223A205B5D2C20226D616C616D757465223A205B5D2C20226D616C696E6F6973223A205B5D2C20226D6F756E7461696E223A205B226265726E657365222C20227377697373225D2C20226F76636861726B61223A205B2263617563617369616E225D2C2022706170696C6C6F6E223A205B5D2C202270656B696E657365223A205B5D2C202270656D62726F6B65223A205B5D2C202270696E7363686572223A205B226D696E696174757265225D2C2022707972656E656573223A205B5D2C20227368656570646F67223A205B22656E676C697368222C2022736865746C616E64225D2C2022737072696E676572223A205B22656E676C697368225D2C2022746572767572656E223A205B5D2C20227761746572646F67223A205B227370616E697368225D2C202262726162616E636F6E223A205B5D2C2022636174746C65646F67223A205B226175737472616C69616E225D2C2022636869687561687561223A205B5D2C2022636F6F6E686F756E64223A205B5D2C2022646163687368756E64223A205B5D2C202264616C6D617469616E223A205B5D2C202264656572686F756E64223A205B2273636F7474697368225D2C202267726579686F756E64223A205B226974616C69616E225D2C2022726574726965766572223A205B2263686573617065616B65222C20226375726C79222C2022666C6174636F61746564222C2022676F6C64656E225D2C202272696467656261636B223A205B2272686F64657369616E225D2C20227363686E61757A6572223A205B226769616E74222C20226D696E696174757265225D2C202273746265726E617264223A205B5D2C2022776F6C66686F756E64223A205B226972697368225D2C20226175737472616C69616E223A205B227368657068657264225D2C20226F74746572686F756E64223A205B5D2C2022706F6D6572616E69616E223A205B5D2C2022726F74747765696C6572223A205B5D2C202273636869707065726B65223A205B5D2C20227765696D6172616E6572223A205B5D2C2022617070656E7A656C6C6572223A205B5D2C202262756C6C74657272696572223A205B2273746166666F72647368697265225D2C2022656E746C65627563686572223A205B5D2C202267726F656E656E6461656C223A205B5D2C20226C61627261646F6F646C65223A205B5D2C20226E6577666F756E646C616E64223A205B5D2C2022616666656E70696E7363686572223A205B5D2C2022636F746F6E646574756C656172223A205B5D2C20226765726D616E7368657068657264223A205B5D2C20226D65786963616E686169726C657373223A205B5D7D7D','2023-04-13 10:53:39'),
(3,'Test','https://dog.ceo/api/breeds/list/all','',X'7B22737461747573223A202273756363657373222C20226D657373616765223A207B226D6978223A205B5D2C2022707567223A205B5D2C202263686F77223A205B5D2C202264616E65223A205B226772656174225D2C2022616B697461223A205B5D2C2022626F786572223A205B5D2C2022636F726769223A205B22636172646967616E225D2C202264686F6C65223A205B5D2C202264696E676F223A205B5D2C20226672697365223A205B22626963686F6E225D2C2022686F756E64223A205B2261666768616E222C2022626173736574222C2022626C6F6F64222C2022656E676C697368222C20226962697A616E222C2022706C6F7474222C202277616C6B6572225D2C20226875736B79223A205B5D2C20226C68617361223A205B5D2C20227368696261223A205B5D2C2022737069747A223A205B226A6170616E657365225D2C2022626561676C65223A205B5D2C2022626F727A6F69223A205B5D2C2022627269617264223A205B5D2C2022627568756E64223A205B226E6F7277656769616E225D2C2022636F6C6C6965223A205B22626F72646572225D2C202265736B696D6F223A205B5D2C20226B656C706965223A205B5D2C20226B757661737A223A205B5D2C2022706F6F646C65223A205B226D656469756D222C20226D696E696174757265222C20227374616E64617264222C2022746F79225D2C2022707567676C65223A205B5D2C202273616C756B69223A205B5D2C2022736574746572223A205B22656E676C697368222C2022676F72646F6E222C20226972697368225D2C202276697A736C61223A205B5D2C20226166726963616E223A205B5D2C2022626173656E6A69223A205B5D2C2022626F7576696572223A205B5D2C202262756C6C646F67223A205B22626F73746F6E222C2022656E676C697368222C20226672656E6368225D2C2022636C756D626572223A205B5D2C202266696E6E697368223A205B226C61707068756E64225D2C20226D616C74657365223A205B5D2C20226D617374696666223A205B2262756C6C222C2022656E676C697368222C20227469626574616E225D2C202270697462756C6C223A205B5D2C2022706F696E746572223A205B226765726D616E222C20226765726D616E6C6F6E6768616972225D2C2022726564626F6E65223A205B5D2C202273616D6F796564223A205B5D2C20227365677567696F223A205B226974616C69616E225D2C202273686172706569223A205B5D2C202273686968747A75223A205B5D2C20227370616E69656C223A205B22626C656E6865696D222C20226272697474616E79222C2022636F636B6572222C20226972697368222C20226A6170616E657365222C2022737573736578222C202277656C7368225D2C202274657272696572223A205B22616D65726963616E222C20226175737472616C69616E222C20226265646C696E67746F6E222C2022626F72646572222C2022636169726E222C202264616E646965222C2022666F78222C20226972697368222C20226B65727279626C7565222C20226C616B656C616E64222C20226E6F72666F6C6B222C20226E6F7277696368222C202270617474657264616C65222C202272757373656C6C222C202273636F7474697368222C20227365616C7968616D222C202273696C6B79222C20227469626574616E222C2022746F79222C202277656C7368222C202277657374686967686C616E64222C20227768656174656E222C2022796F726B7368697265225D2C202277686970706574223A205B5D2C20226169726564616C65223A205B5D2C2022626C75657469636B223A205B5D2C2022636F636B61706F6F223A205B5D2C2022646F6265726D616E223A205B5D2C2022656C6B686F756E64223A205B226E6F7277656769616E225D2C2022686176616E657365223A205B5D2C20226B656573686F6E64223A205B5D2C20226B6F6D6F6E646F72223A205B5D2C20226C61627261646F72223A205B5D2C20226C656F6E62657267223A205B5D2C20226D616C616D757465223A205B5D2C20226D616C696E6F6973223A205B5D2C20226D6F756E7461696E223A205B226265726E657365222C20227377697373225D2C20226F76636861726B61223A205B2263617563617369616E225D2C2022706170696C6C6F6E223A205B5D2C202270656B696E657365223A205B5D2C202270656D62726F6B65223A205B5D2C202270696E7363686572223A205B226D696E696174757265225D2C2022707972656E656573223A205B5D2C20227368656570646F67223A205B22656E676C697368222C2022736865746C616E64225D2C2022737072696E676572223A205B22656E676C697368225D2C2022746572767572656E223A205B5D2C20227761746572646F67223A205B227370616E697368225D2C202262726162616E636F6E223A205B5D2C2022636174746C65646F67223A205B226175737472616C69616E225D2C2022636869687561687561223A205B5D2C2022636F6F6E686F756E64223A205B5D2C2022646163687368756E64223A205B5D2C202264616C6D617469616E223A205B5D2C202264656572686F756E64223A205B2273636F7474697368225D2C202267726579686F756E64223A205B226974616C69616E225D2C2022726574726965766572223A205B2263686573617065616B65222C20226375726C79222C2022666C6174636F61746564222C2022676F6C64656E225D2C202272696467656261636B223A205B2272686F64657369616E225D2C20227363686E61757A6572223A205B226769616E74222C20226D696E696174757265225D2C202273746265726E617264223A205B5D2C2022776F6C66686F756E64223A205B226972697368225D2C20226175737472616C69616E223A205B227368657068657264225D2C20226F74746572686F756E64223A205B5D2C2022706F6D6572616E69616E223A205B5D2C2022726F74747765696C6572223A205B5D2C202273636869707065726B65223A205B5D2C20227765696D6172616E6572223A205B5D2C2022617070656E7A656C6C6572223A205B5D2C202262756C6C74657272696572223A205B2273746166666F72647368697265225D2C2022656E746C65627563686572223A205B5D2C202267726F656E656E6461656C223A205B5D2C20226C61627261646F6F646C65223A205B5D2C20226E6577666F756E646C616E64223A205B5D2C2022616666656E70696E7363686572223A205B5D2C2022636F746F6E646574756C656172223A205B5D2C20226765726D616E7368657068657264223A205B5D2C20226D65786963616E686169726C657373223A205B5D7D7D','2023-04-13 10:58:45');
/*!40000 ALTER TABLE `test_logs` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;