funcs_ast_validator.go 9.3 KB

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