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.Query;
   8 import org.springframework.data.repository.query.Param;
   9 import org.springframework.stereotype.Repository;
  10 import org.springframework.transaction.annotation.Transactional;
  11
  12 @Repository
  13 @Transactional
  14 public interface EpWidgetCatalogParameterDao extends JpaRepository<EpWidgetCatalogParameter, Long> {
  15
  16        @Query
  17        Optional<List<EpWidgetCatalogParameter>> retrieveByParamId(@Param("PARAMID") Long paramId);
  18
  19        @Query
  20        void deleteWidgetCatalogParameter(@Param("PARAMID") Long paramId);
  21
  22        @Query
  23        Optional<List<EpWidgetCatalogParameter>> getUserParamById(@Param("WIDGETID") Long widgetId,
  24                @Param("USERID") Long userId, @Param("PARAMID") Long paramId);
  25 }