funcsStr.go 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
  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. if args[0] == nil || args[1] == nil {
  34. return false, true
  35. }
  36. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  37. return strings.HasSuffix(arg0, arg1), true
  38. case "indexof":
  39. if args[0] == nil || args[1] == nil {
  40. return -1, true
  41. }
  42. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  43. return strings.Index(arg0, arg1), true
  44. case "length":
  45. arg0 := cast.ToStringAlways(args[0])
  46. return utf8.RuneCountInString(arg0), true
  47. case "lower":
  48. if args[0] == nil {
  49. return nil, true
  50. }
  51. arg0 := cast.ToStringAlways(args[0])
  52. return strings.ToLower(arg0), true
  53. case "lpad":
  54. if args[0] == nil {
  55. return nil, true
  56. }
  57. arg0 := cast.ToStringAlways(args[0])
  58. arg1, err := cast.ToInt(args[1], cast.STRICT)
  59. if err != nil {
  60. return err, false
  61. }
  62. return strings.Repeat(" ", arg1) + arg0, true
  63. case "ltrim":
  64. if args[0] == nil {
  65. return nil, true
  66. }
  67. arg0 := cast.ToStringAlways(args[0])
  68. return strings.TrimLeftFunc(arg0, unicode.IsSpace), true
  69. case "numbytes":
  70. arg0 := cast.ToStringAlways(args[0])
  71. return len(arg0), true
  72. case "format_time":
  73. if args[0] == nil {
  74. return nil, true
  75. }
  76. arg0, err := cast.InterfaceToTime(args[0], "")
  77. if err != nil {
  78. return err, false
  79. }
  80. arg1 := cast.ToStringAlways(args[1])
  81. if s, err := cast.FormatTime(arg0, arg1); err == nil {
  82. return s, true
  83. } else {
  84. return err, false
  85. }
  86. case "regexp_matches":
  87. if args[0] == nil || args[1] == nil {
  88. return false, true
  89. }
  90. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  91. if matched, err := regexp.MatchString(arg1, arg0); err != nil {
  92. return err, false
  93. } else {
  94. return matched, true
  95. }
  96. case "regexp_replace":
  97. if args[0] == nil || args[1] == nil || args[2] == nil {
  98. return nil, true
  99. }
  100. arg0, arg1, arg2 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1]), cast.ToStringAlways(args[2])
  101. if re, err := regexp.Compile(arg1); err != nil {
  102. return err, false
  103. } else {
  104. return re.ReplaceAllString(arg0, arg2), true
  105. }
  106. case "regexp_substr":
  107. if args[0] == nil || args[1] == nil {
  108. return nil, true
  109. }
  110. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  111. if re, err := regexp.Compile(arg1); err != nil {
  112. return err, false
  113. } else {
  114. return re.FindString(arg0), true
  115. }
  116. case "rpad":
  117. if args[0] == nil {
  118. return nil, true
  119. }
  120. arg0 := cast.ToStringAlways(args[0])
  121. arg1, err := cast.ToInt(args[1], cast.STRICT)
  122. if err != nil {
  123. return err, false
  124. }
  125. return arg0 + strings.Repeat(" ", arg1), true
  126. case "rtrim":
  127. if args[0] == nil {
  128. return nil, true
  129. }
  130. arg0 := cast.ToStringAlways(args[0])
  131. return strings.TrimRightFunc(arg0, unicode.IsSpace), true
  132. case "substring":
  133. if args[0] == nil {
  134. return nil, true
  135. }
  136. arg0 := cast.ToStringAlways(args[0])
  137. arg1, err := cast.ToInt(args[1], cast.STRICT)
  138. if err != nil {
  139. return err, false
  140. }
  141. if arg1 < 0 {
  142. return fmt.Errorf("start index must be a positive number"), false
  143. }
  144. if len(args) > 2 {
  145. arg2, err := cast.ToInt(args[2], cast.STRICT)
  146. if err != nil {
  147. return err, false
  148. }
  149. if arg2 < 0 {
  150. return fmt.Errorf("end index must be a positive number"), false
  151. }
  152. if arg1 > arg2 {
  153. return fmt.Errorf("start index must be smaller than end index"), false
  154. }
  155. if arg1 > len(arg0) {
  156. return "", true
  157. }
  158. if arg2 > len(arg0) {
  159. return arg0[arg1:], true
  160. }
  161. return arg0[arg1:arg2], true
  162. } else {
  163. if arg1 > len(arg0) {
  164. return "", true
  165. }
  166. return arg0[arg1:], true
  167. }
  168. case "startswith":
  169. if args[0] == nil {
  170. return false, true
  171. }
  172. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  173. return strings.HasPrefix(arg0, arg1), true
  174. case "split_value":
  175. if args[0] == nil || args[1] == nil {
  176. return nil, true
  177. }
  178. arg0, arg1 := cast.ToStringAlways(args[0]), cast.ToStringAlways(args[1])
  179. ss := strings.Split(arg0, arg1)
  180. v, _ := cast.ToInt(args[2], cast.STRICT)
  181. if v > (len(ss) - 1) {
  182. return fmt.Errorf("%d out of index array (size = %d)", v, len(ss)), false
  183. } else {
  184. return ss[v], true
  185. }
  186. case "trim":
  187. if args[0] == nil {
  188. return nil, true
  189. }
  190. arg0 := cast.ToStringAlways(args[0])
  191. return strings.TrimSpace(arg0), true
  192. case "upper":
  193. if args[0] == nil {
  194. return nil, true
  195. }
  196. arg0 := cast.ToStringAlways(args[0])
  197. return strings.ToUpper(arg0), true
  198. default:
  199. return fmt.Errorf("unknown string function name %s", name), false
  200. }
  201. }