funcs_ast_validator.go 9.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  1. package xsql
  2. import (
  3. "engine/common/plugin_manager"
  4. "engine/xstream/api"
  5. "fmt"
  6. "strings"
  7. )
  8. type AllowTypes struct {
  9. types []Literal
  10. }
  11. func validateFuncs(funcName string, args []Expr) error {
  12. lowerName := strings.ToLower(funcName)
  13. if _, ok := mathFuncMap[lowerName]; ok {
  14. return validateMathFunc(funcName, args)
  15. } else if _, ok := strFuncMap[lowerName]; ok {
  16. return validateStrFunc(funcName, args)
  17. } else if _, ok := convFuncMap[lowerName]; ok {
  18. return validateConvFunc(lowerName, args)
  19. } else if _, ok := hashFuncMap[lowerName]; ok {
  20. return validateHashFunc(lowerName, args)
  21. } else if _, ok := otherFuncMap[lowerName]; ok {
  22. return validateOtherFunc(lowerName, args)
  23. } else {
  24. if nf, err := plugin_manager.GetPlugin(funcName, "functions"); err != nil {
  25. return err
  26. }else{
  27. f, ok := nf.(api.Function)
  28. if !ok {
  29. return fmt.Errorf("exported symbol %s is not type of api.Function", funcName)
  30. }
  31. var targs []interface{}
  32. for _, arg := range args{
  33. targs = append(targs, arg)
  34. }
  35. return f.Validate(targs)
  36. }
  37. }
  38. }
  39. func validateMathFunc(name string, args []Expr) error {
  40. len := len(args)
  41. switch name {
  42. case "abs", "acos", "asin", "atan", "ceil", "cos", "cosh", "exp", "ln", "log", "round", "sign", "sin", "sinh",
  43. "sqrt", "tan", "tanh" :
  44. if err := validateLen(name, 1, len); err != nil {
  45. return err
  46. }
  47. if isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  48. return produceErrInfo(name, 0, "number - float or int")
  49. }
  50. case "bitand", "bitor", "bitxor":
  51. if err := validateLen(name, 2, len); err != nil {
  52. return err
  53. }
  54. if isFloatArg(args[0]) || isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]){
  55. return produceErrInfo(name, 0, "int")
  56. }
  57. if isFloatArg(args[1]) || isStringArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
  58. return produceErrInfo(name, 1, "int")
  59. }
  60. case "bitnot":
  61. if err := validateLen(name, 1, len); err != nil {
  62. return err
  63. }
  64. if isFloatArg(args[0]) || isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  65. return produceErrInfo(name, 0, "int")
  66. }
  67. case "atan2", "mod", "power":
  68. if err := validateLen(name, 2, len); err != nil {
  69. return err
  70. }
  71. if isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  72. return produceErrInfo(name, 0, "number - float or int")
  73. }
  74. if isStringArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]){
  75. return produceErrInfo(name, 1, "number - float or int")
  76. }
  77. case "rand":
  78. if err := validateLen(name, 0, len); err != nil {
  79. return err
  80. }
  81. }
  82. return nil
  83. }
  84. func validateStrFunc(name string, args []Expr) error {
  85. len := len(args)
  86. switch name {
  87. case "concat":
  88. if len == 0 {
  89. return fmt.Errorf("The arguments for %s should be at least one.\n", name)
  90. }
  91. for i, a := range args {
  92. if isNumericArg(a) || isTimeArg(a) || isBooleanArg(a) {
  93. return produceErrInfo(name, i, "string")
  94. }
  95. }
  96. case "endswith", "indexof", "regexp_matches", "startswith":
  97. if err := validateLen(name, 2, len); err != nil {
  98. return err
  99. }
  100. for i := 0; i < 2; i++ {
  101. if isNumericArg(args[i]) || isTimeArg(args[i])|| isBooleanArg(args[i]) {
  102. return produceErrInfo(name, i, "string")
  103. }
  104. }
  105. case "format_time":
  106. if err := validateLen(name, 2, len); err != nil {
  107. return err
  108. }
  109. if isNumericArg(args[0]) || isStringArg(args[0])|| isBooleanArg(args[0]) {
  110. return produceErrInfo(name, 0, "datetime")
  111. }
  112. if isNumericArg(args[1]) || isTimeArg(args[1])|| isBooleanArg(args[1]) {
  113. return produceErrInfo(name, 1, "string")
  114. }
  115. case "regexp_replace":
  116. if err := validateLen(name, 3, len); err != nil {
  117. return err
  118. }
  119. for i := 0; i < 3; i++ {
  120. if isNumericArg(args[i]) || isTimeArg(args[i])|| isBooleanArg(args[i]) {
  121. return produceErrInfo(name, i, "string")
  122. }
  123. }
  124. case "length", "lower", "ltrim", "numbytes", "rtrim", "trim", "upper":
  125. if err := validateLen(name, 1, len); err != nil {
  126. return err
  127. }
  128. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  129. return produceErrInfo(name, 0, "string")
  130. }
  131. case "lpad", "rpad":
  132. if err := validateLen(name, 2, len); err != nil {
  133. return err
  134. }
  135. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  136. return produceErrInfo(name, 0, "string")
  137. }
  138. if isFloatArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) || isStringArg(args[1]) {
  139. return produceErrInfo(name, 1, "int")
  140. }
  141. case "substring":
  142. if len != 2 && len != 3 {
  143. return fmt.Errorf("the arguments for substring should be 2 or 3")
  144. }
  145. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  146. return produceErrInfo(name, 0, "string")
  147. }
  148. for i := 1; i < len; i++ {
  149. if isFloatArg(args[i]) || isTimeArg(args[i]) || isBooleanArg(args[i]) || isStringArg(args[i]) {
  150. return produceErrInfo(name, i, "int")
  151. }
  152. }
  153. if s, ok := args[1].(*IntegerLiteral); ok {
  154. sv := s.Val
  155. if sv < 0 {
  156. return fmt.Errorf("The start index should not be a nagtive integer.")
  157. }
  158. if len == 3{
  159. if e, ok1 := args[2].(*IntegerLiteral); ok1 {
  160. ev := e.Val
  161. if ev < sv {
  162. return fmt.Errorf("The end index should be larger than start index.")
  163. }
  164. }
  165. }
  166. }
  167. case "split_value":
  168. if len != 3 {
  169. return fmt.Errorf("the arguments for split_value should be 3")
  170. }
  171. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  172. return produceErrInfo(name, 0, "string")
  173. }
  174. if isNumericArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
  175. return produceErrInfo(name, 1, "string")
  176. }
  177. if isFloatArg(args[2]) || isTimeArg(args[2]) || isBooleanArg(args[2]) || isStringArg(args[2]) {
  178. return produceErrInfo(name, 2, "int")
  179. }
  180. if s, ok := args[2].(*IntegerLiteral); ok {
  181. if s.Val < 0 {
  182. return fmt.Errorf("The index should not be a nagtive integer.")
  183. }
  184. }
  185. }
  186. return nil
  187. }
  188. func validateConvFunc(name string, args []Expr) error {
  189. len := len(args)
  190. switch name {
  191. case "cast":
  192. if err := validateLen(name, 2, len); err != nil {
  193. return err
  194. }
  195. a := args[1]
  196. if !isStringArg(a) {
  197. return produceErrInfo(name, 1, "string")
  198. }
  199. if av, ok := a.(*StringLiteral); ok {
  200. if !(av.Val == "bigint" || av.Val == "float" || av.Val == "string" || av.Val == "boolean" || av.Val == "datetime") {
  201. return fmt.Errorf("Expect one of following value for the 2nd parameter: bigint, float, string, boolean, datetime.")
  202. }
  203. }
  204. case "chr":
  205. if err := validateLen(name, 1, len); err != nil {
  206. return err
  207. }
  208. if isFloatArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  209. return produceErrInfo(name, 0, "int")
  210. }
  211. case "encode":
  212. if err := validateLen(name, 2, len); err != nil {
  213. return err
  214. }
  215. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  216. return produceErrInfo(name, 0, "string")
  217. }
  218. a := args[1]
  219. if !isStringArg(a) {
  220. return produceErrInfo(name, 1, "string")
  221. }
  222. if av, ok := a.(*StringLiteral); ok {
  223. if av.Val != "base64" {
  224. return fmt.Errorf("Only base64 is supported for the 2nd parameter.")
  225. }
  226. }
  227. case "trunc":
  228. if err := validateLen(name, 2, len); err != nil {
  229. return err
  230. }
  231. if isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) {
  232. return produceErrInfo(name, 0, "number - float or int")
  233. }
  234. if isFloatArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) || isStringArg(args[1]) {
  235. return produceErrInfo(name, 1, "int")
  236. }
  237. }
  238. return nil
  239. }
  240. func validateHashFunc(name string, args []Expr) error {
  241. len := len(args)
  242. switch name {
  243. case "md5", "sha1", "sha224", "sha256", "sha384", "sha512":
  244. if err := validateLen(name, 1, len); err != nil {
  245. return err
  246. }
  247. if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
  248. return produceErrInfo(name, 0, "string")
  249. }
  250. }
  251. return nil
  252. }
  253. func validateOtherFunc(name string, args []Expr) error {
  254. len := len(args)
  255. switch name {
  256. case "isNull":
  257. if err := validateLen(name, 1, len); err != nil {
  258. return err
  259. }
  260. case "nanvl":
  261. if err := validateLen(name, 2, len); err != nil {
  262. return err
  263. }
  264. if isIntegerArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) {
  265. return produceErrInfo(name, 1, "float")
  266. }
  267. case "newuuid":
  268. if err := validateLen(name, 0, len); err != nil {
  269. return err
  270. }
  271. case "mqtt":
  272. if err := validateLen(name, 1, len); err != nil {
  273. return err
  274. }
  275. if isIntegerArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) || isFloatArg(args[0]) {
  276. return produceErrInfo(name, 0, "field reference")
  277. }
  278. if p, ok := args[0].(*FieldRef); ok {
  279. if _, ok := SpecialKeyMapper[p.Name]; !ok {
  280. return fmt.Errorf("Parameter of mqtt function can be only topic or messageid.")
  281. }
  282. }
  283. }
  284. return nil
  285. }
  286. // Index is starting from 0
  287. func produceErrInfo(name string, index int, expect string) (err error) {
  288. index++
  289. err = fmt.Errorf("Expect %s type for %d parameter of function %s.", expect, index, name)
  290. return
  291. }
  292. func validateLen(funcName string, exp, actual int) error {
  293. if actual != exp {
  294. return fmt.Errorf("The arguments for %s should be %d.", funcName, exp)
  295. }
  296. return nil
  297. }
  298. func isNumericArg(arg Expr) bool {
  299. if _, ok := arg.(*NumberLiteral); ok {
  300. return true
  301. } else if _, ok := arg.(*IntegerLiteral); ok {
  302. return true
  303. }
  304. return false
  305. }
  306. func isIntegerArg(arg Expr) bool {
  307. if _, ok := arg.(*IntegerLiteral); ok {
  308. return true
  309. }
  310. return false
  311. }
  312. func isFloatArg(arg Expr) bool {
  313. if _, ok := arg.(*NumberLiteral); ok {
  314. return true
  315. }
  316. return false
  317. }
  318. func isBooleanArg(arg Expr) bool {
  319. if _, ok := arg.(*BooleanLiteral); ok {
  320. return true
  321. }
  322. return false
  323. }
  324. func isStringArg(arg Expr) bool {
  325. if _, ok := arg.(*StringLiteral); ok {
  326. return true
  327. }
  328. return false
  329. }
  330. func isTimeArg(arg Expr) bool {
  331. if _, ok := arg.(*TimeLiteral); ok {
  332. return true
  333. }
  334. return false
  335. }