/
dbclient.go
88 lines (76 loc) · 2.13 KB
/
dbclient.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
78
79
80
81
82
83
84
85
86
87
88
// Copyright (c) 2021 Terminus, Inc.
//
// This program is free software: you can use, redistribute, and/or modify
// it under the terms of the GNU Affero General Public License, version 3
// or later ("AGPL"), as published by the Free Software Foundation.
//
// This program is distributed in the hope that it will be useful, but WITHOUT
// ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
// FITNESS FOR A PARTICULAR PURPOSE.
//
// You should have received a copy of the GNU Affero General Public License
// along with this program. If not, see <http://www.gnu.org/licenses/>.
// Package dbclient 定义数据库操作的方法, orm 等。
package dao
import (
"fmt"
"reflect"
"github.com/erda-project/erda/modules/dop/conf"
"github.com/erda-project/erda/pkg/database/dbengine"
"github.com/jinzhu/gorm"
gormbulk "github.com/t-tiger/gorm-bulk-insert"
)
const BULK_INSERT_CHUNK_SIZE = 3000
type DBClient struct {
*dbengine.DBEngine
}
func Open() (*DBClient, error) {
engine, err := dbengine.Open()
if err != nil {
return nil, err
}
if conf.Debug() {
engine.LogMode(true)
}
db := DBClient{DBEngine: engine}
// custom init
if err := db.initOpts(); err != nil {
return nil, err
}
return &db, nil
}
func (db *DBClient) Close() error {
if db == nil || db.DBEngine == nil {
return nil
}
return db.DBEngine.Close()
}
// TODO: 自定义初始化内容
func (db *DBClient) initOpts() error {
return nil
}
func (db *DBClient) BulkInsert(objects interface{}, excludeColumns ...string) error {
v := reflect.ValueOf(objects)
if v.Kind() != reflect.Slice {
return fmt.Errorf("invalid objects type, must be a slice of struct")
}
var structSlice []interface{}
for i := 0; i < v.Len(); i++ {
structSlice = append(structSlice, v.Index(i).Interface())
}
return gormbulk.BulkInsert(db.DB, structSlice, BULK_INSERT_CHUNK_SIZE, excludeColumns...)
}
// Transaction Execute Transaction
func (db *DBClient) Transaction(f func(tx *gorm.DB) error) error {
tx := db.Begin()
defer func() {
if r := recover(); r != nil {
tx.Rollback()
}
}()
if err := f(tx); err != nil {
tx.Rollback()
return err
}
return tx.Commit().Error
}