portal-BE/src/main/java/org/onap/portal/dao/ep/EpWidgetCatalogParameterDao.java

   1 package org.onap.portal.dao.ep;
   2
   3 import java.util.List;
   4 import java.util.Optional;
   5 import org.onap.portal.domain.db.ep.EpWidgetCatalogParameter;
   6 import org.springframework.data.jpa.repository.JpaRepository;
   7 import org.springframework.data.jpa.repository.Modifying;
   8 import org.springframework.data.jpa.repository.Query;
   9 import org.springframework.data.repository.query.Param;
  10 import org.springframework.stereotype.Repository;
  11 import org.springframework.transaction.annotation.Transactional;
  12
  13 @Repository
  14 @Transactional
  15 public interface EpWidgetCatalogParameterDao extends JpaRepository<EpWidgetCatalogParameter, Long> {
  16
  17        @Query
  18        Optional<List<EpWidgetCatalogParameter>> retrieveByParamId(@Param("PARAMID") Long paramId);
  19
  20        @Query
  21        @Modifying
  22        void deleteWidgetCatalogParameter(@Param("PARAMID") Long paramId);
  23
  24        @Query
  25        Optional<List<EpWidgetCatalogParameter>> getUserParamById(@Param("WIDGETID") Long widgetId,
  26                @Param("USERID") Long userId, @Param("PARAMID") Long paramId);
  27 }