From 6eecd93c185e5c3122da1a5c53a3784fc580d013 Mon Sep 17 00:00:00 2001
From: Hendrik Jungnitsch <hendrik.jungnitsch@gedoplan.de>
Date: Mi, 07 Sep 2022 15:10:10 +0200
Subject: [PATCH] exercis03
---
src/main/java/de/gedoplan/seminar/jpa/exercise/rest/HighwayResource.java | 4 ++--
src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java | 7 +++++++
2 files changed, 9 insertions(+), 2 deletions(-)
diff --git a/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java b/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
index afdf070..d66679f 100644
--- a/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
+++ b/src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java
@@ -1,11 +1,18 @@
package de.gedoplan.seminar.jpa.exercise.repository;
+import java.util.List;
+
import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import de.gedoplan.seminar.jpa.exercise.domain.Highway;
@Repository
public interface HighwayRepository extends JpaRepository<Highway, Integer> {
+
+ public List<Highway> findByOrigin(String orgigin);
+ @Query("select count(distinct h.origin) from Highway h")
+ public Long countOrigins();
}
diff --git a/src/main/java/de/gedoplan/seminar/jpa/exercise/rest/HighwayResource.java b/src/main/java/de/gedoplan/seminar/jpa/exercise/rest/HighwayResource.java
index 03d90e7..de8eb58 100644
--- a/src/main/java/de/gedoplan/seminar/jpa/exercise/rest/HighwayResource.java
+++ b/src/main/java/de/gedoplan/seminar/jpa/exercise/rest/HighwayResource.java
@@ -62,7 +62,7 @@
public List<Highway> findByOrigin(@PathVariable("origin") String origin) {
this.logger.debug("----- findByOrigin -----");
- List<Highway> highways = List.of(); //this.highwayRepository.
+ List<Highway> highways = this.highwayRepository.findByOrigin(origin);
this.logger.debug(origin+": "+highways);
return highways;
}
@@ -71,7 +71,7 @@
public Long findByOrigin() {
this.logger.debug("----- countOrigins -----");
- Long count = 0L;// this.highwayRepository.
+ Long count = this.highwayRepository.countOrigins();
this.logger.debug("Count distinct Origins: "+count);
return count;
}
--
Gitblit v1.7.1