From 43926b41e7459e19e87c3050e1e2a9f602a978b5 Mon Sep 17 00:00:00 2001
From: =?utf8?q?=E5=88=98=E6=B4=AA=E9=9D=92?= <hongqing.liu@supwisdom.com>
Date: Sun, 29 Sep 2019 18:18:01 +0800
Subject: [PATCH] =?utf8?q?docs:=20=E8=B0=83=E6=95=B4route=E7=9A=84sql?=
 =?utf8?q?=E8=84=9A=E6=9C=AC?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 .../backend/base/domain/entity/Route.java     | 18 +++++--
 sql/base.sql                                  | 49 +++++++++++--------
 2 files changed, 41 insertions(+), 26 deletions(-)

diff --git a/base/domain/src/main/java/com/supwisdom/institute/backend/base/domain/entity/Route.java b/base/domain/src/main/java/com/supwisdom/institute/backend/base/domain/entity/Route.java
index 17f91cb..6a58e92 100644
--- a/base/domain/src/main/java/com/supwisdom/institute/backend/base/domain/entity/Route.java
+++ b/base/domain/src/main/java/com/supwisdom/institute/backend/base/domain/entity/Route.java
@@ -50,20 +50,28 @@ public class Route extends ABaseEntity {
   @Setter
   private String status;
 
+  /**
+   * 路径前缀
+   */
+  @Column(name = "PATH_PREFIX")
+  @Getter
+  @Setter
+  private String pathPrefix;
+
   /**
    * 路由地址
    */
-  @Column(name = "URI")
+  @Column(name = "URL")
   @Getter
   @Setter
-  private String uri;
+  private String url;
 
   /**
-   * 路径前缀
+   * 是否排除前缀
    */
-  @Column(name = "PATH_PREFIX")
+  @Column(name = "STRIP_PREFIX")
   @Getter
   @Setter
-  private String pathPrefix;
+  private Boolean stripPrefix;
 
 }
diff --git a/sql/base.sql b/sql/base.sql
index 0404695..2701905 100644
--- a/sql/base.sql
+++ b/sql/base.sql
@@ -49,9 +49,9 @@ CREATE TABLE `TB_BASE_ROUTE` (
   `MEMO` VARCHAR(500) COMMENT '备注',
   `STATUS` VARCHAR(10) NOT NULL COMMENT '状态（1 启用，0 停用）',
 
-  `URI` VARCHAR(500) NOT NULL COMMENT '路由地址',
-
   `PATH_PREFIX` VARCHAR(100) NOT NULL COMMENT '路径前缀',
+  `URL` VARCHAR(500) NOT NULL COMMENT '路由地址',
+  `STRIP_PREFIX` INT(1) COMMENT '是否排除前缀',
 
   PRIMARY KEY (`ID`),
   UNIQUE KEY `UQ_CODE` (`COMPANY_ID`,`CODE`)
@@ -60,15 +60,15 @@ COMMENT = '路由信息表';
 
 
 
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX) 
-values ('10', 0, 'aggr-api', '管理服务 - 聚合接口', '1', 'http://localhost:8081', '/api/aggr');
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
+values ('1', 0, 'bff-api', '管理服务 - 聚合接口', '1', '/api/bff', 'http://localhost:8081', 1);
 
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX) 
-values ('11', 0, 'base-api', '管理服务 - 基础接口', '1', 'http://localhost:8082', '/api/base');
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX) 
-values ('12', 0, 'system-api', '管理服务 - 系统接口', '1', 'http://localhost:8082', '/api/system');
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX) 
-values ('13', 0, 'biz-api', '管理服务 - 业务接口', '1', 'http://localhost:8082', '/api/biz');
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
+values ('10', 0, 'admin-base-api', '管理服务 - 基础接口', '1', '/api/base', 'http://localhost:8082', 1);
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
+values ('20', 0, 'adminsystem-api', '管理服务 - 系统接口', '1', '/api/system', 'http://localhost:8082', 1);
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX) 
+values ('30', 0, 'biz-api', '管理服务 - 业务接口', '1', '/api/biz', 'http://localhost:8083', 1);
 
 commit;
 
@@ -355,31 +355,36 @@ commit;
 
 
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 20);
+values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 18);
 
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 2, 17);
+values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 2, 15);
 
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
 values ('10100', 0, 'admin.base.account', '帐号管理', '1', '2', '', '1', '10000', 10100, 2, 3, 4);
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
 values ('10200', 0, 'admin.base.role', '角色管理', '1', '2', '', '1', '10000', 10200, 2, 5, 6);
 
+
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10300', 0, 'admin.base.menu', '菜单管理', '1', '2', '', '1', '10000', 10300, 2, 7, 8);
+values ('10400', 0, 'admin.base.menu', '菜单管理', '1', '2', '', '1', '10000', 10400, 2, 7, 8);
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10400', 0, 'admin.base.operation', '操作管理', '1', '2', '', '1', '10000', 10400, 2, 9, 10);
+values ('10500', 0, 'admin.base.operation', '操作管理', '1', '2', '', '1', '10000', 10500, 2, 9, 10);
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10500', 0, 'admin.base.resource', '资源管理', '1', '2', '', '1', '10000', 10500, 2, 11, 12);
+values ('10600', 0, 'admin.base.resource', '资源管理', '1', '2', '', '1', '10000', 10600, 2, 11, 12);
+
 
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10600', 0, 'admin.base.application', '应用管理', '1', '2', '', '1', '10000', 10600, 2, 13, 14);
-insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('10700', 0, 'admin.base.route', '路由管理', '1', '2', '', '1', '10000', 10700, 2, 15, 16);
+values ('10700', 0, 'admin.base.route', '路由管理', '1', '2', '', '1', '10000', 10700, 2, 13, 14);
 
 
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
-values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 18, 19);
+values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 16, 17);
+
+/*
+insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
+values ('10300', 0, 'admin.base.application', '应用管理', '1', '2', '', '1', '10000', 10300, 2, 13, 14);
+*/
 
 /*
 insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) 
@@ -446,7 +451,7 @@ values ('10208', 0, 'BaseAdminRole.rolePermissions', '获取角色的权限', '1
 insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
 values ('10209', 0, 'BaseAdminRole.relatePermissions', '关联角色的权限', '1', 'POST', '/api/base/v1/admin/roles/{id}/permissions', 'authorize');
 
-
+/*
 insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
 values ('10301', 0, 'BaseAdminApplication.query', '查询应用', '1', 'GET', '/api/base/v1/admin/applications', 'authorize');
 insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
@@ -457,7 +462,7 @@ insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACC
 values ('10304', 0, 'BaseAdminApplication.update', '修改应用', '1', 'PUT', '/api/base/v1/admin/applications/{id}', 'authorize');
 insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
 values ('10305', 0, 'BaseAdminApplication.delete', '删除应用', '1', 'DELETE', '/api/base/v1/admin/applications/{id}', 'authorize');
-
+*/
 
 insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
 values ('10401', 0, 'BaseAdminMenu.query', '查询菜单', '1', 'GET', '/api/base/v1/admin/menus', 'authorize');
@@ -582,6 +587,7 @@ values ('10200_10208', 0, '10200', '10208');
 insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
 values ('10200_10209', 0, '10200', '10209');
 
+/*
 insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
 values ('10300_10301', 0, '10300', '10301');
 insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
@@ -592,6 +598,7 @@ insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID
 values ('10300_10304', 0, '10300', '10304');
 insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
 values ('10300_10305', 0, '10300', '10305');
+*/
 
 insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
 values ('10400_10401', 0, '10400', '10401');
-- 
2.17.1