/
db.go
74 lines (60 loc) · 1.29 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
package db
import (
"fmt"
"net"
"time"
_ "embed"
"github.com/jackc/pgtype"
pgtypeuuid "github.com/jackc/pgtype/ext/gofrs-uuid"
"github.com/jackc/pgx/v4"
"github.com/jackc/pgx/v4/pgxpool"
"golang.org/x/net/context"
)
//go:embed schema.sql
var schema string
type DB struct {
Host string
Database string
Username string
Password string
Timeout time.Duration
*pgxpool.Pool
}
func (db DB) dsn() string {
addr, port, _ := net.SplitHostPort(db.Host)
return fmt.Sprintf(
"host='%s' port='%s' user='%s' password='%s' dbname='%s' sslmode=disable",
addr,
port,
db.Username,
db.Password,
db.Database,
)
}
func (db *DB) Open() error {
cfg, err := pgxpool.ParseConfig(db.dsn())
if err != nil {
return err
}
cfg.AfterConnect = func(ctx context.Context, conn *pgx.Conn) error {
conn.ConnInfo().RegisterDataType(pgtype.DataType{
Value: &pgtypeuuid.UUID{},
Name: "uuid",
OID: pgtype.UUIDOID,
})
return nil
}
ctx, cancel := context.WithTimeout(context.Background(), db.Timeout)
defer cancel()
db.Pool, err = pgxpool.ConnectConfig(ctx, cfg)
if err != nil {
return err
}
return db.Ping(ctx)
}
func (db *DB) Migrate() error {
ctx, cancel := context.WithTimeout(context.Background(), db.Timeout)
defer cancel()
_, err := db.Exec(ctx, schema)
return err
}