代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50635
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 50635
File Encoding : 65001
Date: 04/08/2023 11:59:30
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for interface_info
-- ----------------------------
DROP TABLE IF EXISTS `interface_info`;
CREATE TABLE `interface_info` (
`api_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
`api_method` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'HttpMethod：GET、PUT、POST',
`api_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '拦截路径',
`api_status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态：-1-删除, 0-草稿，1-发布，2-有变更，3-禁用',
`api_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '注释',
`api_type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '脚本类型：SQL、DataQL',
`api_script` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '查询脚本：xxxxxxx',
`api_schema` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接口的请求/响应数据结构',
`api_sample` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求/响应/请求头样本数据',
`api_option` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '扩展配置信息',
`api_create_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建时间',
`api_gmt_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '修改时间',
PRIMARY KEY (`api_id`) USING BTREE,
UNIQUE INDEX `uk_interface_info`(`api_path`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Dataway 中的API' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of interface_info
-- ----------------------------
INSERT INTO `interface_info` VALUES ('i_ehg30mhke-76k', 'GET', '/api/info', '1', '', 'SQL', '-- a new Query.\nselect * from info;', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"message\":{\"type\":\"string\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"object\",\"properties\":{\"major\":{\"type\":\"string\"},\"name\":{\"type\":\"string\"},\"id\":{\"type\":\"number\"},\"age\":{\"type\":\"number\"}}}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"message\\\":\\\"Hello DataQL.\\\"}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":2,\\n\\t\\\"executionTime\\\":0,\\n\\t\\\"value\\\":{\\n\\t\\t\\\"id\\\":1,\\n\\t\\t\\\"name\\\":\\\"张绍刚\\\",\\n\\t\\t\\\"age\\\":50,\\n\\t\\t\\\"major\\\":\\\"主持人\\\"\\n\\t}\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106262574', '1622106265054');
INSERT INTO `interface_info` VALUES ('i_ehg32gk307c79', 'POST', '/api/add', '1', '', 'SQL', '-- a new Query.\ninsert into student(id,age,name,is_delete) values(#{id},#{age},#{name},#{isDelete})', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"isDelete\":{\"type\":\"number\"},\"name\":{\"type\":\"string\"},\"age\":{\"type\":\"number\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"number\"}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\n \\\"name\\\": \\\"张少锋\\\",\\n \\\"age\\\": 20,\\n \\\"isDelete\\\": 1\\n}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":10,\\n\\t\\\"executionTime\\\":7,\\n\\t\\\"value\\\":1\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106844488', '1626425855472');
INSERT INTO `interface_info` VALUES ('i_eieheki1g-556', 'POST', '/api/test', '1', '', 'SQL', '-- a new Query.\nselect * from student where age = #{age};', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"age\":{\"type\":\"number\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"age\\\":1}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":4,\\n\\t\\\"executionTime\\\":1\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1626426622120', '1626426700640');
-- ----------------------------
-- Table structure for interface_release
-- ----------------------------
DROP TABLE IF EXISTS `interface_release`;
CREATE TABLE `interface_release` (
`pub_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Publish ID',
`pub_api_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所属API ID',
`pub_method` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'HttpMethod：GET、PUT、POST',
`pub_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '拦截路径',
`pub_status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态：-1-删除, 0-草稿，1-发布，2-有变更，3-禁用',
`pub_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '注释',
`pub_type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '脚本类型：SQL、DataQL',
`pub_script` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '查询脚本：xxxxxxx',
`pub_script_ori` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原始查询脚本，仅当类型为SQL时不同',
`pub_schema` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '接口的请求/响应数据结构',
`pub_sample` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求/响应/请求头样本数据',
`pub_option` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '扩展配置信息',
`pub_release_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发布时间（下线不更新）',
PRIMARY KEY (`pub_id`) USING BTREE,
INDEX `idx_interface_release_api`(`pub_api_id`) USING BTREE,
INDEX `idx_interface_release_path`(`pub_path`) USING BTREE,
INDEX `idx_interface_release`(`pub_api_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Dataway API 发布历史。' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of interface_release
-- ----------------------------
INSERT INTO `interface_release` VALUES ('r_ehg3099b1-31i', 'i_ehg308g287k8h', 'POST', '/api/', '-1', '', 'DataQL', 'var query = @@sql()<% select * from info %>\nreturn query()', 'var query = @@sql()<% select * from info %>\nreturn query()', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"tableName\":{\"type\":\"string\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"object\",\"properties\":{\"major\":{\"type\":\"string\"},\"name\":{\"type\":\"string\"},\"id\":{\"type\":\"number\"},\"age\":{\"type\":\"number\"}}}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"tableName\\\":\\\"student\\\"}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":5,\\n\\t\\\"executionTime\\\":2,\\n\\t\\\"value\\\":{\\n\\t\\t\\\"id\\\":1,\\n\\t\\t\\\"name\\\":\\\"张绍刚\\\",\\n\\t\\t\\\"age\\\":50,\\n\\t\\t\\\"major\\\":\\\"主持人\\\"\\n\\t}\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106078025');
INSERT INTO `interface_release` VALUES ('r_ehg30g83g-932', 'i_ehg308g287k8h', 'POST', '/api/', '-1', '', 'DataQL', 'var query = @@sql()<% select * from info %>\nreturn query()', 'var query = @@sql()<% select * from info %>\nreturn query()', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"tableName\":{\"type\":\"string\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"object\",\"properties\":{\"major\":{\"type\":\"string\"},\"name\":{\"type\":\"string\"},\"id\":{\"type\":\"number\"},\"age\":{\"type\":\"number\"}}}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"tableName\\\":\\\"student\\\"}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":2,\\n\\t\\\"executionTime\\\":1,\\n\\t\\\"value\\\":{\\n\\t\\t\\\"id\\\":1,\\n\\t\\t\\\"name\\\":\\\"张绍刚\\\",\\n\\t\\t\\\"age\\\":50,\\n\\t\\t\\\"major\\\":\\\"主持人\\\"\\n\\t}\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106174040');
INSERT INTO `interface_release` VALUES ('r_ehg30mm40-2bn', 'i_ehg30mhke-76k', 'GET', '/api/info', '1', '', 'SQL', 'var tempCall = @@sql(`message`)<%-- a new Query.\nselect * from info;%>;\nreturn tempCall(${message});', '-- a new Query.\nselect * from info;', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"message\":{\"type\":\"string\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"object\",\"properties\":{\"major\":{\"type\":\"string\"},\"name\":{\"type\":\"string\"},\"id\":{\"type\":\"number\"},\"age\":{\"type\":\"number\"}}}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"message\\\":\\\"Hello DataQL.\\\"}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":2,\\n\\t\\\"executionTime\\\":0,\\n\\t\\\"value\\\":{\\n\\t\\t\\\"id\\\":1,\\n\\t\\t\\\"name\\\":\\\"张绍刚\\\",\\n\\t\\t\\\"age\\\":50,\\n\\t\\t\\\"major\\\":\\\"主持人\\\"\\n\\t}\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106265056');
INSERT INTO `interface_release` VALUES ('r_ehg32hdfg-50a', 'i_ehg32gk307c79', 'POST', '/api/add', '3', '', 'SQL', 'var tempCall = @@sql(`name`,`age`)<%-- a new Query.\ninsert into student(id,age,name) values(#{id},#{age},#{name})%>;\nreturn tempCall(${name},${age});', '-- a new Query.\ninsert into student(id,age,name) values(#{id},#{age},#{name})', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"name\":{\"type\":\"string\"},\"age\":{\"type\":\"number\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"number\"}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\n \\\"name\\\": \\\"张少锋\\\",\\n \\\"age\\\": 20\\n}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":6,\\n\\t\\\"executionTime\\\":2,\\n\\t\\\"value\\\":1\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1622106854584');
INSERT INTO `interface_release` VALUES ('r_eiehcd722-5lm', 'i_ehg32gk307c79', 'POST', '/api/add', '1', '', 'SQL', 'var tempCall = @@sql(`isDelete`,`name`,`age`)<%-- a new Query.\ninsert into student(id,age,name,is_delete) values(#{id},#{age},#{name},#{isDelete})%>;\nreturn tempCall(${isDelete},${name},${age});', '-- a new Query.\ninsert into student(id,age,name,is_delete) values(#{id},#{age},#{name},#{isDelete})', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"isDelete\":{\"type\":\"number\"},\"name\":{\"type\":\"string\"},\"age\":{\"type\":\"number\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":\"number\"}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\n \\\"name\\\": \\\"张少锋\\\",\\n \\\"age\\\": 20,\\n \\\"isDelete\\\": 1\\n}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":10,\\n\\t\\\"executionTime\\\":7,\\n\\t\\\"value\\\":1\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1626425855474');
INSERT INTO `interface_release` VALUES ('r_eiehf2abi5gd6', 'i_eieheki1g-556', 'POST', '/api/test', '1', '', 'SQL', 'var tempCall = @@sql(`age`)<%-- a new Query.\nselect * from student where age = #{age};%>;\nreturn tempCall(${age});', '-- a new Query.\nselect * from student where age = #{age};', '{\"requestHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"requestBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"age\":{\"type\":\"number\"}}},\"responseHeader\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{}},\"responseBody\":{\"$schema\":\"http://json-schema.org/draft-04/schema#\",\"type\":\"object\",\"properties\":{\"executionTime\":{\"type\":\"number\"},\"code\":{\"type\":\"number\"},\"success\":{\"type\":\"boolean\"},\"lifeCycleTime\":{\"type\":\"number\"},\"location\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]},\"message\":{\"type\":\"string\"},\"value\":{\"type\":[\"string\",\"boolean\",\"number\",\"object\",\"array\",\"null\"]}}}}', '{\"requestHeader\":\"[]\",\"requestBody\":\"{\\\"age\\\":1}\",\"responseHeader\":\"{}\",\"responseBody\":\"{\\n\\t\\\"success\\\":true,\\n\\t\\\"message\\\":\\\"OK\\\",\\n\\t\\\"code\\\":0,\\n\\t\\\"lifeCycleTime\\\":4,\\n\\t\\\"executionTime\\\":1\\n}\"}', '{\"enableCrossDomain\":false,\"hasor.dataway.globalConfig.responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@blockLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"API_BASE_URL\":\"/api/\",\"resultStructure\":true,\"showGitButton\":true,\"hasor.dataway.globalConfig.enableCrossDomain\":\"true\",\"CONTEXT_PATH\":\"\",\"hasor.dataway.globalConfig.resultStructure\":\"true\",\"responseFormat\":\"{\\n \\\"success\\\" : \\\"@resultStatus\\\",\\n \\\"message\\\" : \\\"@resultMessage\\\",\\n \\\"location\\\" : \\\"@codeLocation\\\",\\n \\\"code\\\" : \\\"@resultCode\\\",\\n \\\"lifeCycleTime\\\": \\\"@timeLifeCycle\\\",\\n \\\"executionTime\\\": \\\"@timeExecution\\\",\\n \\\"value\\\" : \\\"@resultData\\\"\\n}\",\"wrapAllParameters\":false,\"hasor.dataway.globalConfig.wrapAllParameters\":\"false\",\"hasor.dataway.globalConfig.showGitButton\":\"true\",\"hasor.dataway.globalConfig.wrapParameterName\":\"root\",\"wrapParameterName\":\"root\"}', '1626426700698');
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手