数据库类型管理
February 26, 2024About 6 min
数据库类型管理
SDK类名：/resource/ActiveDbType
示例接口副本
示例接口描述
URL
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| foo | String | | 请求属性示例 | @ctitle | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| string | String | | 字符串属性示例 | ★ | 1-10 |
| number | Number | | 数字属性示例 | 1 | 1-100 |
| boolean | Boolean | | 布尔属性示例 | true | 1-2 |
| regexp | RegExp | | 正则属性示例 | /[a-z][A-Z][0-9]/ | |
| function | Function | | 函数属性示例 | function() {
return this.number
} | |
| array | Array | | 数组属性示例 | | 1-10 |
| foo | Number | | 数组元素示例 | 1 | +1 |
| bar | String | | 数组元素示例 | ★ | 1-10 |
| items | Array | | 自定义数组元素示例 | [1, true, 'hello', /\w{10}/] | |
| object | Object | | 对象属性示例 | | |
| foo | Number | | 对象属性示例 | 1 | +1 |
| bar | String | | 对象属性示例 | ★ | 1-10 |
| placeholder | String | | 占位符示例 | @title | |
数据库支持类型 - 列表
SDK方法名：listActiveDbType;
URL
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| where_args | Object | | | | |
| type_uuid | Array | | 类型uuid | | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | Number | | | 200 | |
| msg | String | | | | |
| data | Object | | | | |
| code | Number | | | 0 | |
| message | String | | | [0] 操作成功。 | |
| info_list | Array | | | | 44 |
| id | Number | | | 51 | +1 |
| type_name | Array | | | ["oracle","kafka","postgresql","mysql","dm","gauss100","gauss200","gaussopen","hive","hbase","kudu","sap hana","sqlserver","db2","goldendb","tidb","tdsql","hotdb","qianbase","oceanbase","teradata","qianbase_binlog","informix","qianbase_xtp","mongodb","redis","hudi","hdfs","starrocks","sundb","argodb","lightdb","vertica","antdb","mdb","elasticsearch","sequoiadb","gbase8a","gbase8c","gbase8s","vastbase","kingbase","shentong","clickhouse"] | +1 |
| type_uuid | Array | | | ["87DC927D-FD7F-4F03-A7BA-03739C0A77DF","735D9E29-5176-4112-9E38-C7263EC682B3","D44AEFB9-676C-4683-8BD8-BF6AD02A372A","B0B4E832-2587-409E-A9E8-79F6DFB1B86F","90F762AC-BD1C-4F40-890F-B51E0CAEA399","76C4D7AE-A6D9-48DA-A5A7-C9FDA04D944C","12C41191-1350-4EE5-8577-A9B73576C0B4","6E8F1BB8-445C-4AD0-BE93-37A44E7B0A4A","2532F873-6731-483D-B209-228DBAE2EC21","8C98922A-B2FC-4C5A-8A76-961EECE8F32E","CDCF2F08-F667-41B4-97A1-BD6D44EF909B","1463476D-F7D5-4F69-B274-A4E727F65CA8","64E98FD4-6A22-4FEA-9C33-F248A9B2F835","267FFA5F-1068-4DC4-95B2-6BFDF8E4B64D","541E6776-C9BD-4871-BEA2-5174533E1ECD","605F18CE-1235-4B91-8D0C-A666B4439314","4A318CB9-728E-4D80-A35E-AB9250FEE590","7F98206B-57E7-495E-952F-21BA609FFCAF","34E0EBFA-8B35-46FC-952D-2688E9114DA3","2574D87C-772D-4D48-8F67-D6A4A474928B","CCE724D8-83A9-4156-A059-CABC0E298844","FCA80CBC-4A35-464F-848B-75722EB6C03A","F459568F-4DF8-4128-9CCF-D3A895DF9DF9","90775E99-6290-4174-AE92-E0280C597EFA","52AF4631-93A1-4B16-B890-006A9124E757","82DCF795-D4F6-441E-A017-A55AB678A259","625586A8-A8FA-4674-988B-93A06E490ECD","5338F5BA-78C2-41E2-B5BF-A042E3E142C0","C68A854A-F527-4BCC-BC2F-3CA36C50C483","F1F2A378-CBE6-4974-B295-D894A5892BB5","30AF478A-EEED-4F78-9FF6-DD9373C29740","79E447B4-CF9C-41ED-BA02-7A28D9828084","CEC82930-D1D2-40D7-9F06-6CFAB76C5B58","E36429D6-6E9E-4EC2-B2B0-E34822972232","30CAB8E8-D53E-4A15-B87A-463084F188BF","769F314E-1B1B-4334-BEFF-8BCF692C2F26","9A1F9143-2635-4D55-AA50-2AEEE0E6895F","4FEB969E-22DD-4534-825D-091DBD76FC51","91A0809D-EFA9-4476-BAFD-6E8E9BDAF1BE","1272D373-36C3-423A-A200-917F68C186C3","DBFD4A1A-8E29-4680-821C-AE7084540AC9","9DDF0A5B-42E8-482C-931F-08A960586FCD","489E25BD-941E-4427-B2C5-BECFCA9276DB","30774CF2-91F8-44A3-A998-260ED87FCA0D"] | +1 |
| comment | Null | | | | |
| mapping_type_uuid | Null | | | | |
| is_source | Number | | | 1 | |
| build_in | Number | | | 1 | |
| created_at | Number | | | 1713516928 | |
| updated_at | Null | | | | |
| mapping_type_name | Null | | | | |
| total | Number | | | 44 | |
数据库支持类型 - 支持的映射类型
SDK方法名：listActiveDbTypeAvailMappingType;
URL
/vers/v3/active/db_type/mapping_type
Method
Request
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
| db_type | String | | 数据库类型 | | |
| mapping_type_uuid | String | | 映射数据库类型uuid | | |
| mapping_db_type | String | | 映射数据库类型 | | |
| is_source | Number | | 是否源端，0：关，1：开 | | |
| build_in | Number | | 是否内置类型，0：关，1：开 | | |
数据库支持类型 - 新建
SDK方法名：createActiveDbType;
URL
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| type_name | String | | 数据库类型名称 | | |
| mapping_type | String | | 映射数据库类型，目前只支持mysql、postgresql、oracle | | |
| is_source | Number | | 是否支持源端，0：关，1：开 | | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
数据库支持类型 - 修改
SDK方法名：modifyActiveDbType;
URL
/vers/v3/active/db_type/:uuid([A-F0-9-]+)
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| type_name | String | | 类型名称 | | |
| mapping_type_name | String | | 映射数据库类型，目前只支持mysql、postgresql、oracle | | |
| is_source | String | | 是否源端 | | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
数据库支持类型 - 删除
SDK方法名：deleteActiveDbType;
URL
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| type_uuid | String | | 类型uuid | | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
获取特定菜单可用源端类型 - 列表
SDK方法名：listAvailActiveDbSourceType;
URL
/vers/v3/active/db_type/avail_src_type
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| where_args[src_type_name]: | String | | 菜单类型，如MySQL同步规则菜单中，需要获取MySQL以及映射到MySQL同时支持源端类型的自定义类型时，传mysql、同理Oracle与pgsql的菜单需要传oracle、postgresql。 | mysql | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
| info_list | Object | | | | |
| db_type | String | | | | |
| type_uuid | String | | | | |
| mapping_type_uuid | String | | | | |
| mapping_db_type | String | | | | |
数据库备端支持类型 - 列表
SDK方法名：listAvailActiveDbType;
URL
/vers/v3/active/db_type/avail_type
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| where_args | Object | | | | |
| type_uuid | String | | 数据库类型uuid（不传就是全部映射） | | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
| info_list | Object | | | | |
| build_in | Number | | 是否内置类型，0：否，1：是 | | |
| type_name | String | | 类型名称 | | |
| type_uuid | String | | 类型uuid | | |
| is_source | Number | | 是否源端类型，0：否，1：是 | | |
| dst_type_list | Array | | 源备类型映射信息列表 | | |
| src_build_in | Number | | 源端类型是否内置 | | |
| src_mapping_type_name | String | | 源端映射类型名 | | |
| src_type_name | String | | 源端类型名 | | |
| src_type_uuid | String | | 源端类型uuid | | |
| dst_build_in | Number | | 备端类型是否内置 | | |
| dst_mapping_type_name | String | | 备端映射类型名 | | |
| dst_type_name | String | | 备端类型名 | | |
| dst_type_uuid | String | | 备端类型uuid | | |
数据库备端支持类型 - 修改
SDK方法名：modifyAvailActiveDbType;
URL
/vers/v3/active/db_type/type_mapping
Method
Request
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| type_uuid | String | | 源端类型uuid | | |
| dst_type_uuid_list | Array | | 备端类型uuid数组 | [
"8F26595D-CBB9-4053-9B3A-43F9F23BFCD7",
"A4733F57-70B9-4DF8-83D8-43F8557A1C8F"
] | |
Response
| 名称 | 类型 | 必选 | 简介 | Mock初始值 | Mock规则 |
|---|
| ret | String | | | 200 | |
| msg | String | | | success | |
| data | Object | | | | |
| code | String | | | 0 | |
| message | String | | | success | |
