user.go 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. package model
  2. import (
  3. "database/sql/driver"
  4. "fmt"
  5. "time"
  6. )
  7. /* code 结构体 */
  8. type CodeData struct {
  9. Code string `form:"code" binding:"required"`
  10. Gid string `form:"gid" binding:"required"`
  11. Pf string `form:"pf" binding:"required"`
  12. Secret string `form:"secret"`
  13. }
  14. type Users struct {
  15. ID int `json:"id" gorm:"not null;"`
  16. OpenId string `json:"openId" gorm:"not null;column:openId;"`
  17. Pf string `json:"pf" gorm:"not null;"`
  18. UserId int `json:"userId" gorm:"not null;column:userId;"`
  19. CreatedAt time.Time `json:"createdAt" gorm:"column:createdAt;"`
  20. UpdatedAt time.Time `json:"updatedAt" gorm:"column:updatedAt;"`
  21. }
  22. type User struct {
  23. ID int `json:"id" gorm:"not null;"`
  24. Pf string `json:"pf" gorm:"not null;"`
  25. Gid string `json:"gid" gorm:"not null;"`
  26. UserId int `json:"userId" gorm:"not null;column:userId;"`
  27. CreatedAt time.Time `json:"createdAt" gorm:"column:createdAt;"`
  28. }
  29. type UserLogin struct {
  30. ID int `json:"id" gorm:"not null;"`
  31. Pf string `json:"pf" gorm:"not null;"`
  32. Gid string `json:"gid" gorm:"not null;"`
  33. UserId int `json:"userId" gorm:"not null;column:userId;"`
  34. LoginTime time.Time `json:"loginTime" gorm:"column:loginTime;"`
  35. }
  36. type UserOnline struct {
  37. ID int `json:"id" gorm:"not null;"`
  38. Pf string `json:"pf" gorm:"not null;"`
  39. Gid string `json:"gid" gorm:"not null;"`
  40. Type int `json:"type" gorm:"not null;"`
  41. UserId int `json:"userId" gorm:"not null;column:userId;"`
  42. LogTime time.Time `json:"logTime" gorm:"column:logTime;"`
  43. }
  44. // 1. 创建 time.Time 类型的副本 XTime;
  45. type XTime struct {
  46. time.Time
  47. }
  48. // 2. 为 Xtime 重写 MarshaJSON 方法,在此方法中实现自定义格式的转换;
  49. func (t XTime) MarshalJSON() ([]byte, error) {
  50. output := fmt.Sprintf("\"%s\"", t.Format("2006-01-02 15:04:05"))
  51. return []byte(output), nil
  52. }
  53. // 3. 为 Xtime 实现 Value 方法,写入数据库时会调用该方法将自定义时间类型转换并写入数据库;
  54. func (t XTime) Value() (driver.Value, error) {
  55. var zeroTime time.Time
  56. if t.Time.UnixNano() == zeroTime.UnixNano() {
  57. return nil, nil
  58. }
  59. return t.Time, nil
  60. }
  61. // 4. 为 Xtime 实现 Scan 方法,读取数据库时会调用该方法将时间数据转换成自定义时间类型;
  62. func (t *XTime) Scan(v interface{}) error {
  63. value, ok := v.(time.Time)
  64. if ok {
  65. *t = XTime{Time: value}
  66. return nil
  67. }
  68. return fmt.Errorf("can not convert %v to timestamp", v)
  69. }
  70. type GameAction struct {
  71. ID int `json:"id" gorm:"not null;"`
  72. Gid string `json:"gid" gorm:"not null;"`
  73. ActionId string `json:"actionId" gorm:"not null;column:actionId;"`
  74. ActionName string `json:"actionName" gorm:"not null;column:actionName;"`
  75. Status int `json:"status" gorm:"not null;column:status;"`
  76. Remark string `json:"remark" gorm:"not null;column:remark;"`
  77. CreatedAt XTime `json:"createdAt" gorm:"column:createdAt;type:date;"`
  78. UpdatedAt XTime `json:"updatedAt" gorm:"column:updatedAt;type:date;"`
  79. }
  80. type GameActionOption struct {
  81. ID int `json:"id" gorm:"not null;"`
  82. ActionId int `json:"actionId" gorm:"not null;column:actionId;"`
  83. OptionId string `json:"optionId" gorm:"not null;column:optionId;"`
  84. OptionName string `json:"optionName" gorm:"not null;column:optionName;"`
  85. OptionType string `json:"optionType" gorm:"not null;column:optionType;"`
  86. Status int `json:"status" gorm:"not null;column:status;"`
  87. CreatedAt XTime `json:"createdAt" gorm:"column:createdAt;"`
  88. UpdatedAt XTime `json:"updatedAt" gorm:"column:updatedAt;"`
  89. }
  90. type UserAction struct {
  91. ID int `json:"id" gorm:"not null;"`
  92. Pf string `json:"pf" gorm:"not null;"`
  93. Gid string `json:"gid" gorm:"not null;"`
  94. ActionId string `json:"actionId" gorm:"not null;column:actionId;"`
  95. UserId int `json:"userId" gorm:"not null;column:userId;"`
  96. CreatedAt XTime `json:"createdAt" gorm:"column:createdAt;type:date;"`
  97. Data string `json:"data" gorm:"not null;column:data;"`
  98. }