123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402 |
- package xsql
- import (
- "fmt"
- "github.com/emqx/kuiper/plugins"
- "github.com/emqx/kuiper/xstream/api"
- "strings"
- )
- type AllowTypes struct {
- types []Literal
- }
- func validateFuncs(funcName string, args []Expr) error {
- lowerName := strings.ToLower(funcName)
- if _, ok := mathFuncMap[lowerName]; ok {
- return validateMathFunc(funcName, args)
- } else if _, ok := strFuncMap[lowerName]; ok {
- return validateStrFunc(funcName, args)
- } else if _, ok := convFuncMap[lowerName]; ok {
- return validateConvFunc(lowerName, args)
- } else if _, ok := hashFuncMap[lowerName]; ok {
- return validateHashFunc(lowerName, args)
- } else if _, ok := otherFuncMap[lowerName]; ok {
- return validateOtherFunc(lowerName, args)
- } else if _, ok := aggFuncMap[lowerName]; ok {
- return validateAggFunc(lowerName, args)
- } else {
- if nf, err := plugins.GetPlugin(funcName, plugins.FUNCTION); err != nil {
- return err
- } else {
- f, ok := nf.(api.Function)
- if !ok {
- return fmt.Errorf("exported symbol %s is not type of api.Function", funcName)
- }
- var targs []interface{}
- for _, arg := range args {
- targs = append(targs, arg)
- }
- return f.Validate(targs)
- }
- }
- }
- func validateMathFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "abs", "acos", "asin", "atan", "ceil", "cos", "cosh", "exp", "ln", "log", "round", "sign", "sin", "sinh",
- "sqrt", "tan", "tanh":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "number - float or int")
- }
- case "bitand", "bitor", "bitxor":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isFloatArg(args[0]) || isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "int")
- }
- if isFloatArg(args[1]) || isStringArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
- return produceErrInfo(name, 1, "int")
- }
- case "bitnot":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isFloatArg(args[0]) || isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "int")
- }
- case "atan2", "mod", "power":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "number - float or int")
- }
- if isStringArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
- return produceErrInfo(name, 1, "number - float or int")
- }
- case "rand":
- if err := validateLen(name, 0, len); err != nil {
- return err
- }
- }
- return nil
- }
- func validateStrFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "concat":
- if len == 0 {
- return fmt.Errorf("The arguments for %s should be at least one.\n", name)
- }
- for i, a := range args {
- if isNumericArg(a) || isTimeArg(a) || isBooleanArg(a) {
- return produceErrInfo(name, i, "string")
- }
- }
- case "endswith", "indexof", "regexp_matches", "startswith":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- for i := 0; i < 2; i++ {
- if isNumericArg(args[i]) || isTimeArg(args[i]) || isBooleanArg(args[i]) {
- return produceErrInfo(name, i, "string")
- }
- }
- case "format_time":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isNumericArg(args[0]) || isStringArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "datetime")
- }
- if isNumericArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
- return produceErrInfo(name, 1, "string")
- }
- case "regexp_replace":
- if err := validateLen(name, 3, len); err != nil {
- return err
- }
- for i := 0; i < 3; i++ {
- if isNumericArg(args[i]) || isTimeArg(args[i]) || isBooleanArg(args[i]) {
- return produceErrInfo(name, i, "string")
- }
- }
- case "length", "lower", "ltrim", "numbytes", "rtrim", "trim", "upper":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- case "lpad", "rpad":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- if isFloatArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) || isStringArg(args[1]) {
- return produceErrInfo(name, 1, "int")
- }
- case "substring":
- if len != 2 && len != 3 {
- return fmt.Errorf("the arguments for substring should be 2 or 3")
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- for i := 1; i < len; i++ {
- if isFloatArg(args[i]) || isTimeArg(args[i]) || isBooleanArg(args[i]) || isStringArg(args[i]) {
- return produceErrInfo(name, i, "int")
- }
- }
- if s, ok := args[1].(*IntegerLiteral); ok {
- sv := s.Val
- if sv < 0 {
- return fmt.Errorf("The start index should not be a nagtive integer.")
- }
- if len == 3 {
- if e, ok1 := args[2].(*IntegerLiteral); ok1 {
- ev := e.Val
- if ev < sv {
- return fmt.Errorf("The end index should be larger than start index.")
- }
- }
- }
- }
- case "split_value":
- if len != 3 {
- return fmt.Errorf("the arguments for split_value should be 3")
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- if isNumericArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) {
- return produceErrInfo(name, 1, "string")
- }
- if isFloatArg(args[2]) || isTimeArg(args[2]) || isBooleanArg(args[2]) || isStringArg(args[2]) {
- return produceErrInfo(name, 2, "int")
- }
- if s, ok := args[2].(*IntegerLiteral); ok {
- if s.Val < 0 {
- return fmt.Errorf("The index should not be a nagtive integer.")
- }
- }
- }
- return nil
- }
- func validateConvFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "cast":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- a := args[1]
- if !isStringArg(a) {
- return produceErrInfo(name, 1, "string")
- }
- if av, ok := a.(*StringLiteral); ok {
- if !(av.Val == "bigint" || av.Val == "float" || av.Val == "string" || av.Val == "boolean" || av.Val == "datetime") {
- return fmt.Errorf("Expect one of following value for the 2nd parameter: bigint, float, string, boolean, datetime.")
- }
- }
- case "chr":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isFloatArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "int")
- }
- case "encode":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- a := args[1]
- if !isStringArg(a) {
- return produceErrInfo(name, 1, "string")
- }
- if av, ok := a.(*StringLiteral); ok {
- if av.Val != "base64" {
- return fmt.Errorf("Only base64 is supported for the 2nd parameter.")
- }
- }
- case "trunc":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) {
- return produceErrInfo(name, 0, "number - float or int")
- }
- if isFloatArg(args[1]) || isTimeArg(args[1]) || isBooleanArg(args[1]) || isStringArg(args[1]) {
- return produceErrInfo(name, 1, "int")
- }
- }
- return nil
- }
- func validateHashFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "md5", "sha1", "sha224", "sha256", "sha384", "sha512":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isNumericArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "string")
- }
- }
- return nil
- }
- func validateOtherFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "isNull":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- case "nanvl":
- if err := validateLen(name, 2, len); err != nil {
- return err
- }
- if isIntegerArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) {
- return produceErrInfo(name, 1, "float")
- }
- case "newuuid":
- if err := validateLen(name, 0, len); err != nil {
- return err
- }
- case "mqtt":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isIntegerArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) || isStringArg(args[0]) || isFloatArg(args[0]) {
- return produceErrInfo(name, 0, "meta reference")
- }
- if p, ok := args[0].(*MetaRef); ok {
- name := strings.ToLower(p.Name)
- if name != "topic" && name != "messageid" {
- return fmt.Errorf("Parameter of mqtt function can be only topic or messageid.")
- }
- }
- case "meta":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if _, ok := args[0].(*MetaRef); ok {
- return nil
- }
- expr := args[0]
- for {
- if be, ok := expr.(*BinaryExpr); ok {
- if _, ok := be.LHS.(*MetaRef); ok && be.OP == ARROW {
- return nil
- }
- expr = be.LHS
- } else {
- break
- }
- }
- return produceErrInfo(name, 0, "meta reference")
- }
- return nil
- }
- func validateAggFunc(name string, args []Expr) error {
- len := len(args)
- switch name {
- case "avg", "max", "min", "sum":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- if isStringArg(args[0]) || isTimeArg(args[0]) || isBooleanArg(args[0]) {
- return produceErrInfo(name, 0, "number - float or int")
- }
- case "count":
- if err := validateLen(name, 1, len); err != nil {
- return err
- }
- }
- return nil
- }
- // Index is starting from 0
- func produceErrInfo(name string, index int, expect string) (err error) {
- index++
- err = fmt.Errorf("Expect %s type for %d parameter of function %s.", expect, index, name)
- return
- }
- func validateLen(funcName string, exp, actual int) error {
- if actual != exp {
- return fmt.Errorf("The arguments for %s should be %d.", funcName, exp)
- }
- return nil
- }
- func isNumericArg(arg Expr) bool {
- if _, ok := arg.(*NumberLiteral); ok {
- return true
- } else if _, ok := arg.(*IntegerLiteral); ok {
- return true
- }
- return false
- }
- func isIntegerArg(arg Expr) bool {
- if _, ok := arg.(*IntegerLiteral); ok {
- return true
- }
- return false
- }
- func isFloatArg(arg Expr) bool {
- if _, ok := arg.(*NumberLiteral); ok {
- return true
- }
- return false
- }
- func isBooleanArg(arg Expr) bool {
- if _, ok := arg.(*BooleanLiteral); ok {
- return true
- }
- return false
- }
- func isStringArg(arg Expr) bool {
- if _, ok := arg.(*StringLiteral); ok {
- return true
- }
- return false
- }
- func isTimeArg(arg Expr) bool {
- if _, ok := arg.(*TimeLiteral); ok {
- return true
- }
- return false
- }
|