user_poster.go 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. package service
  2. import (
  3. "context"
  4. "errors"
  5. "icloudapp.cn/tools/entity"
  6. "icloudapp.cn/tools/repository/mysql"
  7. "icloudapp.cn/tools/util"
  8. )
  9. type UserPoster struct {
  10. ctx context.Context
  11. }
  12. func NewPoster(ctx context.Context) *UserPoster {
  13. return &UserPoster{ctx}
  14. }
  15. func (p *UserPoster) TableName() string {
  16. return "user_poster"
  17. }
  18. func (p *UserPoster) InfoByID(posterID int64) (entity.UserPosterInfo, error) {
  19. var userPosterInfo entity.UserPosterInfo
  20. var userPoster entity.UserPoster
  21. userPoster.PosterID = posterID
  22. result := mysql.DBConn.Where("poster_id = ?", posterID).Table(p.TableName()).Find(&userPoster)
  23. if result.Error != nil {
  24. userPosterInfo.Code = entity.CodeServerBusy
  25. userPosterInfo.Msg = entity.CodeServerBusy.Msg()
  26. return userPosterInfo, errors.New(result.Error.Error())
  27. }
  28. if result.RowsAffected == 0 {
  29. userPosterInfo.Code = entity.CodeDataDoesNotExist
  30. userPosterInfo.Msg = entity.CodeDataDoesNotExist.Msg()
  31. return userPosterInfo, util.NewError("未找到相关数据")
  32. }
  33. userPosterInfo.Body = userPoster
  34. return userPosterInfo, nil
  35. }
  36. func (p *UserPoster) InfoByUUID(uuid int64) (entity.UserPosterInfo, error) {
  37. var userPosterInfo entity.UserPosterInfo
  38. var userPoster entity.UserPoster
  39. userPoster.PosterID = uuid
  40. result := mysql.DBConn.Where("uuid = ?", uuid).Table(p.TableName()).Find(&userPoster)
  41. if result.Error != nil {
  42. userPosterInfo.Code = entity.CodeServerBusy
  43. userPosterInfo.Msg = entity.CodeServerBusy.Msg()
  44. return userPosterInfo, errors.New(result.Error.Error())
  45. }
  46. if result.RowsAffected == 0 {
  47. userPosterInfo.Code = entity.CodeDataDoesNotExist
  48. userPosterInfo.Msg = entity.CodeDataDoesNotExist.Msg()
  49. return userPosterInfo, util.NewError("未找到相关数据")
  50. }
  51. userPosterInfo.Body = userPoster
  52. return userPosterInfo, nil
  53. }