-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_builder.go
76 lines (61 loc) · 1.6 KB
/
insert_builder.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
package db
import (
"context"
"database/sql"
"reflect"
"github.com/pkg/errors"
)
// Exec executes the query represented by the builder, inserting each val
// provided to the builder into the database.
func (ib *InsertBuilder) Exec(ctx context.Context) (sql.Result, error) {
if len(ib.rows) == 0 {
return nil, &NoRowsError{}
}
template := ib.rows[0]
cols := ColumnsForStruct(template)
if ib.ignoredCols != nil {
finalCols := make([]string, 0, len(cols))
for _, col := range cols {
if ib.ignoredCols[col] {
continue
}
finalCols = append(finalCols, col)
}
cols = finalCols
}
sql := ib.sql.Columns(cols...)
// add rows onto the builder
for _, row := range ib.rows {
// extract field values
rrow := reflect.ValueOf(row)
rvals := mapper.FieldsByName(rrow, cols)
// convert fields values to interface{}
vals := make([]interface{}, len(cols))
for i, rval := range rvals {
vals[i] = rval.Interface()
}
// append row to insert statement
sql = sql.Values(vals...)
}
// TODO: support return inserted id
r, err := ib.Table.Session.Exec(ctx, sql)
if err != nil {
return nil, errors.Wrap(err, "insert failed")
}
return r, nil
}
// IgnoreCols adds colums to ignore list (will not be inserted)
func (ib *InsertBuilder) IgnoreCols(cols ...string) *InsertBuilder {
if ib.ignoredCols == nil {
ib.ignoredCols = make(map[string]bool)
}
for _, col := range cols {
ib.ignoredCols[col] = true
}
return ib
}
// Rows appends more rows onto the insert statement
func (ib *InsertBuilder) Rows(rows ...interface{}) *InsertBuilder {
ib.rows = append(ib.rows, rows...)
return ib
}