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 luckysheet
  • ¥25 关于##爬虫##的问题,如何解决?:
  • ¥15 ZABBIX6.0L连接数据库报错,如何解决?(操作系统-centos)
  • ¥15 找一位技术过硬的游戏pj程序员
  • ¥15 matlab生成电测深三层曲线模型代码
  • ¥50 随机森林与房贷信用风险模型
  • ¥50 buildozer打包kivy app失败
  • ¥30 在vs2022里运行python代码
  • ¥15 不同尺寸货物如何寻找合适的包装箱型谱
  • ¥15 求解 yolo算法问题