dbo/connector.go at master · Cyberpull/dbo · GitHub

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
89
package dbo

import (
	"time"

	"github.com/Cyberpull/dbo/clauses"
	"github.com/Cyberpull/dbo/scopes"

	"gorm.io/gorm"
)

type ConnectionCallback func(db *gorm.DB) *gorm.DB

type Connector interface {
	Connect(callback ...ConnectionCallback) (inst Instance, err error)
}

type xConnector struct {
	opts Options
}

func (x *xConnector) Connect(callback ...ConnectionCallback) (inst Instance, err error) {
	var db *gorm.DB
	var conn gorm.Dialector

	config := x.opts.getConfig()

	if conn, err = x.opts.getDialector(); err != nil {
		return
	}

	if db, err = gorm.Open(conn, config); err != nil {
		return
	}

	sqldb, err := db.DB()

	if err != nil {
		return
	}

	if x.opts.MaxOpenConns > 0 {
		sqldb.SetMaxOpenConns(x.opts.MaxOpenConns)
	}

	if x.opts.MaxIdleConns > 0 {
		sqldb.SetMaxIdleConns(x.opts.MaxIdleConns)
	}

	if x.opts.ConnMaxLifetime > 0 {
		duration := time.Millisecond * time.Duration(x.opts.ConnMaxLifetime)
		sqldb.SetConnMaxLifetime(duration)
	}

	if x.opts.ConnMaxIdleTime > 0 {
		duration := time.Millisecond * time.Duration(x.opts.ConnMaxIdleTime)
		sqldb.SetConnMaxIdleTime(duration)
	}

	clauses.RegisterPlugin(db)
	scopes.RegisterPlugin(db)

	switch x.opts.getDriver() {
	case DRIVER_PGSQL:
		err = db.Exec(`SET DEFAULT_TRANSACTION_ISOLATION TO SERIALIZABLE`).Error
		// SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
		// SET DEFAULT_TRANSACTION_ISOLATION TO SERIALIZABLE;
	}

	db = x.call(db, callback...)

	inst = &xInstance{opts: x.opts, db: db}

	return
}

func (x *xConnector) call(db *gorm.DB, callbacks ...ConnectionCallback) *gorm.DB {
	for _, callback := range callbacks {
		db = callback(db)
	}

	return db
}

// ===============================

func NewConnector(opts Options) Connector {
	return &xConnector{opts: opts}
}