Fiber - HTTP + DB reads

db.go

package main

import (
	"context"
	"database/sql"
	"os"

	"github.com/uptrace/bun"
	"github.com/uptrace/bun/dialect/pgdialect"
	"github.com/uptrace/bun/driver/pgdriver"
)

type User struct {
	bun.BaseModel `bun:"table:users"`
	Email string    `bun:"email,pk"`
	First  string   `bun:"first"`
	Last   string   `bun:"last"`
	City   string   `bun:"city"`
	County string   `bun:"county"`
	Age    int      `bun:"age"`
}

var sqldb = sql.OpenDB(pgdriver.NewConnector(
	pgdriver.WithNetwork("tcp"),
	pgdriver.WithAddr("localhost:5432"),
	pgdriver.WithUser(os.Getenv("dbUser")),
	pgdriver.WithPassword(os.Getenv("dbUserPass")),
	pgdriver.WithDatabase(os.Getenv("dbName")),
	pgdriver.WithInsecure(true),
))

var db = bun.NewDB(sqldb, pgdialect.New())

func init() {
	sqldb.SetMaxOpenConns(10)
	sqldb.SetMaxIdleConns(10)
}

func GetUser(email string) User {
	ctx := context.Background()
	var user User
	err := db.NewSelect().Model(&user).Where("email = ?", email).Scan(ctx)
	if err != nil {
		return user
	}
	return user
}

fiberApp.go

package main

import (
	"log"

	"net/http"

	"github.com/gofiber/fiber/v2"
)

type RequestBody struct {
    Email string `json:"userEmail"`
}

func main() {
	app := fiber.New()
	port := ":3000"

	app.Post("/", func(c *fiber.Ctx) error {
		var requestBody RequestBody
		if err := c.BodyParser(&requestBody); err != nil {
			return c.SendStatus(http.StatusBadRequest)
		}
		if requestBody.Email == "" {
			return c.SendStatus(http.StatusBadRequest)
		}

		var user = GetUser(requestBody.Email)
		return c.JSON(user)
	})

	log.Fatal(app.Listen(port))
}