forked from thmeitz/ksqldb-go
-
Notifications
You must be signed in to change notification settings - Fork 0
/
pull.go
103 lines (83 loc) · 2.58 KB
/
pull.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
/*
Copyright © 2021 Thomas Meitz
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/
package cmd
import (
"context"
"fmt"
"time"
"github.com/Masterminds/log-go"
"github.com/spf13/cobra"
"github.com/spf13/viper"
"github.com/DinoShambar/ksqldb-go"
"github.com/DinoShambar/ksqldb-go/net"
)
// pullCmd represents the pull command
var pullCmd = &cobra.Command{
Use: "pull",
Short: "print the dog stats",
}
func init() {
pullCmd.Run = dogstats
rootCmd.AddCommand(pullCmd)
pullCmd.Flags().StringP("dogsize", "d", "medium", "dogsizes are small|medium|large")
if err := viper.BindPFlag("dogsize", pullCmd.Flags().Lookup("dogsize")); err != nil {
log.Fatal(err)
}
}
func dogstats(cmd *cobra.Command, args []string) {
setLogger()
host := viper.GetString("host")
user := viper.GetString("username")
password := viper.GetString("password")
dogsize := viper.GetString("dogsize")
options := net.Options{
Credentials: net.Credentials{Username: user, Password: password},
BaseUrl: host,
AllowHTTP: true,
}
kcl, err := ksqldb.NewClientWithOptions(options)
if err != nil {
log.Fatal(err)
}
defer kcl.Close()
query := `select timestamptostring(windowstart,'yyyy-MM-dd HH:mm:ss','Europe/London') as window_start,
timestamptostring(windowend,'HH:mm:ss','Europe/London') as window_end, dog_size, dogs_ct
from dogs_by_size where dog_size=?;`
stmnt, err := ksqldb.QueryBuilder(query, dogsize)
if err != nil {
log.Fatal(err)
}
fmt.Println(*stmnt)
ctx, cancel := context.WithTimeout(context.TODO(), 50*time.Second)
defer cancel()
qOpts := (&ksqldb.QueryOptions{Sql: *stmnt}).EnablePullQueryTableScan(true)
log.Infof("%+v", qOpts)
_, r, err := kcl.Pull(ctx, *qOpts)
if err != nil {
log.Fatal(err)
}
var windowStart string
var windowEnd string
var dogSize string
var dogsCt float64
for _, row := range r {
if row != nil {
// Should do some type assertions here
windowStart = row[0].(string)
windowEnd = row[1].(string)
dogSize = row[2].(string)
dogsCt = row[3].(float64)
log.Infof("🐶 There are %v dogs size %v between %v and %v", dogsCt, dogSize, windowStart, windowEnd)
}
}
}