Package es.kukenan.smartfi.microservice.onboarding.repository

Interface SourceFundsRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<SourceFunds,String>, org.springframework.data.jpa.repository.JpaRepository<SourceFunds,String>, org.springframework.data.repository.PagingAndSortingRepository<SourceFunds,String>, org.springframework.data.repository.query.QueryByExampleExecutor<SourceFunds>, org.springframework.data.repository.Repository<SourceFunds,String>
@Repository public interface SourceFundsRepository extends org.springframework.data.jpa.repository.JpaRepository<SourceFunds,String>
Repository for queries for Source of Funds.

  • Method Summary

    Modifier and Type
    Method
    Description
    List<es.kukenan.smartfi.dto.DataOnboardingResponse>
    findAllByLanguageId(int language)
    Select registers by language.
    SourceFunds
    findById(int id)
    Select registers by id.

    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

    • findById

      @Query("SELECT sf FROM SourceFunds sf WHERE sf.id = :id") SourceFunds findById(@Param("id") int id)
      Select registers by id.
      Parameters:
      id - identifier for Source of Funds.
      Returns:
      Annual revenues object from database

    • findAllByLanguageId

      @Query("SELECT NEW es.kukenan.smartfi.dto.DataOnboardingResponse(sf.id, sf.description, sf.id) FROM SourceFunds sf WHERE sf.language.id = :language") List<es.kukenan.smartfi.dto.DataOnboardingResponse> findAllByLanguageId(@Param("language") int language)
      Select registers by language.
      Parameters:
      language - for Source of Funds.
      Returns:
      List of object for Source of Funds