Skip to content

Latest commit

 

History

History
166 lines (145 loc) · 4.49 KB

10.md

File metadata and controls

166 lines (145 loc) · 4.49 KB

干RDS

在阿里云上,一个RDS是一个相当于一个数据库软件,在里面可以创建多个Database
创建多个账号,在平时手动管理的情况下,可以所有Database使用统一的账号.
比如一个读账号,一个读写账号,可以操作所有Database.
但是这样其实是有风险的,如果我们使用了很好的管理方式,就可以给不同的Database分配不同的账号.
这样做到权限的隔离.而且还可以更细的划分,给不同服务操作相同Database时,分配不同的账号.
这样更能更明确知道是谁操作的。当然,最好不要不同服务使用同一个Database.
最好一个服务维护,给其它服务提供接口

tag: 0.5.10

后端

涉及文件及目录

utils/aliyun/rds.py
utils/aliyun/__init__.py
asset/rds/models.py
asset/rds/controllers/sync.py
asset/rds/controllers/rds.py
asset/rds/apis/rds.py
asset/rds/urls/rds.py
asset/rds/controllers/database.py
asset/rds/apis/database.py
asset/rds/urls/database.py
asset/rds/controllers/account.py
asset/rds/apis/account.py
asset/rds/urls/account.py
asset/rds/urls/__init__.py
asset/urls.py
rurality/settings.py
data/sql/rurality.sql
requirements.txt

代码

utils/aliyun/rds.py
utils/aliyun/__init__.py

增加操作阿里云RDS工具类, 目前只做查询.

asset/rds/models.py

定义rds相关model,rds account database分别有对应的model.
并且还会建立account和database的关联model.


asset/rds/controllers/sync.py:
同步RDS、同步Account、同步Database
在同步Database时,额外记录了accounts字段,方便之后建立关联时,不用再调接口获取.
当然也可以在同步Database时直接建立关联,但是我想逻辑分开,清晰.


asset/rds/controllers/rds.py
asset/rds/apis/rds.py
asset/rds/urls/rds.py

rds对应方法及接口


asset/rds/controllers/database.py
asset/rds/apis/database.py
asset/rds/urls/database.py

操作Database接口


asset/rds/controllers/account.py
asset/rds/apis/account.py
asset/rds/urls/account.py

操作Account接口


asset/rds/urls/__init__.py
asset/urls.py

url配置


rurality/settings.py:
apps中增加asset.rds


requirements.txt:
pip install -r requirements.txt安装阿里云rds sdk


data/sql/rurality.sql:
最新的sql文件.

前端

涉及文件及目录

src/api/asset/rds/url.js
src/api/asset/rds/index.js

src/views/asset/rds/index.vue
src/views/asset/rds/detail.vue
src/views/asset/rds/components/BaseInfo/index.vue
src/views/asset/rds/components/AccountList/index.vue
src/views/asset/rds/components/DatabaseList/index.vue
src/views/asset/rds/components/Account/detail.vue
src/views/asset/rds/components/Account/components/BaseInfo/index.vue
src/views/asset/rds/components/Account/components/DatabaseList/index.vue
src/views/asset/rds/components/Account/components/ObjDialog/index.vue
src/views/asset/rds/components/Database/detail.vue
src/views/asset/rds/components/Database/components/BaseInfo/index.vue
src/views/asset/rds/components/Database/components/AccountList/index.vue
src/router/modules/asset.js

代码

src/api/asset/rds/index.js
src/api/asset/rds/url.js

RDS相关接口


src/views/asset/rds/index.vue
src/views/asset/rds/detail.vue
src/views/asset/rds/components/BaseInfo/index.vue
src/views/asset/rds/components/AccountList/index.vue
src/views/asset/rds/components/DatabaseList/index.vue

RDS对应列表及详情页
RDS下分Database和Account


src/views/asset/rds/components/Account/detail.vue
src/views/asset/rds/components/Account/components/BaseInfo/index.vue
src/views/asset/rds/components/Account/components/DatabaseList/index.vue
src/views/asset/rds/components/Account/components/ObjDialog/index.vue

RDS账号详情页,提供编辑账号密码功能(因为使用接口不能获取账号的密码,所以需要管理)
等以后通过平台自动创建账号时,就可以自动生成密码了.


src/views/asset/rds/components/Database/detail.vue
src/views/asset/rds/components/Database/components/BaseInfo/index.vue
src/views/asset/rds/components/Database/components/AccountList/index.vue

RDS下的Database详情页,在RDS下可以快速跳转到这里,并且可以在这页快速跳转到RDS页.
Database最后会和服务关联.


src/router/modules/asset.js:
增加对应的路由.