如何使用此重新思考的数据库文档结构更新 ids 字段

Question

尝试更新文档结构中的 ids 字段时遇到问题：

[
    [0] {
                   "rank" => nil,
             "profile_id" => 3,
        "daily_providers" => [
            [0] {
                "relationships" => [
                  [0] {
                      "relationship_type" => "friend",
                                  "count" => 0
                  },
                  [1] {
                      "relationship_type" => "acquaintance",
                                    "ids" => [],
                                  "count" => 0
                  }
                ],
                "countries" => [
                   [0] {
                         "country_name" => "United States",
                         "count" => 0
                       },
                   [1] {
                         "country_name" => "Great Britain",
                         "count" => 0
                       }
                ],
                "provider_name" => "foo",
                 "date" => 20130912
            },
            [1] {
                "provider_name" => "bar"
            }
        ]
    }
]

Answer 1

在 JavaScript 中，你可以做

r.db('test').table('test').get(3).update(function(doc) {
  return {daily_providers: doc("daily_providers").changeAt(
    0,
    doc("daily_providers").nth(0).merge({
      relationships: doc("daily_providers").nth(0)("relationships").changeAt(
        1,
        doc("daily_providers").nth(0)("relationships").nth(1).merge({
          ids: [1]
        })
      )
    })
  )}
})

在红宝石中变成

r.db('test').table('test').get(3).update{ |doc|
  {"daily_providers" => doc["daily_providers"].changeAt(
    0,
    doc["daily_providers"][0].merge({
      "relationships" => doc["daily_providers"][0]["relationships"].changeAt(
        1,
        doc["daily_providers"][0]["relationships"][1].merge({
          ids => [1]
        })
      )
    })
  )}
}

您可能应该为日常提供者提供另一个表并进行连接。这将使事情变得更加简单。