added migrations via tern, updated db package to connect to pgsql db, updated config to build db connection string, updated example .newsstand.toml config, new pgx dependency

1 files changed, 17 insertions, 6 deletions

diff --git a/src/db/db.go b/src/db/db.go
index 62218b2..4daf561 100644
--- a/src/db/db.go
+++ b/src/db/db.go
@@ -1,15 +1,26 @@
 package db
 
 import (
-	"database/sql"
+	"context"
+	"log"
+
+	"github.com/jackc/pgx/v5/pgxpool"
 
 	"gitlab.com/alexkavon/newsstand/src/conf"
 )
 
-type Db struct {
-	Db *sql.DB
-}
+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()
 
-func NewDb(config *conf.Conf) *sql.DB {
-	return &sql.DB{}
+	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
 }