forked from go-gorm/gen
-
Notifications
You must be signed in to change notification settings - Fork 0
/
table.go
70 lines (57 loc) · 1.79 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
package generate
import (
"context"
"errors"
"gorm.io/gorm"
"github.com/JasonTangJun/gen/internalopen/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 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)
}