How can I retrieve instance of last added item

Question

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?

score 18 · Accepted Answer · edited Oct 19 '17 at 03:21

18

type User struct {
  Id int
  Name string
}

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

edited Oct 19 '17 at 03:21

Community

1
1

answered Feb 28 '15 at 01:12

Jinzhu

485
4
8

1

I wasn't passing it as a pointer! It works well now. Meanwhile, thank you for a very useful library. – sathishvj Mar 01 '15 at 22:10

score 3 · Answer 2 · answered Oct 16 '18 at 07:27

3

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

answered Oct 16 '18 at 07:27

Nisal Edu

7,237
4
28
34

Can't we do this via db.Create? – balaaagi Apr 02 '19 at 02:38
@BalajiSrinivasan you can but Create insert the value into database and Save update value in database, if the value doesn't have primary key, will insert it – Nisal Edu Apr 02 '19 at 04:43

How can I retrieve instance of last added item

2 Answers2

Linked