GORM 2.0 get last insert ID

user_15354902 0
Viewed 3513

I'm operating on a MySQL database using GORM v 2.0. I'm inserting row into database using GORM transaction (tx := db.Begin()). In previous GORM versions, Begin() returned sql.Tx object that allowed to use LastInsertId() method on query return parameter.

To do that in GORM v 2.0, i can simply call db.Last() function after insert row into database, or i can use smarter method?

Thank you.

go-gorm go mysql sql
1 Answers

In V2.0 the GetLastInsertId method was removed. As @rustyx says, the ID is populated in the model you pass the Create function. I wouldn't bother calling db.Last(&...) as this is a bit of a waste when the model will already have it.

    type User struct {
        gorm.Model
        Name string
    }

    user1 := User{Name: "User One"}

    _ = db.Transaction(func(tx *gorm.DB) error {
        tx.Create(&user1)
        return nil
    })

    // This is unnecessary
    // db.Last(&user1)

    fmt.Printf("User one ID: %d\n", user1.ID)
user_46475590
Related