sink.go 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226
  1. // Copyright 2021-2023 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. //go:build redisdb || !core
  15. package redis
  16. import (
  17. "encoding/json"
  18. "errors"
  19. "fmt"
  20. "github.com/lf-edge/ekuiper/internal/topo/transform"
  21. "github.com/lf-edge/ekuiper/pkg/api"
  22. "github.com/lf-edge/ekuiper/pkg/ast"
  23. "github.com/lf-edge/ekuiper/pkg/cast"
  24. "github.com/redis/go-redis/v9"
  25. "time"
  26. )
  27. type config struct {
  28. // host:port address.
  29. Addr string `json:"addr,omitempty"`
  30. Username string `json:"username,omitempty"`
  31. // Optional password. Must match the password specified in the
  32. Password string `json:"password,omitempty"`
  33. // Database to be selected after connecting to the server.
  34. Db int `json:"db,omitempty"`
  35. // key of field
  36. Field string `json:"field,omitempty"`
  37. // key define
  38. Key string `json:"key,omitempty"`
  39. KeyType string `json:"keyType,omitempty"`
  40. DataType string `json:"dataType,omitempty"`
  41. Expiration time.Duration `json:"expiration,omitempty"`
  42. RowkindField string `json:"rowkindField"`
  43. DataTemplate string `json:"dataTemplate"`
  44. Fields []string `json:"fields"`
  45. }
  46. type RedisSink struct {
  47. c *config
  48. cli *redis.Client
  49. }
  50. func (r *RedisSink) Configure(props map[string]interface{}) error {
  51. c := &config{DataType: "string", Expiration: -1, KeyType: "single"}
  52. err := cast.MapToStruct(props, c)
  53. if err != nil {
  54. return err
  55. }
  56. if c.KeyType == "single" && c.Key == "" && c.Field == "" {
  57. return errors.New("redis sink must have key or field when KeyType is single")
  58. }
  59. if c.KeyType != "single" && c.KeyType != "multiple" {
  60. return errors.New("KeyType only support single or multiple")
  61. }
  62. if c.DataType != "string" && c.DataType != "list" {
  63. return errors.New("redis sink only support string or list data type")
  64. }
  65. r.c = c
  66. return nil
  67. }
  68. func (r *RedisSink) Open(ctx api.StreamContext) (err error) {
  69. logger := ctx.GetLogger()
  70. logger.Debug("Opening redis sink")
  71. r.cli = redis.NewClient(&redis.Options{
  72. Addr: r.c.Addr,
  73. Username: r.c.Username,
  74. Password: r.c.Password,
  75. DB: r.c.Db, // use default DB
  76. })
  77. _, err = r.cli.Ping(ctx).Result()
  78. return err
  79. }
  80. func (r *RedisSink) Collect(ctx api.StreamContext, data interface{}) error {
  81. logger := ctx.GetLogger()
  82. var val string
  83. if r.c.DataTemplate != "" { // The result is a string
  84. v, _, err := ctx.TransformOutput(data, true)
  85. if err != nil {
  86. logger.Error(err)
  87. return err
  88. }
  89. m := make(map[string]interface{})
  90. err = json.Unmarshal(v, &m)
  91. if err != nil {
  92. return fmt.Errorf("fail to decode data %s after applying dataTemplate for error %v", string(v), err)
  93. }
  94. data = m
  95. val = string(v)
  96. } else if len(r.c.Fields) > 0 {
  97. m, err := transform.SelectMap(data, r.c.Fields)
  98. if err != nil {
  99. return fmt.Errorf("fail to select fields %v for data %v", r.c.Fields, data)
  100. }
  101. data = m
  102. }
  103. switch d := data.(type) {
  104. case []map[string]interface{}:
  105. for _, el := range d {
  106. err := r.save(ctx, el, val)
  107. if err != nil {
  108. return err
  109. }
  110. }
  111. case map[string]interface{}:
  112. err := r.save(ctx, d, val)
  113. if err != nil {
  114. return err
  115. }
  116. default:
  117. return fmt.Errorf("unrecognized format of %s", data)
  118. }
  119. logger.Debug("insert success %v", data)
  120. return nil
  121. }
  122. func (r *RedisSink) Close(ctx api.StreamContext) error {
  123. ctx.GetLogger().Infof("Closing redis sink")
  124. err := r.cli.Close()
  125. return err
  126. }
  127. func (r *RedisSink) save(ctx api.StreamContext, data map[string]interface{}, val string) error {
  128. logger := ctx.GetLogger()
  129. // prepare key value pairs
  130. values := make(map[string]string)
  131. if r.c.KeyType == "multiple" {
  132. for key, val := range data {
  133. v, _ := cast.ToString(val, cast.CONVERT_ALL)
  134. values[key] = v
  135. }
  136. } else {
  137. if val == "" {
  138. jsonBytes, err := json.Marshal(data)
  139. if err != nil {
  140. return err
  141. }
  142. val = string(jsonBytes)
  143. }
  144. key := r.c.Key
  145. var err error
  146. if r.c.Field != "" {
  147. keyval, ok := data[r.c.Field]
  148. if !ok {
  149. return fmt.Errorf("field %s does not exist in data %v", r.c.Field, data)
  150. }
  151. key, err = cast.ToString(keyval, cast.CONVERT_ALL)
  152. if err != nil {
  153. return fmt.Errorf("key must be string or convertible to string, but got %v", keyval)
  154. }
  155. }
  156. values[key] = val
  157. }
  158. //get action type
  159. rowkind := ast.RowkindUpsert
  160. if r.c.RowkindField != "" {
  161. c, ok := data[r.c.RowkindField]
  162. if ok {
  163. rowkind, ok = c.(string)
  164. if !ok {
  165. return fmt.Errorf("rowkind field %s is not a string in data %v", r.c.RowkindField, data)
  166. }
  167. if rowkind != ast.RowkindInsert && rowkind != ast.RowkindUpdate && rowkind != ast.RowkindDelete && rowkind != ast.RowkindUpsert {
  168. return fmt.Errorf("invalid rowkind %s", rowkind)
  169. }
  170. }
  171. }
  172. //set key value pairs
  173. for key, val := range values {
  174. var err error
  175. switch rowkind {
  176. case ast.RowkindInsert, ast.RowkindUpdate, ast.RowkindUpsert:
  177. if r.c.DataType == "list" {
  178. err = r.cli.LPush(ctx, key, val).Err()
  179. if err != nil {
  180. return fmt.Errorf("lpush %s:%s error, %v", key, val, err)
  181. }
  182. logger.Debugf("push redis list success, key:%s data: %v", key, val)
  183. } else {
  184. err = r.cli.Set(ctx, key, val, r.c.Expiration*time.Second).Err()
  185. if err != nil {
  186. return fmt.Errorf("set %s:%s error, %v", key, val, err)
  187. }
  188. logger.Debugf("set redis string success, key:%s data: %s", key, val)
  189. }
  190. case ast.RowkindDelete:
  191. if r.c.DataType == "list" {
  192. err = r.cli.LPop(ctx, key).Err()
  193. if err != nil {
  194. return fmt.Errorf("lpop %s error, %v", key, err)
  195. }
  196. logger.Debugf("pop redis list success, key:%s data: %v", key, val)
  197. } else {
  198. err = r.cli.Del(ctx, key).Err()
  199. if err != nil {
  200. logger.Error(err)
  201. return err
  202. }
  203. logger.Debugf("delete redis string success, key:%s data: %s", key, val)
  204. }
  205. default:
  206. // never happen
  207. logger.Errorf("unexpected rowkind %s", rowkind)
  208. }
  209. }
  210. return nil
  211. }
  212. func GetSink() api.Sink {
  213. return &RedisSink{}
  214. }