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[common.User](ctx, s.db.DB, ErrUserNotFound, "username = ?", username)

func IsRetryableWriteError ¶ added in v2.8.0

func IsRetryableWriteError(err error) bool

IsRetryableWriteError reports whether a database write failed because the database was temporarily busy or timed out.

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.