-
Notifications
You must be signed in to change notification settings - Fork 3
/
driver.go
77 lines (60 loc) · 1.78 KB
/
driver.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 driver
import (
"context"
"database/sql"
"database/sql/driver"
"errors"
"github.com/alexfalkowski/go-service/database/sql/config"
logger "github.com/alexfalkowski/go-service/database/sql/driver/telemetry/logger/zap"
"github.com/alexfalkowski/go-service/database/sql/driver/telemetry/tracer"
"github.com/alexfalkowski/go-service/time"
"github.com/linxGnu/mssqlx"
"github.com/ngrok/sqlmw"
"go.opentelemetry.io/otel/trace"
"go.uber.org/fx"
"go.uber.org/zap"
)
// Register the driver for SQL.
func Register(name string, driver driver.Driver, trace trace.Tracer, log *zap.Logger) {
var interceptor sqlmw.Interceptor = &sqlmw.NullInterceptor{}
interceptor = tracer.NewInterceptor(name, trace, interceptor)
interceptor = logger.NewInterceptor(name, log, interceptor)
sql.Register(name, sqlmw.Driver(driver, interceptor))
}
// Open a DB pool.
func Open(lc fx.Lifecycle, name string, cfg *config.Config) (*mssqlx.DBs, error) {
masters := make([]string, len(cfg.Masters))
for i, m := range cfg.Masters {
u, err := m.GetURL()
if err != nil {
return nil, err
}
masters[i] = u
}
slaves := make([]string, len(cfg.Slaves))
for i, s := range cfg.Slaves {
u, err := s.GetURL()
if err != nil {
return nil, err
}
slaves[i] = u
}
db, err := connect(name, masters, slaves)
if err != nil {
return nil, err
}
lc.Append(fx.Hook{
OnStop: func(_ context.Context) error {
return errors.Join(db.Destroy()...)
},
})
d := time.MustParseDuration(cfg.ConnMaxLifetime)
db.SetConnMaxLifetime(d)
db.SetMaxIdleConns(cfg.MaxIdleConns)
db.SetMaxOpenConns(cfg.MaxOpenConns)
return db, nil
}
func connect(name string, masterDSNs, slaveDSNs []string) (*mssqlx.DBs, error) {
db, errs := mssqlx.ConnectMasterSlaves(name, masterDSNs, slaveDSNs)
return db, errors.Join(errs...)
}