javascript - 使用 futon map 程序在 couchdb 中加入两个不同的文档？

Question

我有两个文件如下:

{
   "_id": "00315fd5428d43a19ce86ae7a273085f",
   "_rev": "3-031e613837bf7e9c75f8bc9f5230d921",
   "device_sno": "WEC343",
   "moving_status": true,
   "overall_status": true,
   "temperature": "-1° C",
   "trip_id":3
}

{
  "_id": "1a",
  "_rev": "4-e876b14dcb4cfd18aba8eb36b2be33bd",
  "customer_name": "praneeth",
  "customer_id": 2,
  "tripp_id": 3
}

现在根据第一个文档中的行程 ID，我想从 doc2 中获取客户名称。谁能帮我解决这个问题，这对我有很大帮助.........

Answer 1

您可以使用 couchdb linked documents 执行此操作.

If you emit an object value which has {'_id': XXX} then include_docs=true will fetch the document with id XXX rather than the document which was processed to emit the key/value pair.

This means that if one document contains the ids of other documents, it can cause those documents to be fetched in the view too, adjacent to the same key if required.

如果您稍微更改文档的架构，并像这样在第一个文档中包含第二个文档的 _id 字段

{....,{"trip_id":"要获取的文档的 id"}}

然后你可以定义一个 View

function(doc){
 emit(doc.key,{"_id":doc.trip_id});//doc.key is the key on which you want your view to be sorted.
}

现在你可以这样查询了

http://localhost:5984/db_name/_design/ddoc_name/_view/view_name?key="some-value"&include_docs=true

这将获取链接的文档。这里需要注意的重点是 emit 中的第二个参数必须指向您要获取的文档。在您的情况下，trip_id 必须指向第二个文档的 _id。