funcs_misc.go 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290
  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 function
  15. import (
  16. "crypto/md5"
  17. "crypto/sha1"
  18. "crypto/sha256"
  19. "crypto/sha512"
  20. b64 "encoding/base64"
  21. "fmt"
  22. "github.com/google/uuid"
  23. "github.com/lf-edge/ekuiper/internal/conf"
  24. "github.com/lf-edge/ekuiper/pkg/api"
  25. "github.com/lf-edge/ekuiper/pkg/cast"
  26. "hash"
  27. "io"
  28. "math"
  29. "reflect"
  30. "strconv"
  31. "strings"
  32. )
  33. func convCall(name string, args []interface{}) (interface{}, bool) {
  34. switch name {
  35. case "cast":
  36. if v, ok := args[1].(string); ok {
  37. v = strings.ToLower(v)
  38. switch v {
  39. case "bigint":
  40. if v1, ok1 := args[0].(int); ok1 {
  41. return v1, true
  42. } else if v1, ok1 := args[0].(float64); ok1 {
  43. return int(v1), true
  44. } else if v1, ok1 := args[0].(string); ok1 {
  45. if temp, err := strconv.Atoi(v1); err == nil {
  46. return temp, true
  47. } else {
  48. return err, false
  49. }
  50. } else if v1, ok1 := args[0].(bool); ok1 {
  51. if v1 {
  52. return 1, true
  53. } else {
  54. return 0, true
  55. }
  56. } else {
  57. return fmt.Errorf("Not supported type conversion."), false
  58. }
  59. case "float":
  60. if v1, ok1 := args[0].(int); ok1 {
  61. return float64(v1), true
  62. } else if v1, ok1 := args[0].(float64); ok1 {
  63. return v1, true
  64. } else if v1, ok1 := args[0].(string); ok1 {
  65. if temp, err := strconv.ParseFloat(v1, 64); err == nil {
  66. return temp, true
  67. } else {
  68. return err, false
  69. }
  70. } else if v1, ok1 := args[0].(bool); ok1 {
  71. if v1 {
  72. return 1.0, true
  73. } else {
  74. return 0.0, true
  75. }
  76. } else {
  77. return fmt.Errorf("Not supported type conversion."), false
  78. }
  79. case "string":
  80. if v1, ok1 := args[0].(int); ok1 {
  81. return fmt.Sprintf("%d", v1), true
  82. } else if v1, ok1 := args[0].(float64); ok1 {
  83. return fmt.Sprintf("%g", v1), true
  84. } else if v1, ok1 := args[0].(string); ok1 {
  85. return v1, true
  86. } else if v1, ok1 := args[0].(bool); ok1 {
  87. if v1 {
  88. return "true", true
  89. } else {
  90. return "false", true
  91. }
  92. } else {
  93. return fmt.Errorf("Not supported type conversion."), false
  94. }
  95. case "boolean":
  96. if v1, ok1 := args[0].(int); ok1 {
  97. if v1 == 0 {
  98. return false, true
  99. } else {
  100. return true, true
  101. }
  102. } else if v1, ok1 := args[0].(float64); ok1 {
  103. if v1 == 0.0 {
  104. return false, true
  105. } else {
  106. return true, true
  107. }
  108. } else if v1, ok1 := args[0].(string); ok1 {
  109. if temp, err := strconv.ParseBool(v1); err == nil {
  110. return temp, true
  111. } else {
  112. return err, false
  113. }
  114. } else if v1, ok1 := args[0].(bool); ok1 {
  115. return v1, true
  116. } else {
  117. return fmt.Errorf("Not supported type conversion."), false
  118. }
  119. case "datetime":
  120. dt, err := cast.InterfaceToTime(args[0], "")
  121. if err != nil {
  122. return err, false
  123. } else {
  124. return dt, true
  125. }
  126. default:
  127. return fmt.Errorf("Unknow type, only support bigint, float, string, boolean and datetime."), false
  128. }
  129. } else {
  130. return fmt.Errorf("Expect string type for the 2nd parameter."), false
  131. }
  132. case "chr":
  133. if v, ok := args[0].(int); ok {
  134. return rune(v), true
  135. } else if v, ok := args[0].(float64); ok {
  136. temp := int(v)
  137. return rune(temp), true
  138. } else if v, ok := args[0].(string); ok {
  139. if len(v) > 1 {
  140. return fmt.Errorf("Parameter length cannot larger than 1."), false
  141. }
  142. r := []rune(v)
  143. return r[0], true
  144. } else {
  145. return fmt.Errorf("Only bigint, float and string type can be convert to char type."), false
  146. }
  147. case "encode":
  148. if v, ok := args[1].(string); ok {
  149. v = strings.ToLower(v)
  150. if v == "base64" {
  151. if v1, ok1 := args[0].(string); ok1 {
  152. return b64.StdEncoding.EncodeToString([]byte(v1)), true
  153. } else {
  154. return fmt.Errorf("Only string type can be encoded."), false
  155. }
  156. } else {
  157. return fmt.Errorf("Only base64 encoding is supported."), false
  158. }
  159. }
  160. case "trunc":
  161. var v0 float64
  162. if v1, ok := args[0].(int); ok {
  163. v0 = float64(v1)
  164. } else if v1, ok := args[0].(float64); ok {
  165. v0 = v1
  166. } else {
  167. return fmt.Errorf("Only int and float type can be truncated."), false
  168. }
  169. if v2, ok := args[1].(int); ok {
  170. return toFixed(v0, v2), true
  171. } else {
  172. return fmt.Errorf("The 2nd parameter must be int value."), false
  173. }
  174. default:
  175. return fmt.Errorf("Not supported function name %s", name), false
  176. }
  177. return nil, false
  178. }
  179. func round(num float64) int {
  180. return int(num + math.Copysign(0.5, num))
  181. }
  182. func toFixed(num float64, precision int) float64 {
  183. output := math.Pow(10, float64(precision))
  184. return float64(round(num*output)) / output
  185. }
  186. func hashCall(name string, args []interface{}) (interface{}, bool) {
  187. if args[0] == nil {
  188. return nil, true
  189. }
  190. arg0 := cast.ToStringAlways(args[0])
  191. var h hash.Hash
  192. switch name {
  193. case "md5":
  194. h = md5.New()
  195. case "sha1":
  196. h = sha1.New()
  197. case "sha256":
  198. h = sha256.New()
  199. case "sha384":
  200. h = sha512.New384()
  201. case "sha512":
  202. h = sha512.New()
  203. default:
  204. return fmt.Errorf("unknown hash function name %s", name), false
  205. }
  206. _, err := io.WriteString(h, arg0)
  207. if err != nil {
  208. return err, false
  209. }
  210. return fmt.Sprintf("%x", h.Sum(nil)), true
  211. }
  212. func otherCall(name string, args []interface{}) (interface{}, bool) {
  213. switch name {
  214. case "isnull":
  215. if args[0] == nil {
  216. return true, true
  217. } else {
  218. v := reflect.ValueOf(args[0])
  219. switch v.Kind() {
  220. case reflect.Slice, reflect.Map:
  221. return v.IsNil(), true
  222. default:
  223. return false, true
  224. }
  225. }
  226. case "newuuid":
  227. if newUUID, err := uuid.NewUUID(); err != nil {
  228. return err, false
  229. } else {
  230. return newUUID.String(), true
  231. }
  232. case "tstamp":
  233. return conf.GetNowInMilli(), true
  234. case "mqtt":
  235. if v, ok := args[0].(string); ok {
  236. return v, true
  237. }
  238. return nil, false
  239. case "meta":
  240. return args[0], true
  241. case "cardinality":
  242. val := reflect.ValueOf(args[0])
  243. if val.Kind() == reflect.Slice {
  244. return val.Len(), true
  245. }
  246. return 0, true
  247. default:
  248. return fmt.Errorf("unknown function name %s", name), false
  249. }
  250. }
  251. func jsonCall(ctx api.StreamContext, name string, args []interface{}) (interface{}, bool) {
  252. result, err := ctx.ParseDynamicProp(args[1].(string), args[0])
  253. if err != nil {
  254. if name == "json_path_exists" {
  255. return false, true
  256. }
  257. return fmt.Errorf("%s function error: %s", name, err), false
  258. }
  259. switch name {
  260. case "json_path_query":
  261. return result, true
  262. case "json_path_query_first":
  263. if arr, ok := result.([]interface{}); ok {
  264. return arr[0], true
  265. } else {
  266. return fmt.Errorf("%s function error: query result (%v) is not an array", name, result), false
  267. }
  268. case "json_path_exists":
  269. if result == nil {
  270. return false, true
  271. }
  272. e := true
  273. switch reflect.TypeOf(result).Kind() {
  274. case reflect.Slice, reflect.Array:
  275. e = reflect.ValueOf(result).Len() > 0
  276. default:
  277. e = result != nil
  278. }
  279. return e, true
  280. }
  281. return fmt.Errorf("invalid function name: %s", name), false
  282. }