apiview
/
apiviewdict.sql

-- 请求类型字典
delete from sys_dict_type where dict_type='api_http_method';
delete from sys_dict_data where dict_type='api_http_method';

INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES (10, '请求类型', 'api_http_method', '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '请求类型列表');

INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (26, 1, 'ALL', 'ALL', 'api_http_method', '', 'default', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'ALL');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (27, 2, 'POST', 'POST', 'api_http_method', '', 'default', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'POST');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (28, 3, 'GET', 'GET', 'api_http_method', '', 'primary', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'GET');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (34, 4, 'DELETE', 'DELETE', 'api_http_method', '', 'danger', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'DELETE');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (35, 5, 'OPTIONS', 'OPTIONS', 'api_http_method', '', 'warning', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'OPTIONS');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (36, 6, 'PATCH', 'PATCH', 'api_http_method', '', 'info', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'PATCH');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (37, 7, 'HEAD', 'HEAD', 'api_http_method', '', 'success', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'HEAD');


-- 请求类型字典
delete from sys_dict_type where dict_type='api_value_type';
delete from sys_dict_data where dict_type='api_value_type';

INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES (11, '值类型', 'api_value_type', '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '请求类型列表');

INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (29, 1, '字符串', 'String', 'api_value_type', '', 'warning', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', '字符串');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (30, 2, '整数', 'Integer', 'api_value_type', '', 'success', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', '整数');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (31, 3, '正整数', 'PositiveInteger', 'api_value_type', '', 'info', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', '正整数');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (32, 4, '数字', 'decimal', 'api_value_type', '', 'primary', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', '数字');
INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (33, 5, 'JSON', 'json', 'api_value_type', '', 'danger', 'Y', '0', 'admin', '2018-10-03 22:53:03', 'admin', '2018-10-03 22:53:03', 'JSON');


-- 请求类型字典
delete from sys_dict_type where dict_type='param_transmission_mode';
delete from sys_dict_data where dict_type='param_transmission_mode';
INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES (12, '传参方式', 'param_transmission_mode', '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '参数传输方式');
INSERT INTO apiview.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (100, 50, 'RequestBody', 'RequestBody', 'param_transmission_mode', '', 'default', 'Y', '0', 'admin', '2020-11-14 17:09:44', 'admin', '2020-11-14 17:16:29', 'post调用时候的主体信息，像上传文件等都是用这种方式');
INSERT INTO apiview.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (101, 40, 'RequestHeader', 'RequestHeader', 'param_transmission_mode', '', 'warning', 'Y', '0', 'admin', '2020-11-14 17:10:26', 'admin', '2020-11-14 17:16:24', 'request.getHeader("myHeader") 获取的参数');
INSERT INTO apiview.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (102, 30, 'CookieValue', 'CookieValue', 'param_transmission_mode', '', 'danger', 'Y', '0', 'admin', '2020-11-14 17:10:46', 'admin', '2020-11-14 17:16:18', '');
INSERT INTO apiview.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (103, 20, 'PathVariable', 'PathVariable', 'param_transmission_mode', '', 'primary', 'Y', '0', 'admin', '2020-11-14 17:12:11', 'admin', '2020-11-14 17:16:14', '参数的值包含在URL当中');
INSERT INTO apiview.sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES (104, 10, 'RequestParam', 'RequestParam', 'param_transmission_mode', '', 'info', 'Y', '0', 'admin', '2020-11-14 17:14:06', 'admin', '2020-11-14 17:16:04', '常用的方式，参数在url末端 http://localhost:8080/login?username=admin&amp;password=admin');