repo

package pl.rmitula.shopbe.repository;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import pl.rmitula.shopbe.dto.SearchDetail;
import pl.rmitula.shopbe.model.Product;

import java.util.List;

@Repository
public interface ProductRepository extends JpaRepository<Product, Long>, JpaSpecificationExecutor<Product> {

    Page<Product> findAllByCategoryId(Long categoryId, Pageable pageable);

    Page<Product> findByNameLike(String phrase, Pageable pageable);

    @Query("SELECT p.category.id, COUNT(p.id) " +
            "FROM Product p " +
            "WHERE p.name LIKE ?1 " +
            "GROUP BY p.category.id")
    List<SearchDetail> findSearchDetailsByName(String phrase);
}