-
Notifications
You must be signed in to change notification settings - Fork 1
/
db.go
103 lines (91 loc) · 2.41 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 db
import (
"context"
"errors"
"fmt"
"path"
"path/filepath"
"runtime"
"github.com/golang-migrate/migrate/v4"
_ "github.com/golang-migrate/migrate/v4/database/postgres"
_ "github.com/golang-migrate/migrate/v4/source/file"
"github.com/jackc/pgx/v5"
"github.com/jackc/pgx/v5/stdlib"
"github.com/labasubagia/realworld-backend/internal/adapter/repository/sql/db/migration"
"github.com/labasubagia/realworld-backend/internal/core/port"
"github.com/labasubagia/realworld-backend/internal/core/util"
"github.com/uptrace/bun"
"github.com/uptrace/bun/dialect/pgdialect"
bunMigrate "github.com/uptrace/bun/migrate"
)
type DB struct {
config util.Config
logger port.Logger
db *bun.DB
}
func New(config util.Config, logger port.Logger) (*DB, error) {
var err error
database := &DB{
config: config,
logger: logger,
}
if database.db, err = database.connect(); err != nil {
return nil, err
}
if err := database.migrate(); err != nil {
return nil, err
}
return database, nil
}
func (db *DB) DB() *bun.DB {
return db.db
}
func (db *DB) connect() (*bun.DB, error) {
config, err := pgx.ParseConfig(db.config.PostgresSource)
if err != nil {
return nil, err
}
sqlDB := stdlib.OpenDB(*config)
database := bun.NewDB(sqlDB, pgdialect.New())
// log
if !db.config.IsProduction() {
// database.AddQueryHook(bundebug.NewQueryHook(bundebug.WithVerbose(true)))
database.AddQueryHook(&LoggerHook{verbose: true, logger: db.logger})
}
return database, nil
}
func (db *DB) migrate() error {
_, currentFile, _, ok := runtime.Caller(0)
if !ok {
return errors.New("unable to get the current current file")
}
currentDir := filepath.Dir(currentFile)
migrationURL := fmt.Sprintf("file://%s", path.Join(currentDir, "migration"))
migration, err := migrate.New(migrationURL, db.config.PostgresSource)
if err != nil {
return fmt.Errorf("cannot create new migration instance: %s", err)
}
if err := migration.Up(); err != nil && err != migrate.ErrNoChange {
return fmt.Errorf("failed to run migrate: %s", err)
}
return nil
}
func (db *DB) migrateBun() error {
ctx := context.Background()
migrator := bunMigrate.NewMigrator(db.db, migration.Migrations)
if err := migrator.Init(ctx); err != nil {
return err
}
if err := migrator.Lock(ctx); err != nil {
return err
}
defer migrator.Unlock(ctx)
group, err := migrator.Migrate(ctx)
if err != nil {
return err
}
if group.IsZero() {
return nil
}
return nil
}