-
Notifications
You must be signed in to change notification settings - Fork 75
/
plan.go
136 lines (117 loc) · 3.52 KB
/
plan.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
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
package schemaherocli
import (
"fmt"
"os"
"path/filepath"
"github.com/pkg/errors"
"github.com/schemahero/schemahero/pkg/database"
"github.com/spf13/cobra"
"github.com/spf13/viper"
)
func Plan() *cobra.Command {
cmd := &cobra.Command{
Use: "plan",
Short: "plan a spec application against a database",
Long: `...`,
SilenceUsage: true,
PreRun: func(cmd *cobra.Command, args []string) {
viper.BindPFlags(cmd.Flags())
},
RunE: func(cmd *cobra.Command, args []string) error {
v := viper.GetViper()
// to support automaticenv, we can't use cobra required flags
driver := v.GetString("driver")
specFile := v.GetString("spec-file")
uri := v.GetString("uri")
vaultUriRef := v.GetString("vault-uri-ref")
if driver == "" || specFile == "" || (uri == "" && vaultUriRef == "") {
missing := []string{}
if driver == "" {
missing = append(missing, "driver")
}
if specFile == "" {
missing = append(missing, "spec-file")
}
if uri == "" && vaultUriRef == "" {
missing = append(missing, "uri or vault-uri-ref")
}
return fmt.Errorf("missing required params: %v", missing)
}
fi, err := os.Stat(v.GetString("spec-file"))
if err != nil {
return err
}
if _, err = os.Stat(v.GetString("out")); err == nil {
if !v.GetBool("overwrite") {
return errors.Errorf("file %s already exists", v.GetString("out"))
}
err = os.RemoveAll(v.GetString("out"))
if err != nil {
return errors.Wrap(err, "failed remove existing file")
}
}
var f *os.File
if v.GetString("out") != "" {
f, err = os.OpenFile(v.GetString("out"), os.O_APPEND|os.O_CREATE|os.O_WRONLY, 0644)
if err != nil {
return err
}
defer f.Close()
}
db := database.Database{
InputDir: v.GetString("input-dir"),
OutputDir: v.GetString("output-dir"),
Driver: v.GetString("driver"),
URI: v.GetString("uri"),
VaultURIRef: v.GetString("vault-uri-ref"),
}
if fi.Mode().IsDir() {
err := filepath.Walk(v.GetString("spec-file"), func(path string, info os.FileInfo, err error) error {
if !info.IsDir() {
statements, err := db.PlanSync(path)
if err != nil {
return err
}
if f != nil {
for _, statement := range statements {
if _, err := f.WriteString(fmt.Sprintf("%s;\n", statement)); err != nil {
return err
}
}
} else {
for _, statement := range statements {
fmt.Printf("%s;\n", statement)
}
}
}
return nil
})
return err
} else {
statements, err := db.PlanSync(v.GetString("spec-file"))
if err != nil {
return err
}
if f != nil {
for _, statement := range statements {
if _, err := f.WriteString(fmt.Sprintf("%s;\n", statement)); err != nil {
return err
}
}
} else {
for _, statement := range statements {
fmt.Printf("%s;\n", statement)
}
}
return nil
}
},
}
cmd.Flags().String("driver", "", "name of the database driver to use")
cmd.Flags().String("uri", "", "connection string uri to use")
cmd.Flags().String("vault-uri-ref", "", "URI-reference to Vault-injected connection URI")
cmd.Flags().String("spec-file", "", "filename or directory name containing the spec(s) to apply")
cmd.Flags().String("out", "", "filename to write DDL statements to, if not present output file be written to stdout")
cmd.Flags().Bool("overwrite", true, "when set, will overwrite the out file, if it already exists")
return cmd
}