stream.go 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320
  1. // Copyright 2021-2022 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 processor
  15. import (
  16. "bytes"
  17. "encoding/json"
  18. "fmt"
  19. "github.com/lf-edge/ekuiper/internal/conf"
  20. "github.com/lf-edge/ekuiper/internal/pkg/store"
  21. "github.com/lf-edge/ekuiper/internal/xsql"
  22. "github.com/lf-edge/ekuiper/pkg/ast"
  23. "github.com/lf-edge/ekuiper/pkg/errorx"
  24. "github.com/lf-edge/ekuiper/pkg/kv"
  25. "strings"
  26. )
  27. var (
  28. log = conf.Log
  29. )
  30. type StreamProcessor struct {
  31. db kv.KeyValue
  32. }
  33. func NewStreamProcessor() *StreamProcessor {
  34. err, db := store.GetKV("stream")
  35. if err != nil {
  36. panic(fmt.Sprintf("Can not initalize store for the stream processor at path 'stream': %v", err))
  37. }
  38. processor := &StreamProcessor{
  39. db: db,
  40. }
  41. return processor
  42. }
  43. func (p *StreamProcessor) ExecStmt(statement string) (result []string, err error) {
  44. parser := xsql.NewParser(strings.NewReader(statement))
  45. stmt, err := xsql.Language.Parse(parser)
  46. if err != nil {
  47. return nil, err
  48. }
  49. switch s := stmt.(type) {
  50. case *ast.StreamStmt: //Table is also StreamStmt
  51. var r string
  52. err = p.execSave(s, statement, false)
  53. stt := ast.StreamTypeMap[s.StreamType]
  54. if err != nil {
  55. err = fmt.Errorf("Create %s fails: %v.", stt, err)
  56. } else {
  57. r = fmt.Sprintf("%s %s is created.", strings.Title(stt), s.Name)
  58. log.Printf("%s", r)
  59. }
  60. result = append(result, r)
  61. case *ast.ShowStreamsStatement:
  62. result, err = p.execShow(ast.TypeStream)
  63. case *ast.ShowTablesStatement:
  64. result, err = p.execShow(ast.TypeTable)
  65. case *ast.DescribeStreamStatement:
  66. var r string
  67. r, err = p.execDescribe(s, ast.TypeStream)
  68. result = append(result, r)
  69. case *ast.DescribeTableStatement:
  70. var r string
  71. r, err = p.execDescribe(s, ast.TypeTable)
  72. result = append(result, r)
  73. case *ast.ExplainStreamStatement:
  74. var r string
  75. r, err = p.execExplain(s, ast.TypeStream)
  76. result = append(result, r)
  77. case *ast.ExplainTableStatement:
  78. var r string
  79. r, err = p.execExplain(s, ast.TypeTable)
  80. result = append(result, r)
  81. case *ast.DropStreamStatement:
  82. var r string
  83. r, err = p.execDrop(s, ast.TypeStream)
  84. result = append(result, r)
  85. case *ast.DropTableStatement:
  86. var r string
  87. r, err = p.execDrop(s, ast.TypeTable)
  88. result = append(result, r)
  89. default:
  90. return nil, fmt.Errorf("Invalid stream statement: %s", statement)
  91. }
  92. return
  93. }
  94. func (p *StreamProcessor) execSave(stmt *ast.StreamStmt, statement string, replace bool) error {
  95. s, err := json.Marshal(xsql.StreamInfo{
  96. StreamType: stmt.StreamType,
  97. Statement: statement,
  98. })
  99. if err != nil {
  100. return fmt.Errorf("error when saving to db: %v.", err)
  101. }
  102. if replace {
  103. err = p.db.Set(string(stmt.Name), string(s))
  104. } else {
  105. err = p.db.Setnx(string(stmt.Name), string(s))
  106. }
  107. return err
  108. }
  109. func (p *StreamProcessor) ExecReplaceStream(name string, statement string, st ast.StreamType) (string, error) {
  110. parser := xsql.NewParser(strings.NewReader(statement))
  111. stmt, err := xsql.Language.Parse(parser)
  112. if err != nil {
  113. return "", err
  114. }
  115. stt := ast.StreamTypeMap[st]
  116. switch s := stmt.(type) {
  117. case *ast.StreamStmt:
  118. if s.StreamType != st {
  119. return "", errorx.NewWithCode(errorx.NOT_FOUND, fmt.Sprintf("%s %s is not found", ast.StreamTypeMap[st], s.Name))
  120. }
  121. if string(s.Name) != name {
  122. return "", fmt.Errorf("Replace %s fails: the sql statement must update the %s source.", name, name)
  123. }
  124. err = p.execSave(s, statement, true)
  125. if err != nil {
  126. return "", fmt.Errorf("Replace %s fails: %v.", stt, err)
  127. } else {
  128. info := fmt.Sprintf("%s %s is replaced.", strings.Title(stt), s.Name)
  129. log.Printf("%s", info)
  130. return info, nil
  131. }
  132. default:
  133. return "", fmt.Errorf("Invalid %s statement: %s", stt, statement)
  134. }
  135. }
  136. func (p *StreamProcessor) ExecStreamSql(statement string) (string, error) {
  137. r, err := p.ExecStmt(statement)
  138. if err != nil {
  139. return "", err
  140. } else {
  141. return strings.Join(r, "\n"), err
  142. }
  143. }
  144. func (p *StreamProcessor) execShow(st ast.StreamType) ([]string, error) {
  145. keys, err := p.ShowStream(st)
  146. if len(keys) == 0 {
  147. keys = append(keys, fmt.Sprintf("No %s definitions are found.", ast.StreamTypeMap[st]))
  148. }
  149. return keys, err
  150. }
  151. func (p *StreamProcessor) ShowStream(st ast.StreamType) ([]string, error) {
  152. stt := ast.StreamTypeMap[st]
  153. keys, err := p.db.Keys()
  154. if err != nil {
  155. return nil, fmt.Errorf("Show %ss fails, error when loading data from db: %v.", stt, err)
  156. }
  157. var (
  158. v string
  159. vs = &xsql.StreamInfo{}
  160. result = make([]string, 0)
  161. )
  162. for _, k := range keys {
  163. if ok, _ := p.db.Get(k, &v); ok {
  164. if err := json.Unmarshal([]byte(v), vs); err == nil && vs.StreamType == st {
  165. result = append(result, k)
  166. }
  167. }
  168. }
  169. return result, nil
  170. }
  171. func (p *StreamProcessor) getStream(name string, st ast.StreamType) (string, error) {
  172. vs, err := xsql.GetDataSourceStatement(p.db, name)
  173. if vs != nil && vs.StreamType == st {
  174. return vs.Statement, nil
  175. }
  176. if err != nil {
  177. return "", err
  178. }
  179. return "", errorx.NewWithCode(errorx.NOT_FOUND, fmt.Sprintf("%s %s is not found", ast.StreamTypeMap[st], name))
  180. }
  181. func (p *StreamProcessor) execDescribe(stmt ast.NameNode, st ast.StreamType) (string, error) {
  182. streamStmt, err := p.DescStream(stmt.GetName(), st)
  183. if err != nil {
  184. return "", err
  185. }
  186. switch s := streamStmt.(type) {
  187. case *ast.StreamStmt:
  188. var buff bytes.Buffer
  189. buff.WriteString("Fields\n--------------------------------------------------------------------------------\n")
  190. for _, f := range s.StreamFields {
  191. buff.WriteString(f.Name + "\t")
  192. buff.WriteString(printFieldType(f.FieldType))
  193. buff.WriteString("\n")
  194. }
  195. buff.WriteString("\n")
  196. printOptions(s.Options, &buff)
  197. return buff.String(), err
  198. default:
  199. return "%s", fmt.Errorf("Error resolving the %s %s, the data in db may be corrupted.", ast.StreamTypeMap[st], stmt.GetName())
  200. }
  201. }
  202. func printOptions(opts *ast.Options, buff *bytes.Buffer) {
  203. if opts.CONF_KEY != "" {
  204. buff.WriteString(fmt.Sprintf("CONF_KEY: %s\n", opts.CONF_KEY))
  205. }
  206. if opts.DATASOURCE != "" {
  207. buff.WriteString(fmt.Sprintf("DATASOURCE: %s\n", opts.DATASOURCE))
  208. }
  209. if opts.FORMAT != "" {
  210. buff.WriteString(fmt.Sprintf("FORMAT: %s\n", opts.FORMAT))
  211. }
  212. if opts.KEY != "" {
  213. buff.WriteString(fmt.Sprintf("KEY: %s\n", opts.KEY))
  214. }
  215. if opts.RETAIN_SIZE != 0 {
  216. buff.WriteString(fmt.Sprintf("RETAIN_SIZE: %d\n", opts.RETAIN_SIZE))
  217. }
  218. if opts.SHARED {
  219. buff.WriteString(fmt.Sprintf("SHARED: %v\n", opts.SHARED))
  220. }
  221. if opts.STRICT_VALIDATION {
  222. buff.WriteString(fmt.Sprintf("STRICT_VALIDATION: %v\n", opts.STRICT_VALIDATION))
  223. }
  224. if opts.TIMESTAMP != "" {
  225. buff.WriteString(fmt.Sprintf("TIMESTAMP: %s\n", opts.TIMESTAMP))
  226. }
  227. if opts.TIMESTAMP_FORMAT != "" {
  228. buff.WriteString(fmt.Sprintf("TIMESTAMP_FORMAT: %s\n", opts.TIMESTAMP_FORMAT))
  229. }
  230. if opts.TYPE != "" {
  231. buff.WriteString(fmt.Sprintf("TYPE: %s\n", opts.TYPE))
  232. }
  233. }
  234. func (p *StreamProcessor) DescStream(name string, st ast.StreamType) (ast.Statement, error) {
  235. statement, err := p.getStream(name, st)
  236. if err != nil {
  237. return nil, fmt.Errorf("Describe %s fails, %s.", ast.StreamTypeMap[st], err)
  238. }
  239. parser := xsql.NewParser(strings.NewReader(statement))
  240. stream, err := xsql.Language.Parse(parser)
  241. if err != nil {
  242. return nil, err
  243. }
  244. return stream, nil
  245. }
  246. func (p *StreamProcessor) execExplain(stmt ast.NameNode, st ast.StreamType) (string, error) {
  247. _, err := p.getStream(stmt.GetName(), st)
  248. if err != nil {
  249. return "", fmt.Errorf("Explain %s fails, %s.", ast.StreamTypeMap[st], err)
  250. }
  251. return "TO BE SUPPORTED", nil
  252. }
  253. func (p *StreamProcessor) execDrop(stmt ast.NameNode, st ast.StreamType) (string, error) {
  254. s, err := p.DropStream(stmt.GetName(), st)
  255. if err != nil {
  256. return s, fmt.Errorf("Drop %s fails: %s.", ast.StreamTypeMap[st], err)
  257. }
  258. return s, nil
  259. }
  260. func (p *StreamProcessor) DropStream(name string, st ast.StreamType) (string, error) {
  261. _, err := p.getStream(name, st)
  262. if err != nil {
  263. return "", err
  264. }
  265. err = p.db.Delete(name)
  266. if err != nil {
  267. return "", err
  268. } else {
  269. return fmt.Sprintf("%s %s is dropped.", strings.Title(ast.StreamTypeMap[st]), name), nil
  270. }
  271. }
  272. func printFieldType(ft ast.FieldType) (result string) {
  273. switch t := ft.(type) {
  274. case *ast.BasicType:
  275. result = t.Type.String()
  276. case *ast.ArrayType:
  277. result = "array("
  278. if t.FieldType != nil {
  279. result += printFieldType(t.FieldType)
  280. } else {
  281. result += t.Type.String()
  282. }
  283. result += ")"
  284. case *ast.RecType:
  285. result = "struct("
  286. isFirst := true
  287. for _, f := range t.StreamFields {
  288. if isFirst {
  289. isFirst = false
  290. } else {
  291. result += ", "
  292. }
  293. result = result + f.Name + " " + printFieldType(f.FieldType)
  294. }
  295. result += ")"
  296. }
  297. return
  298. }