Interface PositionTransactionRepository

All Superinterfaces:

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

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

Data-access layer for PositionTransaction entities.

Version:

3.0.6

Author:

Stephen Prizio

Method Summary

Modifier and Type	Method	Description
long	countByPositionId(Long positionId)	Counts all PositionTransactions for the given position id.
List<PositionTransaction>	findAllByPosition(Position position)	Returns all PositionTransactions for the given Position.
Optional<PositionTransaction>	findByIdAndPosition(Long id, Position position)	Returns a PositionTransaction by id for the given Position.
Optional<PositionTransaction>	findByPositionAndExternalTransactionId(Position position, String externalTransactionId)	Returns a PositionTransaction by imported external transaction id for the given Position.
Optional<PositionTransaction>	findOwned(long id, long positionNumber, String accountNumber, Long userId)	Returns a position transaction 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 pt FROM PositionTransaction pt\nWHERE pt.id = :id\n  AND pt.position.positionNumber = :positionNumber\n  AND pt.position.account.accountNumber = :accountNumber\n  AND pt.position.account.user.id = :userId\n  AND pt.position.account.portfolio.active = true\n")
Optional<PositionTransaction> findOwned(@Param("id")
 long id,
 @Param("positionNumber")
 long positionNumber,
 @Param("accountNumber")
 String accountNumber,
 @Param("userId")
 Long userId)

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

Parameters:

id - position transaction id decoded from its UID

positionNumber - position number

accountNumber - account number

userId - owning user id

Returns:

Optional of PositionTransaction

findByIdAndPosition

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

Returns a PositionTransaction by id for the given Position.

Parameters:

id - position transaction id

position - Position

Returns:

Optional PositionTransaction

findByPositionAndExternalTransactionId

Optional<PositionTransaction> findByPositionAndExternalTransactionId(Position position,
 String externalTransactionId)

Returns a PositionTransaction by imported external transaction id for the given Position.

Parameters:

position - Position

externalTransactionId - external transaction id

Returns:

Optional PositionTransaction

findAllByPosition

List<PositionTransaction> findAllByPosition(Position position)

Returns all PositionTransactions for the given Position.

Parameters:

position - Position

Returns:

List of PositionTransactions

countByPositionId

long countByPositionId(Long positionId)

Counts all PositionTransactions for the given position id.

Parameters:

positionId - position id

Returns:

count