-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmain.go
More file actions
186 lines (165 loc) · 3.43 KB
/
main.go
File metadata and controls
186 lines (165 loc) · 3.43 KB
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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
package main
import (
"database/sql"
"fmt"
"html/template"
"log"
"os"
"strings"
_ "github.com/go-sql-driver/mysql"
"github.com/spf13/viper"
)
var DB *sql.DB
var Dsn string
var DBName string
var OutDir string
var InTpl string
var Tables []string
var GoPackage string
var Package string
func init() {
viper.SetConfigFile("config.yml")
err := viper.ReadInConfig()
if err != nil {
log.Fatal(err)
}
Dsn = viper.GetString("db.dsn")
DBName = viper.GetString("db.db_name")
OutDir = viper.GetString("config.out_dir")
if OutDir == "" {
OutDir = "message"
}
GoPackage = viper.GetString("config.go_package")
if GoPackage == "" {
GoPackage = OutDir
}
InTpl = viper.GetString("config.in_tpl")
if InTpl == "" {
InTpl = "proto.tpl"
}
Package = viper.GetString("config.package")
Tables = viper.GetStringSlice("db.db_tables")
}
func main() {
Run(DBName)
}
func Run(dbName string) {
db, err := Connect("mysql", Dsn)
if err != nil {
log.Fatal("db连接失败")
}
DB = db
all := GetTables(dbName)
if len(Tables) > 0 {
var b []string
for _, v := range Tables {
for _, v2 := range all {
if v2 == v {
b = append(b, v2)
break
}
}
}
all = b
}
if len(all) == 0 {
return
}
var messages []Message
for _, v := range all {
var one Message
one.Name = v
all := GetStruct(v, dbName)
for k, v2 := range all {
all[k].Type = TypeMToP(v2.Type)
}
one.MessageDetail = all
messages = append(messages, one)
}
Genarate(OutDir, messages)
}
func Genarate(dir string, all []Message) {
tmpl, err := template.ParseFiles(InTpl)
if err != nil {
log.Fatal(err)
}
_, err = os.Stat(dir)
if err != nil {
// 创建文件夹
os.MkdirAll(dir, 0755)
}
// 循环，创建具体得文件
for _, v := range all {
filepath := fmt.Sprintf("%v/%v.proto", dir, v.Name)
file, err := os.OpenFile(filepath, os.O_CREATE|os.O_WRONLY|os.O_TRUNC, 0755)
if err != nil {
log.Fatal(err)
}
v.GoPackage = GoPackage
v.Package = Package
err = tmpl.Execute(file, v)
if err != nil {
log.Fatal(err)
}
}
}
func GetTables(dbName string) []string {
rows, err := DB.Query(fmt.Sprintf(`SELECT TABLE_NAME FROM information_schema.TABLES t WHERE t.TABLE_SCHEMA = "%v"`, dbName))
if err != nil {
log.Fatal(err)
}
defer rows.Close()
var all []string
for rows.Next() {
var name string
rows.Scan(&name)
all = append(all, name)
}
if err = rows.Err(); err != nil {
log.Fatal(err)
}
return all
}
func GetStruct(dbTable, dbName string) []TableFied {
rows, err := DB.Query("SELECT c.COLUMN_NAME,c.COLUMN_TYPE,c.COLUMN_COMMENT FROM INFORMATION_SCHEMA.Columns c WHERE c.`TABLE_SCHEMA`='" + dbName + "' AND c.TABLE_NAME = '" + dbTable + "' ORDER BY c.ORDINAL_POSITION" )
if err != nil {
log.Fatal(err)
}
defer rows.Close()
var all []TableFied
var num = 1
for rows.Next() {
var one TableFied
rows.Scan(&one.Name, &one.Type, &one.Comment)
one.Num = num
n := strings.Index(one.Type, "(")
if n > 0 {
one.Type = one.Type[0:n]
}
n = strings.Index(one.Type, " ")
if n > 0 {
one.Type = one.Type[0:n]
}
all = append(all, one)
num++
}
return all
}
func Connect(driverName, dsn string) (*sql.DB, error) {
db, err := sql.Open(driverName, dsn)
if err != nil {
log.Fatalln(err)
}
db.SetMaxIdleConns(0)
db.SetMaxOpenConns(30)
if err := db.Ping(); err != nil {
log.Fatalln(err)
}
return db, err
}
func TypeMToP(m string) string {
if _, ok := typeArr[m]; ok {
return typeArr[m]
}
return "string"
}