-
Notifications
You must be signed in to change notification settings - Fork 0
/
crud.go
77 lines (67 loc) · 1.97 KB
/
crud.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
package database
import (
_ "embed"
"strings"
"github.com/pkg/errors"
"zombiezen.com/go/sqlite"
"zombiezen.com/go/sqlite/sqlitex"
)
func ExecuteInsertion(conn *sqlite.Conn, query string, namedParams map[string]interface{}) error {
return errors.Wrap(
sqlitex.Execute(conn, query, &sqlitex.ExecOptions{
Named: namedParams,
}),
"couldn't execute insertion statement",
)
}
//go:embed select-last-insert-rowid.sql
var rawSelectLastInsertRowIDQuery string
var selectLastInsertRowIDQuery string = strings.TrimSpace(rawSelectLastInsertRowIDQuery)
func ExecuteInsertionForID(
conn *sqlite.Conn, query string, namedParams map[string]interface{},
) (rowID int64, err error) {
defer sqlitex.Save(conn)(&err)
if err = sqlitex.Execute(conn, query, &sqlitex.ExecOptions{
Named: namedParams,
}); err != nil {
return 0, errors.Wrapf(err, "couldn't execute insertion statement")
}
if err = sqlitex.Execute(conn, selectLastInsertRowIDQuery, &sqlitex.ExecOptions{
ResultFunc: func(s *sqlite.Stmt) error {
// TODO: instead
rowID = s.GetInt64("row_id")
return nil
},
}); err != nil {
return 0, errors.Wrapf(err, "couldn't look up id of inserted row")
}
return rowID, err
}
func ExecuteUpdate(conn *sqlite.Conn, query string, namedParams map[string]interface{}) error {
return errors.Wrap(
sqlitex.Execute(conn, query, &sqlitex.ExecOptions{
Named: namedParams,
}),
"couldn't execute update statement",
)
}
func ExecuteDelete(conn *sqlite.Conn, query string, namedParams map[string]interface{}) error {
return errors.Wrap(
sqlitex.Execute(conn, query, &sqlitex.ExecOptions{
Named: namedParams,
}),
"couldn't execute delete statement",
)
}
func ExecuteSelection(
conn *sqlite.Conn, query string, namedParams map[string]interface{},
resultFunc func(s *sqlite.Stmt) error,
) error {
return errors.Wrap(
sqlitex.Execute(conn, query, &sqlitex.ExecOptions{
Named: namedParams,
ResultFunc: resultFunc,
}),
"couldn't execute selection statement",
)
}