1 |
e111342b
|
Jakub Smid
|
package cz.zcu.kiv.backendapi.catalog;
|
2 |
|
|
|
3 |
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
4 |
|
|
import org.springframework.data.jpa.repository.Query;
|
5 |
|
|
import org.springframework.stereotype.Repository;
|
6 |
|
|
|
7 |
b539ef29
|
Jakub Smid
|
import java.util.List;
|
8 |
e111342b
|
Jakub Smid
|
import java.util.UUID;
|
9 |
|
|
|
10 |
|
|
/**
|
11 |
|
|
* Catalog repository
|
12 |
|
|
*/
|
13 |
|
|
@Repository
|
14 |
b30f120b
|
Jakub Smid
|
public interface CatalogItemRepository extends JpaRepository<CatalogItem, UUID> {
|
15 |
e111342b
|
Jakub Smid
|
|
16 |
b539ef29
|
Jakub Smid
|
/**
|
17 |
|
|
* Selects catalog items with given name (alternative name)
|
18 |
|
|
*
|
19 |
|
|
* @param name name
|
20 |
|
|
* @return list of catalog items with given name
|
21 |
|
|
*/
|
22 |
fb55e8e9
|
Jakub Smid
|
@Query("SELECT DISTINCT a.catalogItem FROM CatalogItemName a WHERE ?1 = a.name")
|
23 |
b539ef29
|
Jakub Smid
|
List<CatalogItem> getItemsByName(String name);
|
24 |
e111342b
|
Jakub Smid
|
}
|