数据库列表查询(mysqlSelect)
接口描述:
mysqlSelect 查询数据库列表
请求参数:
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
Key | 否 | string | 实例名称,内网ip |
| Page_Size | 否 | number | 每页条数 |
| Page | 否 | number | 当前页码 |
| Project_Id | 否 | number | 项目id |
| Order | 否 | string | 排序方式 asc,desc|default:desc |
| Order_By | 否 | string | 排序字段name,ip,start_time,end_time,is_autorenew|default:start_time |
响应示例:
{
"code":200,
"msg":"操作成功",
"time":1621330877,
"data":{
"count":1,
"list":[
{
"bdb_id":"BDB1exv3ah70fij5le",
"name":"lets",
"type":"1",
"version":"mysql5.6",
"ip":"10.120.100.145",
"cpu":"1",
"memory":"1500",
"disk":"20",
"port":"3306",
"config_id":"1",
"term_type":"term_demand",
"start_time":"2021-01-18 16:55:27",
"end_time":"",
"is_lock":"0",
"is_stop":"1",
"master_id":"",
"is_autorenew":"1",
"is_isolated":"0",
"status":"halted",
"count_type":"hour"
}
]
}
}