-
-
Notifications
You must be signed in to change notification settings - Fork 290
/
table.go
88 lines (73 loc) · 2.17 KB
/
table.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
package generate
import (
"context"
"errors"
"gorm.io/gorm"
"gorm.io/gen/internal/model"
)
// ITableInfo table info interface
type ITableInfo interface {
GetTableColumns(schemaName string, tableName string) (result []*model.Column, err error)
GetTableIndex(schemaName string, tableName string) (indexes []gorm.Index, err error)
}
func getTableInfo(db *gorm.DB) ITableInfo {
return &tableInfo{db}
}
func getTableComment(db *gorm.DB, tableName string) string {
table, err := getTableType(db, tableName)
if err != nil || table == nil {
return ""
}
if comment, ok := table.Comment(); ok {
return comment
}
return ""
}
func getTableType(db *gorm.DB, tableName string) (result gorm.TableType, err error) {
if db == nil || db.Migrator() == nil {
return
}
return db.Migrator().TableType(tableName)
}
func getTableColumns(db *gorm.DB, schemaName string, tableName string, indexTag bool) (result []*model.Column, err error) {
if db == nil {
return nil, errors.New("gorm db is nil")
}
mt := getTableInfo(db)
result, err = mt.GetTableColumns(schemaName, tableName)
if err != nil {
return nil, err
}
if !indexTag || len(result) == 0 {
return result, nil
}
index, err := mt.GetTableIndex(schemaName, tableName)
if err != nil { //ignore find index err
db.Logger.Warn(context.Background(), "GetTableIndex for %s,err=%s", tableName, err.Error())
return result, nil
}
if len(index) == 0 {
return result, nil
}
im := model.GroupByColumn(index)
for _, c := range result {
c.Indexes = im[c.Name()]
}
return result, nil
}
type tableInfo struct{ *gorm.DB }
// GetTableColumns struct
func (t *tableInfo) GetTableColumns(schemaName string, tableName string) (result []*model.Column, err error) {
types, err := t.Migrator().ColumnTypes(tableName)
if err != nil {
return nil, err
}
for _, column := range types {
result = append(result, &model.Column{ColumnType: column, TableName: tableName, UseScanType: t.Dialector.Name() != "mysql" && t.Dialector.Name() != "sqlite"})
}
return result, nil
}
// GetTableIndex index
func (t *tableInfo) GetTableIndex(schemaName string, tableName string) (indexes []gorm.Index, err error) {
return t.Migrator().GetIndexes(tableName)
}