请求地址
/v2/webservice/table/table-index-info
请求方法
Post
请求参数说明
| 参数名称 | 类型 | 是否必填 | 说明 |
|---|---|---|---|
| app_id | number | 是 | |
| zone_id | number | 是 | |
| table_name | string | 是 |
示例
{
"app_id":2,
"zone_id":111,
"table_name": "TestData"
}
返回参数说明
| 参数名称 | 类型 | 说明 |
|---|---|---|
| dbcluster_info | DBClusterInfoObject | 索引的全部信息 |
db_tables
DBClusterInfoObject
| 参数名称 | 类型 | 说明 |
|---|---|---|
| index_info.shard_num | 数字 | 分片数 |
| db_tables.db_table | DBTables数组 | |
DBTables数组
| 参数名称 | 类型 | 说明 |
|---|---|---|
| value_fields | {"field_num": number,"field"：{field_name:"string"}[]} | field_name:为配置了索引的字段 |
| key_fields | {"field_num": number,"field"：{field_name:"string"}[]} | field_name:为配置了索引的字段成功返回 |
存在索引
{
"code": 0,
"request_id": "7432d149-7bfb-4087-98ad-7af6dca8cff6",
"data": {
"app_id": 2,
"zone_id": 111,
"table_name": "TestData",
"table_type": 0,
"dbcluster_info": {
"app_id": 2,
"zone_id": 111,
"table_name": "TestData",
"table_type": 0,
"db_sources": {
"db_source_num": 1,
"db_source": [
{
"db_source_name": "DbSource",
"ip": "",
"port": 0,
"user": "",
"passwd": "",
"db_name": "",
"conn_pool_size": 10,
"character_set": "utf8"
}
]
},
"db_tables": {
"db_table_num": 1,
"db_table": [
{
"table_prefix": "",
"sub_table_count": 0,
"value_fields": {
"field_num": 1,
"field": [
{
"field_name": "buffer",
"db_field_name": ""
}
]
},
"key_fields": {
"field_num": 0
},
"deploy": {
"sub_table_store_place_num": 1,
"sub_table_store_place": [
{
"sub_table_index_start": 0,
"sub_table_index_end": 0,
"db_source_name": "DbSource"
}
]
}
}
]
},
"field_type_stmts": {
"table_tdr_file": "../../cfg/tcapdb_1_2_5_1/43c13cc1845030b9c99ef8be52554c86.tdr",
"table_tdr_name": "TestData",
"key_field_stmts": {
"field_stmt_num": 0
},
"value_field_stmts": {
"field_stmt_num": 0
},
"table_idl_file": "",
"idl_type": 1
},
"route_key_fields": {
"field_num": 0
},
"tdbank_conf": {
"bid": "",
"tid": "",
"db_name": "",
"string_encode_manner": 0,
"msgtype": 0,
"tdbank_addr": ""
},
"db_type": 4,
"index_info": {
"replication_num": 1,
"shard_num": 3
},
"plugin_info": {
"plugin_name": "",
"plugin_file_id": 0,
"plugin_file_path": "",
"window_size": 10,
"alarm_receivers": ""
},
"kafka_info": {
"instance": "",
"address": "",
"topic": "",
"user": "",
"password": "",
"is_vpc": 0
}
},
"syncdb_type": 4
}
}
表没有配置索引
{
"code": 0,
"request_id": "e3b9aa5f-cc8c-4132-8f7c-3bf80329a660",
"data": {
"app_id": 4,
"zone_id": 14209,
"table_name": "ChatChannelTable",
"table_type": 0,
"dbcluster_info": null,
"syncdb_type": 1
}
}
失败返回
{
"request_id": "5e62f740-a058-41d0-b39b-d1669f9197df",
"code": 102,
"message": "表不存在",
"debug_message": {
"app_id": 4,
"zone_id": 14209,
"table_name": "ChatChannelTable1"
}
}