/
main.go
90 lines (81 loc) · 1.79 KB
/
main.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
package main
import (
"flag"
"fmt"
"github.com/phayes/errors"
"github.com/vaughan0/go-ini"
"io/ioutil"
"log"
"os"
"os/exec"
"regexp"
"strings"
)
var (
ErrDataDir = errors.New("Could not determine mysql data directory")
ErrInvalidDB = errors.New("Invalid database name")
ErrInvalidDir = errors.New("Invalid database directory")
ValidDBName = regexp.MustCompile("[0-9a-zA-Z$_]+")
DataDir string
)
func main() {
flag.Parse()
c, err := ini.LoadFile("/etc/my.cnf")
if err != nil {
// Syntax errors are OK because my.cnf contains weird syntax
if _, ok := err.(ini.ErrSyntax); !ok {
log.Fatal(err)
}
}
var ok bool
DataDir, ok = c.Get("mysqld", "datadir")
if !ok {
log.Fatal(ErrDataDir)
}
var databases []string
if flag.Arg(0) != "" {
db := flag.Arg(0)
if !ValidDBName.MatchString(db) {
log.Fatal(ErrInvalidDB)
}
databases = []string{flag.Arg(0)}
} else {
databases = make([]string, 0)
files, err := ioutil.ReadDir(DataDir)
if err != nil {
log.Fatal(err)
}
for _, file := range files {
if file.IsDir() && ValidDBName.MatchString(file.Name()) {
databases = append(databases, file.Name())
}
}
}
for _, db := range databases {
size, err := GetDBSize(db)
if err != nil {
log.Fatal(err)
}
if flag.Arg(0) == "" {
fmt.Println(db + " " + size)
} else {
fmt.Println(size)
}
}
}
func GetDBSize(dbname string) (size string, err error) {
info, err := os.Stat(DataDir + "/" + dbname)
if err != nil {
return "", err
}
if !info.IsDir() {
return "", ErrInvalidDir
}
cmd := exec.Command("du", DataDir+"/"+dbname, "-s", "-k")
output, err := cmd.CombinedOutput()
if err != nil {
return "", errors.Append(err, errors.New(string(output)))
}
size = strings.TrimSpace(strings.Split(string(output), "\t")[0])
return size, nil
}