forked from stellar/go
/
insert_builder.go
52 lines (40 loc) · 1.09 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
package db
import (
"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() (sql.Result, error) {
if len(ib.rows) == 0 {
return nil, &NoRowsError{}
}
template := ib.rows[0]
cols := columnsForStruct(template)
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(sql)
if err != nil {
return nil, errors.Wrap(err, "insert failed")
}
return r, nil
}
// Rows appends more rows onto the insert statement
func (ib *InsertBuilder) Rows(rows ...interface{}) *InsertBuilder {
ib.rows = append(ib.rows, rows...)
return ib
}