From cd1a6cbd06d3b75adf708fcd2a7974bf94452248 Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.eu>
Date: Thu, 22 Feb 2024 22:59:53 +0100
Subject: Switch from mysql to postgres

---
 main.go | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'main.go')

diff --git a/main.go b/main.go
index f68b7b7..8ed57bf 100644
--- a/main.go
+++ b/main.go
@@ -1,11 +1,13 @@
 package main
 
 import (
+	"context"
 	"log"
 	"net/http"
 	"os"
 
 	"github.com/gorilla/handlers"
+	"github.com/jackc/pgx/v5/pgxpool"
 	"github.com/joho/godotenv"
 
 	"gosten/model"
@@ -38,10 +40,14 @@ func main() {
 
 	checkEnv()
 
-	db := openDB(os.Getenv("GOSTEN_DSN"))
-	if err := db.Ping(); err != nil {
+	db, err := pgxpool.New(context.Background(), os.Getenv("GOSTEN_DSN"))
+	if err != nil {
 		log.Fatal(err)
 	}
+	if err := db.Ping(context.Background()); err != nil {
+		log.Fatal(err)
+	}
+	defer db.Close()
 
 	Q = model.New(db)
 
-- 
cgit v1.2.3-70-g09d2