Coder编程的博客

最怕你一生碌碌无为,却告诉自己平凡可贵

携程 Apollo 配置中心 | 学习笔记(十二)| 如何删除发布后的项目(AppId)?

本章将介绍如何在Apollo配置中心中删除已经发布的项目。

专栏目录:

携程 Apollo 配置中心 | 学习笔记 序章

欢迎关注个人公众号:  Coder编程

欢迎关注个人网站:www.52melrin.com


需求

在使用携程Apollo配置中心的时候,有时候我们创建的项目仅仅用来测试,或者没用了。这时候我们想把他删除,会发现无法删除项目。

例如:我们想删除apid 为bb的项目:


如何删除应用?

     根据官方描述

由于删除应用影响面较大,所以现在暂无删除应用功能。

此外,除了appId之外,其它app相关信息都能修改,所以不建议删除app。

如果确实需要删除应用的话,可以参照下面的sql手动删除数据库相关的表。


1.删除ApolloPortalDB中的数据

复制下面的sql内容,把第一行的appId从testApp改为实际要删除的appId,在ApolloPortalDB中执行即可。

set @appId = 'bb';

Use `ApolloPortalDB`;

update `App` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `AppNamespace` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `Favorite` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;

# handle roles and permissions
create temporary table `PermissionIds` as select `Id` from `Permission` where (`TargetId` = @appId or `TargetId` like CONCAT(@appId, '+%'))  and `IsDeleted` = 0;
update `Permission` set `IsDeleted` = 1 where `Id` in (select `Id` from `PermissionIds`);
update `RolePermission` set `IsDeleted` = 1 where `PermissionId` in (select `Id` from `PermissionIds`);
drop temporary table `PermissionIds`;

create temporary table `RoleIds` as select `Id` from `Role` where (`RoleName` = CONCAT('Master+', @appId) or `RoleName` like CONCAT('ModifyNamespace+', @appId, '+%') or `RoleName` like CONCAT('ReleaseNamespace+', @appId, '+%')) and `IsDeleted` = 0;
update `Role` set `IsDeleted` = 1 where `Id` in (select `Id` from `RoleIds`);
update `UserRole` set `IsDeleted` = 1 where `RoleId` in (select `Id` from `RoleIds`);
update `ConsumerRole` set `IsDeleted` = 1 where `RoleId` in (select `Id` from `RoleIds`);
drop temporary table `RoleIds`;
将appid 修改为项目appid

2.删除ApolloConfigDB中的数据

set @appId = 'bb';

Use `ApolloConfigDB`;

update `App` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `AppNamespace` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `Cluster` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `Commit` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `GrayReleaseRule` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `Release` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
update `ReleaseHistory` set `IsDeleted` = 1 where `AppId` = @appId and `IsDeleted` = 0;
delete from `Instance` where `AppId` = @appId;
delete from `InstanceConfig` where `ConfigAppId` = @appId;
delete from `ReleaseMessage` where `Message` like CONCAT(@appId, '+%');

# handle namespaces and items
create temporary table `NamespaceIds` as select `Id` from `Namespace` where `AppId` = @appId and `IsDeleted` = 0;
update `Namespace` set `IsDeleted` = 1 where `Id` in (select `Id` from `NamespaceIds`);
update `Item` set `IsDeleted` = 1 where `NamespaceId` in (select `Id` from `NamespaceIds`);
delete from `NamespaceLock` where `NamespaceId` in (select `Id` from `NamespaceIds`);
drop temporary table `NamespaceIds`;

执行上述sql语句可以删除项目id;

结果

可以看到已经成功删除项目了。



阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/Michael_HM/article/details/80346382
所属专栏: 携程Apollo配置中心
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

携程 Apollo 配置中心 | 学习笔记(十二)| 如何删除发布后的项目(AppId)?

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