blob: 2b72382f95fe0751c8b919c05714921ef7fb3d95 (
plain)
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
|
package db
import (
"context"
"log"
"github.com/jackc/pgx/v5/pgxpool"
"gitlab.com/alexkavon/newsstand/src/conf"
)
type Database struct {
p *pgxpool.Pool
}
func NewDb(config *conf.Conf) *Database {
pool, err := pgxpool.New(context.Background(), config.Db.Url)
if err != nil {
log.Fatal(err)
}
defer pool.Close()
var testquery string
err = pool.QueryRow(context.Background(), "select 'Hello, PostgreSQL!'").Scan(&testquery)
if err != nil {
log.Fatal(err)
}
log.Println("Database connection pool created.", testquery)
return &Database{
p: pool,
}
}
|
