exercis03

Hendrik Jungnitsch

2022-08-29 6eecd93c185e5c3122da1a5c53a3784fc580d013

exercis03

 src/main/java/de/gedoplan/seminar/jpa/exercise/repository/HighwayRepository.java

@@ -1,6 +1,9 @@
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;
@@ -8,4 +11,8 @@
@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();
}

 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;
  }