doulu8847 2017-03-06 07:20
浏览 71
已采纳

Golang-mgo中的$ literal用法

I can't understand how to properly use $literal. I am using mgo.v2 and mgo.v2/bson package.

db.store.aggregate([
{"$project":{
    "location":{
        "type":{"$literal":"Point"},
        "coordinates":["$longitude","$latitude"]
    }}
},])

I used the above code to fetch data in mongodb and working fine.It gives me the result

 { "location":{
            "type":"Point",
            "coordinates":[77.587073,12.958794] 
        }}

I tried to use the same in golang and it is shown below

pipe :=DB.C("store").Pipe([]bson.M{
        {"$project":bson.M{"location":
        bson.M{"type":
         bson.M{"$literal":"Point"},"coordinates":[]interface{}{"$longitude","$latitude"}}}}}

Above code, throws me an error

panic: bad query: BadValue: Point must be an array or object

so I replaced it like this

pipe :=DB.C("store").Pipe([]bson.M{
        {"$project":bson.M{"location":
        bson.M{"$literal":
         bson.M{"type":"Point"},"coordinates":[]interface{}{"$longitude","$latitude"}}}}})

but this also throws me an error

panic: this object is already an operator expression, and can't be used as a document expression (at 'coordinates')

my complete work is shown in the below link my work is here please help me to solve this. Thank you

  • 写回答

1条回答 默认 最新

  • dotj78335 2017-03-06 11:08
    关注

    To be complete, this is what you actually try to do:

    pipe := DB.C("store").Pipe([]bson.M{
        {"$project": bson.M{"location": bson.M{"type": bson.M{"$literal": "Point"}, "coordinates": []interface{}{"$longitude", "$latitude"}}}},
        {"$match": bson.M{"location": bson.M{"$geoWithin": bson.M{"$centerSphere": []interface{}{"$coordinates", 10 / 6378.11}}}}},
    })
    

    The problem is not with your "Point" literal, it's just a mere coincidence. If you change it to "Pt" for example, you will still see the exact same error message.

    The Point in the error message refers to $centerSphere, which expects a center point and a radius. And the way you try to "pass" it does not work.

    This works for example:

    "$centerSphere": []interface{}{[]interface{}{1.0, 2.0}, 10 / 6378.11}
    

    Your original query does not make sense, as you try to find documents where the location is within 10 kilometers from itself, which would match all documents.

    Instead you want to / should query documents which are within 10 kilometers of a specific location, and you may pass the coordinates of this specific location to $centerSphere:

    myLong, myLat := 10.0, 20.0
    
    // ...
    
    "$centerSphere": []interface{}{[]interface{}{myLong, myLat}, 10 / 6378.11}
    

    The complete query:

    myLong, myLat := 10.0, 20.0
    pipe := DB.C("store").Pipe([]bson.M{
        {"$project": bson.M{"location": bson.M{"type": bson.M{"$literal": "Point"}, "coordinates": []interface{}{"$longitude", "$latitude"}}}},
        {"$match": bson.M{"location.coordinates": bson.M{"$geoWithin": bson.M{"$centerSphere": []interface{}{[]interface{}{myLong, myLat}, 10 / 6378.11}}}}},
    })
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 ecplise在连接数据库时显示加载驱动成功但是数据库连接失败
  • ¥15 visionmaster启动失败,提示为“机器不满足授权而被禁用”
  • ¥50 用logisim设计16位单时钟周期cpu
  • ¥15 IDEA中圈复杂度如何具体设置
  • ¥50 labview采集不了数据
  • ¥15 Multisim红外倒车雷达仿真中距离问题
  • ¥15 请上面代码做什么处理或什么混淆
  • ¥15 英雄联盟自定义房间置顶
  • ¥15 W5500网线插上无反应
  • ¥15 如何用字典的Key,显示在WPF的xaml中