登录测试
curl http://10.141.130.183:8779/udal/openapi/v1/config/cluster/getAllClusters -X POST -d '{"tenantId":4120417,"userId":4123764}' --header "Content-Type: application/json"{
"resultCode":"0",
"resultMsg":"success",
"data":[
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000001",
"name":"LCYQ-DBPROXY-001",
"status":"enabled",
"prodInstId":"518492541872505856",
"versionNo":"2.7.8",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194",
"name":"LCYQ-DBPROXY-002",
"status":"enabled",
"prodInstId":"518495597708182528",
"versionNo":"2.7.8",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000005776",
"name":"LCYQ-DBPROXY-003",
"status":"enabled",
"prodInstId":"662182208663979008",
"versionNo":"2.7.8",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000005969",
"name":"LCYQ-DBPROXY-004",
"status":"enabled",
"prodInstId":"662183014809207808",
"versionNo":"2.7.8",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000011886",
"name":"LCYQ-DBPROXY-005",
"status":"enabled",
"prodInstId":"968841779832947712",
"versionNo":"2.8.2",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000013843",
"name":"LCYQ-DBPROXY-006",
"status":"enabled",
"prodInstId":"1026712679173063680",
"versionNo":"2.8.3",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000014045",
"name":"LCYQ-DBPROXY-007",
"status":"enabled",
"prodInstId":"1026719445617214464",
"versionNo":"2.8.3",
"container":false
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000014239",
"name":"LCYQ-DBPROXY-008",
"status":"enabled",
"prodInstId":"1026720748300928000",
"versionNo":"2.8.3",
"container":false
}
]
}获取Schema列表
curl http://10.141.130.183:8779/udal/openapi/v1/config/schema/getStandDBBySchemaIds -X POST -d '{"tenantId":4120417,"clusterId": "/dbproxy_cluster/dbproxy_cluster_0000000194"}' --header "Content-Type: application/json"{
"resultCode":"0",
"resultMsg":"success",
"data":[
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000003765",
"schemaName":"lcyqdb_backlog",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_backlog"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000003800",
"schemaName":"lcyqdb_operationssupport",
"dbInstance":"10.141.145.174:8922",
"database":"lcyqdb_operationssupport"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000006378",
"schemaName":"lcyqdb_ucl_gd",
"dbInstance":"10.141.145.107:8921",
"database":"lcyqdb_ucl_gd"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000006389",
"schemaName":"lcyqdb_ucl_js",
"dbInstance":"10.141.145.59:8922",
"database":"lcyqdb_ucl_js"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000006440",
"schemaName":"lcyqdb_ucl_qgyt",
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000007417",
"schemaName":"lcyqdb_holiday",
"dbInstance":"10.141.145.174:8922",
"database":"lcyqdb_holiday"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000007452",
"schemaName":"lcyqdb_statistic-sms",
"dbInstance":"10.141.145.174:8922",
"database":"lcyqdb_statistic-sms"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000007473",
"schemaName":"lcyqdb_sms_center",
"dbInstance":"10.141.145.174:8922",
"database":"lcyqdb_sms_center"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000008827",
"schemaName":"lcyqdb_ucfg_js",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_js"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000008838",
"schemaName":"lcyqdb_ucfg_gd",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_gd"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000008849",
"schemaName":"lcyqdb_ucfg_qgyt",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_qgyt"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000012680",
"schemaName":"lcyqdb_ucl_hwx",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucl_hwx"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000012713",
"schemaName":"lcyqdb_ucfg_hwx",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_hwx"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016215",
"schemaName":"lcyqdb_ucl_zmej",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucl_zmej"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016226",
"schemaName":"lcyqdb_ucfg_zmej",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_zmej"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016237",
"schemaName":"lcyqdb_ucfg_bf10s1",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_bf10s1"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016248",
"schemaName":"lcyqdb_ucfg_bf10s2",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucfg_bf10s2"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016259",
"schemaName":"lcyqdb_ucl_bf10s2",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucl_bf10s2"
},
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000016270",
"schemaName":"lcyqdb_ucl_bf10s1",
"dbInstance":"10.141.145.100:8923",
"database":"lcyqdb_ucl_bf10s1"
}
]
}获取表列表
curl http://10.141.130.183:8779/udal/openapi/v1/config/schema/getSchemaShardings -X POST -d '{"tenantId":4120417,"clusterId":"/dbproxy_cluster/dbproxy_cluster_0000000194","schemaNames":"lcyqdb_ucl_qgyt"}' --header "Content-Type: application/json"{
"resultCode":"0",
"resultMsg":"success",
"data":[
{
"id":"/dbproxy_cluster/dbproxy_cluster_0000000194/schemas/schema_0000006440",
"schemaName":"lcyqdb_ucl_qgyt",
"datanodes":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt",
"isStandard":"true"
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"isStandard":"false"
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"isStandard":"false"
}
],
"tables":[
{
"name":"ucl_error_msg",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"ucl_error_msg"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"ucl_error_msg"
]
}
]
},
{
"name":"ucl_collector_system",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"ucl_collector_system"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"ucl_collector_system"
]
}
]
},
{
"name":"ucl_global_config",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"ucl_global_config"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"ucl_global_config"
]
}
]
},
{
"name":"ucl_workitem_state_delete",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"ucl_workitem_state_delete"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"ucl_workitem_state_delete"
]
}
]
},
{
"name":"system_url",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"system_url"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"system_url"
]
}
]
},
{
"name":"ucl_user",
"type":"全局表",
"shardings":[
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_1",
"physicalTable":[
"ucl_user"
]
},
{
"dbInstance":"10.141.145.27:8923",
"database":"lcyqdb_ucl_qgyt_2",
"physicalTable":[
"ucl_user"
]
}
]
}
]
}
]
}文档更新时间: 2023-05-31 05:19 作者：阿力
