duanbenzan4050
2016-07-08 15:16 阅读 263
已采纳

Golang Gorm:是否可以通过many2many关系删除记录?

I have a many2many structure similar to GORM's example:

// User has and belongs to many languages, use `user_languages` as join table
type User struct {
    gorm.Model
    Languages         []Language `gorm:"many2many:user_languages;"`
}

type Language struct {
    gorm.Model
    Name string
}

db.Model(&user).Related(&languages)

Let's say I create a user and it has two associated languages.

I fetch a user record from the database and remove one language from the user's Languages array. I then save the user with gorm:save_associations set to true.

I would expect GORM to delete the record associating the user to this language (in the association table that GORM manages). However, it is not deleted. Is this expected?

Is it possible to delete many2many association records by removing a language from the Languages list on the user record and then saving the user? If not, how should this be done in GORM?

Update

I found a solution to this question, but not sure it's the best way to do this. I store the current languages, clear all the associations, then add back the languages, then save.

languages := user.Languages
DB.Model(&user).Association("Languages").Clear()
user.Languages = languages
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

3条回答 默认 最新

  • 已采纳
    douying9296 douying9296 2016-07-08 21:15

    I found a solution to this question, but not sure it's the best way to do this. I store the current languages, clear all the associations, then add back the languages, then save.

    languages := user.Languages 
    DB.Model(&user).Association("Languages").Clear()
    user.Languages = languages
    
    点赞 评论 复制链接分享
  • doulin2555 doulin2555 2016-07-12 05:29

    I was having the same problem, If you want to just remove one of the associations this worked for me

        c.DB.Model(&user).Association("Roles").Delete(&role)
    
    点赞 评论 复制链接分享
  • doukui4786 doukui4786 2017-09-15 16:49

    Also, you can do this by using "replace"

    DB.Model(&user).Association("Languages").Replace(user.Languages)
    
    点赞 评论 复制链接分享

相关推荐