Interface PositionOrderRepository

All Superinterfaces:

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

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

Data-access layer for PositionOrder entities.

Version:

3.0.6

Author:

Stephen Prizio

Method Summary

Modifier and Type	Method	Description
long	countByPositionId(Long positionId)	Counts all PositionOrders for the given position id.
List<PositionOrder>	findAllByPosition(Position position)	Returns all PositionOrders for the given Position.
Optional<PositionOrder>	findByIdAndPosition(Long id, Position position)	Returns a PositionOrder by id for the given Position.
Optional<PositionOrder>	findByPositionAndExternalOrderId(Position position, String externalOrderId)	Returns a PositionOrder by imported external order id for the given Position.
Optional<PositionOrder>	findFirstByExternalOrderId(String externalOrderId)	Returns a PositionOrder by imported external order id.
Optional<PositionOrder>	findOwned(long id, long positionNumber, String accountNumber, Long userId)	Returns a position order matching its request hierarchy and authenticated owner.

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

findOwned

@Query("SELECT po FROM PositionOrder po\nWHERE po.id = :id\n  AND po.position.positionNumber = :positionNumber\n  AND po.position.account.accountNumber = :accountNumber\n  AND po.position.account.user.id = :userId\n  AND po.position.account.portfolio.active = true\n")
Optional<PositionOrder> findOwned(@Param("id")
 long id,
 @Param("positionNumber")
 long positionNumber,
 @Param("accountNumber")
 String accountNumber,
 @Param("userId")
 Long userId)

Returns a position order matching its request hierarchy and authenticated owner.

Parameters:

id - position order id decoded from its UID

positionNumber - position number

accountNumber - account number

userId - owning user id

Returns:

Optional of PositionOrder

findByIdAndPosition

Optional<PositionOrder> findByIdAndPosition(Long id,
 Position position)

Returns a PositionOrder by id for the given Position.

Parameters:

id - position order id

position - Position

Returns:

Optional PositionOrder

findByPositionAndExternalOrderId

Optional<PositionOrder> findByPositionAndExternalOrderId(Position position,
 String externalOrderId)

Returns a PositionOrder by imported external order id for the given Position.

Parameters:

position - Position

externalOrderId - external order id

Returns:

Optional PositionOrder

findFirstByExternalOrderId

Optional<PositionOrder> findFirstByExternalOrderId(String externalOrderId)

Returns a PositionOrder by imported external order id.

Parameters:

externalOrderId - external order id

Returns:

Optional PositionOrder

findAllByPosition

List<PositionOrder> findAllByPosition(Position position)

Returns all PositionOrders for the given Position.

Parameters:

position - Position

Returns:

List of PositionOrders

countByPositionId

long countByPositionId(Long positionId)

Counts all PositionOrders for the given position id.

Parameters:

positionId - position id

Returns:

count