go语言Mongodb聚合统计每个（时间）段内的数据

dx1313113

已于 2022-07-28 12:31:23 修改

阅读量824

点赞数 1

分类专栏： go语言 mongodb 文章标签： mongodb go

于 2022-07-03 13:53:02 首次发布

本文链接：https://blog.csdn.net/qq_48626761/article/details/125583871

版权

go语言同时被 2 个专栏收录

38 篇文章 1 订阅

订阅专栏

mongodb

7 篇文章 0 订阅

订阅专栏

根据（时间）段来聚合统计每个（时间）段内的数据

//每200范围的高度数据统计
client := global.GvaMongo.Database(global.GvaConfig.MongoDB.Dbname).Collection(global.Collection)
groupStage :=bson.D{
   {"$group", bson.D{
      {"_id", bson.D{
         //{"lei_xing", "$lei_xing"},
         //{"xing_hao", "$xing_hao"},
         //{"pi_hao", "$pi_hao"},
         {"$subtract", bson.A{
            bson.M{"$subtract":bson.A{bson.D{{"$convert",bson.D{{"input","$gao_du"},{"to","double"},{"onError","高度数据有误"},{"onNull",0}}}},200}},
            bson.M{ "$mod": bson.A{bson.M{ "$subtract": bson.A{ bson.D{{"$convert",bson.D{{"input","$gao_du"},{"to","double"},{"onError","高度数据有误"},{"onNull",0}}}},200 } },200}},
         },
      },
      },
      },
      {"count",bson.M{"$sum":1}},
      },
   },
}
//var matchCondition = []bson.E{}
var matchCondition = bson.M{}
matchStage :=bson.D{{"$match",matchCondition}}
cur,_:= client.Aggregate(context.TODO(),mongo.Pipeline{matchStage,groupStage})
// Get a list of all returned documents and print them out. // See the mongo.Cursor documentation for more examples of using cursors.
var results []map[string]interface{}
if err = cur.All(context.TODO(), &results);
   err != nil {     log.Fatal(err) }

运行结果：