-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.go
119 lines (95 loc) · 2.4 KB
/
database.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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
package database
import (
"context"
"fmt"
"reflect"
"github.com/kimchhung/gva/extra/config"
"github.com/kimchhung/gva/extra/internal/ent"
"github.com/rs/zerolog"
"entgo.io/ent/dialect"
"entgo.io/ent/dialect/sql"
_ "github.com/go-sql-driver/mysql"
)
type Database struct {
*ent.Client
sql *sql.Driver
Log *zerolog.Logger
Cfg *config.Config
}
type Seeder interface {
Count(ctx context.Context, conn *ent.Client) (int, error)
Seed(ctx context.Context, conn *ent.Client) error
}
func NewDatabase(cfg *config.Config, log *zerolog.Logger) *Database {
db := &Database{
Cfg: cfg,
Log: log,
}
return db
}
func (db *Database) ConnectDatabase() error {
defer db.Log.Info().Msg("Database is connected")
drv, err := sql.Open(dialect.MySQL, db.Cfg.DB.Mysql.DSN)
if err != nil {
return fmt.Errorf("dns %sv, An unknown error occurred when to connect the database!, %v", db.Cfg.DB.Mysql.DSN, err)
}
db.sql = drv
db.Client = ent.NewClient(
ent.Driver(drv),
)
return nil
}
func (db *Database) Sql() *sql.Driver {
return db.sql
}
func (db *Database) ShutdownDatabase() error {
defer db.Log.Info().Msg("Database connection is closed")
if err := db.Client.Close(); err != nil {
return fmt.Errorf("An unknown error occurred when to shutdown the database! %v", err)
}
return nil
}
func (db *Database) SeedModels(ctx context.Context, seeder ...Seeder) {
if !db.Cfg.Seed.Enable {
return
}
defer db.Log.Info().Msg("Seeding was completed!")
for _, v := range seeder {
name := reflect.TypeOf(v).Name()
count, err := v.Count(ctx, db.Client)
if err != nil {
db.Log.Panic().Err(err).Msg("")
}
if count > 0 {
db.Log.Warn().Str("name", name).Msg("Table has seeded already. Skipping!")
continue
}
if err = v.Seed(ctx, db.Client); err != nil {
db.Log.Error().Err(err).Msg("Error seeding data")
continue
}
db.Log.Debug().Str("name", name).Msg("Table has seeded successfully.")
}
}
func WithTx(ctx context.Context, client *ent.Client, fn func(tx *ent.Tx) error) error {
tx, err := client.Tx(ctx)
if err != nil {
return err
}
defer func() {
if v := recover(); v != nil {
tx.Rollback()
panic(v)
}
}()
if err := fn(tx); err != nil {
if rerr := tx.Rollback(); rerr != nil {
err = fmt.Errorf("%w: rolling back transaction: %v", err, rerr)
}
return err
}
if err := tx.Commit(); err != nil {
return fmt.Errorf("committing transaction: %w", err)
}
return nil
}