index.go 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
  1. package schema
  2. import (
  3. "sort"
  4. "strconv"
  5. "strings"
  6. )
  7. type Index struct {
  8. Name string
  9. Class string // UNIQUE | FULLTEXT | SPATIAL
  10. Type string // btree, hash, gist, spgist, gin, and brin
  11. Where string
  12. Comment string
  13. Option string // WITH PARSER parser_name
  14. Fields []IndexOption
  15. }
  16. type IndexOption struct {
  17. *Field
  18. Expression string
  19. Sort string // DESC, ASC
  20. Collate string
  21. Length int
  22. priority int
  23. }
  24. // ParseIndexes parse schema indexes
  25. func (schema *Schema) ParseIndexes() map[string]Index {
  26. var indexes = map[string]Index{}
  27. for _, field := range schema.Fields {
  28. if field.TagSettings["INDEX"] != "" || field.TagSettings["UNIQUEINDEX"] != "" {
  29. for _, index := range parseFieldIndexes(field) {
  30. idx := indexes[index.Name]
  31. idx.Name = index.Name
  32. if idx.Class == "" {
  33. idx.Class = index.Class
  34. }
  35. if idx.Type == "" {
  36. idx.Type = index.Type
  37. }
  38. if idx.Where == "" {
  39. idx.Where = index.Where
  40. }
  41. if idx.Comment == "" {
  42. idx.Comment = index.Comment
  43. }
  44. if idx.Option == "" {
  45. idx.Option = index.Option
  46. }
  47. idx.Fields = append(idx.Fields, index.Fields...)
  48. sort.Slice(idx.Fields, func(i, j int) bool {
  49. return idx.Fields[i].priority < idx.Fields[j].priority
  50. })
  51. indexes[index.Name] = idx
  52. }
  53. }
  54. }
  55. return indexes
  56. }
  57. func (schema *Schema) LookIndex(name string) *Index {
  58. if schema != nil {
  59. indexes := schema.ParseIndexes()
  60. for _, index := range indexes {
  61. if index.Name == name {
  62. return &index
  63. }
  64. for _, field := range index.Fields {
  65. if field.Name == name {
  66. return &index
  67. }
  68. }
  69. }
  70. }
  71. return nil
  72. }
  73. func parseFieldIndexes(field *Field) (indexes []Index) {
  74. for _, value := range strings.Split(field.Tag.Get("gorm"), ";") {
  75. if value != "" {
  76. v := strings.Split(value, ":")
  77. k := strings.TrimSpace(strings.ToUpper(v[0]))
  78. if k == "INDEX" || k == "UNIQUEINDEX" {
  79. var (
  80. name string
  81. tag = strings.Join(v[1:], ":")
  82. idx = strings.Index(tag, ",")
  83. settings = ParseTagSetting(tag, ",")
  84. length, _ = strconv.Atoi(settings["LENGTH"])
  85. )
  86. if idx == -1 {
  87. idx = len(tag)
  88. }
  89. if idx != -1 {
  90. name = tag[0:idx]
  91. }
  92. if name == "" {
  93. name = field.Schema.namer.IndexName(field.Schema.Table, field.Name)
  94. }
  95. if (k == "UNIQUEINDEX") || settings["UNIQUE"] != "" {
  96. settings["CLASS"] = "UNIQUE"
  97. }
  98. priority, err := strconv.Atoi(settings["PRIORITY"])
  99. if err != nil {
  100. priority = 10
  101. }
  102. indexes = append(indexes, Index{
  103. Name: name,
  104. Class: settings["CLASS"],
  105. Type: settings["TYPE"],
  106. Where: settings["WHERE"],
  107. Comment: settings["COMMENT"],
  108. Option: settings["OPTION"],
  109. Fields: []IndexOption{{
  110. Field: field,
  111. Expression: settings["EXPRESSION"],
  112. Sort: settings["SORT"],
  113. Collate: settings["COLLATE"],
  114. Length: length,
  115. priority: priority,
  116. }},
  117. })
  118. }
  119. }
  120. }
  121. return
  122. }