doukui2011 2018-08-07 12:58
浏览 166
已采纳

聚合查询在golang中

I need to write a query in golang with mgo, here's the query in the mongo:

db.some.aggregate([
{$match: { "data.id": "11111" }},
    {$project: { 
            _id : 0,
            url : { $concat: [ "https://www.someurl.com/","$data.aID" ]},
       items :{
       "$map":{
                "input":"$data.items",
                "as":"it",
                "in":{
                  "item_title":"$$it.title",                             
                  "item_id":"$$it.id"
               }}}}])

I will be grateful if you will help in this problem.

// I apologize for the incorrectly posed question, in the future I will follow the instructions, my problem was with $concat

  • 写回答

1条回答 默认 最新

  • douxiong5438 2018-08-07 14:47
    关注

    The syntax here is tricky because it's similar to JSON but different enough to be confusing.

    In particular, note that arrays use curly brace delimiters []bson.M{...} and the $concat value is an array of strings []string{...}:

    query := []bson.M{ // NOTE: slice of bson.M here
      bson.M{
        "$match": bson.M{"data.id": "11111"},
      },
      bson.M{
        "$project": bson.M{
          "_id": 0,
          "url": bson.M{
            "$concat": []string{ // NOTE: slice of strings here
              "https://www.someurl.com/",
              "$data.aID",
            },
          },
          "items": bson.M{
            "$map": bson.M{
              "input": "$data.items",
              "as":    "it",
              "in":    bson.M{"item_title": "$$it.title", "item_id": "$$it.id"},
            },
          },
        },
      },
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 这是哪个作者做的宝宝起名网站
  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!