dongxi4335
2017-10-30 23:55
浏览 72

将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

图片转代码服务由CSDN问答提供 功能建议

我试图从mongo文档中检索所有id和field2,如果field1等于某个值并且field2存在。 / p>

示例: Mongo文档:

  {
 
“ id”:“ id1” 
“ field1”:“ val1  “ 
” field2“:” val2“ 
” field3“:” val3“ 
} 
 
 {
 
” id“:” id2“ 
” field1“:” val4“ 
”  field3“:” val5“ 
} 
   
 
 

结果

  {
 
” id“:  “ id1” 
“ field2”:“ val2” 
} 
   
 
 

我想出了行之有效的mongodb查询:

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

但是我想使用Mgo包在Go中调用此查询。 我无法使用Mgo进行此mongo查询调用。 我尝试了几种方法,但它们似乎没有用。 有人可以帮我吗?

谢谢

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

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
    
    打赏 评论

相关推荐 更多相似问题