-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert.go
100 lines (90 loc) · 2.24 KB
/
insert.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
package sorm
import (
"fmt"
"reflect"
"strings"
_ "github.com/mattn/go-sqlite3"
)
func (db *Database) InsertInto(models ...interface{}) error {
logNotice("Starting insert transaction")
// Starts database transaction
tx, err := db.Connection.Begin()
if err != nil {
logError(fmt.Sprintf("db.Connection.Begin: %v", err))
return err
}
defer func() {
if p := recover(); p != nil {
if rbErr := tx.Rollback(); rbErr != nil {
err = fmt.Errorf("rollback error: %v, original panic: %v", rbErr, p)
} else {
panic(p) // re-throw panic after Rollback
}
} else if err != nil {
if rbErr := tx.Rollback(); rbErr != nil {
err = fmt.Errorf("rollback error: %v, original error: %v", rbErr, err)
}
} else {
if err = tx.Commit(); err != nil {
err = fmt.Errorf("commit error: %v", err)
}
}
}()
// insert
for _, model := range models {
t := reflect.TypeOf(model)
v := reflect.ValueOf(model)
tableName := t.Name()
fields := []string{}
placeholders := []string{}
values := []interface{}{}
logInfo(fmt.Sprintf("Inserting into %v", tableName))
for i := 0; i < t.NumField(); i++ {
field := t.Field(i)
fields = append(fields, field.Name)
placeholders = append(placeholders, "?")
values = append(values, defaultNil(field.Type, v.Field(i).Interface()))
// values = append(values, v.Field(i).Interface())
}
query := fmt.Sprintf("INSERT INTO %s (%s) VALUES (%s);", tableName, strings.Join(fields, ", "), strings.Join(placeholders, ", ")) // #nosec G201
stmt, err := tx.Prepare(query)
if err != nil {
logError(fmt.Sprintf("tx.Prepare: %v", err))
return err
}
defer stmt.Close()
_, err = stmt.Exec(values...)
if err != nil {
logError(fmt.Sprintf("stmt.Exec: %v", err))
return err
}
}
logSuccess("Items inserted")
return err
}
func defaultNil(goType reflect.Type, value interface{}) interface{} {
sqlType := sqlType(goType)
switch sqlType {
case "INTEGER":
if value == 0 {
return 0
}
return value
case "REAL":
if value == 0.0 {
return 0.0
}
return value
case "BOOLEAN":
if value == false {
return 0
}
return value
case "TEXT":
if value == "" {
return "nil"
}
return value
}
return value
}