1
result := db.Where("email = ?", email).First(&user)
2
if result.Error != nil {
3
  if errors.Is(result.Error, gorm.ErrRecordNotFound) {
4
    return ErrUserNotFound
5
  }
6
  return fmt.Errorf("find user: %w", result.Error)
7
}

1
user, err := gorm.G[User](db).Where("id = ?", id).First(ctx)
2
if err != nil {
3
  if errors.Is(err, gorm.ErrRecordNotFound) {
4
    return ErrUserNotFound
5
  }
6
  return fmt.Errorf("find user: %w", err)
7
}

1
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
2
  TranslateError: true,
3
})

1
db.Debug().Where("id = ?", id).First(&user)

1
logger.Config{
2
  ParameterizedQueries:      true,
3
  IgnoreRecordNotFoundError: true,
4
  SlowThreshold:             200 * time.Millisecond,
5
}

1
stmt := db.Session(&gorm.Session{DryRun: true}).
2
  Where("email = ?", email).
3
  First(&User{}).Statement
4

5
fmt.Println(stmt.SQL.String())
6
fmt.Println(stmt.Vars)

1
var ErrUserNotFound = errors.New("user not found")
2

3
func FindUser(ctx context.Context, db *gorm.DB, id uint) (User, error) {
4
  var user User
5
  if err := db.WithContext(ctx).First(&user, id).Error; err != nil {
6
    if errors.Is(err, gorm.ErrRecordNotFound) {
7
      return User{}, ErrUserNotFound
8
    }
9
    return User{}, fmt.Errorf("find user %d: %w", id, err)
10
  }
11
  return user, nil
12
}