From 1597c23f84346dfa44da9605286863b11006bdb5 Mon Sep 17 00:00:00 2001
From: Alexander Kavon <hawk@alexkavon.com>
Date: Tue, 28 Nov 2023 18:32:19 -0500
Subject: 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

---
 src/db/db.go | 23 +++++++++++++++++------
 1 file changed, 17 insertions(+), 6 deletions(-)

(limited to 'src/db')

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
 }
-- 
cgit v1.2.3