复杂的 CouchDb 视图

发布于 2024-10-28 19:02:26 字数 647 浏览 6 评论 0原文

我的数据库中有以下文档：

{
  id: 1,
  text: 'Hello I had a big grannysmith apple today and a big pear'
},
{
  id: 2,
  text: 'Hello I had a big apple today only'
},
{
  id: 3,
  text: 'Hello I had a big apple today, a big pear yesterday and a big orange today'
}

我的视图需要返回文本中特定关键字的聚合计数，但关键字的查找方式需要“宽松”。我的视图应该返回如下内容：

{
  'grannysmith apple' : 3,
  'pear': 2,
  'orange': 1
}

如您所见，我已经数了苹果 3 次，即使标签是 'grannysmith apple'，我仍然想拿起任何也出现了'apples'。

这可能吗？或者我应该在插入 CouchDb 之前执行此操作？我正在使用 Node.js 执行保存 - 我应该在 Node.js 中执行此操作吗？

提前致谢！

原文

I have the following documents in a database:

{
  id: 1,
  text: 'Hello I had a big grannysmith apple today and a big pear'
},
{
  id: 2,
  text: 'Hello I had a big apple today only'
},
{
  id: 3,
  text: 'Hello I had a big apple today, a big pear yesterday and a big orange today'
}

My view needs to return an aggregated count of specific keywords in the text, but the keywords need to be 'loose' on how they found. My view should return something like this:

{
  'grannysmith apple' : 3,
  'pear': 2,
  'orange': 1
}

As you can see I have counted apples 3 times even though the tag is for 'grannysmith apple', I still want to pick up any occurrences of 'apples' as well.

Is this possible? Or should I be doing this before I insert into CouchDb? I'm using node.js to perform the saving - should I do it in node.js?

Thanks in advance!

分享到QQ

分享到微博