doumengmian1180
2017-12-22 21:55
浏览 476

如何在MySQL的Golang GORM中从查询中提取数据?

I'm trying to read the data from a database with GoLang's GORM, and am new to Go in general. This is the snippet I'm trying to get work. It's to search a database using a number and check if it already exists. Just grasping at straws here, and not really understanding how GORM works, and can't find documentation that explains what to do after doing a Where Clause.

res := db.Where("Number = ?", inumber).First(&Profile{})
log.Print("Searched for profile")
if res.RecordNotFound() {
    log.Print("Record not found")
    return "", "", "", false
} else {
    log.Print("RES")

    log.Print(res.Rows())
    ret := res.Scan(&Profile{})
    return
}
return
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongwei7913 2017-12-22 22:17
    已采纳

    You need to retrieve data into some variable to be able to use it later:

    p := Profile{}
    res := db.Where("Number = ?", inumber).First(&p)
    
    // now use p
    log.Printf("%+v", p)
    
    打赏 评论

相关推荐 更多相似问题