dongxi4335 2017-10-30 23:55
浏览 77
已采纳

将Mongo查询转换为Mgo查询

I'm trying to retrieve all id and field2 from mongo document, if field1 equals some value and field2 exists.

Example: Mongo Document:

{

       "id": "id1"
       "field1": "val1"
       "field2": "val2"
       "field3": "val3"
}

{

      "id": "id2"
      "field1": "val4"
      "field3": "val5"
}

Result

{

    "id" : "id1"
    "field2": "val2"
}

I figured out mongodb query that works:

dbname.find( { $and: [ { "field1": "val1" }, { "field2": { $exists: true } } ] } , {"id":1, "field2":1})

But I want to call this query in Go using Mgo package. I'm unable to convert make this mongo query call using Mgo. I tried a few ways but they don't seem to be working. Can anyone help me out here?

Thank you

  • 写回答

1条回答 默认 最新

  • dpdt79577 2017-10-31 00:45
    关注

    Logical AND is the default, so you can generously leave that out:

    dbname.find({"field1": "val1", "field2": {$exists: true}, {"id": 1, "field2": 1})
    

    In mgo:

    In general just use a bson.M map value for each brackets (where keys must be string values). For projection use Query.Select().

    sess := ... // Acquire an mgo session
    
    c := sess.DB("dbname").C("collname") // Use your db name and collection name
    
    var docs []bson.M
    err := c.Find(bson.M{
        "field1": "val1",
        "field2": bson.M{"$exists": true},
    }).Select(bson.M{"id": 1, "field2": 1}).All(&docs)
    
    if err != nil {
        // Handle err
        log.Printf("Query error: "%v", err)
        return
    }
    
    // Process results
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 欧拉系统opt目录空间使用100%
  • ¥15 ul做导航栏格式不对怎么改?
  • ¥20 用户端如何上传图片到服务器和数据库里
  • ¥15 现在研究生在烦开题,看了一些文献,但不知道自己要做什么,求指导。
  • ¥30 vivado封装时总是显示缺少一个dcp文件
  • ¥100 pxe uefi启动 tinycore
  • ¥15 我pycharm运行jupyter时出现Jupyter server process exited with code 1,然后打开cmd显示如下
  • ¥15 可否使用carsim-simulink进行四轮独立转向汽车的联合仿真,实现四轮独立转向汽车原地旋转、斜向形式、横移等动作,如果可以的话在carsim中如何进行相应设置
  • ¥15 Caché 2016 在Java环境通过jdbc 执行sql报Parameter list mismatch错误,但是同样的sql使用连接工具可以查询出数据
  • ¥15 疾病的获得与年龄是否有关