query_part.go 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175
  1. package influxdb
  2. import (
  3. "fmt"
  4. "strings"
  5. "time"
  6. "github.com/grafana/grafana/pkg/tsdb"
  7. )
  8. var renders map[string]QueryDefinition
  9. type DefinitionParameters struct {
  10. Name string
  11. Type string
  12. }
  13. type QueryDefinition struct {
  14. Renderer func(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string
  15. Params []DefinitionParameters
  16. }
  17. func init() {
  18. renders = make(map[string]QueryDefinition)
  19. renders["field"] = QueryDefinition{Renderer: fieldRenderer}
  20. renders["spread"] = QueryDefinition{Renderer: functionRenderer}
  21. renders["count"] = QueryDefinition{Renderer: functionRenderer}
  22. renders["distinct"] = QueryDefinition{Renderer: functionRenderer}
  23. renders["integral"] = QueryDefinition{Renderer: functionRenderer}
  24. renders["mean"] = QueryDefinition{Renderer: functionRenderer}
  25. renders["median"] = QueryDefinition{Renderer: functionRenderer}
  26. renders["sum"] = QueryDefinition{Renderer: functionRenderer}
  27. renders["holt_winters"] = QueryDefinition{
  28. Renderer: functionRenderer,
  29. Params: []DefinitionParameters{{Name: "number", Type: "number"}, {Name: "season", Type: "number"}},
  30. }
  31. renders["holt_winters_with_fit"] = QueryDefinition{
  32. Renderer: functionRenderer,
  33. Params: []DefinitionParameters{{Name: "number", Type: "number"}, {Name: "season", Type: "number"}},
  34. }
  35. renders["derivative"] = QueryDefinition{
  36. Renderer: functionRenderer,
  37. Params: []DefinitionParameters{{Name: "duration", Type: "interval"}},
  38. }
  39. renders["non_negative_derivative"] = QueryDefinition{
  40. Renderer: functionRenderer,
  41. Params: []DefinitionParameters{{Name: "duration", Type: "interval"}},
  42. }
  43. renders["difference"] = QueryDefinition{Renderer: functionRenderer}
  44. renders["moving_average"] = QueryDefinition{
  45. Renderer: functionRenderer,
  46. Params: []DefinitionParameters{{Name: "window", Type: "number"}},
  47. }
  48. renders["stddev"] = QueryDefinition{Renderer: functionRenderer}
  49. renders["time"] = QueryDefinition{
  50. Renderer: functionRenderer,
  51. Params: []DefinitionParameters{{Name: "interval", Type: "time"}, {Name: "offset", Type: "time"}},
  52. }
  53. renders["fill"] = QueryDefinition{
  54. Renderer: functionRenderer,
  55. Params: []DefinitionParameters{{Name: "fill", Type: "string"}},
  56. }
  57. renders["elapsed"] = QueryDefinition{
  58. Renderer: functionRenderer,
  59. Params: []DefinitionParameters{{Name: "duration", Type: "interval"}},
  60. }
  61. renders["bottom"] = QueryDefinition{
  62. Renderer: functionRenderer,
  63. Params: []DefinitionParameters{{Name: "count", Type: "int"}},
  64. }
  65. renders["first"] = QueryDefinition{Renderer: functionRenderer}
  66. renders["last"] = QueryDefinition{Renderer: functionRenderer}
  67. renders["max"] = QueryDefinition{Renderer: functionRenderer}
  68. renders["min"] = QueryDefinition{Renderer: functionRenderer}
  69. renders["percentile"] = QueryDefinition{
  70. Renderer: functionRenderer,
  71. Params: []DefinitionParameters{{Name: "nth", Type: "int"}},
  72. }
  73. renders["top"] = QueryDefinition{
  74. Renderer: functionRenderer,
  75. Params: []DefinitionParameters{{Name: "count", Type: "int"}},
  76. }
  77. renders["tag"] = QueryDefinition{
  78. Renderer: fieldRenderer,
  79. Params: []DefinitionParameters{{Name: "tag", Type: "string"}},
  80. }
  81. renders["math"] = QueryDefinition{Renderer: suffixRenderer}
  82. renders["alias"] = QueryDefinition{Renderer: aliasRenderer}
  83. }
  84. func fieldRenderer(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string {
  85. if part.Params[0] == "*" {
  86. return "*"
  87. }
  88. return fmt.Sprintf(`"%s"`, part.Params[0])
  89. }
  90. func getDefinedInterval(query *Query, queryContext *tsdb.QueryContext) string {
  91. setInterval := strings.Replace(strings.Replace(query.Interval, "<", "", 1), ">", "", 1)
  92. defaultInterval := tsdb.CalculateInterval(queryContext.TimeRange)
  93. if strings.Contains(query.Interval, ">") {
  94. parsedDefaultInterval, err := time.ParseDuration(defaultInterval)
  95. parsedSetInterval, err2 := time.ParseDuration(setInterval)
  96. if err == nil && err2 == nil && parsedDefaultInterval > parsedSetInterval {
  97. return defaultInterval
  98. }
  99. }
  100. return setInterval
  101. }
  102. func functionRenderer(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string {
  103. for i, param := range part.Params {
  104. if param == "$interval" || param == "auto" {
  105. if query.Interval != "" {
  106. part.Params[i] = getDefinedInterval(query, queryContext)
  107. } else {
  108. part.Params[i] = tsdb.CalculateInterval(queryContext.TimeRange)
  109. }
  110. }
  111. }
  112. if innerExpr != "" {
  113. part.Params = append([]string{innerExpr}, part.Params...)
  114. }
  115. params := strings.Join(part.Params, ", ")
  116. return fmt.Sprintf("%s(%s)", part.Type, params)
  117. }
  118. func suffixRenderer(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string {
  119. return fmt.Sprintf("%s %s", innerExpr, part.Params[0])
  120. }
  121. func aliasRenderer(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string {
  122. return fmt.Sprintf(`%s AS "%s"`, innerExpr, part.Params[0])
  123. }
  124. func (r QueryDefinition) Render(query *Query, queryContext *tsdb.QueryContext, part *QueryPart, innerExpr string) string {
  125. return r.Renderer(query, queryContext, part, innerExpr)
  126. }
  127. func NewQueryPart(typ string, params []string) (*QueryPart, error) {
  128. def, exist := renders[typ]
  129. if !exist {
  130. return nil, fmt.Errorf("Missing query definition for %s", typ)
  131. }
  132. return &QueryPart{
  133. Type: typ,
  134. Params: params,
  135. Def: def,
  136. }, nil
  137. }
  138. type QueryPart struct {
  139. Def QueryDefinition
  140. Type string
  141. Params []string
  142. }
  143. func (qp *QueryPart) Render(query *Query, queryContext *tsdb.QueryContext, expr string) string {
  144. return qp.Def.Renderer(query, queryContext, qp, expr)
  145. }