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
}