-
Notifications
You must be signed in to change notification settings - Fork 1
/
postgres_persister.go
56 lines (51 loc) · 1.37 KB
/
postgres_persister.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
package persist
import (
"database/sql"
"fmt"
"log"
"strconv"
"github.com/lib/pq"
"github.com/ourrootsorg/cms-server/model"
)
// PostgresPersister persists the model objects to Postgresql
type PostgresPersister struct {
db *sql.DB
}
// NewPostgresPersister constructs a new PostgresPersister
func NewPostgresPersister(db *sql.DB) PostgresPersister {
return PostgresPersister{
db: db,
}
}
func translateError(err error, id *uint32, refID *uint32, refType string) error {
switch err {
case nil:
return nil
case sql.ErrConnDone:
return model.NewError(model.ErrOther, err.Error())
case sql.ErrNoRows:
var sid string
if id != nil {
sid = strconv.Itoa(int(*id))
}
return model.NewError(model.ErrNotFound, sid)
case sql.ErrTxDone:
return model.NewError(model.ErrOther, err.Error())
default:
pqErr, ok := err.(*pq.Error)
if !ok {
log.Printf("[INFO] Untranslated error: %#v", err)
return model.NewError(model.ErrOther, err.Error())
}
switch pqErr.Code.Name() {
case "foreign_key_violation":
if refID != nil {
return model.NewError(model.ErrBadReference, strconv.Itoa(int(*refID)), refType)
}
return model.NewError(model.ErrOther, fmt.Sprintf("Foreign key violation, but reference information not supplied: %v", err))
default:
log.Printf("[INFO] Untranslated PQ error: %#v", err)
return model.NewError(model.ErrOther, err.Error())
}
}
}