CODEWITHSUNDEEP
mysqlgogo-gormlast-insert-id
sathishvj
sathishvj

Reputation: 1464

How can I retrieve instance of last added item

I'm using github.com/jinzhu/gorm with a mysql backend. I want to retrieve the Id (or the full entity) of the row in the previous Create call.

As in, last-insert-id: (http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id)

How can I do this?

Upvotes: 7

Views: 14438

Answers (2)

Nisal Edu
Nisal Edu

Reputation: 7591

Try as follows

type User struct {
  Id   int    `gorm:"column:id; PRIMARY_KEY" json:"id"`
  Name string `gorm:"column:name" json:"name"`
}

user := User{Name: "Andy"}
db.Save(&user)
// user.Id is set to last insert id

Upvotes: 2

Jinzhu
Jinzhu

Reputation: 535

type User struct {
  Id int
  Name string
}

user := User{Name: "jinzhu"}
db.Save(&user)
// user.Id is set to last insert id

Upvotes: 19

Related Questions