forked from mtusi2026/mtusi2026lab5
37 lines
948 B
Go
37 lines
948 B
Go
// 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
|
|
}
|