token.go 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364
  1. package model
  2. import (
  3. "errors"
  4. "fmt"
  5. "strings"
  6. "github.com/QuantumNous/new-api/common"
  7. "github.com/bytedance/gopkg/util/gopool"
  8. "gorm.io/gorm"
  9. )
  10. type Token struct {
  11. Id int `json:"id"`
  12. UserId int `json:"user_id" gorm:"index"`
  13. Key string `json:"key" gorm:"type:char(48);uniqueIndex"`
  14. Status int `json:"status" gorm:"default:1"`
  15. Name string `json:"name" gorm:"index" `
  16. CreatedTime int64 `json:"created_time" gorm:"bigint"`
  17. AccessedTime int64 `json:"accessed_time" gorm:"bigint"`
  18. ExpiredTime int64 `json:"expired_time" gorm:"bigint;default:-1"` // -1 means never expired
  19. RemainQuota int `json:"remain_quota" gorm:"default:0"`
  20. UnlimitedQuota bool `json:"unlimited_quota"`
  21. ModelLimitsEnabled bool `json:"model_limits_enabled"`
  22. ModelLimits string `json:"model_limits" gorm:"type:varchar(1024);default:''"`
  23. AllowIps *string `json:"allow_ips" gorm:"default:''"`
  24. UsedQuota int `json:"used_quota" gorm:"default:0"` // used quota
  25. Group string `json:"group" gorm:"default:''"`
  26. CrossGroupRetry bool `json:"cross_group_retry" gorm:"default:false"` // 跨分组重试,仅auto分组有效
  27. DeletedAt gorm.DeletedAt `gorm:"index"`
  28. }
  29. func (token *Token) Clean() {
  30. token.Key = ""
  31. }
  32. func (token *Token) GetIpLimits() []string {
  33. // delete empty spaces
  34. //split with \n
  35. ipLimits := make([]string, 0)
  36. if token.AllowIps == nil {
  37. return ipLimits
  38. }
  39. cleanIps := strings.ReplaceAll(*token.AllowIps, " ", "")
  40. if cleanIps == "" {
  41. return ipLimits
  42. }
  43. ips := strings.Split(cleanIps, "\n")
  44. for _, ip := range ips {
  45. ip = strings.TrimSpace(ip)
  46. ip = strings.ReplaceAll(ip, ",", "")
  47. if ip != "" {
  48. ipLimits = append(ipLimits, ip)
  49. }
  50. }
  51. return ipLimits
  52. }
  53. func GetAllUserTokens(userId int, startIdx int, num int) ([]*Token, error) {
  54. var tokens []*Token
  55. var err error
  56. err = DB.Where("user_id = ?", userId).Order("id desc").Limit(num).Offset(startIdx).Find(&tokens).Error
  57. return tokens, err
  58. }
  59. func SearchUserTokens(userId int, keyword string, token string) (tokens []*Token, err error) {
  60. if token != "" {
  61. token = strings.Trim(token, "sk-")
  62. }
  63. err = DB.Where("user_id = ?", userId).Where("name LIKE ?", "%"+keyword+"%").Where(commonKeyCol+" LIKE ?", "%"+token+"%").Find(&tokens).Error
  64. return tokens, err
  65. }
  66. func ValidateUserToken(key string) (token *Token, err error) {
  67. if key == "" {
  68. return nil, errors.New("未提供令牌")
  69. }
  70. token, err = GetTokenByKey(key, false)
  71. if err == nil {
  72. if token.Status == common.TokenStatusExhausted {
  73. keyPrefix := key[:3]
  74. keySuffix := key[len(key)-3:]
  75. return token, errors.New("该令牌额度已用尽 TokenStatusExhausted[sk-" + keyPrefix + "***" + keySuffix + "]")
  76. } else if token.Status == common.TokenStatusExpired {
  77. return token, errors.New("该令牌已过期")
  78. }
  79. if token.Status != common.TokenStatusEnabled {
  80. return token, errors.New("该令牌状态不可用")
  81. }
  82. if token.ExpiredTime != -1 && token.ExpiredTime < common.GetTimestamp() {
  83. if !common.RedisEnabled {
  84. token.Status = common.TokenStatusExpired
  85. err := token.SelectUpdate()
  86. if err != nil {
  87. common.SysLog("failed to update token status" + err.Error())
  88. }
  89. }
  90. return token, errors.New("该令牌已过期")
  91. }
  92. if !token.UnlimitedQuota && token.RemainQuota <= 0 {
  93. if !common.RedisEnabled {
  94. // in this case, we can make sure the token is exhausted
  95. token.Status = common.TokenStatusExhausted
  96. err := token.SelectUpdate()
  97. if err != nil {
  98. common.SysLog("failed to update token status" + err.Error())
  99. }
  100. }
  101. keyPrefix := key[:3]
  102. keySuffix := key[len(key)-3:]
  103. return token, errors.New(fmt.Sprintf("[sk-%s***%s] 该令牌额度已用尽 !token.UnlimitedQuota && token.RemainQuota = %d", keyPrefix, keySuffix, token.RemainQuota))
  104. }
  105. return token, nil
  106. }
  107. return nil, errors.New("无效的令牌")
  108. }
  109. func GetTokenByIds(id int, userId int) (*Token, error) {
  110. if id == 0 || userId == 0 {
  111. return nil, errors.New("id 或 userId 为空!")
  112. }
  113. token := Token{Id: id, UserId: userId}
  114. var err error = nil
  115. err = DB.First(&token, "id = ? and user_id = ?", id, userId).Error
  116. return &token, err
  117. }
  118. func GetTokenById(id int) (*Token, error) {
  119. if id == 0 {
  120. return nil, errors.New("id 为空!")
  121. }
  122. token := Token{Id: id}
  123. var err error = nil
  124. err = DB.First(&token, "id = ?", id).Error
  125. if shouldUpdateRedis(true, err) {
  126. gopool.Go(func() {
  127. if err := cacheSetToken(token); err != nil {
  128. common.SysLog("failed to update user status cache: " + err.Error())
  129. }
  130. })
  131. }
  132. return &token, err
  133. }
  134. func GetTokenByKey(key string, fromDB bool) (token *Token, err error) {
  135. defer func() {
  136. // Update Redis cache asynchronously on successful DB read
  137. if shouldUpdateRedis(fromDB, err) && token != nil {
  138. gopool.Go(func() {
  139. if err := cacheSetToken(*token); err != nil {
  140. common.SysLog("failed to update user status cache: " + err.Error())
  141. }
  142. })
  143. }
  144. }()
  145. if !fromDB && common.RedisEnabled {
  146. // Try Redis first
  147. token, err := cacheGetTokenByKey(key)
  148. if err == nil {
  149. return token, nil
  150. }
  151. // Don't return error - fall through to DB
  152. }
  153. fromDB = true
  154. err = DB.Where(commonKeyCol+" = ?", key).First(&token).Error
  155. return token, err
  156. }
  157. func (token *Token) Insert() error {
  158. var err error
  159. err = DB.Create(token).Error
  160. return err
  161. }
  162. // Update Make sure your token's fields is completed, because this will update non-zero values
  163. func (token *Token) Update() (err error) {
  164. defer func() {
  165. if shouldUpdateRedis(true, err) {
  166. gopool.Go(func() {
  167. err := cacheSetToken(*token)
  168. if err != nil {
  169. common.SysLog("failed to update token cache: " + err.Error())
  170. }
  171. })
  172. }
  173. }()
  174. err = DB.Model(token).Select("name", "status", "expired_time", "remain_quota", "unlimited_quota",
  175. "model_limits_enabled", "model_limits", "allow_ips", "group", "cross_group_retry").Updates(token).Error
  176. return err
  177. }
  178. func (token *Token) SelectUpdate() (err error) {
  179. defer func() {
  180. if shouldUpdateRedis(true, err) {
  181. gopool.Go(func() {
  182. err := cacheSetToken(*token)
  183. if err != nil {
  184. common.SysLog("failed to update token cache: " + err.Error())
  185. }
  186. })
  187. }
  188. }()
  189. // This can update zero values
  190. return DB.Model(token).Select("accessed_time", "status").Updates(token).Error
  191. }
  192. func (token *Token) Delete() (err error) {
  193. defer func() {
  194. if shouldUpdateRedis(true, err) {
  195. gopool.Go(func() {
  196. err := cacheDeleteToken(token.Key)
  197. if err != nil {
  198. common.SysLog("failed to delete token cache: " + err.Error())
  199. }
  200. })
  201. }
  202. }()
  203. err = DB.Delete(token).Error
  204. return err
  205. }
  206. func (token *Token) IsModelLimitsEnabled() bool {
  207. return token.ModelLimitsEnabled
  208. }
  209. func (token *Token) GetModelLimits() []string {
  210. if token.ModelLimits == "" {
  211. return []string{}
  212. }
  213. return strings.Split(token.ModelLimits, ",")
  214. }
  215. func (token *Token) GetModelLimitsMap() map[string]bool {
  216. limits := token.GetModelLimits()
  217. limitsMap := make(map[string]bool)
  218. for _, limit := range limits {
  219. limitsMap[limit] = true
  220. }
  221. return limitsMap
  222. }
  223. func DisableModelLimits(tokenId int) error {
  224. token, err := GetTokenById(tokenId)
  225. if err != nil {
  226. return err
  227. }
  228. token.ModelLimitsEnabled = false
  229. token.ModelLimits = ""
  230. return token.Update()
  231. }
  232. func DeleteTokenById(id int, userId int) (err error) {
  233. // Why we need userId here? In case user want to delete other's token.
  234. if id == 0 || userId == 0 {
  235. return errors.New("id 或 userId 为空!")
  236. }
  237. token := Token{Id: id, UserId: userId}
  238. err = DB.Where(token).First(&token).Error
  239. if err != nil {
  240. return err
  241. }
  242. return token.Delete()
  243. }
  244. func IncreaseTokenQuota(id int, key string, quota int) (err error) {
  245. if quota < 0 {
  246. return errors.New("quota 不能为负数!")
  247. }
  248. if common.RedisEnabled {
  249. gopool.Go(func() {
  250. err := cacheIncrTokenQuota(key, int64(quota))
  251. if err != nil {
  252. common.SysLog("failed to increase token quota: " + err.Error())
  253. }
  254. })
  255. }
  256. if common.BatchUpdateEnabled {
  257. addNewRecord(BatchUpdateTypeTokenQuota, id, quota)
  258. return nil
  259. }
  260. return increaseTokenQuota(id, quota)
  261. }
  262. func increaseTokenQuota(id int, quota int) (err error) {
  263. err = DB.Model(&Token{}).Where("id = ?", id).Updates(
  264. map[string]interface{}{
  265. "remain_quota": gorm.Expr("remain_quota + ?", quota),
  266. "used_quota": gorm.Expr("used_quota - ?", quota),
  267. "accessed_time": common.GetTimestamp(),
  268. },
  269. ).Error
  270. return err
  271. }
  272. func DecreaseTokenQuota(id int, key string, quota int) (err error) {
  273. if quota < 0 {
  274. return errors.New("quota 不能为负数!")
  275. }
  276. if common.RedisEnabled {
  277. gopool.Go(func() {
  278. err := cacheDecrTokenQuota(key, int64(quota))
  279. if err != nil {
  280. common.SysLog("failed to decrease token quota: " + err.Error())
  281. }
  282. })
  283. }
  284. if common.BatchUpdateEnabled {
  285. addNewRecord(BatchUpdateTypeTokenQuota, id, -quota)
  286. return nil
  287. }
  288. return decreaseTokenQuota(id, quota)
  289. }
  290. func decreaseTokenQuota(id int, quota int) (err error) {
  291. err = DB.Model(&Token{}).Where("id = ?", id).Updates(
  292. map[string]interface{}{
  293. "remain_quota": gorm.Expr("remain_quota - ?", quota),
  294. "used_quota": gorm.Expr("used_quota + ?", quota),
  295. "accessed_time": common.GetTimestamp(),
  296. },
  297. ).Error
  298. return err
  299. }
  300. // CountUserTokens returns total number of tokens for the given user, used for pagination
  301. func CountUserTokens(userId int) (int64, error) {
  302. var total int64
  303. err := DB.Model(&Token{}).Where("user_id = ?", userId).Count(&total).Error
  304. return total, err
  305. }
  306. // BatchDeleteTokens 删除指定用户的一组令牌,返回成功删除数量
  307. func BatchDeleteTokens(ids []int, userId int) (int, error) {
  308. if len(ids) == 0 {
  309. return 0, errors.New("ids 不能为空!")
  310. }
  311. tx := DB.Begin()
  312. var tokens []Token
  313. if err := tx.Where("user_id = ? AND id IN (?)", userId, ids).Find(&tokens).Error; err != nil {
  314. tx.Rollback()
  315. return 0, err
  316. }
  317. if err := tx.Where("user_id = ? AND id IN (?)", userId, ids).Delete(&Token{}).Error; err != nil {
  318. tx.Rollback()
  319. return 0, err
  320. }
  321. if err := tx.Commit().Error; err != nil {
  322. return 0, err
  323. }
  324. if common.RedisEnabled {
  325. gopool.Go(func() {
  326. for _, t := range tokens {
  327. _ = cacheDeleteToken(t.Key)
  328. }
  329. })
  330. }
  331. return len(tokens), nil
  332. }