Context Navigation

-              rb738035
+              r76712b2
     List<Location> getVillages();
+    @Query(value = "SELECT * FROM locations AS l WHERE l.id_city = :cityId", nativeQuery = true)
+    List<Location> getLocationsForCity(@Param("cityId") Long cityId);
+    @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);
+}

trip-planner/src/main/java/finki/diplomska/tripplanner/repository/jpa/JpaRegionRepository.java

-              rb738035
+              r76712b2
 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();
+}

rb738035	r76712b2
79	79	.antMatchers("/api/villages").permitAll()
80	80	.antMatchers("/api/cities").permitAll()
	81	.antMatchers("/api/all").permitAll()
	82	.antMatchers("/api/places").permitAll()
81	83	.anyRequest().authenticated();
82	84	http.addFilterBefore(jwtAuthenticationFilter(), UsernamePasswordAuthenticationFilter.class);

rb738035	r76712b2
25	25	List<Location> getVillages();
26	26	List<Long> getAllLocationIdsForPlanner(Long plannerId);
27		List<Location> get~~LocationsForCity(Long cityId~~);
	27	List<Location> getAllLocations(String place);
28	28	}

rb738035	r76712b2
7	7	public interface RegionService {
8	8	List<Region> findAll();
	9	List<String> getAllCitiesAndRegions();
9	10	}

rb738035	r76712b2
185	185
186	186	@Override
187		public List<Location> get~~LocationsForCity(Long cityId~~) {
188		return this.locationRepository.get~~LocationsForCity(cityId~~);
	187	public List<Location> getAllLocations(String place) {
	188	return this.locationRepository.getAllLocations(place);
189	189	}
	190
	191
190	192	}

rb738035	r76712b2
21	21	return this.regionRepository.findAll();
22	22	}
	23
	24	@Override
	25	public List<String> getAllCitiesAndRegions() {
	26	return this.regionRepository.getAllCitiesAndRegions();
	27	}
23	28	}

rb738035	r76712b2
77	77	}
78	78
	79	@GetMapping(value = "/all")
	80	public List<Location> getAllLocations(@RequestParam String place){
	81	return this.locationService.getAllLocations(place);
	82	}
	83
79	84	}

rb738035	r76712b2
25	25	return this.regionService.findAll();
26	26	}
	27
	28	@GetMapping(value = "/places")
	29	public List<String> getAllCitiesAndRegions(){
	30	return this.regionService.getAllCitiesAndRegions();
	31	}
27	32	}

-              rb738035
+              r76712b2
 {"username": "ema@test.com"}
+###
+GET http://localhost:8080/api/all?place=Skopje
+Content-Type: application/json
+###
+GET http://localhost:8080/api/places
+Content-Type: application/json

Note: See TracChangeset for help on using the changeset viewer.