/
db.go
103 lines (90 loc) · 2.33 KB
/
db.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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
package query
import (
"context"
"database/sql"
"embed"
"errors"
"github.com/XSAM/otelsql"
_ "github.com/go-sql-driver/mysql"
"github.com/golang-migrate/migrate/v4"
"github.com/golang-migrate/migrate/v4/database/mysql"
"github.com/golang-migrate/migrate/v4/source/iofs"
"github.com/prometheus/client_golang/prometheus"
"github.com/prometheus/client_golang/prometheus/collectors"
semconv "go.opentelemetry.io/otel/semconv/v1.4.0"
"go.uber.org/fx"
"go.uber.org/zap"
)
var (
//go:embed migrations/*.sql
migrationsFS embed.FS
)
func SetupDB(p Params) (*sql.DB, error) {
if err := MigrateDB(p.Logger, p.Config.Database.DSN); err != nil {
return nil, err
}
// Connect to database
db, err := otelsql.Open("mysql", p.Config.Database.DSN,
otelsql.WithAttributes(
semconv.DBSystemMySQL,
),
otelsql.WithSpanOptions(otelsql.SpanOptions{
DisableErrSkip: true,
}),
)
if err != nil {
return nil, err
}
err = otelsql.RegisterDBStatsMetrics(db, otelsql.WithAttributes(
semconv.DBSystemMySQL,
))
if err != nil {
return nil, err
}
db.SetMaxOpenConns(p.Config.Database.MaxOpenConns)
db.SetMaxIdleConns(p.Config.Database.MaxIdleConns)
db.SetConnMaxIdleTime(p.Config.Database.ConnMaxIdleTime)
db.SetConnMaxLifetime(p.Config.Database.ConnMaxLifetime)
p.LC.Append(fx.StopHook(func(_ context.Context) error {
return db.Close()
}))
// Setup SQL Prometheus metrics collector
prometheus.MustRegister(collectors.NewDBStatsCollector(db, "fivenet"))
return db, nil
}
func MigrateDB(logger *zap.Logger, dsn string) error {
logger.Info("starting database migrations")
// Connect to database
db, err := sql.Open("mysql", dsn+"&multiStatements=true")
if err != nil {
return err
}
// Setup migrate source and driver
source, err := iofs.New(migrationsFS, "migrations")
if err != nil {
return err
}
driver, err := mysql.WithInstance(db, &mysql.Config{
MigrationsTable: "fivenet_zschema_migrations",
})
if err != nil {
return err
}
m, err := migrate.NewWithInstance(
"iofs", source,
"mysql", driver)
if err != nil {
return err
}
// Run migrations
if err := m.Up(); err != nil {
if !errors.Is(err, migrate.ErrNoChange) {
return err
} else {
logger.Info("database migrations have caused no changes")
}
} else {
logger.Info("completed database migrations changes have been made")
}
return db.Close()
}