dbutil

func FirstWhere ¶

func FirstWhere[T any](ctx context.Context, db *gorm.DB, notFound error, where string, args ...any) (*T, error)

FirstWhere fetches a single row of T matching the provided WHERE clause. It maps gorm.ErrRecordNotFound to notFound (when non-nil) and otherwise wraps the error with a generic "failed to query <T>" prefix.

Example:

user, err := dbutil.FirstWhere[models.User](ctx, s.db.DB, ErrUserNotFound, "username = ?", username)

func WithTx ¶

func WithTx(ctx context.Context, db *gorm.DB, fn func(tx *gorm.DB) error) error

WithTx runs fn inside a GORM transaction bound to ctx. Equivalent to db.WithContext(ctx).Transaction(fn) but tightens the surface area at call sites.