forked from go-reform/reform
-
Notifications
You must be signed in to change notification settings - Fork 0
/
cmd_exec.go
74 lines (65 loc) · 1.67 KB
/
cmd_exec.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
package main
import (
"bytes"
"flag"
"fmt"
"io/ioutil"
"os"
"gopkg.in/reform.v1"
)
var (
execFlags = flag.NewFlagSet("exec", flag.ExitOnError)
)
func init() {
execFlags.Usage = func() {
fmt.Fprintf(os.Stderr, "`exec` command executes SQL queries from given files or stdin.\n\n")
fmt.Fprintf(os.Stderr, "Usage:\n")
fmt.Fprintf(os.Stderr, " %s [global flags] exec [file names]\n\n", os.Args[0])
fmt.Fprintf(os.Stderr, "Global flags:\n")
flag.PrintDefaults()
execFlags.PrintDefaults()
fmt.Fprintf(os.Stderr, `
Each file's content is executed as a single query. If it contains multiple
statements, make sure SQL driver supports them. If file names are not given,
a query is read from stdin until EOF, then executed.
`)
}
}
// readFiles reads queries from given files, or from stdin, if files are not given
func readFiles(files []string) (queries []string) {
// read stdin
if len(files) == 0 {
logger.Debugf("no files are given, reading stdin")
b, err := ioutil.ReadAll(os.Stdin)
if err != nil {
logger.Fatalf("failed to read stdin: %s", err)
}
b = bytes.TrimSpace(b)
if len(b) > 0 {
queries = append(queries, string(b))
}
return
}
// read files
for _, f := range files {
logger.Debugf("reading file %s", f)
b, err := ioutil.ReadFile(f)
if err != nil {
logger.Fatalf("failed to read file %s: %s", f, err)
}
b = bytes.TrimSpace(b)
if len(b) > 0 {
queries = append(queries, string(b))
}
}
return
}
// cmdExec implements exec command.
func cmdExec(db *reform.DB, files []string) {
queries := readFiles(files)
for _, q := range queries {
if _, err := db.Exec(q); err != nil {
logger.Fatalf("failed to execute %s: %s", q, err)
}
}
}