From b8ab6de032d3a6ee029331dbb58d764a5409189b Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 28 2월 2022 15:51:13 +0900
Subject: [PATCH] - api로 하위이슈 추가 시 상위이슈의 파트너 정보 적용

---
 src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
index afc7954..5c0f392 100644
--- a/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
+++ b/src/main/java/kr/wisestone/owl/repository/CompanyFieldRepository.java
@@ -2,7 +2,21 @@
 
 import kr.wisestone.owl.domain.CompanyField;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.repository.query.Param;
+
+import java.util.List;
 
 public interface CompanyFieldRepository extends JpaRepository<CompanyField, Long> {
 
+    List<CompanyField> findByNameAndIdNot(@Param("name") String name, @Param("id") Long id);
+
+    List<CompanyField> findByName(@Param("name") String name);
+
+    CompanyField findByUrl(@Param("url") String url);
+
+    CompanyField findByUrlAndIdNot(@Param("url") String url, @Param("id") Long id);
+
+    List<CompanyField> findByIspId(@Param("isp_id") Long id);
+
+    List<CompanyField> findByHostingId(@Param("hosting_id") Long id);
 }

--
Gitblit v1.8.0