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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
package main
import (
"context"
"crypto/tls"
"crypto/x509"
"fmt"
"io"
"io/ioutil"
"os"
"strings"
"github.com/cowsql/go-cowsql/app"
"github.com/cowsql/go-cowsql/client"
"github.com/cowsql/go-cowsql/internal/shell"
"github.com/peterh/liner"
"github.com/spf13/cobra"
)
func main() {
var crt string
var key string
var servers *[]string
var format string
cmd := &cobra.Command{
Use: "cowsql -s <servers> <database> [command]",
Short: "Standard cowsql shell",
Args: cobra.RangeArgs(1, 2),
RunE: func(cmd *cobra.Command, args []string) error {
if len(*servers) == 0 {
return fmt.Errorf("no servers provided")
}
var store client.NodeStore
var err error
first := (*servers)[0]
if strings.HasPrefix(first, "file://") {
if len(*servers) > 1 {
return fmt.Errorf("can't mix server store and explicit list")
}
path := first[len("file://"):]
if _, err := os.Stat(path); err != nil {
return fmt.Errorf("open servers store: %w", err)
}
store, err = client.DefaultNodeStore(path)
if err != nil {
return fmt.Errorf("open servers store: %w", err)
}
} else {
infos := make([]client.NodeInfo, len(*servers))
for i, address := range *servers {
infos[i].Address = address
}
store = client.NewInmemNodeStore()
store.Set(context.Background(), infos)
}
if (crt != "" && key == "") || (key != "" && crt == "") {
return fmt.Errorf("both TLS certificate and key must be given")
}
dial := client.DefaultDialFunc
if crt != "" {
cert, err := tls.LoadX509KeyPair(crt, key)
if err != nil {
return err
}
data, err := ioutil.ReadFile(crt)
if err != nil {
return err
}
pool := x509.NewCertPool()
if !pool.AppendCertsFromPEM(data) {
return fmt.Errorf("bad certificate")
}
config := app.SimpleDialTLSConfig(cert, pool)
dial = client.DialFuncWithTLS(dial, config)
}
sh, err := shell.New(args[0], store, shell.WithDialFunc(dial), shell.WithFormat(format))
if err != nil {
return err
}
if len(args) > 1 {
for _, input := range strings.Split(args[1], ";") {
result, err := sh.Process(context.Background(), input)
if err != nil {
return err
} else if result != "" {
fmt.Println(result)
}
}
return nil
}
line := liner.NewLiner()
defer line.Close()
for {
input, err := line.Prompt("cowsql> ")
if err != nil {
if err == io.EOF {
break
}
return err
}
result, err := sh.Process(context.Background(), input)
if err != nil {
fmt.Println("Error: ", err)
} else {
line.AppendHistory(input)
if result != "" {
fmt.Println(result)
}
}
}
return nil
},
}
flags := cmd.Flags()
servers = flags.StringSliceP("servers", "s", nil, "comma-separated list of db servers, or file://<store>")
flags.StringVarP(&crt, "cert", "c", "", "public TLS cert")
flags.StringVarP(&key, "key", "k", "", "private TLS key")
flags.StringVarP(&format, "format", "f", "tabular", "output format (tabular, json)")
cmd.MarkFlagRequired("servers")
if err := cmd.Execute(); err != nil {
os.Exit(1)
}
}
|
