Index: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaImageRepository.java
===================================================================
--- trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaImageRepository.java	(revision 571e0df9a7a5e798c9941a85842f785177bedbbd)
+++ 	(revision )
@@ -1,16 +1,0 @@
-package finki.diplomska.tripplanner.repository.jpa;
-
-import finki.diplomska.tripplanner.models.Images;
-import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;
-import org.springframework.stereotype.Repository;
-
-import java.util.List;
-
-@Repository
-public interface JpaImageRepository extends JpaRepository<Images, Long> {
-
-    @Query(value = "SELECT * FROM images AS i WHERE i.id_location = :locationId", nativeQuery = true)
-    List<Images> getAllImagesForLocation(@Param("locationId") Long locationId);
-}
Index: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java
===================================================================
--- trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java	(revision 571e0df9a7a5e798c9941a85842f785177bedbbd)
+++ trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaLocationRepository.java	(revision 6a3a178323fd905112b5392bd9d3cb83b66ef2d3)
@@ -44,75 +44,3 @@
             "GROUP BY l.id_location ORDER BY CASE l.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
     List<Location> findLocationsFromCountry(@Param("locName") String ime, @Param("companion") String companion, @Param("region") String region, @Param("categories") List<String> categories);
-
-    @Query(value = "SELECT  * FROM locations AS l  " +
-            "LEFT JOIN recommended_companion AS rc " +
-            "ON l.id_location = rc.id_location " +
-            "LEFT JOIN companions AS companion " +
-            "ON rc.id_companion = companion.id_companion " +
-            "LEFT JOIN locations_belong lb " +
-            "ON l.id_location = lb.id_location " +
-            "LEFT JOIN categories AS category " +
-            "ON lb.id_category = category.id_category " +
-            "LEFT JOIN cities AS city " +
-            "ON city.id_city = l.id_city " +
-            "WHERE city.id_city = :cityId and companion.id_companion = :companionId and category.id_category IN (:categoryIds) " +
-            "GROUP BY l.id_location ORDER BY CASE l.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
-    List<Location> findLocationsFromCityForm(@Param("cityId") Long cityId, @Param("companionId") Long companionId, @Param("categoryIds") List<Long> categoryIds);
-
-    @Query(value="SELECT * FROM locations AS location " +
-            "LEFT JOIN recommended_companion AS rc " +
-            "ON location.id_location = rc.id_location " +
-            "LEFT JOIN companions AS companion " +
-            "ON rc.id_companion = companion.id_companion " +
-            "LEFT JOIN locations_belong lb " +
-            "ON location.id_location = lb.id_location " +
-            "LEFT JOIN categories AS category " +
-            "ON lb.id_category = category.id_category " +
-            "LEFT JOIN regions AS region " +
-            "ON location.id_region = region.id_region " +
-            "LEFT JOIN cities AS city " +
-            "ON region.id_region  = city.id_region " +
-            "AND city.id_city = location.id_city " +
-            "WHERE region.id_region = :regionId AND companion.id_companion  = :companionId AND category.id_category  IN (:categoryIds) " +
-            "GROUP BY location.id_location ORDER BY CASE location.priority WHEN 'high' THEN 1 WHEN 'medium' THEN 2 WHEN 'low' THEN 3 END", nativeQuery = true)
-    List<Location> findLocationsFromRegionForm(@Param("regionId") Long regionId, @Param("companionId") Long companionId, @Param("categoryIds") List<Long> categoryIds);
-
-    @Query(value = "SELECT * " +
-            "FROM locations AS l " +
-            "WHERE l.id_location IN " +
-            "(SELECT pl.id_location FROM planners_contain AS pl WHERE pl.id_planner = :plannerId)", nativeQuery = true)
-    List<Location> getAllLocationsForPlanner(@Param("plannerId") Long plannerId);
-
-
-    @Query(value = "SELECT l.id_location " +
-            "FROM locations AS l " +
-            "WHERE l.id_location IN " +
-            "(SELECT pl.id_location FROM planners_contain AS pl WHERE pl.id_planner = :plannerId)", nativeQuery = true)
-    List<Long> getAllLocationIdsForPlanner(@Param("plannerId") Long plannerId);
-
-    @Query(value = "SELECT *, if(l.id_city is NOT NULL, c.city_name, l.location_name) as result " +
-            "FROM locations AS l " +
-            "LEFT JOIN cities AS c " +
-            "ON l.id_city = c.id_city " +
-            "LEFT JOIN locations_belong AS lb " +
-            "ON l.id_location = lb.id_location " +
-            "WHERE lb.id_category=20", nativeQuery = true)
-    List<Location> getWeekendGetaways();
-
-    @Query(value = "SELECT *, if(l.id_city is NOT NULL, c.city_name, l.location_name) as result " +
-            "FROM locations AS l " +
-            "LEFT JOIN cities AS c " +
-            "ON l.id_city = c.id_city " +
-            "LEFT JOIN locations_belong AS lb " +
-            "ON l.id_location = lb.id_location " +
-            "WHERE lb.id_category=4", nativeQuery = true)
-    List<Location> getVillages();
-
-    @Query(value = "SELECT * FROM locations AS l " +
-            "LEFT JOIN cities AS c " +
-            "ON l.id_city = c.id_city " +
-            "LEFT JOIN regions AS r " +
-            "ON l.id_region = r.id_region " +
-            "WHERE c.city_name = :place OR r.region_name = :place", nativeQuery = true)
-    List<Location> getAllLocations(@Param("place") String place);
 }
