英文:
How to create two join tables with go-gorm [Go]
问题
每次运行AutoMigrate()时，我都会收到错误level=fatal msg="failed to found relation: 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;" json:"-"`}
这是我的友谊模型：
type Friendship struct {gorm.ModelFromUserId 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 stringFriendshipID uintAccepted 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}
英文:
Every time i run AutoMigrate() I get the error level=fatal msg="failed to found relation: UserFriends"
here is my user model
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;"`
}
here is my friendship model
type Friendship struct {gorm.ModelFromUserId 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"`
}
here is my user friend model
type UserFriend struct {UserUUID stringFriendshipID uintAccepted bool
}
and my migration code
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
}
答案1
得分: 1
你应该在这里使用"自引用多对多"的关系。这里有一个很好的例子，展示了用户之间的好友关系。
英文:
You should use Self Referential Many to Many relationship here. Here is a nice example of user friend relationship.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论