model_meta.go 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
  1. package model
  2. import (
  3. "one-api/common"
  4. "strconv"
  5. "gorm.io/gorm"
  6. )
  7. const (
  8. NameRuleExact = iota
  9. NameRulePrefix
  10. NameRuleContains
  11. NameRuleSuffix
  12. )
  13. type BoundChannel struct {
  14. Name string `json:"name"`
  15. Type int `json:"type"`
  16. }
  17. type Model struct {
  18. Id int `json:"id"`
  19. ModelName string `json:"model_name" gorm:"size:128;not null;uniqueIndex:uk_model_name_delete_at,priority:1"`
  20. Description string `json:"description,omitempty" gorm:"type:text"`
  21. Icon string `json:"icon,omitempty" gorm:"type:varchar(128)"`
  22. Tags string `json:"tags,omitempty" gorm:"type:varchar(255)"`
  23. VendorID int `json:"vendor_id,omitempty" gorm:"index"`
  24. Endpoints string `json:"endpoints,omitempty" gorm:"type:text"`
  25. Status int `json:"status" gorm:"default:1"`
  26. CreatedTime int64 `json:"created_time" gorm:"bigint"`
  27. UpdatedTime int64 `json:"updated_time" gorm:"bigint"`
  28. DeletedAt gorm.DeletedAt `json:"-" gorm:"index;uniqueIndex:uk_model_name_delete_at,priority:2"`
  29. BoundChannels []BoundChannel `json:"bound_channels,omitempty" gorm:"-"`
  30. EnableGroups []string `json:"enable_groups,omitempty" gorm:"-"`
  31. QuotaTypes []int `json:"quota_types,omitempty" gorm:"-"`
  32. NameRule int `json:"name_rule" gorm:"default:0"`
  33. MatchedModels []string `json:"matched_models,omitempty" gorm:"-"`
  34. MatchedCount int `json:"matched_count,omitempty" gorm:"-"`
  35. }
  36. func (mi *Model) Insert() error {
  37. now := common.GetTimestamp()
  38. mi.CreatedTime = now
  39. mi.UpdatedTime = now
  40. return DB.Create(mi).Error
  41. }
  42. func IsModelNameDuplicated(id int, name string) (bool, error) {
  43. if name == "" {
  44. return false, nil
  45. }
  46. var cnt int64
  47. err := DB.Model(&Model{}).Where("model_name = ? AND id <> ?", name, id).Count(&cnt).Error
  48. return cnt > 0, err
  49. }
  50. func (mi *Model) Update() error {
  51. mi.UpdatedTime = common.GetTimestamp()
  52. return DB.Session(&gorm.Session{AllowGlobalUpdate: false, FullSaveAssociations: false}).
  53. Model(&Model{}).
  54. Where("id = ?", mi.Id).
  55. Omit("created_time").
  56. Select("*").
  57. Updates(mi).Error
  58. }
  59. func (mi *Model) Delete() error {
  60. return DB.Delete(mi).Error
  61. }
  62. func GetVendorModelCounts() (map[int64]int64, error) {
  63. var stats []struct {
  64. VendorID int64
  65. Count int64
  66. }
  67. if err := DB.Model(&Model{}).
  68. Select("vendor_id as vendor_id, count(*) as count").
  69. Group("vendor_id").
  70. Scan(&stats).Error; err != nil {
  71. return nil, err
  72. }
  73. m := make(map[int64]int64, len(stats))
  74. for _, s := range stats {
  75. m[s.VendorID] = s.Count
  76. }
  77. return m, nil
  78. }
  79. func GetAllModels(offset int, limit int) ([]*Model, error) {
  80. var models []*Model
  81. err := DB.Order("id DESC").Offset(offset).Limit(limit).Find(&models).Error
  82. return models, err
  83. }
  84. func GetBoundChannelsByModelsMap(modelNames []string) (map[string][]BoundChannel, error) {
  85. result := make(map[string][]BoundChannel)
  86. if len(modelNames) == 0 {
  87. return result, nil
  88. }
  89. type row struct {
  90. Model string
  91. Name string
  92. Type int
  93. }
  94. var rows []row
  95. err := DB.Table("channels").
  96. Select("abilities.model as model, channels.name as name, channels.type as type").
  97. Joins("JOIN abilities ON abilities.channel_id = channels.id").
  98. Where("abilities.model IN ? AND abilities.enabled = ?", modelNames, true).
  99. Distinct().
  100. Scan(&rows).Error
  101. if err != nil {
  102. return nil, err
  103. }
  104. for _, r := range rows {
  105. result[r.Model] = append(result[r.Model], BoundChannel{Name: r.Name, Type: r.Type})
  106. }
  107. return result, nil
  108. }
  109. func SearchModels(keyword string, vendor string, offset int, limit int) ([]*Model, int64, error) {
  110. var models []*Model
  111. db := DB.Model(&Model{})
  112. if keyword != "" {
  113. like := "%" + keyword + "%"
  114. db = db.Where("model_name LIKE ? OR description LIKE ? OR tags LIKE ?", like, like, like)
  115. }
  116. if vendor != "" {
  117. if vid, err := strconv.Atoi(vendor); err == nil {
  118. db = db.Where("models.vendor_id = ?", vid)
  119. } else {
  120. db = db.Joins("JOIN vendors ON vendors.id = models.vendor_id").Where("vendors.name LIKE ?", "%"+vendor+"%")
  121. }
  122. }
  123. var total int64
  124. if err := db.Count(&total).Error; err != nil {
  125. return nil, 0, err
  126. }
  127. if err := db.Order("models.id DESC").Offset(offset).Limit(limit).Find(&models).Error; err != nil {
  128. return nil, 0, err
  129. }
  130. return models, total, nil
  131. }