Index: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java
===================================================================
--- trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java	(revision 571e0df9a7a5e798c9941a85842f785177bedbbd)
+++ trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaPlannerRepository.java	(revision 6a3a178323fd905112b5392bd9d3cb83b66ef2d3)
@@ -4,6 +4,4 @@
 import finki.diplomska.tripplanner.models.Planner;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 
@@ -13,12 +11,4 @@
 public interface JpaPlannerRepository extends JpaRepository<Planner, Long> {
 
-        @Query(value = "SELECT * FROM planners AS p left JOIN users AS u ON p.user_id = u.id WHERE u.username like :username", nativeQuery = true)
-        List<Planner> getPlannersByUser(@Param("username") String username );
 
-        @Query(value = "DELETE planners_contain " +
-                "FROM planners_contain " +
-                "JOIN planners ON planners_contain.id_planner = planners.id_planner " +
-                "JOIN locations ON planners_contain.id_location = locations.id_location " +
-                "WHERE planners_contain.id_planner = :plannerId AND planners_contain.id_location = :locationId", nativeQuery = true)
-        void deleteLocationFromPlanner(@Param("plannerId") Long plannerId, @Param("locationId") Long locationId);
 }
Index: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java
===================================================================
--- trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java	(revision 571e0df9a7a5e798c9941a85842f785177bedbbd)
+++ trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java	(revision 6a3a178323fd905112b5392bd9d3cb83b66ef2d3)
@@ -3,16 +3,7 @@
 import finki.diplomska.tripplanner.models.Region;
 import org.springframework.data.jpa.repository.JpaRepository;
-import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
-
-import java.util.List;
 
 @Repository
 public interface JpaRegionRepository extends JpaRepository<Region, Long> {
-
-    @Query(value="SELECT r.region_name " +
-            "FROM regions AS r " +
-            "UNION all " +
-            "SELECT c.city_name FROM cities AS c", nativeQuery = true)
-    List<String> getAllCitiesAndRegions();
 }
Index: trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaUserRepository.java
===================================================================
--- trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaUserRepository.java	(revision 571e0df9a7a5e798c9941a85842f785177bedbbd)
+++ 	(revision )
@@ -1,23 +1,0 @@
-package finki.diplomska.tripplanner.repository.jpa;
-
-import finki.diplomska.tripplanner.models.User;
-import org.springframework.data.jpa.repository.Query;
-import org.springframework.data.repository.CrudRepository;
-import org.springframework.data.repository.query.Param;
-import org.springframework.stereotype.Repository;
-
-import java.util.List;
-import java.util.Optional;
-
-@Repository
-public interface JpaUserRepository extends CrudRepository<User, Long> {
-    User findByUsername(String username);
-    User getById(Long id);
-
-    @Query(value = "SELECT u.username FROM users AS u", nativeQuery = true)
-    List<String> getAllUsernames();
-
-    @Query(value = "SELECT u.password FROM users AS u WHERE u.username LIKE :username ", nativeQuery = true)
-    Optional<String> getPassword(@Param("username") String username);
-
-}
