Interface AccountLedgerRepository

All Superinterfaces:

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

@Repository
public interface AccountLedgerRepository
extends org.springframework.data.jpa.repository.JpaRepository<AccountLedgerEntry, Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<AccountLedgerEntry>

Data-access layer for AccountLedgerEntry entities.

Version:

3.0.5

Author:

Stephen Prizio

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T>

Method Summary

Modifier and Type	Method	Description
void	deleteByAccount(Account account)	Deletes all ledger entries for the given Account.
void	deleteByPosition(Position position)	Deletes all ledger entries for the given Position.
List<AccountLedgerEntry>	findAllByAccountOrderByOccurredAtAscSequenceNumberAsc(Account account)	Returns all ledger entries for the given Account.
List<AccountLedgerEntry>	findAllByAccountsOrderByOccurredAtAscSequenceNumberAsc(List<Account> accounts)	Returns all ledger entries for the given List of Accounts.
List<AccountLedgerEntry>	findAllByTransaction(Transaction transaction)	Returns every ledger entry linked to the given Transaction.
Optional<AccountLedgerEntry>	findFirstByAccountOrderByOccurredAtDescSequenceNumberDesc(Account account)	Returns the latest ledger entry for the given Account.
Optional<AccountLedgerEntry>	findFirstByPosition(Position position)	Returns a ledger entry for the given Position.
Optional<AccountLedgerEntry>	findFirstByTransaction(Transaction transaction)	Returns a ledger entry for the given Transaction.

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.jpa.repository.JpaSpecificationExecutor

count, count, delete, delete, exists, exists, findAll, findAll, findAll, findAll, findAll, findBy, findBy, findOne, findOne, update

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

findAllByAccountOrderByOccurredAtAscSequenceNumberAsc

List<AccountLedgerEntry> findAllByAccountOrderByOccurredAtAscSequenceNumberAsc(Account account)

Returns all ledger entries for the given Account.

Parameters:

account - Account

Returns:

List of AccountLedgerEntry

findAllByAccountsOrderByOccurredAtAscSequenceNumberAsc

@Query("SELECT ale\nFROM AccountLedgerEntry ale\nWHERE ale.account IN :accounts\nORDER BY ale.occurredAt ASC, ale.account.id ASC, ale.sequenceNumber ASC\n")
List<AccountLedgerEntry> findAllByAccountsOrderByOccurredAtAscSequenceNumberAsc(@Param("accounts")
 List<Account> accounts)

Returns all ledger entries for the given List of Accounts.

Parameters:

accounts - List of Accounts

Returns:

List of AccountLedgerEntry

findFirstByAccountOrderByOccurredAtDescSequenceNumberDesc

Optional<AccountLedgerEntry> findFirstByAccountOrderByOccurredAtDescSequenceNumberDesc(Account account)

Returns the latest ledger entry for the given Account.

Parameters:

account - Account

Returns:

Optional AccountLedgerEntry

findFirstByPosition

Optional<AccountLedgerEntry> findFirstByPosition(Position position)

Returns a ledger entry for the given Position.

Parameters:

position - Position

Returns:

Optional AccountLedgerEntry

findFirstByTransaction

Optional<AccountLedgerEntry> findFirstByTransaction(Transaction transaction)

Returns a ledger entry for the given Transaction.

Parameters:

transaction - Transaction

Returns:

Optional AccountLedgerEntry

findAllByTransaction

List<AccountLedgerEntry> findAllByTransaction(Transaction transaction)

Returns every ledger entry linked to the given Transaction.

Parameters:

transaction - Transaction

Returns:

List of AccountLedgerEntry

deleteByPosition

@Modifying(flushAutomatically=true)
@Query("DELETE FROM AccountLedgerEntry ale WHERE ale.position = :position")
void deleteByPosition(@Param("position")
 Position position)

Deletes all ledger entries for the given Position.

Parameters:

position - Position

deleteByAccount

@Modifying(flushAutomatically=true)
@Query("DELETE FROM AccountLedgerEntry ale WHERE ale.account = :account")
void deleteByAccount(@Param("account")
 Account account)

Deletes all ledger entries for the given Account.

Parameters:

account - Account