arangodb AQL如何修改嵌套数组中对象的值？-Java 学习之路

我有这样组织的文件：

{
  "email": "tyler_li@126.com",
  "name": "tyler",
  "address": {
    "street": "Beijing Road",
    "zip": 510000
  },
  "likes": [
    "running",
    {
      "movie": "Star Wars"
    }
  ]
}

我在修改“电影”的 Value 时遇到了问题 . 你能帮助我，如何用AQL修改 Value ？

谢谢！

1 回答

以下查询应该这样做 . 我把解释作为注释放在查询中 . 我的示例假定文档存在于名为 collection 的集合中：

FOR doc IN collection
  /* any filter condition to find the document(s) in question.
     you should make sure this uses an index if there is a substantial
     number of documents in the collection */
  FILTER doc.name == 'tyler' 

  /* enumerate the old likes and return them as is if they are not
     of type object or do not have a 'movie' attribute. If they are
     objects and have a 'movie' attribute, patch them with a 'movie'
     value of 'whatever' */
  LET newLikes = (
    FOR oldLike IN doc.likes 
      RETURN 
        (TYPENAME(oldLike) == 'object' && HAS(oldLike, 'movie')) ?
            { movie: 'whatever' } :
            oldLike
  ) 

  /* finally update the matching document(s) with the new likes */
  UPDATE doc WITH { likes: newLikes } IN collection

回复于 2024-05-10T11:31:55+08:00

arangodb AQL如何修改嵌套数组中对象的值？

1 回答

相关问题