dongqiangou5724 2018-01-28 11:45
浏览 143
已采纳

从go中获取mongo的普通json

I am trying to fetch some data from mongo in go and using gopkg.in/mgo.v2. I have a nested data in mongo.

Note: This is an old database I cannot change structure for and just want to query the data.

I have a database with fields id, name and details. and I have to get details based on id My code:

package main

import (
    "fmt"
    "gopkg.in/mgo.v2"
    "gopkg.in/mgo.v2/bson"
)

type Person struct {
    Name string
    Id string
    Details string
}


func main() {

    session, err := mgo.Dial("mongodb://localhost:27017/naren")

    c := session.DB("naren").C("people")

    result := Person{}
    err = c.Find(bson.M{"id": "12345"}).One(&result)
    if err != nil {
        fmt.Println(err)
    }

    fmt.Println("Details:", result.Details)
    fmt.Println("Name:", result.Name)
    fmt.Println("Id:", result.Id)
}

Id and Name are printing fine but result.Details prints an empty string even when there is data. I just want to print json as string or am happy with a json data.

I have also tried

...
type Person struct { 
    ...
    Details string `json:"details"`
}

But still get empty string. Thanks in advance.

  • 写回答

1条回答 默认 最新

  • dongnai3960 2018-01-28 16:58
    关注

    I am very new to go. This seems very basic now. The value of key details was JSON

    The fix was that I changed the type of details to bson.M

    from

    type Person struct {
        Name string
        Id string
        Details string
    }
    

    to

    type Person struct {
        Name string
        Id string
        Details bson.M
    }
    

    now I can access the details like

    res, err := json.Marshal(result.Details)
    
    fmt.Println(string(res))
    

    Thanks @putu for pointing me to the right direction.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 openwrt双栈NAT
  • ¥15 部分网页页面无法显示!
  • ¥15 怎样解决power bi 中设置管理聚合,详细信息表和详细信息列显示灰色,而不能选择相应的内容呢?
  • ¥15 QTOF MSE数据分析
  • ¥15 平板录音机录音问题解决
  • ¥15 请问维特智能的安卓APP在手机上存储传感器数据后,如何找到它的存储路径?
  • ¥15 (SQL语句|查询结果翻了4倍)
  • ¥15 Odoo17操作下面代码的模块时出现没有'读取'来访问
  • ¥50 .net core 并发调用接口问题
  • ¥15 网上各种方法试过了,pip还是无法使用