문제1,2,3

제가 수강하고 있는 최태현님 강의 출처입니다!

https://inf.run/XKQg

기억해야 할 오류1)
자바의 카멜 표기법이 DB에서는 (언더바)로 변환된다는걸 몰라서 발생한 오류였다.
warehousingDate이라는 변수명을 필드명으로 지정했었는데, 한참 오류가 떠서 구글링하다가 원인을 발견해서 mysql 칼럼명을 warehousing_Date으로 바꾸어 해결할 수 있었다.

기억해야 할 오류2) query did not return a unique result: 2
이 오류는 findByName을 할 때 데이터가 여러갠데 받아오는 리턴 타입이 문제여서 발생했다. 원래는 List으로 받았는데 Collection으로 고쳐서 해결됐다. 근데 나는 List랑 Collection차이를 모르니까 공부해야겠다...

FruitController.java

package com.group.libraryapp.controller.fourthAssignment;

import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.FruitFinalResponse;
import com.group.libraryapp.dto.fourth.response.FruitListFinalResponse;
import com.group.libraryapp.dto.fourth.response.fruitNumResponse;
import com.group.libraryapp.service.fruit.FruitServiceV2;
import org.springframework.web.bind.annotation.*;

@RestController
public class FruitController {

    //추가
    private final FruitServiceV2 fruitService ;

    //추가
    public FruitController(FruitServiceV2 fruitService){


        this.fruitService = fruitService;
    }




    @PostMapping("/api/v1/fruit")
    public void saveFruitInfo(@RequestBody SaveFruitRequest request) {
       fruitService.saveFruitInfo(request);


    }

    @PutMapping("/api/v1/fruit")
    public void updateFruit(@RequestBody SaveFruitRequest request){
       fruitService.updateFruit(request);
    }

    @GetMapping("/api/v1/fruit/stat")
    public FruitFinalResponse getFruits(@RequestParam String name) {
        return fruitService.getFruit(name);

    }

    @GetMapping("/api/v1/fruit/count")
    public fruitNumResponse getFruitNum(@RequestParam String name) {
        return fruitService.getFruitNum(name);

    }

    @GetMapping("/api/v1/fruit/list")
    public FruitListFinalResponse getFruitList(@RequestParam String option, Long price) {
        return fruitService.getFruitList(option,price);

    }




}

FruitServiceV2.java

package com.group.libraryapp.service.fruit;

import com.group.libraryapp.domain.fruit.FruitJpaRepository;
import com.group.libraryapp.dto.fourth.request.SaveFruitRequest;
import com.group.libraryapp.dto.fourth.response.*;
import com.group.libraryapp.repository.fruit.Fruit;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import java.util.stream.Collectors;

@Service
public class FruitServiceV2 {

    private final FruitJpaRepository fruitRepository;

    public FruitServiceV2(FruitJpaRepository fruitRepository) {
        this.fruitRepository = fruitRepository;

    }

    public void saveFruitInfo(SaveFruitRequest request) {


        Fruit fruit = fruitRepository.save(new Fruit(request.getName(), request.getWarehousingDate(), request.getPrice(), request.getId(), request.isSell()));

    }

    public void updateFruit(SaveFruitRequest request) {

        Fruit fruit = fruitRepository.findById(request.getId())
                .orElseThrow(IllegalArgumentException::new);

        //업데이트 sql이 따로있진 않은가..?
        //특정 id에 해당하는 유저의 객체를 가져와서 업데이트 하면됨.


        //직접 넣어도 되려나..?
        fruit.updateFruitSellStatus(true);
        //자동으로 유저의 이름이 바뀐걸 확인하고 유저의 이름이 바뀌어있기 때문에,바뀐걸 기준으로 업데이트쿼리가 날라감.
        fruitRepository.save(fruit);


    }

    public FruitFinalResponse getFruit(String name) {

        Collection<Fruit> fruit = fruitRepository.findByName(name);
        if (fruit == null) {
            throw new IllegalArgumentException();
        } else {
            Collection<Fruit> fruits = fruitRepository.findByName(name);

            List<FruitResponse> fruitList = fruits.stream().
                    map(fruit1 -> new FruitResponse(fruit1.getPrice(), fruit1.isSell()))
                    .collect(Collectors.toList());
            long salesTotal = 0;
            long notSalesTotal = 0;
            for (int i = 0; i < fruitList.size(); i++) {
                if (fruitList.get(i).isSell()) {
                    salesTotal = salesTotal + fruitList.get(i).getSalesAmount();

                } else {
                    notSalesTotal = notSalesTotal + fruitList.get(i).getSalesAmount();

                }
            }
            return new FruitFinalResponse(salesTotal, notSalesTotal);

        }


    }

