如何在使用 cloudant 查找 API 时查找总计行

Question

>我有一个查找查询，如下所示

POST /movies/_find HTTP/1.1
Accept: application/json
Content-Type: application/json
Content-Length: 168
Host: localhost:5984
{
"selector": {
"year": {"$gt": 2010}
},
"fields": ["_id", "_rev", "year", "title"],
"sort": [{"year": "asc"}],
"limit": 2,
"skip": 0
}

返回与查询匹配的前两个结果。是否可以使用此查询获取总行数。这在构建分页时非常有用

Answer 1

不，对不起。为此，查询需要拖网整个集合进行计数。请注意，文本索引已支持开箱即用的分页：

https://console.bluemix.net/docs/services/Cloudant/api/cloudant_query.html#finding-documents-by-using-an-index

Answer 2

您可以使用 GET/movies 获取数据库的元数据

总行数 - "doc_count">

响应示例：

{
"update_seq": "<some data>",
"db_name": "movies",
"sizes": {
"file": <size>,
"external": <size>,
"active": <size>
},
"purge_seq": 0,
"other": {
"data_size": <size>
},
"doc_del_count": <number>,
"doc_count": <number>,
"disk_size": <size>,
"disk_format_version": <version>,
"compact_running": false,
"instance_start_time": "0"
}