Package com.patreonshout.jpa

Interface SearchFiltersRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<SearchFilter,​java.lang.Long>, org.springframework.data.jpa.repository.JpaRepository<SearchFilter,​java.lang.Long>, org.springframework.data.repository.PagingAndSortingRepository<SearchFilter,​java.lang.Long>, org.springframework.data.repository.query.QueryByExampleExecutor<SearchFilter>, org.springframework.data.repository.Repository<SearchFilter,​java.lang.Long>, SearchFiltersCustom
@Transactional
public interface SearchFiltersRepository
extends org.springframework.data.jpa.repository.JpaRepository<SearchFilter,​java.lang.Long>, SearchFiltersCustom
Spring Data Repository for easy use of CRUD operations on the SearchFilter object

  • Method Summary

    Modifier and Type Method Description
    void deleteSearchFilterByFilterId​(long filter_id)
    Deletes a SearchFilter in the database by it's filter_id
    java.util.List<SearchFilter> findSearchFiltersByWebaccountId​(int webaccountId)
    Finds all of the search filters associated with a user

    Methods inherited from interface org.springframework.data.repository.CrudRepository

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

    Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

    deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

    Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

    findAll

    Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

    count, exists, findAll, findBy, findOne

  • Method Details

    • deleteSearchFilterByFilterId

      @Modifying @Query(value="DELETE FROM search_filters WHERE filter_id = ?1", nativeQuery=true) void deleteSearchFilterByFilterId​(long filter_id)
      Deletes a SearchFilter in the database by it's filter_id
      Parameters:
      filter_id - the id of the list

    • findSearchFiltersByWebaccountId

      java.util.List<SearchFilter> findSearchFiltersByWebaccountId​(int webaccountId)
      Finds all of the search filters associated with a user
      Parameters:
      webaccountId - the id of the user's webaccount
      Returns:
      a list of SearchFilter objects