    public fruitNumResponse getFruitNum(String name){
        return new fruitNumResponse(fruitRepository.countByName(name));
    }

    public FruitListFinalResponse getFruitList(String option,Long price){
        Collection<Fruit> fruits;
        if(option.equals("GTE")){
            fruits = fruitRepository.findByPriceGreaterThanEqual(price);

        }else{
            fruits = fruitRepository.findByPriceLessThanEqual(price);
        }

        List<FruitListResponse> fruitList = fruits.stream().
                map(fruit1 -> new FruitListResponse(fruit1.getName(), fruit1.getPrice(),fruit1.getWarehousingDate(),fruit1.isSell()))
                .collect(Collectors.toList());

        List<FruitListResponse> notSellFruits = new ArrayList<>();

        for (FruitListResponse fruitListResponse : fruitList) {
           if(fruitListResponse.isSell()==false) {
               notSellFruits.add(fruitListResponse);

           }

        }
        return new FruitListFinalResponse(notSellFruits);


    }


}

Fruit.java

package com.group.libraryapp.repository.fruit;

import javax.persistence.*;
import java.time.LocalDate;

@Entity
public class Fruit {

    @Column(length = 20,name ="name")
    String name;
    LocalDate warehousingDate;
    long price;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    long id;

    @Column(nullable = false,name = "isSell")
    boolean isSell=false;

    public Fruit(String name, LocalDate warehousingDate, long price, long id, boolean isSell) {
        this.name = name;
        this.warehousingDate = warehousingDate;
        this.price = price;
        this.id = id;
        this.isSell = isSell;
    }

    //jpa 사용 위한 기본 생성자 추가
    public  Fruit(){

    }

    public String getName() {
        return name;
    }

    public LocalDate getWarehousingDate() {
        return warehousingDate;
    }

    public long getPrice() {
        return price;
    }

    public long getId() {
        return id;
    }

    public boolean isSell() {
        return isSell;
    }

  public void updateFruitSellStatus(boolean isSell){
        this.isSell = isSell;

  }


}

FruitNumResponse.java

package com.group.libraryapp.dto.fourth.response;

public class fruitNumResponse {
    long count;

    public fruitNumResponse(long count) {
        this.count = count;
    }

    public long getCount() {
        return count;
    }
}

FruitJpaRepository.java

package com.group.libraryapp.domain.fruit;


import com.group.libraryapp.repository.fruit.Fruit;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import java.util.Collection;

@Repository
public interface FruitJpaRepository extends JpaRepository<Fruit,Long> {


   Collection<Fruit> findByName(String fruitName);

    Collection<Fruit> findByPriceGreaterThanEqual(Long price);
    Collection<Fruit> findByPriceLessThanEqual(Long price);


    Long countByName(String fruitName);


}

FruitListResponse.java

package com.group.libraryapp.dto.fourth.response;

import java.time.LocalDate;

public class FruitListResponse {
  String name;
  Long price;
  LocalDate warehousingDate;
  boolean isSell;

  public FruitListResponse(String name, Long price, LocalDate warehousingDate,boolean isSell) {
      this.name = name;
      this.price = price;
      this.warehousingDate = warehousingDate;
      this.isSell = isSell;
  }

  public String getName() {
      return name;
  }

  public Long getPrice() {
      return price;
  }

  public LocalDate getWarehousingDate() {
      return warehousingDate;
  }

  public boolean isSell() {
      return isSell;
  }
}

FruitListFinalResponse.java

package com.group.libraryapp.dto.fourth.response;

import java.util.List;

public class FruitListFinalResponse {
  List<FruitListResponse> fruitListResponses;

  public FruitListFinalResponse(List<FruitListResponse> fruitListResponses) {
      this.fruitListResponses = fruitListResponses;
  }

  public List<FruitListResponse> getFruitListResponses() {
      return fruitListResponses;
  }
}