我是Go gorm协会的新手。我有这样的代码:
package main
import (
_ "database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jinzhu/gorm"
)
type User struct {
ID uint `gorm:"primary_key"`
Name string
}
type Event struct {
ID uint `gorm:"primary_key"`
EventName string
Users []User `gorm:"many2many:event_reviews;"`
}
type EventReview struct {
UserID uint
EventID uint
Rating float64
Review string
}
func main() {
db, _ := gorm.Open("mysql", "root:@tcp(127.0.0.1:3306)/test1?charset=utf8&parseTime=True")
defer db.Close()
db.DropTableIfExists(&EventReview{}, &Event{}, &User{})
db.AutoMigrate(&User{}, &Event{}, &EventReview{})
//All foreign keys need to define here
db.Model(EventReview{}).AddForeignKey("user_id", "users(id)", "CASCADE", "CASCADE")
db.Model(EventReview{}).AddForeignKey("event_id", "events(id)", "CASCADE", "CASCADE")
user := User{Name: "John"}
db.Create(&user)
event := Event{EventName: "Learning Go"}
db.Create(&event)
eventReview := EventReview{UserID: user.ID, EventID: event.ID, Rating: 2.5, Review: "ExcelentEvent"}
db.Create(&eventReview)
//Fetching
eventFetch := &Event{}
db.Preload("Users").First(&eventFetch)
fmt.Println(eventFetch)
}
我有struct User,Event,Event Review。事件与用户有多对多的关系。我已经阅读了gorm docs associaton Gorm associaton many to many,但我很难从事件评论中获得数据。
结果打印:
&{1 Learning Go [{1 John}]}
预期结果:
&{1 Learning Go [{1 John 2.5 ExcelentEvent}]}
如何得到预期的结果?我使用多对多关系表是错误的吗?
发布于 2019-06-29 08:16:09
使用相关方法:
db.Model(&dm.User{}).Related(&dm.EventReview{}, "user_id")
res:=QueryByStructExample(dm.User{Email: "email@example.com})
func QueryByStructExample(userStruct User) []User {
var results []dm.User
GormDB.Where(userStruct).Find(&results)
return results
}
https://stackoverflow.com/questions/56815932
复制相似问题