// Package store contains the PostgreSQL persistence layer. It uses plain // parameterized SQL, one bounded pool and explicit transaction boundaries. // Contract errors are returned as common.AppError so HTTP status mapping stays // in one place. package store import ( "context" "time" "github.com/jackc/pgx/v5/pgxpool" ) type Store struct { pool *pgxpool.Pool timeout time.Duration idempotencyTTL time.Duration } func New(pool *pgxpool.Pool, timeout, idempotencyTTL time.Duration) *Store { return &Store{pool: pool, timeout: timeout, idempotencyTTL: idempotencyTTL} } func (s *Store) withTimeout(ctx context.Context) (context.Context, context.CancelFunc) { return context.WithTimeout(ctx, s.timeout) } func (s *Store) Ping(ctx context.Context) error { pingCtx, cancel := context.WithTimeout(ctx, 2*time.Second) defer cancel() return s.pool.Ping(pingCtx) } type rowScanner interface { Scan(dest ...any) error }