mongodb字段数据转换

Question

我的测试集

{ "_id" : 0, "Animals" : "cat", "activity" : "sleep" }
{ "_id" : 1, "Animals" : "dog", "activity" : "run" }
{ "_id" : 2, "Animals" : "cow", "activity" : "play" }
{ "_id" : 3, "Animals" : "cow", "activity" : "sleep" }
{ "_id" : 4, "Animals" : "cow", "activity" : "run" }
{ "_id" : 5, "Animals" : "dog", "activity" : "play" }
{ "_id" : 6, "Animals" : "cat", "activity" : "run" }

找到动物和活动的独特价值

db.test.distinct("Animals")
[ "cat", "dog", "cow" ]
db.test.distinct("service")
[ "sleep", "run", "play" ]

之后，动物和猫的-> {猫:1，狗:0，牛:0}和其他的一样

我想更改此类型的格式

{ "_id" : 0, "cat" : 1, "dog" : 0, "cow" : 0, "sleep" : 1, "run" : 0,  "play": 0 }
{ "_id" : 1, "cat" : 0, "dog" : 1, "cow" : 0, "sleep" : 0, "run" : 1,  "play": 0 }
{ "_id" : 2, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 0, "run" : 0,  "play": 1 }
{ "_id" : 3, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 1, "run" : 0,  "play": 0 }
{ "_id" : 4, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 0, "run" : 1,  "play": 0 }
{ "_id" : 5, "cat" : 0, "dog" : 1, "cow" : 0, "sleep" : 0, "run" : 0,  "play": 1 }
{ "_id" : 6, "cat" : 1, "dog" : 0, "cow" : 0, "sleep" : 0, "run" : 1,  "play": 0 }

我该怎么做呢？

Answer 1

对于聚合框架，我将按如下方式完成：

按_id

• count
• activity
• 按升序对结果进行排序

db.test.aggregate([ {
$group: {
_id:    "$_id",
cat:   {$sum: {$cond: [{"$eq": ["$Animals",  "cat"]},   1, 0 ] } },
dog:   {$sum: {$cond: [{"$eq": ["$Animals",  "dog"]},   1, 0 ] } },
cow:   {$sum: {$cond: [{"$eq": ["$Animals",  "cow"]},   1, 0 ] } },
sleep: {$sum: {$cond: [{"$eq": ["$activity", "sleep"]}, 1, 0 ] } },
run:   {$sum: {$cond: [{"$eq": ["$activity", "run"]},   1, 0 ] } },
play:  {$sum: {$cond: [{"$eq": ["$activity", "play"]},  1, 0 ] } }
} }, 
{ $sort: {_id: 1}}
] )

mongo shell中的结果看起来像您正在寻找的：

{ "_id" : 0, "cat" : 1, "dog" : 0, "cow" : 0, "sleep" : 1, "run" : 0, "play" : 0 }
{ "_id" : 1, "cat" : 0, "dog" : 1, "cow" : 0, "sleep" : 0, "run" : 1, "play" : 0 }
{ "_id" : 2, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 0, "run" : 0, "play" : 1 }
{ "_id" : 3, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 1, "run" : 0, "play" : 0 }
{ "_id" : 4, "cat" : 0, "dog" : 0, "cow" : 1, "sleep" : 0, "run" : 1, "play" : 0 }
{ "_id" : 5, "cat" : 0, "dog" : 1, "cow" : 0, "sleep" : 0, "run" : 0, "play" : 1 }
{ "_id" : 6, "cat" : 1, "dog" : 0, "cow" : 0, "sleep" : 0, "run" : 1, "play" : 0 }

Answer 2

我认为您可以按如下方式显示use aggregation：

db.test.aggregate([
    {$group : {
        _id : $_id,
        cat : {$cond : {if: { $eq: [ "$Animals", "cat" ] }, then: 1, else: 0}},
        dog : {$cond : {if: { $eq: [ "$Animals", "dog" ] }, then: 1, else: 0}},
        cow : {$cond : {if: { $eq: [ "$Animals", "cow" ] }, then: 1, else: 0}},
        sleep : {$cond : {if: { $eq: [ "$activity", "sleep" ] }, then: 1, else: 0}},
        run : {$cond : {if: { $eq: [ "$activity", "run" ] }, then: 1, else: 0}},
        play : {$cond : {if: { $eq: [ "$activity", "play" ] }, then: 1, else: 0}}
    }}
]);

这段代码使用$cond聚合运算符+ $eq比较运算符。

阅读更多内容：

http://docs.mongodb.org/manual/reference/operator/aggregation/group/#group-aggregation http://docs.mongodb.org/manual/reference/operator/aggregation/cond/#cond-aggregation http://docs.mongodb.org/manual/core/aggregation-pipeline/