aswi2022code-of-duty-gitlab/backend/src/main/java/cz/zcu/kiv/backendapi/catalog/CatalogItemRepository.java @ b539ef29

package cz.zcu.kiv.backendapi.catalog;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Set;
import java.util.UUID;

/**
 * Catalog repository
 */
@Repository
public interface CatalogItemRepository extends JpaRepository<CatalogItem, UUID> {

    /**
     * Returns all catalog items containing specific values
     *
     * @param name    name - optional
     * @param country country - optional
     * @param type    type - optional
     * @return set of catalog items satisfying filter conditions
     */
    @Query("SELECT DISTINCT e FROM CatalogItem e " +
            "LEFT JOIN FETCH AlternativeName a ON e = a.catalogItem " +
            "LEFT JOIN FETCH Country c ON e = c.catalogItem " +
            "LEFT JOIN FETCH e.types t " +
            "WHERE (?1 = '' OR UPPER(e.name) LIKE UPPER(?1) OR UPPER(a.name) LIKE UPPER(?1)) " +
            "AND (?2 = '' OR UPPER(c.name) LIKE UPPER(?2)) " +
            "AND (?3 = '' OR UPPER(t.type) LIKE UPPER(?3))")
    Set<CatalogItem> filterCatalog(String name, String country, String type);

    /**
     * Selects catalog items with given name (alternative name)
     *
     * @param name name
     * @return list of catalog items with given name
     */
    @Query("SELECT DISTINCT a.catalogItem FROM AlternativeName a WHERE ?1 = a.name")
    List<CatalogItem> getItemsByName(String name);
}