APIJSONDemo-MultiDataSource-Redis

APIJSONDemo

支持多数据源-redis、rediSQL

redis cluster、sentinel、single模式

具体使用

抽空补充到 auto apijson, 方便大家在线测试

Access表

INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (70, 0, 'REDIS_STRING', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-23 17:41:40', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (72, 0, 'REDIS_KEYS', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-24 10:19:29', 'redis', '123', '4732209c-5785-4827-b532-5092f154fd94', NULL, NULL);
INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (73, 0, 'REDIS_LIST', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-25 12:53:01', 'redis', '123', '4732209c-5785-4827-b532-5092f154fd94', NULL, NULL);
INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (74, 0, 'REDIS_HASH', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-25 12:53:17', 'redis', '123', '4732209c-5785-4827-b532-5092f154fd94', NULL, NULL);
INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (75, 0, 'REDIS_SET', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-25 12:53:24', 'redis', '123', '4732209c-5785-4827-b532-5092f154fd94', NULL, NULL);
INSERT INTO `housekeeping`.`access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`, `detail`, `appId`, `userId`, `deletedKey`, `deletedValue`) VALUES (76, 0, 'REDIS_ZSET', NULL, '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"LOGIN\",\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '[\"OWNER\", \"ADMIN\"]', '2022-12-25 12:53:31', 'redis', '123', '4732209c-5785-4827-b532-5092f154fd94', NULL, NULL);

Request表

INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (188, 0, 1, 'POST', 'REDIS_KEYS', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-24 10:21:00', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (189, 0, 1, 'POST', 'REDIS_KEYS[]', '{\"REDIS_KEYS[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}}', '批量新增', '2022-12-24 10:21:00', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (190, 0, 1, 'PUT', 'REDIS_KEYS', '{\"REDIS_KEYS\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-24 10:21:00', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (191, 0, 1, 'DELETE', 'REDIS_KEYS', '{\"REDIS_KEYS\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '批量删除', '2022-12-24 10:21:00', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (192, 0, 1, 'POST', 'REDIS_HASH', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-25 12:54:53', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (193, 0, 1, 'POST', 'REDIS_HASH[]', '{\"REDIS_HASH[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}}', '批量新增', '2022-12-25 12:54:53', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (194, 0, 1, 'PUT', 'REDIS_HASH', '{\"REDIS_HASH\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-25 12:54:53', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (195, 0, 1, 'DELETE', 'REDIS_HASH', '{\"REDIS_HASH\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '批量删除', '2022-12-25 12:54:53', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (196, 0, 1, 'POST', 'REDIS_LIST', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-25 12:55:15', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (197, 0, 1, 'POST', 'REDIS_LIST[]', '{\"REDIS_LIST[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}}', '批量新增', '2022-12-25 12:55:15', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (198, 0, 1, 'PUT', 'REDIS_LIST', '{\"REDIS_LIST\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-25 12:55:15', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (199, 0, 1, 'DELETE', 'REDIS_LIST', '{\"REDIS_LIST\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '批量删除', '2022-12-25 12:55:15', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (200, 0, 1, 'POST', 'REDIS_SET', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-25 12:55:34', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (201, 0, 1, 'POST', 'REDIS_SET[]', '{\"REDIS_SET[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}}', '批量新增', '2022-12-25 12:55:34', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (202, 0, 1, 'PUT', 'REDIS_SET', '{\"REDIS_SET\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-25 12:55:34', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (203, 0, 1, 'DELETE', 'REDIS_SET', '{\"REDIS_SET\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\"}} }', '批量删除', '2022-12-25 12:55:34', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (204, 0, 1, 'POST', 'REDIS_ZSET', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-25 12:55:51', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (205, 0, 1, 'POST', 'REDIS_ZSET[]', '{\"REDIS_ZSET[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}}', '批量新增', '2022-12-25 12:55:51', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (206, 0, 1, 'PUT', 'REDIS_ZSET', '{\"REDIS_ZSET\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-25 12:55:51', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (207, 0, 1, 'DELETE', 'REDIS_ZSET', '{\"REDIS_ZSET\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\"}} }', '批量删除', '2022-12-25 12:55:51', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (208, 0, 1, 'POST', 'REDIS_STRING', '{\"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}, \"REFUSE\": \"id\"}', '新增', '2022-12-25 13:16:23', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (209, 0, 1, 'POST', 'REDIS_STRING[]', '{\"REDIS_STRING[]\": [{\"REFUSE\": \"id\"}], \"UPDATE\": {\"@role\": \"OWNER,ADMIN\"}}', '批量新增', '2022-12-25 13:16:23', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (210, 0, 1, 'PUT', 'REDIS_STRING', '{\"REDIS_STRING\":{ \"REFUSE\": \"userId\", \"INSERT\": {\"@role\": \"OWNER,ADMIN\",\"@combine\": \"key,keys\"}} }', '修改', '2022-12-25 13:16:23', '2332', '4732209c-5785-4827-b532-5092f154fd94');
INSERT INTO `housekeeping`.`request` (`id`, `debug`, `version`, `method`, `tag`, `structure`, `detail`, `date`, `appId`, `userId`) VALUES (211, 0, 1, 'DELETE', 'REDIS_STRING', '{\"REDIS_STRING\":{\"INSERT\": {\"@role\": \"OWNER,ADMIN\"}} }', '批量删除', '2022-12-25 13:16:23', '2332', '4732209c-5785-4827-b532-5092f154fd94');