/
util.go
115 lines (101 loc) · 2.92 KB
/
util.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
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
package shifter
import (
"errors"
"fmt"
"reflect"
"strings"
"github.com/go-pg/pg"
)
//getStructTableName will return table name from table struct
func (s *Shifter) getStructTableName(table interface{}) (
tableName string, err error) {
refObj := reflect.ValueOf(table)
if refObj.Kind() != reflect.Ptr || refObj.Elem().Kind() != reflect.Struct {
msg := fmt.Sprintf("Expected struct pointer of struct but found %v", refObj.Kind().String())
err = errors.New(msg)
} else {
if field, exists := getStructTableNameField(table); exists {
tableName = field.Tag.Get("sql")
} else {
msg := "tableName struct{} field not found in given struct"
err = errors.New(msg)
}
}
return
}
//SetTableModel will set table struct pointer to shifter
func (s *Shifter) SetTableModel(table interface{}) (err error) {
var tableName string
if tableName, err = s.getStructTableName(table); err == nil {
s.table[tableName] = table
}
return
}
// SetTableModels will set multiple table struct pointer to shifter.
// You can set all the table struct pointers and then perform operation by table name only
func (s *Shifter) SetTableModels(tables []interface{}) (err error) {
for _, table := range tables {
if err = s.SetTableModel(table); err != nil {
break
}
}
return
}
//SetEnum will set global enum list
func (s *Shifter) SetEnum(enum map[string][]string) (err error) {
s.enumList = enum
return
}
//getTableTriggersTag will return trigger tag which need to create on table
func (s *Shifter) getTableTriggersTag(tableName string) (tag []string) {
tag = make([]string, 0)
if model, exists := s.table[tableName]; exists {
if field, exists := getStructTableNameField(model); exists {
trigger, exists := field.Tag.Lookup(TriggerTag)
if exists == true {
for _, v := range strings.Split(trigger, ",") {
tag = append(tag, strings.TrimSpace(v))
}
} else {
tag = []string{afterInsertTrigger, afterUpdateTrigger, afterDeleteTrigger, beforeUpdateTrigger}
}
}
}
return
}
//getStructTableNameField will return struct tableName field
func getStructTableNameField(model interface{}) (field reflect.StructField, exists bool) {
refObj := reflect.ValueOf(model)
if refObj.Kind() == reflect.Ptr {
field, exists = refObj.Elem().Type().FieldByName("tableName")
}
return
}
//getTableName will check model is struct of string
//and return table name based on that
func (s *Shifter) getTableName(model interface{}) (
tableName string, err error) {
if reflect.TypeOf(model).Kind() == reflect.String {
tableName = model.(string)
} else {
if err = s.SetTableModel(model); err == nil {
tableName, err = s.getStructTableName(model)
}
}
return
}
//getSP will return skip prompt value
func getSP(val []bool) (skipPrompt bool) {
if len(val) > 0 {
skipPrompt = val[0]
}
return
}
//commitIfNil will commit transation if error is nil
func commitIfNil(tx *pg.Tx, err error) {
if err == nil {
tx.Commit()
} else {
tx.Rollback()
}
}