-
Notifications
You must be signed in to change notification settings - Fork 234
/
collection.go
71 lines (60 loc) · 2.25 KB
/
collection.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
// Copyright (c) 2012-present The upper.io/db authors. All rights reserved.
//
// Permission is hereby granted, free of charge, to any person obtaining
// a copy of this software and associated documentation files (the
// "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish,
// distribute, sublicense, and/or sell copies of the Software, and to
// permit persons to whom the Software is furnished to do so, subject to
// the following conditions:
//
// The above copyright notice and this permission notice shall be
// included in all copies or substantial portions of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
package cockroachdb
import (
db "github.com/upper/db/v4"
"github.com/upper/db/v4/internal/sqladapter"
)
type collectionAdapter struct {
}
func (*collectionAdapter) Insert(col sqladapter.Collection, item interface{}) (interface{}, error) {
pKey, err := col.PrimaryKeys()
if err != nil {
return nil, err
}
q := col.SQL().InsertInto(col.Name()).Values(item)
if len(pKey) == 0 {
// There is no primary key.
res, err := q.Exec()
if err != nil {
return nil, err
}
// Attempt to use LastInsertId() (probably won't work, but the Exec()
// succeeded, so we can safely ignore the error from LastInsertId()).
lastID, err := res.LastInsertId()
if err != nil {
return 0, nil
}
return lastID, nil
}
// Asking the database to return the primary key after insertion.
q = q.Returning(pKey...)
var keyMap db.Cond
if err := q.Iterator().One(&keyMap); err != nil {
return nil, err
}
// The IDSetter interface does not match, look for another interface match.
if len(keyMap) == 1 {
return keyMap[pKey[0]], nil
}
// This was a compound key and no interface matched it, let's return a map.
return keyMap, nil
}