tableBadges.go (539B)
1 package database 2 3 import "time" 4 5 type Badge struct { 6 ID int64 7 Name string 8 CreatedAt time.Time 9 } 10 11 type UserBadge struct { 12 UserID UserID 13 BadgeID int64 14 CreatedAt time.Time 15 User User 16 Badge Badge 17 } 18 19 func (d *DkfDB) CreateUserBadge(userID UserID, badgeID int64) error { 20 ub := UserBadge{UserID: userID, BadgeID: badgeID} 21 return d.db.Create(&ub).Error 22 } 23 24 func (d *DkfDB) GetUsersBadges() (out []UserBadge, err error) { 25 err = d.db.Preload("User").Preload("Badge").Order("created_at").Find(&out).Error 26 return 27 }