src/db/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

package db

import (
	"context"
	"log"

	"github.com/jackc/pgx/v5/pgxpool"

	"gitlab.com/alexkavon/newsstand/src/conf"
)

func NewDb(config *conf.Conf) *pgxpool.Pool {
	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 pool
}