如何使用go-gorm [Go]创建两个连接表

Question

每次运行AutoMigrate()时，我都会得到错误level=fatal msg=“未能找到关系: UserFriends”

这是我的用户模型

type User struct {
UUID          string         `gorm:"primaryKey;unique;not null" json:"user_id"`
Email         string         `gorm:"unique;not null" json:"email" binding:"required,email"`
Password      string         `gorm:"-:all" json:"password"`
DisplayName   string         `gorm:"unique;not null" json:"display_name" binding:"required"`
FirstName     string         `gorm:"not null" json:"first_name" binding:"required"`
LastName      string         `gorm:"not null" json:"last_name" binding:"required"`
PhoneNumber   string         `gorm:"unique;not null" json:"phone_number" binding:"required"`
DateOfBirth   string         `gorm:"not null" json:"date_of_birth" binding:"required"`
EmailVerified bool           `json:"email_verified"`
PhoneVerified bool           `json:"phone_verified"`
PhotoURL      string         `json:"photo_url" binding:"omitempty,url"`
UpdatedAt     time.Time      `json:"updated_at"`
CreatedAt     time.Time      `gorm:"autoCreateTime" json:"created_at"`
DeletedAt     gorm.DeletedAt `gorm:"index" json:"deleted_at"`
RefreshToken  string         `json:"refresh_token"`
Friendship    []Friendship   `gorm:"many2many:users_friendships;"`

}

这是我的友谊模型

type Friendship struct {
gorm.Model
FromUserId   string    `gorm:"primaryKey" json:"from_user"`
ToUserId     string    `gorm:"primaryKey" json:"to_user" binding:"required"`
SentTime     time.Time `json:"sent_time"`
ResponseTime time.Time `json:"response_time"`
Accepted     bool      `json:"accepted"`

}

这是我的用户朋友模型

type UserFriend struct {
UserUUID     string
FriendshipID uint
Accepted     bool

}

以及我的迁移代码

func MigrateDB(db *gorm.DB) error {
err := db.SetupJoinTable(&domain.User{}, "UserFriends", &domain.Friendship{})
if err != nil {
    return err
}

err = db.AutoMigrate(&domain.User{}, &domain.Friendship{}, &joins.UserFriend{})
if err != nil {
    return err
}

return nil

}

Answer 1

您应该在这里使用Self Referential Many to Many关系。这里是一个很好的示例的用户朋友关系。