/
main.go
83 lines (65 loc) · 1.76 KB
/
main.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
package db
import (
"context"
"database/sql"
"errors"
"flag"
"fmt"
"strings"
"time"
"github.com/bdronneau/memoriesbox/pkg/logger"
"go.uber.org/zap"
_ "github.com/jackc/pgx/v5/stdlib"
)
var (
ErrNoHost = errors.New("no host for database connection")
SQLTimeout = time.Second * 5
)
type App struct {
DB *sql.DB
logger *zap.SugaredLogger
}
type Config struct {
dbHost *string
dbUser *string
dbName *string
dbPassword *string
dbPort *int
dbSsl *string
}
func GetConfig(fs *flag.FlagSet) Config {
return Config{
dbHost: fs.String("db-host", "0.0.0.0", "DB Hostname"),
dbUser: fs.String("db-user", "memoriesbox", "DB User"),
dbName: fs.String("db-name", "memoriesbox", "DB Name"),
dbSsl: fs.String("db-ssl", "prefer", "DB SSLMode"),
dbPassword: fs.String("db-password", "memoriesbox", "DB Password"),
dbPort: fs.Int("db-port", 5432, "DB Port"),
}
}
func New(config Config, loggerApp logger.App) (App, error) {
host := strings.TrimSpace(*config.dbHost)
if len(host) == 0 {
return App{}, ErrNoHost
}
user := strings.TrimSpace(*config.dbUser)
pass := *config.dbPassword
name := strings.TrimSpace(*config.dbName)
sslmode := *config.dbSsl
db, err := sql.Open("pgx", fmt.Sprintf("postgres://%s:%s@%s:%d/%s?sslmode=%s&application_name=%s", user, pass, host, *config.dbPort, name, sslmode, "memoriesbox"))
if err != nil {
return App{}, fmt.Errorf("connect to postgres: %w", err)
}
instance := App{
DB: db,
logger: loggerApp.Sugar,
}
ctx, cancel := context.WithTimeout(context.Background(), SQLTimeout)
defer cancel()
return instance, instance.Ping(ctx)
}
func (a App) Ping(ctx context.Context) error {
ctx, cancel := context.WithTimeout(ctx, SQLTimeout)
defer cancel()
return a.DB.PingContext(ctx)
}