funcs_misc.go 7.2 KB

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