/
database.go
62 lines (48 loc) · 1.27 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
package models
import (
"context"
"time"
"github.com/dipdup-net/go-lib/config"
"github.com/dipdup-net/go-lib/database"
pg "github.com/go-pg/pg/v10"
"github.com/go-pg/pg/v10/orm"
"github.com/rs/zerolog/log"
)
// OpenDatabaseConnection -
func OpenDatabaseConnection(ctx context.Context, cfg config.Database, kinds ...string) (db *database.PgGo, err error) {
db = database.NewPgGo()
if err := db.Connect(ctx, cfg); err != nil {
return nil, err
}
database.Wait(ctx, db, 5*time.Second)
data := GetModelsBy(kinds...)
data = append(data, &database.State{})
for i := range data {
if err := db.DB().WithContext(ctx).Model(data[i]).CreateTable(&orm.CreateTableOptions{
IfNotExists: true,
}); err != nil {
if err := db.Close(); err != nil {
return nil, err
}
return nil, err
}
}
if err := database.MakeComments(ctx, db, data...); err != nil {
return nil, err
}
db.DB().AddQueryHook(dbLogger{})
return db, nil
}
type dbLogger struct{}
func (d dbLogger) BeforeQuery(c context.Context, q *pg.QueryEvent) (context.Context, error) {
return c, nil
}
func (d dbLogger) AfterQuery(c context.Context, q *pg.QueryEvent) error {
raw, err := q.FormattedQuery()
if err != nil {
return err
}
sql := string(raw)
log.Debug().Msgf("%+v", sql)
return nil
}