Interface WatchlistItemRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<WatchlistItem, Long>, org.springframework.data.jpa.repository.JpaRepository<WatchlistItem, Long>, org.springframework.data.repository.ListCrudRepository<WatchlistItem, Long>, org.springframework.data.repository.ListPagingAndSortingRepository<WatchlistItem, Long>, org.springframework.data.repository.PagingAndSortingRepository<WatchlistItem, Long>, org.springframework.data.repository.query.QueryByExampleExecutor<WatchlistItem>, org.springframework.data.repository.Repository<WatchlistItem, Long>

@Repository
public interface WatchlistItemRepository
extends org.springframework.data.jpa.repository.JpaRepository<WatchlistItem, Long>

Data-access layer for WatchlistItem.

Version:

3.0.6

Author:

Stephen Prizio

Method Summary

Modifier and Type	Method	Description
void	deleteWatchlistItemById(Long watchlistItemId)	Deletes a WatchlistItem matching the given id.
void	deleteWatchlistItemsByWatchlistId(Long watchlistId)	Deletes all WatchlistItems matching the given watchlist id.
Optional<WatchlistItem>	findByIdAndWatchlistUserId(Long id, Long userId)	Returns a watchlist item matching the decoded UID and authenticated owner.
WatchlistItem	findWatchlistItemByWatchlistAndSymbol(Watchlist watchlist, Symbol symbol)	Returns the WatchlistItem matching the given watchlist and symbol.
List<WatchlistItem>	findWatchlistItemsByPreferredSymbolAlias(SymbolAlias preferredSymbolAlias)	Returns all WatchlistItems matching the given preferred alias.
List<WatchlistItem>	findWatchlistItemsBySymbol(Symbol symbol)	Returns all WatchlistItems matching the given symbol.
List<WatchlistItem>	findWatchlistItemsByWatchlist(Watchlist watchlist)	Returns all WatchlistItems matching the given watchlist.

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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

findAll, findAllById, saveAll

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

findAll

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

findByIdAndWatchlistUserId

Optional<WatchlistItem> findByIdAndWatchlistUserId(Long id,
 Long userId)

Returns a watchlist item matching the decoded UID and authenticated owner.

Parameters:

id - watchlist item id decoded from its UID

userId - owning user id

Returns:

Optional of WatchlistItem

findWatchlistItemByWatchlistAndSymbol

WatchlistItem findWatchlistItemByWatchlistAndSymbol(Watchlist watchlist,
 Symbol symbol)

Returns the WatchlistItem matching the given watchlist and symbol.

Parameters:

watchlist - Watchlist

symbol - Symbol

Returns:

WatchlistItem

findWatchlistItemsByWatchlist

List<WatchlistItem> findWatchlistItemsByWatchlist(Watchlist watchlist)

Returns all WatchlistItems matching the given watchlist.

Parameters:

watchlist - Watchlist

Returns:

List of WatchlistItem

findWatchlistItemsBySymbol

List<WatchlistItem> findWatchlistItemsBySymbol(Symbol symbol)

Returns all WatchlistItems matching the given symbol.

Parameters:

symbol - Symbol

Returns:

List of WatchlistItem

findWatchlistItemsByPreferredSymbolAlias

List<WatchlistItem> findWatchlistItemsByPreferredSymbolAlias(SymbolAlias preferredSymbolAlias)

Returns all WatchlistItems matching the given preferred alias.

Parameters:

preferredSymbolAlias - SymbolAlias

Returns:

List of WatchlistItem

deleteWatchlistItemById

@Modifying(flushAutomatically=true)
@Query("delete from WatchlistItem watchlistItem where watchlistItem.id = :watchlistItemId")
void deleteWatchlistItemById(@Param("watchlistItemId")
 Long watchlistItemId)

Deletes a WatchlistItem matching the given id.

Parameters:

watchlistItemId - watchlist item id

deleteWatchlistItemsByWatchlistId

@Modifying(flushAutomatically=true)
@Query("delete from WatchlistItem watchlistItem where watchlistItem.watchlist.id = :watchlistId")
void deleteWatchlistItemsByWatchlistId(@Param("watchlistId")
 Long watchlistId)

Deletes all WatchlistItems matching the given watchlist id.

Parameters:

watchlistId - watchlist id