sink.go 6.3 KB

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