org.salespointframework.catalog

Interface Catalog<T extends Product>

All Superinterfaces:

org.springframework.data.repository.CrudRepository<T,ProductIdentifier>, org.springframework.data.repository.Repository<T,ProductIdentifier>

public interface Catalog<T extends Product>
extends org.springframework.data.repository.CrudRepository<T,ProductIdentifier>

Repository interface for Products

Author:

Oliver Gierke

Method Summary

Modifier and Type	Method and Description
org.springframework.data.util.Streamable<T>	findByAllCategories(Collection<String> categories) Returns all Product that are assigned to all given categories.
default org.springframework.data.util.Streamable<T>	findByAllCategories(String... categories) Returns all Product that are assigned to all given categories.
org.springframework.data.util.Streamable<T>	findByAnyCategory(Collection<String> categories) Returns all Products that are assigned to any of the given categories.
default org.springframework.data.util.Streamable<T>	findByAnyCategory(String... categories) Returns all Products that are assigned to any of the given categories.
org.springframework.data.util.Streamable<T>	findByCategory(String category) Returns all Products assigned to the given category.
org.springframework.data.util.Streamable<T>	findByName(String name) Returns the Products with the given name.

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Detail

findByCategory

@Query(value="select p from #{#entityName} p where :category member of p.categories")
org.springframework.data.util.Streamable<T> findByCategory(String category)

Returns all Products assigned to the given category.

Parameters:

category -

Returns:

findByAllCategories

default org.springframework.data.util.Streamable<T> findByAllCategories(String... categories)

Returns all Product that are assigned to all given categories.

Parameters:

categories - must not be null.

Returns:

Since:

7.1

findByAllCategories

@Query(value="select  p from #{#entityName} p where (select count(c.id) from #{#entityName} p2 inner join p2.categories c where p2.id = p.id and c.id in :categories) = ?#{#categories.size().longValue()}")
org.springframework.data.util.Streamable<T> findByAllCategories(Collection<String> categories)

Returns all Product that are assigned to all given categories.

Parameters:

categories - must not be null.

Returns:

Since:

7.1

findByAnyCategory

default org.springframework.data.util.Streamable<T> findByAnyCategory(String... categories)

Returns all Products that are assigned to any of the given categories.

Parameters:

categories - must not be null.

Returns:

Since:

7.1

findByAnyCategory

@Query(value="select p from #{#entityName} p join p.categories c where c in :categories")
org.springframework.data.util.Streamable<T> findByAnyCategory(Collection<String> categories)

Returns all Products that are assigned to any of the given categories.

Parameters:

categories - must not be null.

Returns:

Since:

7.1

findByName

org.springframework.data.util.Streamable<T> findByName(String name)

Returns the Products with the given name.

Parameters:

name -

Returns: