From 3eb04b1a2bdf9e53231fe862cfd76327371a9741 Mon Sep 17 00:00:00 2001 From: gramanas Date: Sat, 12 Sep 2026 11:24:17 +0300 Subject: Initial multi-tenant blog host Go + Postgres application serving a management dashboard on the base domain and one public blog per subdomain. Markdown posts organised in pages, form-based theme customisation, image uploads stored in Postgres, JWT cookie sessions with CSRF, superadmin user management, RSS feeds. Docker/compose deployment and a Makefile-driven dev environment with seed data. Co-Authored-By: Claude Opus 5 Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A --- internal/store/store.go | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 internal/store/store.go (limited to 'internal/store/store.go') diff --git a/internal/store/store.go b/internal/store/store.go new file mode 100644 index 0000000..472bb2a --- /dev/null +++ b/internal/store/store.go @@ -0,0 +1,34 @@ +// Package store holds the data models and all SQL queries. +package store + +import ( + "errors" + + "github.com/jackc/pgx/v5" + "github.com/jackc/pgx/v5/pgconn" + "github.com/jackc/pgx/v5/pgxpool" +) + +var ErrNotFound = errors.New("not found") +var ErrConflict = errors.New("already exists") + +type Store struct { + db *pgxpool.Pool +} + +func New(db *pgxpool.Pool) *Store { return &Store{db: db} } + +// wrap maps driver errors onto the store's sentinel errors. +func wrap(err error) error { + if err == nil { + return nil + } + if errors.Is(err, pgx.ErrNoRows) { + return ErrNotFound + } + var pgErr *pgconn.PgError + if errors.As(err, &pgErr) && pgErr.Code == "23505" { // unique_violation + return ErrConflict + } + return err +} -- cgit v1.2.3