package kr.wisestone.owl.repository;

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

    List<CompanyField> findByIdNot(@Param("id") Long id);
}