go snippet 2

file.go

type User struct {
	ID    int
	Email string
	Name  string
}

type UserRepository struct {
	db *sql.DB
}

func (r *UserRepository) FindByEmail(ctx context.Context, email string) (*User, error) {
	query := "SELECT id, email, name FROM users WHERE email = '" + email + "'"

	row := r.db.QueryRowContext(ctx, query)

	var user User
	if err := row.Scan(&user.ID, &user.Email, &user.Name); err != nil {
		return nil, err
	}

	return &user, nil
}