Revize abaa5f46

Experiment with database

backend/src/main/java/cz/zcu/kiv/backendapi/catalog/CatalogItemRepository.java

@@ -3 +3 @@
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
+import org.springframework.transaction.annotation.Transactional;
 
-import java.util.Set;
+import java.util.List;
 import java.util.UUID;
 
 /**
  * Catalog repository
  */
-@Repository
+@Repository()
 public interface CatalogItemRepository extends JpaRepository<CatalogItem, UUID> {
 
     /**
@@ -22 +23 @@
      * @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 " +
-            "INNER JOIN FETCH e.types t " +
+            "LEFT JOIN e.alternativeNames a " +
+            "LEFT JOIN e.countries c " +
+            "LEFT JOIN 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);
+    @Transactional(readOnly = true)
+    List<CatalogItem> filterCatalog(String name, String country, String type);
+
+    @Query("SELECT DISTINCT e FROM CatalogItem e " +
+            "LEFT JOIN e.alternativeNames a " +
+            "LEFT JOIN e.countries c " +
+            "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))")
+    List<CatalogItem> filterCatalog2(String name, String country);
 }