CODEWITHSUNDEEP
mysqldatabasegogo-gorm
kckaiwei
kckaiwei

Reputation: 426

How do I extract the data from a query in Golang's GORM in mysql?

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

Upvotes: 6

Views: 6640

Answers (1)

hsrv
hsrv

Reputation: 1570

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)

Upvotes: 8

Related Questions