funcsStr.go 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. // Copyright 2021 EMQ Technologies Co., Ltd.
  2. //
  3. // Licensed under the Apache License, Version 2.0 (the "License");
  4. // you may not use this file except in compliance with the License.
  5. // You may obtain a copy of the License at
  6. //
  7. // http://www.apache.org/licenses/LICENSE-2.0
  8. //
  9. // Unless required by applicable law or agreed to in writing, software
  10. // distributed under the License is distributed on an "AS IS" BASIS,
  11. // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12. // See the License for the specific language governing permissions and
  13. // limitations under the License.
  14. package xsql
  15. import (
  16. "bytes"
  17. "fmt"
  18. "github.com/lf-edge/ekuiper/pkg/cast"
  19. "regexp"
  20. "strings"
  21. "unicode"
  22. "unicode/utf8"
  23. )
  24. func strCall(name string, args []interface{}) (interface{}, bool) {
  25. switch name {
  26. case "concat":
  27. var b bytes.Buffer
  28. for _, arg := range args {
  29. b.WriteString(cast.ToStringAlways(arg))
  30. }
  31. return b.String(), true
  32. case "endswith":
  33. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  34. return strings.HasSuffix(arg0, arg1), true
  35. case "indexof":
  36. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  37. return strings.Index(arg0, arg1), true
  38. case "length":
  39. arg0 := cast.ToStringAlways(args[0])
  40. return utf8.RuneCountInString(arg0), true
  41. case "lower":
  42. arg0 := cast.ToStringAlways(args[0])
  43. return strings.ToLower(arg0), true
  44. case "lpad":
  45. arg0 := cast.ToStringAlways(args[0])
  46. arg1, err := cast.ToInt(args[1], cast.STRICT)
  47. if err != nil {
  48. return err, false
  49. }
  50. return strings.Repeat(" ", arg1) + arg0, true
  51. case "ltrim":
  52. arg0 := cast.ToStringAlways(args[0])
  53. return strings.TrimLeftFunc(arg0, unicode.IsSpace), true
  54. case "numbytes":
  55. arg0 := cast.ToStringAlways(args[0])
  56. return len(arg0), true
  57. case "format_time":
  58. arg0, err := cast.InterfaceToTime(args[0], "")
  59. if err != nil {
  60. return err, false
  61. }
  62. arg1 := cast.ToStringAlways(args[1])
  63. if s, err := cast.FormatTime(arg0, arg1); err == nil {
  64. return s, true
  65. } else {
  66. return err, false
  67. }
  68. case "regexp_matches":
  69. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  70. if matched, err := regexp.MatchString(arg1, arg0); err != nil {
  71. return err, false
  72. } else {
  73. return matched, true
  74. }
  75. case "regexp_replace":
  76. arg0, arg1, arg2 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1]), cast.ToStringAlways(args[2])
  77. if re, err := regexp.Compile(arg1); err != nil {
  78. return err, false
  79. } else {
  80. return re.ReplaceAllString(arg0, arg2), true
  81. }
  82. case "regexp_substr":
  83. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  84. if re, err := regexp.Compile(arg1); err != nil {
  85. return err, false
  86. } else {
  87. return re.FindString(arg0), true
  88. }
  89. case "rpad":
  90. arg0 := cast.ToStringAlways(args[0])
  91. arg1, err := cast.ToInt(args[1], cast.STRICT)
  92. if err != nil {
  93. return err, false
  94. }
  95. return arg0 + strings.Repeat(" ", arg1), true
  96. case "rtrim":
  97. arg0 := cast.ToStringAlways(args[0])
  98. return strings.TrimRightFunc(arg0, unicode.IsSpace), true
  99. case "substring":
  100. arg0 := cast.ToStringAlways(args[0])
  101. arg1, err := cast.ToInt(args[1], cast.STRICT)
  102. if err != nil {
  103. return err, false
  104. }
  105. if len(args) > 2 {
  106. arg2, err := cast.ToInt(args[2], cast.STRICT)
  107. if err != nil {
  108. return err, false
  109. }
  110. return arg0[arg1:arg2], true
  111. } else {
  112. return arg0[arg1:], true
  113. }
  114. case "startswith":
  115. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  116. return strings.HasPrefix(arg0, arg1), true
  117. case "split_value":
  118. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  119. ss := strings.Split(arg0, arg1)
  120. v, _ := cast.ToInt(args[2], cast.STRICT)
  121. if v > (len(ss) - 1) {
  122. return fmt.Errorf("%d out of index array (size = %d)", v, len(ss)), false
  123. } else {
  124. return ss[v], true
  125. }
  126. case "trim":
  127. arg0 := cast.ToStringAlways(args[0])
  128. return strings.TrimSpace(arg0), true
  129. case "upper":
  130. arg0 := cast.ToStringAlways(args[0])
  131. return strings.ToUpper(arg0), true
  132. default:
  133. return fmt.Errorf("unknown string function name %s", name), false
  134. }
  135. }