token.go 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
  1. package model
  2. import (
  3. "errors"
  4. _ "gorm.io/driver/sqlite"
  5. "gorm.io/gorm"
  6. "one-api/common"
  7. "strings"
  8. )
  9. type Token struct {
  10. Id int `json:"id"`
  11. UserId int `json:"user_id"`
  12. Key string `json:"key" gorm:"type:char(32);uniqueIndex"`
  13. Status int `json:"status" gorm:"default:1"`
  14. Name string `json:"name" gorm:"index" `
  15. CreatedTime int64 `json:"created_time" gorm:"bigint"`
  16. AccessedTime int64 `json:"accessed_time" gorm:"bigint"`
  17. ExpiredTime int64 `json:"expired_time" gorm:"bigint;default:-1"` // -1 means never expired
  18. RemainTimes int `json:"remain_times" gorm:"default:0"`
  19. UnlimitedTimes bool `json:"unlimited_times" gorm:"default:false"`
  20. }
  21. func GetAllUserTokens(userId int, startIdx int, num int) ([]*Token, error) {
  22. var tokens []*Token
  23. var err error
  24. err = DB.Where("user_id = ?", userId).Order("id desc").Limit(num).Offset(startIdx).Find(&tokens).Error
  25. return tokens, err
  26. }
  27. func SearchUserTokens(userId int, keyword string) (tokens []*Token, err error) {
  28. err = DB.Where("user_id = ?", userId).Where("id = ? or name LIKE ?", keyword, keyword+"%").Find(&tokens).Error
  29. return tokens, err
  30. }
  31. func ValidateUserToken(key string) (token *Token, err error) {
  32. if key == "" {
  33. return nil, errors.New("未提供 token")
  34. }
  35. key = strings.Replace(key, "Bearer ", "", 1)
  36. token = &Token{}
  37. err = DB.Where("`key` = ?", key).First(token).Error
  38. if err == nil {
  39. if token.Status != common.TokenStatusEnabled {
  40. return nil, errors.New("该 token 状态不可用")
  41. }
  42. if token.ExpiredTime != -1 && token.ExpiredTime < common.GetTimestamp() {
  43. token.Status = common.TokenStatusExpired
  44. err := token.SelectUpdate()
  45. if err != nil {
  46. common.SysError("更新 token 状态失败:" + err.Error())
  47. }
  48. return nil, errors.New("该 token 已过期")
  49. }
  50. if !token.UnlimitedTimes && token.RemainTimes <= 0 {
  51. token.Status = common.TokenStatusExhausted
  52. err := token.SelectUpdate()
  53. if err != nil {
  54. common.SysError("更新 token 状态失败:" + err.Error())
  55. }
  56. return nil, errors.New("该 token 可用次数已用尽")
  57. }
  58. go func() {
  59. token.AccessedTime = common.GetTimestamp()
  60. err := token.SelectUpdate()
  61. if err != nil {
  62. common.SysError("更新 token 失败:" + err.Error())
  63. }
  64. }()
  65. return token, nil
  66. }
  67. return nil, errors.New("无效的 token")
  68. }
  69. func GetTokenByIds(id int, userId int) (*Token, error) {
  70. if id == 0 || userId == 0 {
  71. return nil, errors.New("id 或 userId 为空!")
  72. }
  73. token := Token{Id: id, UserId: userId}
  74. var err error = nil
  75. err = DB.First(&token, "id = ? and user_id = ?", id, userId).Error
  76. return &token, err
  77. }
  78. func (token *Token) Insert() error {
  79. var err error
  80. err = DB.Create(token).Error
  81. return err
  82. }
  83. // Update Make sure your token's fields is completed, because this will update non-zero values
  84. func (token *Token) Update() error {
  85. var err error
  86. err = DB.Model(token).Select("name", "status", "expired_time", "remain_times", "unlimited_times").Updates(token).Error
  87. return err
  88. }
  89. func (token *Token) SelectUpdate() error {
  90. // This can update zero values
  91. return DB.Model(token).Select("accessed_time", "status").Updates(token).Error
  92. }
  93. func (token *Token) Delete() error {
  94. var err error
  95. err = DB.Delete(token).Error
  96. return err
  97. }
  98. func DeleteTokenById(id int, userId int) (err error) {
  99. // Why we need userId here? In case user want to delete other's token.
  100. if id == 0 || userId == 0 {
  101. return errors.New("id 或 userId 为空!")
  102. }
  103. token := Token{Id: id, UserId: userId}
  104. err = DB.Where(token).First(&token).Error
  105. if err != nil {
  106. return err
  107. }
  108. return token.Delete()
  109. }
  110. func DecreaseTokenRemainTimesById(id int) (err error) {
  111. err = DB.Model(&Token{}).Where("id = ?", id).Update("remain_times", gorm.Expr("remain_times - ?", 1)).Error
  112. return err
  113. }
  114. func TopUpToken(id int, times int) (err error) {
  115. err = DB.Model(&Token{}).Where("id = ?", id).Update("remain_times", gorm.Expr("remain_times + ?", times)).Error
  116. return err
  117. }